Support Article

Unable to save work object due to blob size

SA-31505

Summary



User is executing an activity to duplicate a work object as a new work item but it is failing due to the blob size.


Error Messages



SQLState 22001, Error code -302: com.ibm.db2.jcc.am.SqlDataException: The value of a host variable in the EXECUTE or OPEN statement is out of range for its corresponding use.. SQLCODE=-302, SQLSTATE=22001, DRIVER=3.63.75


Steps to Reproduce

Execute an activity to duplicate the work object.


Root Cause



The Alert log shows the blob size to be inserted is 7192619 bytes but the blob size in the database is only 5242880 bytes.

Resolution



The blob size must be increased in the database, to resolve the issue.

 

Published December 15, 2016 - Updated December 23, 2016

Have a question? Get answers now.

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