Support Article
Error when trying to add an attachment greater than 5 MB
SA-16387
Summary
An error occurs when you try to add an attachment greater than 5 MB in size.
Error Messages
SQL error in the log file
SQLState 22001, Error code -302: com.ibm.db2.jcc.am.SqlDataException: DB2 SQL Error: SQLCODE=-302, SQLSTATE=22001, SQLERRMC=null, DRIVER=3.62.56
Steps to Reproduce
- Open a work object.
- Add an attachment greater than 5 MB.
Root Cause
For DB2, the default size for BLOB columns is 5 MB for all tables, except pr4_rule_file_binary, which is 40 MB.
Resolution
If the requirements of a particular application call for more space, perform the following local-change:
Increase the BLOB size of the pc_data_workattach table.
Published October 4, 2016 - Updated October 8, 2020
Have a question? Get answers now.
Visit the Collaboration Center to ask questions, engage in discussions, share ideas, and help others.