Support Article
SQLSTATE=54008 since sum of column lengths cannot exceed 2000
SA-56800
Summary
When the sum of internal lengths of the columns is greater than the allowable maximum, the index cannot be modified. On PPM_resourceefforttracking, the aggregate sum of the index columns exceeds the 2000-byte maximum (WORKITEMINSKEY = 255 + PXOBJCLASS = 4000).
Error Messages
SQLCODE=-614, SQLSTATE=54008 since the sum of column lengths cannot exceed 2000.
Steps to Reproduce
Import Agile Studio 7.3. 1 in to a Pega 7.3.1.
Root Cause
A defect in Pegasystems’ code or rules.
Agile studio 7.31 created the pxObjClass column of length 4000. This caused the issue when creating the index on DB2.
Resolution
Perform the following local-change:
- Drop the PPM_RESOURCEEFFORTTRACKING table.
- Re-import the Product rule to manually generate the DDL. This must have the Create Table for the main table along with the AUX table or tablespaces.
- Modify the generated DDL such that the pxObjClass column is 96 instead of 4000.
- Manually apply the DDL changes.
Tags:
Published August 24, 2018 - Updated December 2, 2021
Have a question? Get answers now.
Visit the Collaboration Center to ask questions, engage in discussions, share ideas, and help others.