Transaction issue seen with error "Transaction is required to perform this operation (either use a transaction or extended persistence context"

I am facing one issue while testing the below bpmn
In my case the whole execution took almost 2 hrs to reach the “storeMscOperations” block in the bpmn
I am getting the below error

2021-07-08 22:59:48,276 WARN [org.camunda.bpm.engine.jobexecutor] (pool-10-thread-9868) ENGINE-14006 Exception while executing job c9aa7808-e036-11eb-a596-5254009e4d38: : org.camunda.bpm.engine.ScriptEvaluationException: Unable to evaluate script while executing activity ‘storeMscOperations’ in the process definition with id ‘3003d775-da57-11eb-8a47-5254003c0030’: javax.ejb.EJBTransactionRolledbackException: WFLYJPA0060: Transaction is required to perform this operation (either use a transaction or extended persistence context)2021-07-08 22:59:48,276 WARN [org.camunda.bpm.engine.jobexecutor] (pool-10-thread-9868) ENGINE-14006 Exception while executing job c9aa7808-e036-11eb-a596-5254009e4d38: : org.camunda.bpm.engine.ScriptEvaluationException: Unable to evaluate script while executing activity ‘storeMscOperations’ in the process definition with id ‘3003d775-da57-11eb-8a47-5254003c0030’: javax.ejb.EJBTransactionRolledbackException: WFLYJPA0060: Transaction is required to perform this operation (either use a transaction or extended persistence context) at org.camunda.bpm.engine.impl.scripting.CompiledExecutableScript.evaluate(CompiledExecutableScript.java:61) [camunda-engine-7.14.6-ee.jar:7.14.6-ee] at org.camunda.bpm.engine.impl.scripting.SourceExecutableScript.evaluate(SourceExecutableScript.java:61) [camunda-engine-7.14.6-ee.jar:7.14.6-ee] at org.camunda.bpm.engine.impl.scripting.ResourceExecutableScript.evaluate(Resourc
I am suspecting that I should specify " ```
“asyncBefore” as true to my script


Is it the issue with asyncBefore and asyncAfter ?
Please suggest a solution

Hey @Sravya_Boppana, maybe you can find a workaround for this transaction time out problem. But, maybe you could think about having a more event oriented solution here despite of synchrony waiting for a 2hr long transaction?

When I kept the script block as async before and after, I am getting this exception

2021-07-28 13:19:12,020 WARN [org.camunda.bpm.engine.jobexecutor] (pool-11-thread-5450) ENGINE-14006 Exception while executing job 580ff77c-ef9c-11eb-b944-5254003c0030: : org.camunda.bpm.engine.ProcessEngineException: An exception occurred in the persistence layer. Please check the server logs for a detailed message and the entire exception stack trace.
at org.camunda.bpm.engine.impl.util.ExceptionUtil.wrapPersistenceException(ExceptionUtil.java:263) [camunda-engine-7.14.6-ee.jar:7.14.6-ee]
at org.camunda.bpm.engine.impl.util.ExceptionUtil.doWithExceptionWrapper(ExceptionUtil.java:257) [camunda-engine-7.14.6-ee.jar:7.14.6-ee]
at org.camunda.bpm.engine.impl.db.sql.DbSqlSession.executeSelectList(DbSqlSession.java:111) [camunda-engine-7.14.6-ee.jar:7.14.6-ee]
at org.camunda.bpm.engine.impl.db.sql.DbSqlSession.selectList(DbSqlSession.java:103) [camunda-engine-7.14.6-ee.jar:7.14.6-ee]
at org.camunda.bpm.engine.impl.db.entitymanager.DbEntityManager.selectListWithRawParameter(DbEntityManager.java:182) [camunda-engine-7.14.6-ee.jar:7.14.6-ee]
at org.camunda.bpm.engine.impl.db.entitymanager.DbEntityManager.selectList(DbEntityManager.java:174) [camunda-engine-7.14.6-ee.jar:7.14.6-ee]
at org.camunda.bpm.engine.impl.db.entitymanager.DbEntityManager.selectList(DbEntityManager.java:170) [camunda-engine-7.14.6-ee.jar:7.14.6-ee]
at org.camunda.bpm.engine.impl.db.entitymanager.DbEntityManager.selectList(DbEntityManager.java:154) [camunda-engine-7.14.6-ee.jar:7.14.6-ee]
at org.camunda.bpm.engine.impl.persistence.entity.ExecutionManager.findExecutionsByProcessInstanceId(ExecutionManager.java:113) [camunda-engine-7.14.6-ee.jar:7.14.6-ee]
at org.camunda.bpm.engine.impl.persistence.entity.ExecutionEntity.ensureExecutionTreeInitialized(ExecutionEntity.java:1299) [camunda-engine-7.14.6-ee.jar:7.14.6-ee]
at org.camunda.bpm.engine.impl.persistence.entity.ExecutionEntity.ensureExecutionsInitialized(ExecutionEntity.java:723) [camunda-engine-7.14.6-ee.jar:7.14.6-ee]
at org.camunda.bpm.engine.impl.persistence.entity.ExecutionEntity.getExecutions(ExecutionEntity.java:711) [camunda-engine-7.14.6-ee.jar:7.14.6-ee]
at org.camunda.bpm.engine.impl.pvm.runtime.PvmExecutionImpl.getNonEventScopeExecutions(PvmExecutionImpl.java:1081) [camunda-engine-7.14.6-ee.jar:7.14.6-ee]
at org.camunda.bpm.engine.impl.tree.LeafActivityInstanceExecutionCollector.visit(LeafActivityInstanceExecutionCollector.java:38) [camunda-engine-7.14.6-ee.jar:7.14.6-ee]
at org.camunda.bpm.engine.impl.tree.LeafActivityInstanceExecutionCollector.visit(LeafActivityInstanceExecutionCollector.java:33) [camunda-engine-7.14.6-ee.jar:7.14.6-ee]
at org.camunda.bpm.engine.impl.tree.ReferenceWalker.walkUntil(ReferenceWalker.java:91) [camunda-engine-7.14.6-ee.jar:7.14.6-ee]
at org.camunda.bpm.engine.impl.tree.ReferenceWalker.walkUntil(ReferenceWalker.java:69) [camunda-engine-7.14.6-ee.jar:7.14.6-ee]
at org.camunda.bpm.engine.impl.pvm.runtime.PvmExecutionImpl.createActivityExecutionMapping(PvmExecutionImpl.java:1498) [camunda-engine-7.14.6-ee.jar:7.14.6-ee]
at org.camunda.bpm.engine.impl.pvm.runtime.PvmExecutionImpl.createActivityExecutionMapping(PvmExecutionImpl.java:1530) [camunda-engine-7.14.6-ee.jar:7.14.6-ee]
at org.camunda.bpm.engine.impl.tree.ActivityExecutionHierarchyWalker.(ActivityExecutionHierarchyWalker.java:40) [camunda-engine-7.14.6-ee.jar:7.14.6-ee]
at org.camunda.bpm.engine.impl.bpmn.helper.BpmnExceptionHandler.propagateError(BpmnExceptionHandler.java:99) [camunda-engine-7.14.6-ee.jar:7.14.6-ee]
at org.camunda.bpm.engine.impl.bpmn.helper.BpmnExceptionHandler.propagateExceptionAsError(BpmnExceptionHandler.java:62) [camunda-engine-7.14.6-ee.jar:7.14.6-ee]
at org.camunda.bpm.engine.impl.bpmn.helper.BpmnExceptionHandler.propagateException(BpmnExceptionHandler.java:52) [camunda-engine-7.14.6-ee.jar:7.14.6-ee]
at org.camunda.bpm.engine.impl.bpmn.behavior.AbstractBpmnActivityBehavior.executeWithErrorPropagation(AbstractBpmnActivityBehavior.java:95) [camunda-engine-7.14.6-ee.jar:7.14.6-ee]
at org.camunda.bpm.engine.impl.bpmn.behavior.ScriptTaskActivityBehavior.performExecution(ScriptTaskActivityBehavior.java:51) [camunda-engine-7.14.6-ee.jar:7.14.6-ee]
at org.camunda.bpm.engine.impl.bpmn.behavior.TaskActivityBehavior.execute(TaskActivityBehavior.java:69) [camunda-engine-7.14.6-ee.jar:7.14.6-ee]
at org.camunda.bpm.engine.impl.pvm.runtime.operation.PvmAtomicOperationActivityExecute$2.callback(PvmAtomicOperationActivityExecute.java:61) [camunda-engine-7.14.6-ee.jar:7.14.6-ee]
at org.camunda.bpm.engine.impl.pvm.runtime.operation.PvmAtomicOperationActivityExecute$2.callback(PvmAtomicOperationActivityExecute.java:50) [camunda-engine-7.14.6-ee.jar:7.14.6-ee]
at org.camunda.bpm.engine.impl.pvm.runtime.PvmExecutionImpl.continueIfExecutionDoesNotAffectNextOperation(PvmExecutionImpl.java:2039) [camunda-engine-7.14.6-ee.jar:7.14.6-ee]
at org.camunda.bpm.engine.impl.pvm.runtime.operation.PvmAtomicOperationActivityExecute.execute(PvmAtomicOperationActivityExecute.java:42) [camunda-engine-7.14.6-ee.jar:7.14.6-ee]
at org.camunda.bpm.engine.impl.pvm.runtime.operation.PvmAtomicOperationActivityExecute.execute(PvmAtomicOperationActivityExecute.java:31) [camunda-engine-7.14.6-ee.jar:7.14.6-ee]
at org.camunda.bpm.engine.impl.interceptor.AtomicOperationInvocation.execute(AtomicOperationInvocation.java:99) [camunda-engine-7.14.6-ee.jar:7.14.6-ee]
at org.camunda.bpm.engine.impl.interceptor.CommandInvocationContext.invokeNext(CommandInvocationContext.java:131) [camunda-engine-7.14.6-ee.jar:7.14.6-ee]
at org.camunda.bpm.engine.impl.interceptor.CommandInvocationContext.performNext(CommandInvocationContext.java:111) [camunda-engine-7.14.6-ee.jar:7.14.6-ee]
at org.camunda.bpm.engine.impl.interceptor.CommandInvocationContext.performOperation(CommandInvocationContext.java:86) [camunda-engine-7.14.6-ee.jar:7.14.6-ee]
at org.camunda.bpm.engine.impl.persistence.entity.ExecutionEntity.performOperation(ExecutionEntity.java:634) [camunda-engine-7.14.6-ee.jar:7.14.6-ee]
at org.camunda.bpm.engine.impl.persistence.entity.ExecutionEntity.performOperation(ExecutionEntity.java:608) [camunda-engine-7.14.6-ee.jar:7.14.6-ee]
at org.camunda.bpm.engine.impl.pvm.runtime.PvmExecutionImpl$6.callback(PvmExecutionImpl.java:1978) [camunda-engine-7.14.6-ee.jar:7.14.6-ee]
at org.camunda.bpm.engine.impl.pvm.runtime.PvmExecutionImpl$6.callback(PvmExecutionImpl.java:1975) [camunda-engine-7.14.6-ee.jar:7.14.6-ee]
at org.camunda.bpm.engine.impl.pvm.runtime.PvmExecutionImpl.continueExecutionIfNotCanceled(PvmExecutionImpl.java:2045) [camunda-engine-7.14.6-ee.jar:7.14.6-ee]
at org.camunda.bpm.engine.impl.pvm.runtime.PvmExecutionImpl.dispatchDelayedEventsAndPerformOperation(PvmExecutionImpl.java:1994) [camunda-engine-7.14.6-ee.jar:7.14.6-ee]
at org.camunda.bpm.engine.impl.pvm.runtime.PvmExecutionImpl.dispatchDelayedEventsAndPerformOperation(PvmExecutionImpl.java:1975) [camunda-engine-7.14.6-ee.jar:7.14.6-ee]
at org.camunda.bpm.engine.impl.pvm.runtime.operation.PvmAtomicOperationTransitionNotifyListenerStart.eventNotificationsCompleted(PvmAtomicOperationTransitionNotifyListenerStart.java:60) [camunda-engine-7.14.6-ee.jar:7.14.6-ee]
at org.camunda.bpm.engine.impl.pvm.runtime.operation.PvmAtomicOperationTransitionNotifyListenerStart.eventNotificationsCompleted(PvmAtomicOperationTransitionNotifyListenerStart.java:30) [camunda-engine-7.14.6-ee.jar:7.14.6-ee]
at org.camunda.bpm.engine.impl.core.operation.AbstractEventAtomicOperation.execute(AbstractEventAtomicOperation.java:66) [camunda-engine-7.14.6-ee.jar:7.14.6-ee]
at org.camunda.bpm.engine.impl.interceptor.AtomicOperationInvocation.execute(AtomicOperationInvocation.java:99) [camunda-engine-7.14.6-ee.jar:7.14.6-ee]
at org.camunda.bpm.engine.impl.interceptor.CommandInvocationContext.invokeNext(CommandInvocationContext.java:131) [camunda-engine-7.14.6-ee.jar:7.14.6-ee]
at org.camunda.bpm.engine.impl.interceptor.CommandInvocationContext.performNext(CommandInvocationContext.java:111) [camunda-engine-7.14.6-ee.jar:7.14.6-ee]
at org.camunda.bpm.engine.impl.interceptor.CommandInvocationContext.performOperation(CommandInvocationContext.java:86) [camunda-engine-7.14.6-ee.jar:7.14.6-ee]
at org.camunda.bpm.engine.impl.interceptor.CommandInvocationContext.performOperation(CommandInvocationContext.java:76) [camunda-engine-7.14.6-ee.jar:7.14.6-ee]
at org.camunda.bpm.engine.impl.persistence.entity.ExecutionEntity.performOperationSync(ExecutionEntity.java:643) [camunda-engine-7.14.6-ee.jar:7.14.6-ee]
at org.camunda.bpm.engine.impl.persistence.entity.ExecutionEntity.performOperationSync(ExecutionEntity.java:618) [camunda-engine-7.14.6-ee.jar:7.14.6-ee]
at org.camunda.bpm.engine.impl.core.operation.AbstractEventAtomicOperation.execute(AbstractEventAtomicOperation.java:62) [camunda-engine-7.14.6-ee.jar:7.14.6-ee]
at org.camunda.bpm.engine.impl.interceptor.AtomicOperationInvocation.execute(AtomicOperationInvocation.java:99) [camunda-engine-7.14.6-ee.jar:7.14.6-ee]
at org.camunda.bpm.engine.impl.interceptor.CommandInvocationContext.invokeNext(CommandInvocationContext.java:131) [camunda-engine-7.14.6-ee.jar:7.14.6-ee]
at org.camunda.bpm.engine.impl.interceptor.CommandInvocationContext.performNext(CommandInvocationContext.java:111) [camunda-engine-7.14.6-ee.jar:7.14.6-ee]
at org.camunda.bpm.engine.impl.interceptor.CommandInvocationContext.performOperation(CommandInvocationContext.java:86) [camunda-engine-7.14.6-ee.jar:7.14.6-ee]
at org.camunda.bpm.engine.impl.interceptor.CommandInvocationContext.performOperation(CommandInvocationContext.java:76) [camunda-engine-7.14.6-ee.jar:7.14.6-ee]
at org.camunda.bpm.engine.impl.persistence.entity.ExecutionEntity.performOperationSync(ExecutionEntity.java:643) [camunda-engine-7.14.6-ee.jar:7.14.6-ee]
at org.camunda.bpm.engine.impl.persistence.entity.ExecutionEntity.performOperationSync(ExecutionEntity.java:618) [camunda-engine-7.14.6-ee.jar:7.14.6-ee]
at org.camunda.bpm.engine.impl.core.operation.AbstractEventAtomicOperation.execute(AbstractEventAtomicOperation.java:62) [camunda-engine-7.14.6-ee.jar:7.14.6-ee]
at org.camunda.bpm.engine.impl.interceptor.AtomicOperationInvocation.execute(AtomicOperationInvocation.java:99) [camunda-engine-7.14.6-ee.jar:7.14.6-ee]
at org.camunda.bpm.engine.impl.interceptor.CommandInvocationContext.invokeNext(CommandInvocationContext.java:131) [camunda-engine-7.14.6-ee.jar:7.14.6-ee]
at org.camunda.bpm.engine.impl.interceptor.CommandInvocationContext.performNext(CommandInvocationContext.java:111) [camunda-engine-7.14.6-ee.jar:7.14.6-ee]
at org.camunda.bpm.engine.impl.interceptor.CommandInvocationContext.performOperation(CommandInvocationContext.java:86) [camunda-engine-7.14.6-ee.jar:7.14.6-ee]
at org.camunda.bpm.engine.impl.persistence.entity.ExecutionEntity.performOperation(ExecutionEntity.java:634) [camunda-engine-7.14.6-ee.jar:7.14.6-ee]
at org.camunda.bpm.engine.impl.persistence.entity.ExecutionEntity.performOperation(ExecutionEntity.java:608) [camunda-engine-7.14.6-ee.jar:7.14.6-ee]
at org.camunda.bpm.engine.impl.pvm.runtime.operation.PvmAtomicOperationTransitionCreateScope.scopeCreated(PvmAtomicOperationTransitionCreateScope.java:38) [camunda-engine-7.14.6-ee.jar:7.14.6-ee]
at org.camunda.bpm.engine.impl.pvm.runtime.operation.PvmAtomicOperationCreateScope.execute(PvmAtomicOperationCreateScope.java:54) [camunda-engine-7.14.6-ee.jar:7.14.6-ee]
at org.camunda.bpm.engine.impl.pvm.runtime.operation.PvmAtomicOperationCreateScope.execute(PvmAtomicOperationCreateScope.java:28) [camunda-engine-7.14.6-ee.jar:7.14.6-ee]
at org.camunda.bpm.engine.impl.interceptor.AtomicOperationInvocation.execute(AtomicOperationInvocation.java:99) [camunda-engine-7.14.6-ee.jar:7.14.6-ee]
at org.camunda.bpm.engine.impl.interceptor.CommandInvocationContext.invokeNext(CommandInvocationContext.java:131) [camunda-engine-7.14.6-ee.jar:7.14.6-ee]
at org.camunda.bpm.engine.impl.interceptor.CommandInvocationContext.performNext(CommandInvocationContext.java:118) [camunda-engine-7.14.6-ee.jar:7.14.6-ee]
at org.camunda.bpm.engine.impl.interceptor.CommandInvocationContext$1.call(CommandInvocationContext.java:102) [camunda-engine-7.14.6-ee.jar:7.14.6-ee]
at org.camunda.bpm.engine.impl.interceptor.CommandInvocationContext$1.call(CommandInvocationContext.java:100) [camunda-engine-7.14.6-ee.jar:7.14.6-ee]
at org.camunda.bpm.engine.impl.context.ProcessApplicationClassloaderInterceptor.call(ProcessApplicationClassloaderInterceptor.java:48) [camunda-engine-7.14.6-ee.jar:7.14.6-ee]
at org.camunda.bpm.application.impl.EjbProcessApplication.execute(EjbProcessApplication.java:140) [camunda-engine-7.14.6-ee.jar:7.14.6-ee]
at org.camunda.bpm.application.AbstractProcessApplication.execute(AbstractProcessApplication.java:132) [camunda-engine-7.14.6-ee.jar:7.14.6-ee]
at sun.reflect.GeneratedMethodAccessor385.invoke(Unknown Source) [:1.8.0_281]
at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:43) [rt.jar:1.8.0_281]
at java.lang.reflect.Method.invoke(Method.java:498) [rt.jar:1.8.0_281]
at org.jboss.as.ee.component.ManagedReferenceMethodInterceptor.processInvocation(ManagedReferenceMethodInterceptor.java:52)
at org.jboss.invocation.InterceptorContext.proceed(InterceptorContext.java:422)
at org.jboss.invocation.InterceptorContext$Invocation.proceed(InterceptorContext.java:509)
at org.jboss.as.weld.interceptors.Jsr299BindingsInterceptor.delegateInterception(Jsr299BindingsInterceptor.java:79)
at org.jboss.as.weld.interceptors.Jsr299BindingsInterceptor.doMethodInterception(Jsr299BindingsInterceptor.java:89)
at org.jboss.as.weld.interceptors.Jsr299BindingsInterceptor.processInvocation(Jsr299BindingsInterceptor.java:102)
at org.jboss.as.ee.component.interceptors.UserInterceptorFactory$1.processInvocation(UserInterceptorFactory.java:63)
at org.jboss.invocation.InterceptorContext.proceed(InterceptorContext.java:422)
at org.jboss.as.ejb3.component.invocationmetrics.ExecutionTimeInterceptor.processInvocation(ExecutionTimeInterceptor.java:43)
at org.jboss.invocation.InterceptorContext.proceed(InterceptorContext.java:422)
at org.jboss.as.ee.concurrent.ConcurrentContextInterceptor.processInvocation(ConcurrentContextInterceptor.java:45)
at org.jboss.invocation.InterceptorContext.proceed(InterceptorContext.java:422)
at org.jboss.invocation.InitialInterceptor.processInvocation(InitialInterceptor.java:40)
at org.jboss.invocation.InterceptorContext.proceed(InterceptorContext.java:422)
at org.jboss.invocation.ChainedInterceptor.processInvocation(ChainedInterceptor.java:53)
at org.jboss.as.ee.component.interceptors.ComponentDispatcherInterceptor.processInvocation(ComponentDispatcherInterceptor.java:52)
at org.jboss.invocation.InterceptorContext.proceed(InterceptorContext.java:422)
at org.jboss.as.ejb3.component.singleton.SingletonComponentInstanceAssociationInterceptor.processInvocation(SingletonComponentInstanceAssociationInterceptor.java:53)
at org.jboss.invocation.InterceptorContext.proceed(InterceptorContext.java:422)
at org.jboss.as.ejb3.component.interceptors.AdditionalSetupInterceptor.processInvocation(AdditionalSetupInterceptor.java:54)
at org.jboss.invocation.InterceptorContext.proceed(InterceptorContext.java:422)
at org.jboss.as.ejb3.tx.CMTTxInterceptor.invokeInCallerTx(CMTTxInterceptor.java:197)
at org.jboss.as.ejb3.tx.CMTTxInterceptor.required(CMTTxInterceptor.java:388)
at org.jboss.as.ejb3.tx.CMTTxInterceptor.processInvocation(CMTTxInterceptor.java:156)
at org.jboss.invocation.InterceptorContext.proceed(InterceptorContext.java:422)
at org.jboss.invocation.InterceptorContext$Invocation.proceed(InterceptorContext.java:509)
at org.jboss.weld.module.ejb.AbstractEJBRequestScopeActivationInterceptor.aroundInvoke(AbstractEJBRequestScopeActivationInterceptor.java:81)
at org.jboss.as.weld.ejb.EjbRequestScopeActivationInterceptor.processInvocation(EjbRequestScopeActivationInterceptor.java:89)
at org.jboss.invocation.InterceptorContext.proceed(InterceptorContext.java:422)
at org.jboss.as.ejb3.component.interceptors.CurrentInvocationContextInterceptor.processInvocation(CurrentInvocationContextInterceptor.java:41)
at org.jboss.invocation.InterceptorContext.proceed(InterceptorContext.java:422)
at org.jboss.as.ejb3.component.invocationmetrics.WaitTimeInterceptor.processInvocation(WaitTimeInterceptor.java:47)
at org.jboss.invocation.InterceptorContext.proceed(InterceptorContext.java:422)
at org.jboss.as.ejb3.security.SecurityContextInterceptor.processInvocation(SecurityContextInterceptor.java:100)
at org.jboss.invocation.InterceptorContext.proceed(InterceptorContext.java:422)
at org.jboss.as.ejb3.deployment.processors.StartupAwaitInterceptor.processInvocation(StartupAwaitInterceptor.java:22)
at org.jboss.invocation.InterceptorContext.proceed(InterceptorContext.java:422)
at org.jboss.as.ejb3.component.interceptors.ShutDownInterceptorFactory$1.processInvocation(ShutDownInterceptorFactory.java:64)
at org.jboss.invocation.InterceptorContext.proceed(InterceptorContext.java:422)
at org.jboss.as.ejb3.component.interceptors.LoggingInterceptor.processInvocation(LoggingInterceptor.java:67)
at org.jboss.invocation.InterceptorContext.proceed(InterceptorContext.java:422)
at org.jboss.as.ee.component.NamespaceContextInterceptor.processInvocation(NamespaceContextInterceptor.java:50)
at org.jboss.invocation.InterceptorContext.proceed(InterceptorContext.java:422)
at org.jboss.invocation.ContextClassLoaderInterceptor.processInvocation(ContextClassLoaderInterceptor.java:60)
at org.jboss.invocation.InterceptorContext.proceed(InterceptorContext.java:422)
at org.jboss.invocation.InterceptorContext.run(InterceptorContext.java:438)
at org.wildfly.security.manager.WildFlySecurityManager.doChecked(WildFlySecurityManager.java:628)
at org.jboss.invocation.AccessCheckingInterceptor.processInvocation(AccessCheckingInterceptor.java:57)
at org.jboss.invocation.InterceptorContext.proceed(InterceptorContext.java:422)
at org.jboss.invocation.ChainedInterceptor.processInvocation(ChainedInterceptor.java:53)
at org.jboss.as.ee.component.ViewService$View.invoke(ViewService.java:198)
at org.jboss.as.ee.component.ViewDescription$1.processInvocation(ViewDescription.java:191)
at org.jboss.as.ee.component.ProxyInvocationHandler.invoke(ProxyInvocationHandler.java:81)
at org.camunda.bpm.application.ProcessApplicationInterface$$$view23.execute(Unknown Source)
at org.camunda.bpm.engine.impl.context.Context.executeWithinProcessApplication(Context.java:206) [camunda-engine-7.14.6-ee.jar:7.14.6-ee]
at org.camunda.bpm.engine.impl.interceptor.CommandInvocationContext.performNext(CommandInvocationContext.java:100) [camunda-engine-7.14.6-ee.jar:7.14.6-ee]
at org.camunda.bpm.engine.impl.interceptor.CommandInvocationContext.performOperation(CommandInvocationContext.java:86) [camunda-engine-7.14.6-ee.jar:7.14.6-ee]
at org.camunda.bpm.engine.impl.interceptor.CommandInvocationContext.performOperation(CommandInvocationContext.java:76) [camunda-engine-7.14.6-ee.jar:7.14.6-ee]
at org.camunda.bpm.engine.impl.jobexecutor.AsyncContinuationJobHandler.execute(AsyncContinuationJobHandler.java:81) [camunda-engine-7.14.6-ee.jar:7.14.6-ee]
at org.camunda.bpm.engine.impl.jobexecutor.AsyncContinuationJobHandler.execute(AsyncContinuationJobHandler.java:40) [camunda-engine-7.14.6-ee.jar:7.14.6-ee]
at org.camunda.bpm.engine.impl.persistence.entity.JobEntity.execute(JobEntity.java:134) [camunda-engine-7.14.6-ee.jar:7.14.6-ee]
at org.camunda.bpm.engine.impl.cmd.ExecuteJobsCmd.execute(ExecuteJobsCmd.java:110) [camunda-engine-7.14.6-ee.jar:7.14.6-ee]
at org.camunda.bpm.engine.impl.cmd.ExecuteJobsCmd.execute(ExecuteJobsCmd.java:43) [camunda-engine-7.14.6-ee.jar:7.14.6-ee]
at org.camunda.bpm.engine.impl.interceptor.CommandExecutorImpl.execute(CommandExecutorImpl.java:28) [camunda-engine-7.14.6-ee.jar:7.14.6-ee]
at org.camunda.bpm.engine.impl.interceptor.CommandContextInterceptor.execute(CommandContextInterceptor.java:110) [camunda-engine-7.14.6-ee.jar:7.14.6-ee]
at org.camunda.bpm.engine.impl.interceptor.JtaTransactionInterceptor.execute(JtaTransactionInterceptor.java:67) [camunda-engine-7.14.6-ee.jar:7.14.6-ee]
at org.camunda.bpm.engine.impl.interceptor.ProcessApplicationContextInterceptor.execute(ProcessApplicationContextInterceptor.java:70) [camunda-engine-7.14.6-ee.jar:7.14.6-ee]
at org.camunda.bpm.engine.impl.interceptor.CommandCounterInterceptor.execute(CommandCounterInterceptor.java:35) [camunda-engine-7.14.6-ee.jar:7.14.6-ee]
at org.camunda.bpm.engine.impl.interceptor.LogInterceptor.execute(LogInterceptor.java:33) [camunda-engine-7.14.6-ee.jar:7.14.6-ee]
at org.camunda.bpm.engine.impl.jobexecutor.ExecuteJobHelper.executeJob(ExecuteJobHelper.java:57) [camunda-engine-7.14.6-ee.jar:7.14.6-ee]
at org.camunda.bpm.engine.impl.jobexecutor.ExecuteJobsRunnable.executeJob(ExecuteJobsRunnable.java:110) [camunda-engine-7.14.6-ee.jar:7.14.6-ee]
at org.camunda.bpm.engine.impl.jobexecutor.ExecuteJobsRunnable.run(ExecuteJobsRunnable.java:71) [camunda-engine-7.14.6-ee.jar:7.14.6-ee]
at org.jboss.threads.SimpleDirectExecutor.execute(SimpleDirectExecutor.java:29)
at org.jboss.threads.QueueExecutor.runTask(QueueExecutor.java:789)
at org.jboss.threads.QueueExecutor.access$100(QueueExecutor.java:44)
at org.jboss.threads.QueueExecutor$Worker.run(QueueExecutor.java:830)
at java.lang.Thread.run(Thread.java:748) [rt.jar:1.8.0_281]
at org.jboss.threads.JBossThread.run(JBossThread.java:485)
Caused by: org.apache.ibatis.exceptions.PersistenceException:

