SQLSTATE=54008 since sum of column lengths cannot exceed 2000
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).
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.
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.
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.
0% found this useful