Issue
Case Archival jobs fail with database errors on inserts into pr_metadata where pxInsName and/or pzInsKey is larger than 255 characters.
Symptoms and Impact
Archival jobs fail.
Error: org.postgresql.util.PSQLException: ERROR: value too long for type character varying(255)
Steps to reproduce
Enable Case Archival by defining a retention policy for a case type.
Root Cause
A defect in Pega code/rules which results in pxInsName and pzInsKey values for archival metadata which exceed the established column size configuration.
Solution
This issue is planned to be addressed in a future Pega Platform release. Issues are prioritized based on impact, severity, and capacity. The specific release for the fix has not yet been determined. This section will be updated with release details when the fix for this issue is available.
An interim workaround to perform the below alterations to the pr_metadata database table is available for the pxInsName and pzInsKey columns:
- pxInsName: ALTER from VARCHAR(255) to VARCHAR(512)
- pzInsKey: ALTER from VARCHAR(255) to VARCHAR(1024)
References
Enabling the Case archival process