Skip to main content

This content has been archived and is no longer being updated. Links may not function; however, this content may be relevant to outdated versions of the product.

Support Article

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).

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.


Perform the following local-change:
  2. 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.
  3. Modify the generated DDL such that the pxObjClass column is 96 instead of 4000.
  4. Manually apply the DDL changes.

Published August 24, 2018 - Updated December 2, 2021

Was this useful?

0% found this useful

Have a question? Get answers now.

Visit the Collaboration Center to ask questions, engage in discussions, share ideas, and help others.

Did you find this content helpful?

Want to help us improve this content?

We'd prefer it if you saw us at our best.

Pega Community has detected you are using a browser which may prevent you from experiencing the site as intended. To improve your experience, please update your browser.

Close Deprecation Notice
Contact us