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
- Create a new database table which is identical to the pc_data_workattach table.
- Perform the data-admin-db-table (DABT) mapping to map the identical table with the Data-WorkAttach-Note class.
- 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
Have a question? Get answers now.
Visit the Collaboration Center to ask questions, engage in discussions, share ideas, and help others.