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

Long value in Index-.pxIndexPurpose property cause pyCommitError



While creating a work object, user experienced "pyCommitError" in the recently upgraded Pega 7.1.6 setup.

Error Messages

"Please correct the errors indicated and try again.
pyCommitError:** The key property pxIndexPurpose in database PegaDATA, table pr_index is too big for its column; column size: 32, property size: 36, property value: Index_HRCRiskRating_CustomerTypeRisk, instance class: Index-<Org>-Data-GSCM-RiskRating, trying to run SQL: insert into PEGA7_FCCM_DEV.pr_index (PXCREATEDATETIME , PXCREATEOPERATOR , PXCREATEOPNAME , PXCREATESYSTEMID , PXINDEXCOUNT , PXINDEXPURPOSE , PXINSINDEXEDCLASS , PXINSINDEXEDKEY , PXINSNAME , PXOBJCLASS , PXPRIVILEGECLASS , PXPRIVILEGENAME , PXUPDATEDATETIME , PXUPDATEOPERATOR , PXUPDATEOPNAME , PXUPDATESYSTEMID , PYLABEL , pzInsKey , pzPVStream) values (? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ?)"

Steps to Reproduce

1. Create a Work Object.
2. Set the pxIndexPurpose property for Index- class objects to a value with > 32 characters.
3. Save the object/record to the database and pyCommitError will manifest on the screen and this does not allow user navigate to the next screen.

Root Cause

Column size of PXINDEXPURPOSE in the table PR_INDEX was 32 bytes. When user tries to insert value exceeds 32 bytes in this column, pyCommitError issue manifests.


As a local-change, user has increased the column size "PXINDEXPURPOSE" in the table PR_INDEX from 32 to 64 bytes. 

Published January 31, 2016 - Updated October 8, 2020

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