AnsweredAssumed Answered

Error while completing Action

Question asked by nprajapatiasite on Nov 1, 2018

Hi Community,

 

I am getting below Error while completing Task in to workflow.

please find my workflow by attached files

 

from my workflow while i am completing action "RBL Lead" then it will throw below Error.

can anyone give proper solution to resolve it we are using activity framework version 5.15.1 

 

 

2018-07-12 16:51:32,691 ERROR [com.asite.wom.service.impl.TasksService] (ASITE_ASITE_TP_JMS_POOL1) Error in to complete action :: org.apache.ibatis.exceptions.PersistenceException:
### Error updating database. Cause: java.sql.SQLException: The DELETE statement conflicted with the SAME TABLE REFERENCE constraint "act_ru_execution$ACT_FK_EXE_PARENT". The conflict occurred in database "awomdb", table "dbo.act_ru_execution", column 'PARENT_ID_'.
### The error may involve org.activiti.engine.impl.persistence.entity.ExecutionEntity.deleteExecution-Inline
### The error occurred while setting parameters
### SQL: delete from ACT_RU_EXECUTION where ID_ = ? and REV_ = ?
### Cause: java.sql.SQLException: The DELETE statement conflicted with the SAME TABLE REFERENCE constraint "act_ru_execution$ACT_FK_EXE_PARENT". The conflict occurred in database "awomdb", table "dbo.act_ru_execution", column 'PARENT_ID_'.
at org.apache.ibatis.exceptions.ExceptionFactory.wrapException(ExceptionFactory.java:23)
at org.apache.ibatis.session.defaults.DefaultSqlSession.update(DefaultSqlSession.java:150)
at org.apache.ibatis.session.defaults.DefaultSqlSession.delete(DefaultSqlSession.java:161)
at org.activiti.engine.impl.db.DbSqlSession$CheckedDeleteOperation.execute(DbSqlSession.java:271)
at org.activiti.engine.impl.db.DbSqlSession.flushDeletes(DbSqlSession.java:647)
at org.activiti.engine.impl.db.DbSqlSession.flush(DbSqlSession.java:504)
at org.activiti.engine.impl.interceptor.CommandContext.flushSessions(CommandContext.java:182)
at org.activiti.engine.impl.interceptor.CommandContext.close(CommandContext.java:128)
at org.activiti.engine.impl.interceptor.CommandContextInterceptor.execute(CommandContextInterceptor.java:66)
at org.activiti.spring.SpringTransactionInterceptor$1.doInTransaction(SpringTransactionInterceptor.java:47)
at org.springframework.transaction.support.TransactionTemplate.execute(TransactionTemplate.java:133)
at org.activiti.spring.SpringTransactionInterceptor.execute(SpringTransactionInterceptor.java:45)
at org.activiti.engine.impl.interceptor.LogInterceptor.execute(LogInterceptor.java:31)
at org.activiti.engine.impl.cfg.CommandExecutorImpl.execute(CommandExecutorImpl.java:40)
at org.activiti.engine.impl.cfg.CommandExecutorImpl.execute(CommandExecutorImpl.java:35)
at org.activiti.engine.impl.TaskServiceImpl.complete(TaskServiceImpl.java:174)
at com.asite.wom.service.impl.TasksService.completeAction(TasksService.java:530)
at com.asite.wom.service.impl.TasksService.completeAction(TasksService.java:466)
at com.asite.wom.service.impl.TasksService$$FastClassBySpringCGLIB$$79d1d730.invoke(<generated>)
at org.springframework.cglib.proxy.MethodProxy.invoke(MethodProxy.java:204)
at org.springframework.aop.framework.CglibAopProxy$CglibMethodInvocation.invokeJoinpoint(CglibAopProxy.java:738)
at org.springframework.aop.framework.ReflectiveMethodInvocation.proceed(ReflectiveMethodInvocation.java:157)
at org.springframework.transaction.interceptor.TransactionInterceptor$1.proceedWithInvocation(TransactionInterceptor.java:99)
at org.springframework.transaction.interceptor.TransactionAspectSupport.invokeWithinTransaction(TransactionAspectSupport.java:281)
at org.springframework.transaction.interceptor.TransactionInterceptor.invoke(TransactionInterceptor.java:96)
at org.springframework.aop.framework.ReflectiveMethodInvocation.proceed(ReflectiveMethodInvocation.java:179)
at org.springframework.aop.framework.CglibAopProxy$DynamicAdvisedInterceptor.intercept(CglibAopProxy.java:673)
at com.asite.wom.service.impl.TasksService$$EnhancerBySpringCGLIB$$302ef0fe.completeAction(<generated>)
at com.asite.wom.command.worker.ClearActionCommandWorker.call(ClearActionCommandWorker.java:51)
at com.asite.wom.command.worker.ClearActionCommandWorker.call(ClearActionCommandWorker.java:19)
at java.util.concurrent.FutureTask.run(FutureTask.java:266)
at java.util.concurrent.ThreadPoolExecutor.runWorker(ThreadPoolExecutor.java:1142)
at java.util.concurrent.ThreadPoolExecutor$Worker.run(ThreadPoolExecutor.java:617)
at java.lang.Thread.run(Thread.java:745)
Caused by: java.sql.SQLException: The DELETE statement conflicted with the SAME TABLE REFERENCE constraint "act_ru_execution$ACT_FK_EXE_PARENT". The conflict occurred in database "awomdb", table "dbo.act_ru_execution", column 'PARENT_ID_'.
at net.sourceforge.jtds.jdbc.SQLDiagnostic.addDiagnostic(SQLDiagnostic.java:368)
at net.sourceforge.jtds.jdbc.TdsCore.tdsErrorToken(TdsCore.java:2816)
at net.sourceforge.jtds.jdbc.TdsCore.nextToken(TdsCore.java:2254)

Attachments

Outcomes