Uploaded image for project: 'ERM Platform'
  1. ERM Platform
  2. ERM-834

PCI not created when title is too long



    • ERM Sprint 87, ERM Sprint 88
    • Bienenvolk


      PCI title can go beyond 255 characters (as it combines the name of the resource, platform and package names) using the form:

      <resource title> on Platform <platform name> in Package <package name>

      Since each of the components <resource_title>, <platform_name> and <package_name> can all be 255, it is possible for each of the components to have a valid name while creating an invalid name for the PCI

      Presumably the same issue can occur for the PTI as well as this uses the form:

      <resource title> on Platform <platform name>

      As once again each of the components can have 255 chars

      This issue can result in failure to create PCIs (and presumably PTIs) with an unclear message in the log e.g.

      Skipping Handbook of Research on the Psychological Contract at Work. System error: Hibernate operation: could not execute statement; SQL [n/a]; ERROR: value too long for type character varying(255); nested exception is org.postgresql.util.PSQLException: ERROR: value too long for type character varying(255)

      Ideally we should find a solution that:

      • Prevents this situation occurring - potentially truncating the concatenated names in this instance?
      • That adequately logs what has occurred if this happens through data sync or package upload

      TestRail: Results


          Issue Links



                sosguthorpe Steve Osguthorpe
                ostephens Owen Stephens
                0 Vote for this issue
                2 Start watching this issue



                  TestRail: Runs

                    TestRail: Cases