Error querying database. Cause: java.sql.SQLException: IJ031070: Transaction cannot proceed: STATUS_ROLLEDBACK

The error may exist in org/camunda/bpm/engine/impl/mapping/entity/Execution.xml

The error may involve org.camunda.bpm.engine.impl.persistence.entity.ExecutionEntity.selectExecutionsByProcessInstanceId

The error occurred while executing a query

SQL: select * from ACT_RU_EXECUTION where PROC_INST_ID_ = ?

Cause: java.sql.SQLException: IJ031070: Transaction cannot proceed: STATUS_ROLLEDBACK

at org.apache.ibatis.exceptions.ExceptionFactory.wrapException(ExceptionFactory.java:30) [mybatis-3.5.6.jar:3.5.6]
at org.apache.ibatis.session.defaults.DefaultSqlSession.selectList(DefaultSqlSession.java:149) [mybatis-3.5.6.jar:3.5.6]
at org.apache.ibatis.session.defaults.DefaultSqlSession.selectList(DefaultSqlSession.java:140) [mybatis-3.5.6.jar:3.5.6]
at org.camunda.bpm.engine.impl.db.sql.DbSqlSession.lambda$executeSelectList$1(DbSqlSession.java:111) [camunda-engine-7.14.6-ee.jar:7.14.6-ee]
at org.camunda.bpm.engine.impl.util.ExceptionUtil.doWithExceptionWrapper(ExceptionUtil.java:254) [camunda-engine-7.14.6-ee.jar:7.14.6-ee]
... 157 more

