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.
Was this topic helpful?
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