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

Commit failure for fully exposed data class issue



After additional properties were added to a class that is mapped to a fully exposed external database table, an error occurred on execution.

Error Messages

Cannot save an instance of a class [AAA-FW-......Data-MyClass] it belongs to fully exposed table MySchema.My_Table in database PegaDATA, but the instance has properties which do not correspond to columns, Prop1, Prop2

Steps to Reproduce

  1. Attempt to save an instance of a class, that is mapped to a fully exposed external database table.
  2. Ensure that external database table must have more properties than there are columns in the associated database table.

Root Cause

An issue in the custom application code or rules where properties that did not align with columns in the fully exposed external database table were present on the clipboard when instances are saved.


Here’s the explanation for the reported behavior:  This behavior is expected.  When an instance of a class is saved, all of the properties in that instance are saved to the associated database table.  If the table is fully exposed, all of the properties being saved must have a column to be saved into.  To avoid this behavior, the following options are available:
  1. Utilize an internal, Pega generated, table such as the table that is created when the class was created. Internal tables can leverage the pzPVStream property  (also known as the BLOB) to save non-exposed properties.  External tables cannot leverage the pzPVStream property, and must be fully exposed.
  2. Add columns to the external table that line up with the additional properties.
  3. Remove the additional properties from the clipboard before saving back to the database.

Published February 12, 2016 - Updated October 8, 2020

Was this useful?

62% 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