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