[10/5/20 11:02:19:801 CEST] 00000150 LocalTransact E J2CA0024E: Method commit, within transaction branch ID {XidImpl: formatId(57415344), gtrid_length(36), bqual_length(40),, data(00000174f7ff53ae000000015f9657088e47d80177abe5ac8ca18e562e30040eb4df490900000174f7ff53ae000000015f9657088e47d80177abe5ac8ca18e562e30040eb4df490900000001)} of resource pool jdbc/ProcessEngine, caught com.ibm.ws.exception.WsException: DSRA0080E: An exception was received by the Data Store Adapter. See original exception message: ERROR: restart transaction: TransactionRetryWithProtoRefreshError: TransactionRetryError: retry txn (RETRY_SERIALIZABLE): "sql txn" meta={id=188ce2bb key=/Table/74/1/"7944078b-06e9-11eb-a03c-0242ac120009"/0 pri=0.00431906 epo=0 ts=1601888539.567908598,1 min=1601888539.567203988,0 seq=65} lock=true stat=PENDING rts=1601888539.567203988,0 wto=false max=1601888539.567203988,0. with SQL State : 40001 SQL Code : 0, at org.postgresql.core.v3.QueryExecutorImpl.receiveErrorResponse(QueryExecutorImpl.java:2553), at org.postgresql.core.v3.QueryExecutorImpl.processResults(QueryExecutorImpl.java:2285), at org.postgresql.core.v3.QueryExecutorImpl.execute(QueryExecutorImpl.java:323), at org.postgresql.jdbc.PgConnection.executeTransactionCommand(PgConnection.java:857), at org.postgresql.jdbc.PgConnection.commit(PgConnection.java:879), at sun.reflect.GeneratedMethodAccessor374.invoke(Unknown Source), at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:55), at java.lang.reflect.Method.invoke(Method.java:508), at org.postgresql.ds.PGPooledConnection$ConnectionHandler.invoke(PGPooledConnection.java:348), at com.sun.proxy.$Proxy123.commit(Unknown Source), at com.ibm.ws.rsadapter.spi.WSRdbSpiLocalTransactionImpl.commit(WSRdbSpiLocalTransactionImpl.java:396), at com.ibm.ejs.j2c.LocalTransactionWrapper.commit(LocalTransactionWrapper.java:281), at com.ibm.tx.jta.impl.OnePhaseResourceImpl.commit_one_phase(OnePhaseResourceImpl.java:145), at com.ibm.tx.jta.impl.RegisteredResources.flowCommitOnePhase(RegisteredResources.java:2398), at com.ibm.tx.jta.impl.TransactionImpl.commitXAResources(TransactionImpl.java:1829), at com.ibm.ws.tx.jta.TransactionImpl.stage1CommitProcessing(TransactionImpl.java:601), at com.ibm.tx.jta.impl.TransactionImpl.processCommit(TransactionImpl.java:1039), at com.ibm.tx.jta.impl.TransactionImpl.commit(TransactionImpl.java:973), at com.ibm.ws.tx.jta.TranManagerImpl.commit(TranManagerImpl.java:439), at com.ibm.tx.jta.impl.TranManagerSet.commit(TranManagerSet.java:191), at com.ibm.ws.uow.UOWManagerImpl.uowCommit(UOWManagerImpl.java:809), at com.ibm.ws.uow.embeddable.EmbeddableUOWManagerImpl.uowEnd(EmbeddableUOWManagerImpl.java:888), at com.ibm.ws.uow.UOWManagerImpl.uowEnd(UOWManagerImpl.java:784), at com.ibm.ws.uow.embeddable.EmbeddableUOWManagerImpl.runUnderNewUOW(EmbeddableUOWManagerImpl.java:825), at com.ibm.ws.uow.embeddable.EmbeddableUOWManagerImpl.runUnderUOW(EmbeddableUOWManagerImpl.java:377), at org.springframework.transaction.jta.WebSphereUowTransactionManager.execute(WebSphereUowTransactionManager.java:306), at org.springframework.transaction.support.TransactionTemplate.execute(TransactionTemplate.java:134), at org.camunda.bpm.engine.spring.SpringTransactionInterceptor.execute(SpringTransactionInterceptor.java:44), at org.camunda.bpm.engine.impl.interceptor.ProcessApplicationContextInterceptor.execute(ProcessApplicationContextInterceptor.java:70), at org.camunda.bpm.engine.impl.interceptor.CommandCounterInterceptor.execute(CommandCounterInterceptor.java:35), at org.camunda.bpm.engine.impl.interceptor.LogInterceptor.execute(LogInterceptor.java:33), at org.camunda.bpm.engine.impl.interceptor.CrdbTransactionRetryInterceptor.execute(CrdbTransactionRetryInterceptor.java:46), at org.camunda.bpm.engine.impl.jobexecutor.ExecuteJobHelper.executeJob(ExecuteJobHelper.java:57), at org.camunda.bpm.engine.impl.jobexecutor.ExecuteJobHelper.executeJob(ExecuteJobHelper.java:51), at org.camunda.bpm.container.impl.ejb.JobExecutionHandlerMDB.executeJob(JobExecutionHandlerMDB.java:44), at sun.reflect.GeneratedMethodAccessor827.invoke(Unknown Source), at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:55), at java.lang.reflect.Method.invoke(Method.java:508), at com.ibm.ejs.container.EJSContainer.invokeProceed(EJSContainer.java:5323), at com.ibm.ejs.container.interceptors.InvocationContextImpl.proceed(InvocationContextImpl.java:652), at com.ibm.ws.cdi.ejb.impl.InterceptorChain.proceed(InterceptorChain.java:115), at com.ibm.ws.cdi.ejb.impl.EJBCDIInterceptorWrapper.invokeInterceptors(EJBCDIInterceptorWrapper.java:140), at com.ibm.ws.cdi.ejb.impl.EJBCDIInterceptorWrapper.aroundInvoke(EJBCDIInterceptorWrapper.java:56), at sun.reflect.GeneratedMethodAccessor279.invoke(Unknown Source), at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:55), at java.lang.reflect.Method.invoke(Method.java:508), at com.ibm.ejs.container.interceptors.InterceptorProxy.invokeInterceptor(InterceptorProxy.java:201), at com.ibm.ejs.container.interceptors.InvocationContextImpl.proceed(InvocationContextImpl.java:632), at org.jboss.weld.ejb.AbstractEJBRequestScopeActivationInterceptor.aroundInvoke(AbstractEJBRequestScopeActivationInterceptor.java:73), at com.ibm.ws.cdi.ejb.impl.WeldSessionBeanInterceptorWrapper.aroundInvoke(WeldSessionBeanInterceptorWrapper.java:58), at sun.reflect.GeneratedMethodAccessor278.invoke(Unknown Source), at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:55), at java.lang.reflect.Method.invoke(Method.java:508), at com.ibm.ejs.container.interceptors.InterceptorProxy.invokeInterceptor(InterceptorProxy.java:201), at com.ibm.ejs.container.interceptors.InvocationContextImpl.proceed(InvocationContextImpl.java:632), at com.ibm.ejs.container.interceptors.InvocationContextImpl.doAroundInterceptor(InvocationContextImpl.java:306), at com.ibm.ejs.container.interceptors.InvocationContextImpl.doAroundInvoke(InvocationContextImpl.java:273), at com.ibm.ejs.container.EJSContainer.invoke(EJSContainer.java:5215), at org.camunda.bpm.container.impl.ejb.MDBProxyJobExecutionHandlerMDB_53d2ac45.executeJob(MDBProxyJobExecutionHandlerMDB_53d2ac45.java), at org.camunda.bpm.container.impl.threading.ra.inflow.JcaInflowExecuteJobsRunnable.executeJob(JcaInflowExecuteJobsRunnable.java:77), at org.camunda.bpm.engine.impl.jobexecutor.ExecuteJobsRunnable.run(ExecuteJobsRunnable.java:71), at org.camunda.bpm.container.impl.threading.ra.commonj.CommonjWorkRunnableAdapter.run(CommonjWorkRunnableAdapter.java:36), at com.ibm.ws.asynchbeans.J2EEContext.run(J2EEContext.java:1046), at com.ibm.ws.asynchbeans.WorkWithExecutionContextImpl.go(WorkWithExecutionContextImpl.java:199), at com.ibm.ws.asynchbeans.CJWorkItemImpl.run(CJWorkItemImpl.java:236), at com.ibm.ws.util.ThreadPool$Worker.run(ThreadPool.java:1892), Caused by: java.sql.SQLException: ERROR: restart transaction: TransactionRetryWithProtoRefreshError: TransactionRetryError: retry txn (RETRY_SERIALIZABLE): "sql txn" meta={id=188ce2bb key=/Table/74/1/"7944078b-06e9-11eb-a03c-0242ac120009"/0 pri=0.00431906 epo=0 ts=1601888539.567908598,1 min=1601888539.567203988,0 seq=65} lock=true stat=PENDING rts=1601888539.567203988,0 wto=false max=1601888539.567203988,0 DSRA0010E: SQL State = 40001, Error Code = 0, ... 66 more, and threw a XAException., [10/5/20 11:02:19:802 CEST] 00000150 RegisteredRes E WTRN0075W: Transaction camunda-ibm-websphere-ear#camunda-ibm-websphere-service.jar#JobExecutionHandlerMDB 00000174F7FF53AE000000015F9657088E47D80177ABE5AC8CA18E562E30040EB4DF490900000174F7FF53AE000000015F9657088E47D80177ABE5AC8CA18E562E30040EB4DF490900000001 received a heuristic exception when committing a resource., [10/5/20 11:02:19:802 CEST] 00000150 MCWrapper E J2CA0081E: Method cleanup failed while trying to execute method cleanup on ManagedConnection WSRdbManagedConnectionImpl@51b7bfbc from resource jdbc/ProcessEngine. Caught exception: com.ibm.ws.exception.WsException: DSRA0080E: An exception was received by the Data Store Adapter. See original exception message: Cannot call 'cleanup' on a ManagedConnection while it is still in a transaction.., at com.ibm.ws.rsadapter.exceptions.DataStoreAdapterException.(DataStoreAdapterException.java:256), at com.ibm.ws.rsadapter.exceptions.DataStoreAdapterException.(DataStoreAdapterException.java:205), at com.ibm.ws.rsadapter.AdapterUtil.createDataStoreAdapterException(AdapterUtil.java:447), at com.ibm.ws.rsadapter.spi.WSRdbManagedConnectionImpl.cleanupTransactions(WSRdbManagedConnectionImpl.java:4836), at com.ibm.ws.rsadapter.spi.WSRdbManagedConnectionImpl.cleanup(WSRdbManagedConnectionImpl.java:4216), at com.ibm.ejs.j2c.MCWrapper.cleanup(MCWrapper.java:1829), at com.ibm.ejs.j2c.FreePool.cleanupAndDestroyMCWrapper(FreePool.java:763), at com.ibm.ejs.j2c.FreePool.returnToFreePool(FreePool.java:528), at com.ibm.ejs.j2c.PoolManager.release(PoolManager.java:2925), at com.ibm.ejs.j2c.MCWrapper.releaseToPoolManager(MCWrapper.java:2618), at com.ibm.ejs.j2c.LocalTransactionWrapper.afterCompletion(LocalTransactionWrapper.java:1295), at com.ibm.tx.jta.impl.RegisteredSyncs.coreDistributeAfter(RegisteredSyncs.java:359), at com.ibm.ws.tx.jta.RegisteredSyncs.distributeAfter(RegisteredSyncs.java:320), at com.ibm.tx.jta.embeddable.impl.EmbeddableTransactionImpl.distributeAfter(EmbeddableTransactionImpl.java:208), at com.ibm.tx.jta.impl.TransactionImpl.postCompletion(TransactionImpl.java:2992), at com.ibm.tx.jta.impl.TransactionImpl.postCompletion(TransactionImpl.java:2893), at com.ibm.tx.jta.impl.TransactionImpl.commitXAResources(TransactionImpl.java:1875), at com.ibm.ws.tx.jta.TransactionImpl.stage1CommitProcessing(TransactionImpl.java:601), at com.ibm.tx.jta.impl.TransactionImpl.processCommit(TransactionImpl.java:1039), at com.ibm.tx.jta.impl.TransactionImpl.commit(TransactionImpl.java:973), at com.ibm.ws.tx.jta.TranManagerImpl.commit(TranManagerImpl.java:439), at com.ibm.tx.jta.impl.TranManagerSet.commit(TranManagerSet.java:191), at com.ibm.ws.uow.UOWManagerImpl.uowCommit(UOWManagerImpl.java:809), at com.ibm.ws.uow.embeddable.EmbeddableUOWManagerImpl.uowEnd(EmbeddableUOWManagerImpl.java:888), at com.ibm.ws.uow.UOWManagerImpl.uowEnd(UOWManagerImpl.java:784), at com.ibm.ws.uow.embeddable.EmbeddableUOWManagerImpl.runUnderNewUOW(EmbeddableUOWManagerImpl.java:825), at com.ibm.ws.uow.embeddable.EmbeddableUOWManagerImpl.runUnderUOW(EmbeddableUOWManagerImpl.java:377), at org.springframework.transaction.jta.WebSphereUowTransactionManager.execute(WebSphereUowTransactionManager.java:306), at org.springframework.transaction.support.TransactionTemplate.execute(TransactionTemplate.java:134), at org.camunda.bpm.engine.spring.SpringTransactionInterceptor.execute(SpringTransactionInterceptor.java:44), at org.camunda.bpm.engine.impl.interceptor.ProcessApplicationContextInterceptor.execute(ProcessApplicationContextInterceptor.java:70), at org.camunda.bpm.engine.impl.interceptor.CommandCounterInterceptor.execute(CommandCounterInterceptor.java:35), at org.camunda.bpm.engine.impl.interceptor.LogInterceptor.execute(LogInterceptor.java:33), at org.camunda.bpm.engine.impl.interceptor.CrdbTransactionRetryInterceptor.execute(CrdbTransactionRetryInterceptor.java:46), at org.camunda.bpm.engine.impl.jobexecutor.ExecuteJobHelper.executeJob(ExecuteJobHelper.java:57), at org.camunda.bpm.engine.impl.jobexecutor.ExecuteJobHelper.executeJob(ExecuteJobHelper.java:51), at org.camunda.bpm.container.impl.ejb.JobExecutionHandlerMDB.executeJob(JobExecutionHandlerMDB.java:44), at sun.reflect.GeneratedMethodAccessor827.invoke(Unknown Source), at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:55), at java.lang.reflect.Method.invoke(Method.java:508), at com.ibm.ejs.container.EJSContainer.invokeProceed(EJSContainer.java:5323), at com.ibm.ejs.container.interceptors.InvocationContextImpl.proceed(InvocationContextImpl.java:652), at com.ibm.ws.cdi.ejb.impl.InterceptorChain.proceed(InterceptorChain.java:115), at com.ibm.ws.cdi.ejb.impl.EJBCDIInterceptorWrapper.invokeInterceptors(EJBCDIInterceptorWrapper.java:140), at com.ibm.ws.cdi.ejb.impl.EJBCDIInterceptorWrapper.aroundInvoke(EJBCDIInterceptorWrapper.java:56), at sun.reflect.GeneratedMethodAccessor279.invoke(Unknown Source), at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:55), at java.lang.reflect.Method.invoke(Method.java:508), at com.ibm.ejs.container.interceptors.InterceptorProxy.invokeInterceptor(InterceptorProxy.java:201), at com.ibm.ejs.container.interceptors.InvocationContextImpl.proceed(InvocationContextImpl.java:632), at org.jboss.weld.ejb.AbstractEJBRequestScopeActivationInterceptor.aroundInvoke(AbstractEJBRequestScopeActivationInterceptor.java:73), at com.ibm.ws.cdi.ejb.impl.WeldSessionBeanInterceptorWrapper.aroundInvoke(WeldSessionBeanInterceptorWrapper.java:58), at sun.reflect.GeneratedMethodAccessor278.invoke(Unknown Source), at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:55), at java.lang.reflect.Method.invoke(Method.java:508), at com.ibm.ejs.container.interceptors.InterceptorProxy.invokeInterceptor(InterceptorProxy.java:201), at com.ibm.ejs.container.interceptors.InvocationContextImpl.proceed(InvocationContextImpl.java:632), at com.ibm.ejs.container.interceptors.InvocationContextImpl.doAroundInterceptor(InvocationContextImpl.java:306), at com.ibm.ejs.container.interceptors.InvocationContextImpl.doAroundInvoke(InvocationContextImpl.java:273), at com.ibm.ejs.container.EJSContainer.invoke(EJSContainer.java:5215), at org.camunda.bpm.container.impl.ejb.MDBProxyJobExecutionHandlerMDB_53d2ac45.executeJob(MDBProxyJobExecutionHandlerMDB_53d2ac45.java), at org.camunda.bpm.container.impl.threading.ra.inflow.JcaInflowExecuteJobsRunnable.executeJob(JcaInflowExecuteJobsRunnable.java:77), at org.camunda.bpm.engine.impl.jobexecutor.ExecuteJobsRunnable.run(ExecuteJobsRunnable.java:71), at org.camunda.bpm.container.impl.threading.ra.commonj.CommonjWorkRunnableAdapter.run(CommonjWorkRunnableAdapter.java:36), at com.ibm.ws.asynchbeans.J2EEContext.run(J2EEContext.java:1046), at com.ibm.ws.asynchbeans.WorkWithExecutionContextImpl.go(WorkWithExecutionContextImpl.java:199), at com.ibm.ws.asynchbeans.CJWorkItemImpl.run(CJWorkItemImpl.java:236), at com.ibm.ws.util.ThreadPool$Worker.run(ThreadPool.java:1892), , [10/5/20 11:02:19:867 CEST] 0000014e LocalExceptio E CNTR0020E: EJB threw an unexpected (non-declared) exception during invocation of method "executeJob" on bean "BeanId(camunda-ibm-websphere-ear#camunda-ibm-websphere-service.jar#JobExecutionHandlerMDB, null)". Exception data: org.springframework.transaction.TransactionSystemException: UOWManager transaction processing failed; nested exception is com.ibm.wsspi.uow.UOWException: javax.transaction.HeuristicMixedException, at org.springframework.transaction.jta.WebSphereUowTransactionManager.execute(WebSphereUowTransactionManager.java:313), at org.springframework.transaction.support.TransactionTemplate.execute(TransactionTemplate.java:134), at org.camunda.bpm.engine.spring.SpringTransactionInterceptor.execute(SpringTransactionInterceptor.java:44), at org.camunda.bpm.engine.impl.interceptor.ProcessApplicationContextInterceptor.execute(ProcessApplicationContextInterceptor.java:70), at org.camunda.bpm.engine.impl.interceptor.CommandCounterInterceptor.execute(CommandCounterInterceptor.java:35), at org.camunda.bpm.engine.impl.interceptor.LogInterceptor.execute(LogInterceptor.java:33), at org.camunda.bpm.engine.impl.interceptor.CrdbTransactionRetryInterceptor.execute(CrdbTransactionRetryInterceptor.java:46), at org.camunda.bpm.engine.impl.jobexecutor.ExecuteJobHelper.executeJob(ExecuteJobHelper.java:57), at org.camunda.bpm.engine.impl.jobexecutor.ExecuteJobHelper.executeJob(ExecuteJobHelper.java:51), at org.camunda.bpm.container.impl.ejb.JobExecutionHandlerMDB.executeJob(JobExecutionHandlerMDB.java:44), at sun.reflect.GeneratedMethodAccessor827.invoke(Unknown Source), at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:55), at java.lang.reflect.Method.invoke(Method.java:508), at com.ibm.ejs.container.EJSContainer.invokeProceed(EJSContainer.java:5323), at com.ibm.ejs.container.interceptors.InvocationContextImpl.proceed(InvocationContextImpl.java:652), at com.ibm.ws.cdi.ejb.impl.InterceptorChain.proceed(InterceptorChain.java:115), at com.ibm.ws.cdi.ejb.impl.EJBCDIInterceptorWrapper.invokeInterceptors(EJBCDIInterceptorWrapper.java:140), at com.ibm.ws.cdi.ejb.impl.EJBCDIInterceptorWrapper.aroundInvoke(EJBCDIInterceptorWrapper.java:56), at sun.reflect.GeneratedMethodAccessor279.invoke(Unknown Source), at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:55), at java.lang.reflect.Method.invoke(Method.java:508), at com.ibm.ejs.container.interceptors.InterceptorProxy.invokeInterceptor(InterceptorProxy.java:201), at com.ibm.ejs.container.interceptors.InvocationContextImpl.proceed(InvocationContextImpl.java:632), at org.jboss.weld.ejb.AbstractEJBRequestScopeActivationInterceptor.aroundInvoke(AbstractEJBRequestScopeActivationInterceptor.java:73), at com.ibm.ws.cdi.ejb.impl.WeldSessionBeanInterceptorWrapper.aroundInvoke(WeldSessionBeanInterceptorWrapper.java:58), at sun.reflect.GeneratedMethodAccessor278.invoke(Unknown Source), at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:55), at java.lang.reflect.Method.invoke(Method.java:508), at com.ibm.ejs.container.interceptors.InterceptorProxy.invokeInterceptor(InterceptorProxy.java:201), at com.ibm.ejs.container.interceptors.InvocationContextImpl.proceed(InvocationContextImpl.java:632), at com.ibm.ejs.container.interceptors.InvocationContextImpl.doAroundInterceptor(InvocationContextImpl.java:306), at com.ibm.ejs.container.interceptors.InvocationContextImpl.doAroundInvoke(InvocationContextImpl.java:273), at com.ibm.ejs.container.EJSContainer.invoke(EJSContainer.java:5215), at org.camunda.bpm.container.impl.ejb.MDBProxyJobExecutionHandlerMDB_53d2ac45.executeJob(MDBProxyJobExecutionHandlerMDB_53d2ac45.java), at org.camunda.bpm.container.impl.threading.ra.inflow.JcaInflowExecuteJobsRunnable.executeJob(JcaInflowExecuteJobsRunnable.java:77), at org.camunda.bpm.engine.impl.jobexecutor.ExecuteJobsRunnable.run(ExecuteJobsRunnable.java:71), at org.camunda.bpm.container.impl.threading.ra.commonj.CommonjWorkRunnableAdapter.run(CommonjWorkRunnableAdapter.java:36), at com.ibm.ws.asynchbeans.J2EEContext.run(J2EEContext.java:1046), at com.ibm.ws.asynchbeans.WorkWithExecutionContextImpl.go(WorkWithExecutionContextImpl.java:199), at com.ibm.ws.asynchbeans.CJWorkItemImpl.run(CJWorkItemImpl.java:236), at com.ibm.ws.util.ThreadPool$Worker.run(ThreadPool.java:1892), Caused by: com.ibm.wsspi.uow.UOWException: javax.transaction.HeuristicMixedException, at com.ibm.ws.uow.embeddable.EmbeddableUOWManagerImpl.runUnderNewUOW(EmbeddableUOWManagerImpl.java:830), at com.ibm.ws.uow.embeddable.EmbeddableUOWManagerImpl.runUnderUOW(EmbeddableUOWManagerImpl.java:377), at org.springframework.transaction.jta.WebSphereUowTransactionManager.execute(WebSphereUowTransactionManager.java:306), ... 40 more, Caused by: javax.transaction.HeuristicMixedException, at com.ibm.tx.jta.impl.TransactionImpl.commit(TransactionImpl.java:979), at com.ibm.ws.tx.jta.TranManagerImpl.commit(TranManagerImpl.java:439), at com.ibm.tx.jta.impl.TranManagerSet.commit(TranManagerSet.java:191), at com.ibm.ws.uow.UOWManagerImpl.uowCommit(UOWManagerImpl.java:809), at com.ibm.ws.uow.embeddable.EmbeddableUOWManagerImpl.uowEnd(EmbeddableUOWManagerImpl.java:888), at com.ibm.ws.uow.UOWManagerImpl.uowEnd(UOWManagerImpl.java:784), at com.ibm.ws.uow.embeddable.EmbeddableUOWManagerImpl.runUnderNewUOW(EmbeddableUOWManagerImpl.java:825), ... 42 more, Caused by: javax.transaction.xa.XAException, at com.ibm.ejs.j2c.LocalTransactionWrapper.commit(LocalTransactionWrapper.java:305), at com.ibm.tx.jta.impl.OnePhaseResourceImpl.commit_one_phase(OnePhaseResourceImpl.java:145), at com.ibm.tx.jta.impl.RegisteredResources.flowCommitOnePhase(RegisteredResources.java:2398), at com.ibm.tx.jta.impl.TransactionImpl.commitXAResources(TransactionImpl.java:1829), at com.ibm.ws.tx.jta.TransactionImpl.stage1CommitProcessing(TransactionImpl.java:601), at com.ibm.tx.jta.impl.TransactionImpl.processCommit(TransactionImpl.java:1039), at com.ibm.tx.jta.impl.TransactionImpl.commit(TransactionImpl.java:973), ... 48 more, Caused by: com.ibm.ws.rsadapter.exceptions.DataStoreAdapterException: DSRA0080E: An exception was received by the Data Store Adapter. See original exception message: ERROR: restart transaction: TransactionRetryWithProtoRefreshError: TransactionRetryError: retry txn (RETRY_SERIALIZABLE): "sql txn" meta={id=df3749eb key=/Table/81/1/"7945400f-06e9-11eb-a03c-0242ac120009"/0 pri=0.00926103 epo=0 ts=1601888539.567908598,1 min=1601888539.484682777,0 seq=42} lock=true stat=PENDING rts=1601888539.484682777,0 wto=false max=1601888539.484682777,0., at com.ibm.ws.rsadapter.AdapterUtil.translateSQLException(AdapterUtil.java:1590), at com.ibm.ws.rsadapter.spi.WSRdbSpiLocalTransactionImpl.commit(WSRdbSpiLocalTransactionImpl.java:417), at com.ibm.ejs.j2c.LocalTransactionWrapper.commit(LocalTransactionWrapper.java:281), ... 54 more, Caused by: java.sql.SQLException: ERROR: restart transaction: TransactionRetryWithProtoRefreshError: TransactionRetryError: retry txn (RETRY_SERIALIZABLE): "sql txn" meta={id=df3749eb key=/Table/81/1/"7945400f-06e9-11eb-a03c-0242ac120009"/0 pri=0.00926103 epo=0 ts=1601888539.567908598,1 min=1601888539.484682777,0 seq=42} lock=true stat=PENDING rts=1601888539.484682777,0 wto=false max=1601888539.484682777,0 DSRA0010E: SQL State = 40001, Error Code = 0, at org.postgresql.core.v3.QueryExecutorImpl.receiveErrorResponse(QueryExecutorImpl.java:2553), at org.postgresql.core.v3.QueryExecutorImpl.processResults(QueryExecutorImpl.java:2285), at org.postgresql.core.v3.QueryExecutorImpl.execute(QueryExecutorImpl.java:323), at org.postgresql.jdbc.PgConnection.executeTransactionCommand(PgConnection.java:857), at org.postgresql.jdbc.PgConnection.commit(PgConnection.java:879), at sun.reflect.GeneratedMethodAccessor374.invoke(Unknown Source), at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:55), at java.lang.reflect.Method.invoke(Method.java:508), at org.postgresql.ds.PGPooledConnection$ConnectionHandler.invoke(PGPooledConnection.java:348), at com.sun.proxy.$Proxy123.commit(Unknown Source), at com.ibm.ws.rsadapter.spi.WSRdbSpiLocalTransactionImpl.commit(WSRdbSpiLocalTransactionImpl.java:396), ... 55 more, , [10/5/20 11:02:19:869 CEST] 0000014e JcaInflowExec W Exception while executing job with id '781cc563-06e9-11eb-a03c-0242ac120009'., com.ibm.ejs.container.UnknownLocalException: nested exception is: org.springframework.transaction.TransactionSystemException: UOWManager transaction processing failed; nested exception is com.ibm.wsspi.uow.UOWException: javax.transaction.HeuristicMixedException, at org.springframework.transaction.jta.WebSphereUowTransactionManager.execute(WebSphereUowTransactionManager.java:313), at org.springframework.transaction.support.TransactionTemplate.execute(TransactionTemplate.java:134), at org.camunda.bpm.engine.spring.SpringTransactionInterceptor.execute(SpringTransactionInterceptor.java:44), at org.camunda.bpm.engine.impl.interceptor.ProcessApplicationContextInterceptor.execute(ProcessApplicationContextInterceptor.java:70), at org.camunda.bpm.engine.impl.interceptor.CommandCounterInterceptor.execute(CommandCounterInterceptor.java:35), at org.camunda.bpm.engine.impl.interceptor.LogInterceptor.execute(LogInterceptor.java:33), at org.camunda.bpm.engine.impl.interceptor.CrdbTransactionRetryInterceptor.execute(CrdbTransactionRetryInterceptor.java:46), at org.camunda.bpm.engine.impl.jobexecutor.ExecuteJobHelper.executeJob(ExecuteJobHelper.java:57), at org.camunda.bpm.engine.impl.jobexecutor.ExecuteJobHelper.executeJob(ExecuteJobHelper.java:51), at org.camunda.bpm.container.impl.ejb.JobExecutionHandlerMDB.executeJob(JobExecutionHandlerMDB.java:44), at sun.reflect.GeneratedMethodAccessor827.invoke(Unknown Source), at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:55), at java.lang.reflect.Method.invoke(Method.java:508), at com.ibm.ejs.container.EJSContainer.invokeProceed(EJSContainer.java:5323), at com.ibm.ejs.container.interceptors.InvocationContextImpl.proceed(InvocationContextImpl.java:652), at com.ibm.ws.cdi.ejb.impl.InterceptorChain.proceed(InterceptorChain.java:115), at com.ibm.ws.cdi.ejb.impl.EJBCDIInterceptorWrapper.invokeInterceptors(EJBCDIInterceptorWrapper.java:140), at com.ibm.ws.cdi.ejb.impl.EJBCDIInterceptorWrapper.aroundInvoke(EJBCDIInterceptorWrapper.java:56), at sun.reflect.GeneratedMethodAccessor279.invoke(Unknown Source), at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:55), at java.lang.reflect.Method.invoke(Method.java:508), at com.ibm.ejs.container.interceptors.InterceptorProxy.invokeInterceptor(InterceptorProxy.java:201), at com.ibm.ejs.container.interceptors.InvocationContextImpl.proceed(InvocationContextImpl.java:632), at org.jboss.weld.ejb.AbstractEJBRequestScopeActivationInterceptor.aroundInvoke(AbstractEJBRequestScopeActivationInterceptor.java:73), at com.ibm.ws.cdi.ejb.impl.WeldSessionBeanInterceptorWrapper.aroundInvoke(WeldSessionBeanInterceptorWrapper.java:58), at sun.reflect.GeneratedMethodAccessor278.invoke(Unknown Source), at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:55), at java.lang.reflect.Method.invoke(Method.java:508), at com.ibm.ejs.container.interceptors.InterceptorProxy.invokeInterceptor(InterceptorProxy.java:201), at com.ibm.ejs.container.interceptors.InvocationContextImpl.proceed(InvocationContextImpl.java:632), at com.ibm.ejs.container.interceptors.InvocationContextImpl.doAroundInterceptor(InvocationContextImpl.java:306), at com.ibm.ejs.container.interceptors.InvocationContextImpl.doAroundInvoke(InvocationContextImpl.java:273), at com.ibm.ejs.container.EJSContainer.invoke(EJSContainer.java:5215), at org.camunda.bpm.container.impl.ejb.MDBProxyJobExecutionHandlerMDB_53d2ac45.executeJob(MDBProxyJobExecutionHandlerMDB_53d2ac45.java), at org.camunda.bpm.container.impl.threading.ra.inflow.JcaInflowExecuteJobsRunnable.executeJob(JcaInflowExecuteJobsRunnable.java:77), at org.camunda.bpm.engine.impl.jobexecutor.ExecuteJobsRunnable.run(ExecuteJobsRunnable.java:71), at org.camunda.bpm.container.impl.threading.ra.commonj.CommonjWorkRunnableAdapter.run(CommonjWorkRunnableAdapter.java:36), at com.ibm.ws.asynchbeans.J2EEContext.run(J2EEContext.java:1046), at com.ibm.ws.asynchbeans.WorkWithExecutionContextImpl.go(WorkWithExecutionContextImpl.java:199), at com.ibm.ws.asynchbeans.CJWorkItemImpl.run(CJWorkItemImpl.java:236), at com.ibm.ws.util.ThreadPool$Worker.run(ThreadPool.java:1892), Caused by: org.springframework.transaction.TransactionSystemException: UOWManager transaction processing failed; nested exception is com.ibm.wsspi.uow.UOWException: javax.transaction.HeuristicMixedException, ... 41 more, Caused by: com.ibm.wsspi.uow.UOWException: javax.transaction.HeuristicMixedException, at com.ibm.ws.uow.embeddable.EmbeddableUOWManagerImpl.runUnderNewUOW(EmbeddableUOWManagerImpl.java:830), at com.ibm.ws.uow.embeddable.EmbeddableUOWManagerImpl.runUnderUOW(EmbeddableUOWManagerImpl.java:377), at org.springframework.transaction.jta.WebSphereUowTransactionManager.execute(WebSphereUowTransactionManager.java:306), ... 40 more, Caused by: javax.transaction.HeuristicMixedException, at com.ibm.tx.jta.impl.TransactionImpl.commit(TransactionImpl.java:979), at com.ibm.ws.tx.jta.TranManagerImpl.commit(TranManagerImpl.java:439), at com.ibm.tx.jta.impl.TranManagerSet.commit(TranManagerSet.java:191), at com.ibm.ws.uow.UOWManagerImpl.uowCommit(UOWManagerImpl.java:809), at com.ibm.ws.uow.embeddable.EmbeddableUOWManagerImpl.uowEnd(EmbeddableUOWManagerImpl.java:888), at com.ibm.ws.uow.UOWManagerImpl.uowEnd(UOWManagerImpl.java:784), at com.ibm.ws.uow.embeddable.EmbeddableUOWManagerImpl.runUnderNewUOW(EmbeddableUOWManagerImpl.java:825), ... 42 more, Caused by: javax.transaction.xa.XAException, at com.ibm.ejs.j2c.LocalTransactionWrapper.commit(LocalTransactionWrapper.java:305), at com.ibm.tx.jta.impl.OnePhaseResourceImpl.commit_one_phase(OnePhaseResourceImpl.java:145), at com.ibm.tx.jta.impl.RegisteredResources.flowCommitOnePhase(RegisteredResources.java:2398), at com.ibm.tx.jta.impl.TransactionImpl.commitXAResources(TransactionImpl.java:1829), at com.ibm.ws.tx.jta.TransactionImpl.stage1CommitProcessing(TransactionImpl.java:601), at com.ibm.tx.jta.impl.TransactionImpl.processCommit(TransactionImpl.java:1039), at com.ibm.tx.jta.impl.TransactionImpl.commit(TransactionImpl.java:973), ... 48 more, Caused by: com.ibm.ws.rsadapter.exceptions.DataStoreAdapterException: DSRA0080E: An exception was received by the Data Store Adapter. See original exception message: ERROR: restart transaction: TransactionRetryWithProtoRefreshError: TransactionRetryError: retry txn (RETRY_SERIALIZABLE): "sql txn" meta={id=df3749eb key=/Table/81/1/"7945400f-06e9-11eb-a03c-0242ac120009"/0 pri=0.00926103 epo=0 ts=1601888539.567908598,1 min=1601888539.484682777,0 seq=42} lock=true stat=PENDING rts=1601888539.484682777,0 wto=false max=1601888539.484682777,0., at com.ibm.ws.rsadapter.AdapterUtil.translateSQLException(AdapterUtil.java:1590), at com.ibm.ws.rsadapter.spi.WSRdbSpiLocalTransactionImpl.commit(WSRdbSpiLocalTransactionImpl.java:417), at com.ibm.ejs.j2c.LocalTransactionWrapper.commit(LocalTransactionWrapper.java:281), ... 54 more, Caused by: java.sql.SQLException: ERROR: restart transaction: TransactionRetryWithProtoRefreshError: TransactionRetryError: retry txn (RETRY_SERIALIZABLE): "sql txn" meta={id=df3749eb key=/Table/81/1/"7945400f-06e9-11eb-a03c-0242ac120009"/0 pri=0.00926103 epo=0 ts=1601888539.567908598,1 min=1601888539.484682777,0 seq=42} lock=true stat=PENDING rts=1601888539.484682777,0 wto=false max=1601888539.484682777,0 DSRA0010E: SQL State = 40001, Error Code = 0, at org.postgresql.core.v3.QueryExecutorImpl.receiveErrorResponse(QueryExecutorImpl.java:2553), at org.postgresql.core.v3.QueryExecutorImpl.processResults(QueryExecutorImpl.java:2285), at org.postgresql.core.v3.QueryExecutorImpl.execute(QueryExecutorImpl.java:323), at org.postgresql.jdbc.PgConnection.executeTransactionCommand(PgConnection.java:857), at org.postgresql.jdbc.PgConnection.commit(PgConnection.java:879), at sun.reflect.GeneratedMethodAccessor374.invoke(Unknown Source), at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:55), at java.lang.reflect.Method.invoke(Method.java:508), at org.postgresql.ds.PGPooledConnection$ConnectionHandler.invoke(PGPooledConnection.java:348), at com.sun.proxy.$Proxy123.commit(Unknown Source), at com.ibm.ws.rsadapter.spi.WSRdbSpiLocalTransactionImpl.commit(WSRdbSpiLocalTransactionImpl.java:396), ... 55 more, , [10/5/20 11:02:19:870 CEST] 0000014e LocalTranCoor E WLTC0017E: Resources rolled back due to setRollbackOnly() being called., [10/5/20 11:02:19:897 CEST] 00000150 LocalExceptio E CNTR0020E: EJB threw an unexpected (non-declared) exception during invocation of method "executeJob" on bean "BeanId(camunda-ibm-websphere-ear#camunda-ibm-websphere-service.jar#JobExecutionHandlerMDB, null)". Exception data: org.springframework.transaction.TransactionSystemException: UOWManager transaction processing failed; nested exception is com.ibm.wsspi.uow.UOWException: javax.transaction.HeuristicMixedException, at org.springframework.transaction.jta.WebSphereUowTransactionManager.execute(WebSphereUowTransactionManager.java:313), at org.springframework.transaction.support.TransactionTemplate.execute(TransactionTemplate.java:134), at org.camunda.bpm.engine.spring.SpringTransactionInterceptor.execute(SpringTransactionInterceptor.java:44), at org.camunda.bpm.engine.impl.interceptor.ProcessApplicationContextInterceptor.execute(ProcessApplicationContextInterceptor.java:70), at org.camunda.bpm.engine.impl.interceptor.CommandCounterInterceptor.execute(CommandCounterInterceptor.java:35), at org.camunda.bpm.engine.impl.interceptor.LogInterceptor.execute(LogInterceptor.java:33), at org.camunda.bpm.engine.impl.interceptor.CrdbTransactionRetryInterceptor.execute(CrdbTransactionRetryInterceptor.java:46), at org.camunda.bpm.engine.impl.jobexecutor.ExecuteJobHelper.executeJob(ExecuteJobHelper.java:57), at org.camunda.bpm.engine.impl.jobexecutor.ExecuteJobHelper.executeJob(ExecuteJobHelper.java:51), at org.camunda.bpm.container.impl.ejb.JobExecutionHandlerMDB.executeJob(JobExecutionHandlerMDB.java:44), at sun.reflect.GeneratedMethodAccessor827.invoke(Unknown Source), at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:55), at java.lang.reflect.Method.invoke(Method.java:508), at com.ibm.ejs.container.EJSContainer.invokeProceed(EJSContainer.java:5323), at com.ibm.ejs.container.interceptors.InvocationContextImpl.proceed(InvocationContextImpl.java:652), at com.ibm.ws.cdi.ejb.impl.InterceptorChain.proceed(InterceptorChain.java:115), at com.ibm.ws.cdi.ejb.impl.EJBCDIInterceptorWrapper.invokeInterceptors(EJBCDIInterceptorWrapper.java:140), at com.ibm.ws.cdi.ejb.impl.EJBCDIInterceptorWrapper.aroundInvoke(EJBCDIInterceptorWrapper.java:56), at sun.reflect.GeneratedMethodAccessor279.invoke(Unknown Source), at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:55), at java.lang.reflect.Method.invoke(Method.java:508), at com.ibm.ejs.container.interceptors.InterceptorProxy.invokeInterceptor(InterceptorProxy.java:201), at com.ibm.ejs.container.interceptors.InvocationContextImpl.proceed(InvocationContextImpl.java:632), at org.jboss.weld.ejb.AbstractEJBRequestScopeActivationInterceptor.aroundInvoke(AbstractEJBRequestScopeActivationInterceptor.java:73), at com.ibm.ws.cdi.ejb.impl.WeldSessionBeanInterceptorWrapper.aroundInvoke(WeldSessionBeanInterceptorWrapper.java:58), at sun.reflect.GeneratedMethodAccessor278.invoke(Unknown Source), at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:55), at java.lang.reflect.Method.invoke(Method.java:508), at com.ibm.ejs.container.interceptors.InterceptorProxy.invokeInterceptor(InterceptorProxy.java:201), at com.ibm.ejs.container.interceptors.InvocationContextImpl.proceed(InvocationContextImpl.java:632), at com.ibm.ejs.container.interceptors.InvocationContextImpl.doAroundInterceptor(InvocationContextImpl.java:306), at com.ibm.ejs.container.interceptors.InvocationContextImpl.doAroundInvoke(InvocationContextImpl.java:273), at com.ibm.ejs.container.EJSContainer.invoke(EJSContainer.java:5215), at org.camunda.bpm.container.impl.ejb.MDBProxyJobExecutionHandlerMDB_53d2ac45.executeJob(MDBProxyJobExecutionHandlerMDB_53d2ac45.java), at org.camunda.bpm.container.impl.threading.ra.inflow.JcaInflowExecuteJobsRunnable.executeJob(JcaInflowExecuteJobsRunnable.java:77), at org.camunda.bpm.engine.impl.jobexecutor.ExecuteJobsRunnable.run(ExecuteJobsRunnable.java:71), at org.camunda.bpm.container.impl.threading.ra.commonj.CommonjWorkRunnableAdapter.run(CommonjWorkRunnableAdapter.java:36), at com.ibm.ws.asynchbeans.J2EEContext.run(J2EEContext.java:1046), at com.ibm.ws.asynchbeans.WorkWithExecutionContextImpl.go(WorkWithExecutionContextImpl.java:199), at com.ibm.ws.asynchbeans.CJWorkItemImpl.run(CJWorkItemImpl.java:236), at com.ibm.ws.util.ThreadPool$Worker.run(ThreadPool.java:1892), Caused by: com.ibm.wsspi.uow.UOWException: javax.transaction.HeuristicMixedException, at com.ibm.ws.uow.embeddable.EmbeddableUOWManagerImpl.runUnderNewUOW(EmbeddableUOWManagerImpl.java:830), at com.ibm.ws.uow.embeddable.EmbeddableUOWManagerImpl.runUnderUOW(EmbeddableUOWManagerImpl.java:377), at org.springframework.transaction.jta.WebSphereUowTransactionManager.execute(WebSphereUowTransactionManager.java:306), ... 40 more, Caused by: javax.transaction.HeuristicMixedException, at com.ibm.tx.jta.impl.TransactionImpl.commit(TransactionImpl.java:979), at com.ibm.ws.tx.jta.TranManagerImpl.commit(TranManagerImpl.java:439), at com.ibm.tx.jta.impl.TranManagerSet.commit(TranManagerSet.java:191), at com.ibm.ws.uow.UOWManagerImpl.uowCommit(UOWManagerImpl.java:809), at com.ibm.ws.uow.embeddable.EmbeddableUOWManagerImpl.uowEnd(EmbeddableUOWManagerImpl.java:888), at com.ibm.ws.uow.UOWManagerImpl.uowEnd(UOWManagerImpl.java:784), at com.ibm.ws.uow.embeddable.EmbeddableUOWManagerImpl.runUnderNewUOW(EmbeddableUOWManagerImpl.java:825), ... 42 more, Caused by: javax.transaction.xa.XAException, at com.ibm.ejs.j2c.LocalTransactionWrapper.commit(LocalTransactionWrapper.java:305), at com.ibm.tx.jta.impl.OnePhaseResourceImpl.commit_one_phase(OnePhaseResourceImpl.java:145), at com.ibm.tx.jta.impl.RegisteredResources.flowCommitOnePhase(RegisteredResources.java:2398), at com.ibm.tx.jta.impl.TransactionImpl.commitXAResources(TransactionImpl.java:1829), at com.ibm.ws.tx.jta.TransactionImpl.stage1CommitProcessing(TransactionImpl.java:601), at com.ibm.tx.jta.impl.TransactionImpl.processCommit(TransactionImpl.java:1039), at com.ibm.tx.jta.impl.TransactionImpl.commit(TransactionImpl.java:973), ... 48 more, Caused by: com.ibm.ws.rsadapter.exceptions.DataStoreAdapterException: DSRA0080E: An exception was received by the Data Store Adapter. See original exception message: ERROR: restart transaction: TransactionRetryWithProtoRefreshError: TransactionRetryError: retry txn (RETRY_SERIALIZABLE): "sql txn" meta={id=188ce2bb key=/Table/74/1/"7944078b-06e9-11eb-a03c-0242ac120009"/0 pri=0.00431906 epo=0 ts=1601888539.567908598,1 min=1601888539.567203988,0 seq=65} lock=true stat=PENDING rts=1601888539.567203988,0 wto=false max=1601888539.567203988,0., at com.ibm.ws.rsadapter.AdapterUtil.translateSQLException(AdapterUtil.java:1590), at com.ibm.ws.rsadapter.spi.WSRdbSpiLocalTransactionImpl.commit(WSRdbSpiLocalTransactionImpl.java:417), at com.ibm.ejs.j2c.LocalTransactionWrapper.commit(LocalTransactionWrapper.java:281), ... 54 more, Caused by: java.sql.SQLException: ERROR: restart transaction: TransactionRetryWithProtoRefreshError: TransactionRetryError: retry txn (RETRY_SERIALIZABLE): "sql txn" meta={id=188ce2bb key=/Table/74/1/"7944078b-06e9-11eb-a03c-0242ac120009"/0 pri=0.00431906 epo=0 ts=1601888539.567908598,1 min=1601888539.567203988,0 seq=65} lock=true stat=PENDING rts=1601888539.567203988,0 wto=false max=1601888539.567203988,0 DSRA0010E: SQL State = 40001, Error Code = 0, at org.postgresql.core.v3.QueryExecutorImpl.receiveErrorResponse(QueryExecutorImpl.java:2553), at org.postgresql.core.v3.QueryExecutorImpl.processResults(QueryExecutorImpl.java:2285), at org.postgresql.core.v3.QueryExecutorImpl.execute(QueryExecutorImpl.java:323), at org.postgresql.jdbc.PgConnection.executeTransactionCommand(PgConnection.java:857), at org.postgresql.jdbc.PgConnection.commit(PgConnection.java:879), at sun.reflect.GeneratedMethodAccessor374.invoke(Unknown Source), at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:55), at java.lang.reflect.Method.invoke(Method.java:508), at org.postgresql.ds.PGPooledConnection$ConnectionHandler.invoke(PGPooledConnection.java:348), at com.sun.proxy.$Proxy123.commit(Unknown Source), at com.ibm.ws.rsadapter.spi.WSRdbSpiLocalTransactionImpl.commit(WSRdbSpiLocalTransactionImpl.java:396), ... 55 more, , [10/5/20 11:02:19:898 CEST] 00000150 JcaInflowExec W Exception while executing job with id '781c7732-06e9-11eb-a03c-0242ac120009'., com.ibm.ejs.container.UnknownLocalException: nested exception is: org.springframework.transaction.TransactionSystemException: UOWManager transaction processing failed; nested exception is com.ibm.wsspi.uow.UOWException: javax.transaction.HeuristicMixedException, at org.springframework.transaction.jta.WebSphereUowTransactionManager.execute(WebSphereUowTransactionManager.java:313), at org.springframework.transaction.support.TransactionTemplate.execute(TransactionTemplate.java:134), at org.camunda.bpm.engine.spring.SpringTransactionInterceptor.execute(SpringTransactionInterceptor.java:44), at org.camunda.bpm.engine.impl.interceptor.ProcessApplicationContextInterceptor.execute(ProcessApplicationContextInterceptor.java:70), at org.camunda.bpm.engine.impl.interceptor.CommandCounterInterceptor.execute(CommandCounterInterceptor.java:35), at org.camunda.bpm.engine.impl.interceptor.LogInterceptor.execute(LogInterceptor.java:33), at org.camunda.bpm.engine.impl.interceptor.CrdbTransactionRetryInterceptor.execute(CrdbTransactionRetryInterceptor.java:46), at org.camunda.bpm.engine.impl.jobexecutor.ExecuteJobHelper.executeJob(ExecuteJobHelper.java:57), at org.camunda.bpm.engine.impl.jobexecutor.ExecuteJobHelper.executeJob(ExecuteJobHelper.java:51), at org.camunda.bpm.container.impl.ejb.JobExecutionHandlerMDB.executeJob(JobExecutionHandlerMDB.java:44), at sun.reflect.GeneratedMethodAccessor827.invoke(Unknown Source), at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:55), at java.lang.reflect.Method.invoke(Method.java:508), at com.ibm.ejs.container.EJSContainer.invokeProceed(EJSContainer.java:5323), at com.ibm.ejs.container.interceptors.InvocationContextImpl.proceed(InvocationContextImpl.java:652), at com.ibm.ws.cdi.ejb.impl.InterceptorChain.proceed(InterceptorChain.java:115), at com.ibm.ws.cdi.ejb.impl.EJBCDIInterceptorWrapper.invokeInterceptors(EJBCDIInterceptorWrapper.java:140), at com.ibm.ws.cdi.ejb.impl.EJBCDIInterceptorWrapper.aroundInvoke(EJBCDIInterceptorWrapper.java:56), at sun.reflect.GeneratedMethodAccessor279.invoke(Unknown Source), at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:55), at java.lang.reflect.Method.invoke(Method.java:508), at com.ibm.ejs.container.interceptors.InterceptorProxy.invokeInterceptor(InterceptorProxy.java:201), at com.ibm.ejs.container.interceptors.InvocationContextImpl.proceed(InvocationContextImpl.java:632), at org.jboss.weld.ejb.AbstractEJBRequestScopeActivationInterceptor.aroundInvoke(AbstractEJBRequestScopeActivationInterceptor.java:73), at com.ibm.ws.cdi.ejb.impl.WeldSessionBeanInterceptorWrapper.aroundInvoke(WeldSessionBeanInterceptorWrapper.java:58), at sun.reflect.GeneratedMethodAccessor278.invoke(Unknown Source), at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:55), at java.lang.reflect.Method.invoke(Method.java:508), at com.ibm.ejs.container.interceptors.InterceptorProxy.invokeInterceptor(InterceptorProxy.java:201), at com.ibm.ejs.container.interceptors.InvocationContextImpl.proceed(InvocationContextImpl.java:632), at com.ibm.ejs.container.interceptors.InvocationContextImpl.doAroundInterceptor(InvocationContextImpl.java:306), at com.ibm.ejs.container.interceptors.InvocationContextImpl.doAroundInvoke(InvocationContextImpl.java:273), at com.ibm.ejs.container.EJSContainer.invoke(EJSContainer.java:5215), at org.camunda.bpm.container.impl.ejb.MDBProxyJobExecutionHandlerMDB_53d2ac45.executeJob(MDBProxyJobExecutionHandlerMDB_53d2ac45.java), at org.camunda.bpm.container.impl.threading.ra.inflow.JcaInflowExecuteJobsRunnable.executeJob(JcaInflowExecuteJobsRunnable.java:77), at org.camunda.bpm.engine.impl.jobexecutor.ExecuteJobsRunnable.run(ExecuteJobsRunnable.java:71), at org.camunda.bpm.container.impl.threading.ra.commonj.CommonjWorkRunnableAdapter.run(CommonjWorkRunnableAdapter.java:36), at com.ibm.ws.asynchbeans.J2EEContext.run(J2EEContext.java:1046), at com.ibm.ws.asynchbeans.WorkWithExecutionContextImpl.go(WorkWithExecutionContextImpl.java:199), at com.ibm.ws.asynchbeans.CJWorkItemImpl.run(CJWorkItemImpl.java:236), at com.ibm.ws.util.ThreadPool$Worker.run(ThreadPool.java:1892), Caused by: org.springframework.transaction.TransactionSystemException: UOWManager transaction processing failed; nested exception is com.ibm.wsspi.uow.UOWException: javax.transaction.HeuristicMixedException, ... 41 more, Caused by: com.ibm.wsspi.uow.UOWException: javax.transaction.HeuristicMixedException, at com.ibm.ws.uow.embeddable.EmbeddableUOWManagerImpl.runUnderNewUOW(EmbeddableUOWManagerImpl.java:830), at com.ibm.ws.uow.embeddable.EmbeddableUOWManagerImpl.runUnderUOW(EmbeddableUOWManagerImpl.java:377), at org.springframework.transaction.jta.WebSphereUowTransactionManager.execute(WebSphereUowTransactionManager.java:306), ... 40 more, Caused by: javax.transaction.HeuristicMixedException, at com.ibm.tx.jta.impl.TransactionImpl.commit(TransactionImpl.java:979), at com.ibm.ws.tx.jta.TranManagerImpl.commit(TranManagerImpl.java:439), at com.ibm.tx.jta.impl.TranManagerSet.commit(TranManagerSet.java:191), at com.ibm.ws.uow.UOWManagerImpl.uowCommit(UOWManagerImpl.java:809), at com.ibm.ws.uow.embeddable.EmbeddableUOWManagerImpl.uowEnd(EmbeddableUOWManagerImpl.java:888), at com.ibm.ws.uow.UOWManagerImpl.uowEnd(UOWManagerImpl.java:784), at com.ibm.ws.uow.embeddable.EmbeddableUOWManagerImpl.runUnderNewUOW(EmbeddableUOWManagerImpl.java:825), ... 42 more, Caused by: javax.transaction.xa.XAException, at com.ibm.ejs.j2c.LocalTransactionWrapper.commit(LocalTransactionWrapper.java:305), at com.ibm.tx.jta.impl.OnePhaseResourceImpl.commit_one_phase(OnePhaseResourceImpl.java:145), at com.ibm.tx.jta.impl.RegisteredResources.flowCommitOnePhase(RegisteredResources.java:2398), at com.ibm.tx.jta.impl.TransactionImpl.commitXAResources(TransactionImpl.java:1829), at com.ibm.ws.tx.jta.TransactionImpl.stage1CommitProcessing(TransactionImpl.java:601), at com.ibm.tx.jta.impl.TransactionImpl.processCommit(TransactionImpl.java:1039), at com.ibm.tx.jta.impl.TransactionImpl.commit(TransactionImpl.java:973), ... 48 more, Caused by: com.ibm.ws.rsadapter.exceptions.DataStoreAdapterException: DSRA0080E: An exception was received by the Data Store Adapter. See original exception message: ERROR: restart transaction: TransactionRetryWithProtoRefreshError: TransactionRetryError: retry txn (RETRY_SERIALIZABLE): "sql txn" meta={id=188ce2bb key=/Table/74/1/"7944078b-06e9-11eb-a03c-0242ac120009"/0 pri=0.00431906 epo=0 ts=1601888539.567908598,1 min=1601888539.567203988,0 seq=65} lock=true stat=PENDING rts=1601888539.567203988,0 wto=false max=1601888539.567203988,0., at com.ibm.ws.rsadapter.AdapterUtil.translateSQLException(AdapterUtil.java:1590), at com.ibm.ws.rsadapter.spi.WSRdbSpiLocalTransactionImpl.commit(WSRdbSpiLocalTransactionImpl.java:417), at com.ibm.ejs.j2c.LocalTransactionWrapper.commit(LocalTransactionWrapper.java:281), ... 54 more, Caused by: java.sql.SQLException: ERROR: restart transaction: TransactionRetryWithProtoRefreshError: TransactionRetryError: retry txn (RETRY_SERIALIZABLE): "sql txn" meta={id=188ce2bb key=/Table/74/1/"7944078b-06e9-11eb-a03c-0242ac120009"/0 pri=0.00431906 epo=0 ts=1601888539.567908598,1 min=1601888539.567203988,0 seq=65} lock=true stat=PENDING rts=1601888539.567203988,0 wto=false max=1601888539.567203988,0 DSRA0010E: SQL State = 40001, Error Code = 0, at org.postgresql.core.v3.QueryExecutorImpl.receiveErrorResponse(QueryExecutorImpl.java:2553), at org.postgresql.core.v3.QueryExecutorImpl.processResults(QueryExecutorImpl.java:2285), at org.postgresql.core.v3.QueryExecutorImpl.execute(QueryExecutorImpl.java:323), at org.postgresql.jdbc.PgConnection.executeTransactionCommand(PgConnection.java:857), at org.postgresql.jdbc.PgConnection.commit(PgConnection.java:879), at sun.reflect.GeneratedMethodAccessor374.invoke(Unknown Source), at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:55), at java.lang.reflect.Method.invoke(Method.java:508), at org.postgresql.ds.PGPooledConnection$ConnectionHandler.invoke(PGPooledConnection.java:348), at com.sun.proxy.$Proxy123.commit(Unknown Source), at com.ibm.ws.rsadapter.spi.WSRdbSpiLocalTransactionImpl.commit(WSRdbSpiLocalTransactionImpl.java:396), ... 55 more, , [10/5/20 11:02:19:900 CEST] 00000150 LocalTranCoor E WLTC0017E: Resources rolled back due to setRollbackOnly() being called.,