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
Update to either of the following Pega Platform versions:
- Pega Platform 25.1.3
- Pega Platform 26
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)