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

PCI not created when title is too long

    XMLWordPrintable

Details

    • ERM Sprint 87, ERM Sprint 88
    • Bienenvolk

    Description

      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

        Attachments

          Issue Links

            Activity

              People

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

                Dates

                  Created:
                  Updated:
                  Resolved:

                  TestRail: Runs

                    TestRail: Cases