Caused by: java.sql.SQLException: IJ031070: Transaction cannot proceed: STATUS_ROLLEDBACK
at org.jboss.jca.adapters.jdbc.WrapperDataSource.checkTransactionActive(WrapperDataSource.java:272)
at org.jboss.jca.adapters.jdbc.WrappedConnection.checkTransactionActive(WrappedConnection.java:2002)
at org.jboss.jca.adapters.jdbc.WrappedConnection.checkStatus(WrappedConnection.java:2017)
at org.jboss.jca.adapters.jdbc.WrappedConnection.checkTransaction(WrappedConnection.java:1991)
at org.jboss.jca.adapters.jdbc.WrappedConnection.prepareStatement(WrappedConnection.java:469)
at org.apache.ibatis.executor.statement.PreparedStatementHandler.instantiateStatement(PreparedStatementHandler.java:86) [mybatis-3.5.6.jar:3.5.6]
at org.apache.ibatis.executor.statement.BaseStatementHandler.prepare(BaseStatementHandler.java:88) [mybatis-3.5.6.jar:3.5.6]
at org.apache.ibatis.executor.statement.RoutingStatementHandler.prepare(RoutingStatementHandler.java:59) [mybatis-3.5.6.jar:3.5.6]
at org.apache.ibatis.executor.BatchExecutor.doQuery(BatchExecutor.java:90) [mybatis-3.5.6.jar:3.5.6]
at org.apache.ibatis.executor.BaseExecutor.queryFromDatabase(BaseExecutor.java:325) [mybatis-3.5.6.jar:3.5.6]
at org.apache.ibatis.executor.BaseExecutor.query(BaseExecutor.java:156) [mybatis-3.5.6.jar:3.5.6]
at org.apache.ibatis.executor.CachingExecutor.query(CachingExecutor.java:109) [mybatis-3.5.6.jar:3.5.6]
at org.apache.ibatis.executor.CachingExecutor.query(CachingExecutor.java:89) [mybatis-3.5.6.jar:3.5.6]
at org.apache.ibatis.session.defaults.DefaultSqlSession.selectList(DefaultSqlSession.java:147) [mybatis-3.5.6.jar:3.5.6]
… 160 more

Could any please help me here with this issue