IBM Support

Deployment process gets stuck or server log shows SQLCODE=22001 when using Db2 as database

Troubleshooting


Problem

Complex deployment process with multiple steps, or component processes called gets stuck and cannot be cancelled.

Symptom

  • Server log contains error messages
2020-01-01 01:02,345 ERROR WorkflowRuntime-182 org.hibernate.util.JDBCExceptionReporter - DB2 SQL Error: SQLCODE=-302, SQLSTATE=22001, SQLERRMC=null, DRIVER=3.63.123
2018-02-20 01:02,345 ERROR WorkflowRuntime-182 com.urbancode.air.workflow.WorkflowRuntime - Uncaught exception in workflow 2fb5a3d6-9cc7-47fa-b467-28fad84aa4f1
org.hibernate.exception.DataException: could not update:
[com.urbancode.air.workflow.WorkflowRecord#2fb5a3d6-9cc7-47fa-b467-28fad84aa4f1]
at org.hibernate.exception.SQLStateConverter.convert(SQLStateConverter.java:102)
at org.hibernate.exception.JDBCExceptionHelper.convert(JDBCExceptionHelper.java:66)
at org.hibernate.persister.entity.AbstractEntityPersister.update(AbstractEntityPersister.java:2612)
at org.hibernate.persister.entity.AbstractEntityPersister.updateOrInsert(AbstractEntityPersister.java:2494)
at org.hibernate.persister.entity.AbstractEntityPersister.update(AbstractEntityPersister.java:2821)
at org.hibernate.action.EntityUpdateAction.execute(EntityUpdateAction.java:113)
...
at com.urbancode.air.workflow.persistence.WorkflowRuntimeStoreHibernate$1.commit(WorkflowRuntimeStoreHibernate.java:70)
at com.urbancode.air.workflow.WorkflowRuntime$TxWrapper.call(WorkflowRuntime.java:464)
...
Caused by: com.ibm.db2.jcc.am.SqlDataException: DB2 SQL Error: SQLCODE=-302, SQLSTATE=22001, SQLERRMC=null, DRIVER=3.63.123
...
at com.ibm.db2.jcc.am.io.executeUpdate(io.java:742)
at com.mchange.v2.c3p0.impl.NewProxyPreparedStatement.executeUpdate(NewProxyPreparedStatement.java:105)
at org.hibernate.jdbc.NonBatchingBatcher.addToBatch(NonBatchingBatcher.java:46)
at org.hibernate.persister.entity.AbstractEntityPersister.update(AbstractEntityPersister.java:2590)
...more

  • Complex deployment processes keep running in the Web user interface, cannot be cancelled and errors as indicated before shown in the server log.

Document Location

Worldwide


[{"Business Unit":{"code":"BU048","label":"IBM Software"},"Product":{"code":"SS4GSP","label":"IBM UrbanCode Deploy"},"Component":"","Platform":[{"code":"PF002","label":"AIX"},{"code":"PF016","label":"Linux"},{"code":"PF033","label":"Windows"}],"Version":"All Versions","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

More support for:
IBM UrbanCode Deploy

Software version:
All Versions

Operating system(s):
AIX, Linux, Windows

Document number:
5691944

Modified date:
13 April 2020

UID

ibm15691944

Manage My Notification Subscriptions