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

pxIndexPurpose Property Definition and Column Size Do Not Match



A save error occurs when the value of the pxIndexPurpose property exceeds 32 characters in length.

Error Messages

pyCommitError: ** The key property pxIndexPurpose in database PegaDATA is too big for its column; column size 32, property size: 55.

Steps to Reproduce

1. Set the pxIndexPurpose property for Index- class objects to a value greater than 32 characters.
2. Save the object/record to the database.

Root Cause

The value of the pxIndexPurpose property is greater than the size specified for the database column.


Increase the size of the pxIndexPurpose column in the database to varchar2(64).
Suggest Edit

Published February 23, 2016 - Updated October 8, 2020

Did you find this content helpful? Yes No

100% found this useful

Have a question? Get answers now.

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

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