IBM Support

Application process hangs while waiting for component process to finish

Troubleshooting


Problem

Attempts to insert into the BLOB column of a very large IBM UrbanCode Deploy workflow table results in the error "Data being inserted into the database table column is larger than the assigned column length" and the application process hangs.

Symptom

Component processes complete successfully, however the Application processes does not register the completion and continues to wait for the component process to finish.

  • You are forced to cancel the deployment, and repeat.
  • Inventory statuses are correct and resume from the correct point moving forward.
  • If you wait too long after the hang to Cancel, you are unable to cancel the deployment.


DB2 errors in the log similar to the following:

ERROR WorkflowRuntime-5
       com.urbancode.air.workflow.WorkflowRuntime - Uncaught
       exception in workflow
       a928028b-a271-4276-8550-54e743e28a23
       org.hibernate.exception.DataException: could not update:
       [com.urbancode.air.workflow.WorkflowRecord
       ...
       ...
       Caused by: com.ibm.db2.jcc.am.SqlDataException: DB2 SQL
       Error: SQLCODE=-302, SQLSTATE=22001, SQLERRMC=null,
       DRIVER=4.15.113
       SQLCODE=-302, SQLSTATE=22001 usually means: - Data being
       inserted into the database table column is larger than
       the assigned column length

[{"Product":{"code":"SS4GSP","label":"IBM UrbanCode Deploy"},"Business Unit":{"code":"BU048","label":"IBM Software"},"Component":"General Information","Platform":[{"code":"PF002","label":"AIX"},{"code":"PF016","label":"Linux"},{"code":"PF033","label":"Windows"},{"code":"PF035","label":"z\/OS"}],"Version":"6.1;6.1.1;6.1.2;6.1.3;6.2","Edition":"","Line of Business":{"code":"LOB77","label":"Automation Platform"}}]

Log InLog in to view more of this document

This document has the abstract of a technical article that is available to authorized users once you have logged on. Please use Log in button above to access the full document. After log in, if you do not have the right authorization for this document, there will be instructions on what to do next.

Document Information

Modified date:
17 June 2018

UID

swg21970137

Page Feedback