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

DatabaseException: String or binary data would be truncated

SA-81231

Summary



DatabaseException occurs when saving a Case Note to a new database table.


Error Messages



DatabaseException: String or binary data would be truncated


Steps to Reproduce

  1. Create a new database table which is identical to the pc_data_workattach table.
  2. Perform the data-admin-db-table (DABT) mapping to map the identical table with the Data-WorkAttach-Note class.
  3. Test the Attach a Note (local action) feature for the case.


Root Cause



DatabaseException occurred while a note was attached to the case. This exception indicated that when a note was added to the database table, the column data size was larger than the column size. In the newly created table, the pzPVStream BLOB column size was set to 1.  This resulted in the exception.


Resolution



As a local-change, modify the pzPVStream BLOB column size to dynamic length.

Published August 19, 2019 - 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