AnsweredAssumed Answered

Error While Updating ACT_RU_TASK RES                         inner join ACT_RE_PROCDEF D

Question asked by kumar.abhishek0809 on May 27, 2018

Caused by: org.apache.ibatis.exceptions.PersistenceException:
### Error querying database. Cause: java.sql.SQLException: addSync: caught Exception
### The error may exist in org/activiti/db/mapping/entity/Task.xml
### The error may involve org.activiti.engine.impl.persistence.entity.TaskEntity.selectTaskByQueryCriteria
### The error occurred while executing a query
### SQL: select * from ( select a.*, ROWNUM rnum from ( select distinct RES.* from ACT_RU_TASK RES inner join ACT_RE_PROCDEF D on RES.PROC_DEF_ID_ = D.ID_ inner join ACT_RU_EXECUTION E on RES.PROC_INST_ID_ = E.ID_ WHERE E.BUSINESS_KEY_ = ? and D.NAME_ = ? order by RES.ID_ asc ) a where ROWNUM < ?) where rnum >= ?
### Cause: java.sql.SQLException: addSync: caught Exception
at org.apache.ibatis.exceptions.ExceptionFactory.wrapException(ExceptionFactory.java:23) ~[mybatis-3.1.1.jar:3.1.1]
at org.apache.ibatis.session.defaults.DefaultSqlSession.selectList(DefaultSqlSession.java:104) ~[mybatis-3.1.1.jar:3.1.1]
at org.apache.ibatis.session.defaults.DefaultSqlSession.selectList(DefaultSqlSession.java:95) ~[mybatis-3.1.1.jar:3.1.1]
at org.activiti.engine.impl.db.DbSqlSession.selectListWithRawParameter(DbSqlSession.java:301) ~[activiti-engine-5.11.jar:5.11]
at org.activiti.engine.impl.db.DbSqlSession.selectList(DbSqlSession.java:292) ~[activiti-engine-5.11.jar:5.11]
at org.activiti.engine.impl.persistence.entity.TaskManager.findTasksByQueryCriteria(TaskManager.java:109) ~[activiti-engine-5.11.jar:5.11]
at org.activiti.engine.impl.TaskQueryImpl.executeList(TaskQueryImpl.java:459) ~[activiti-engine-5.11.jar:5.11]
at org.activiti.engine.impl.AbstractQuery.executeSingleResult(AbstractQuery.java:157) ~[activiti-engine-5.11.jar:5.11]
at org.activiti.engine.impl.AbstractQuery.execute(AbstractQuery.java:140) ~[activiti-engine-5.11.jar:5.11]
at org.activiti.engine.impl.interceptor.CommandExecutorImpl.execute(CommandExecutorImpl.java:24) ~[activiti-engine-5.11.jar:5.11]
at org.activiti.engine.impl.interceptor.CommandContextInterceptor.execute(CommandContextInterceptor.java:60) ~[activiti-engine-5.11.jar:5.11]
at org.activiti.spring.SpringTransactionInterceptor$1.doInTransaction(SpringTransactionInterceptor.java:42) ~[activiti-spring-5.11.jar:?]
at org.springframework.transaction.jta.WebSphereUowTransactionManager$UOWActionAdapter.run(WebSphereUowTransactionManager.java:343) ~[spring-tx-3.2.9.RELEASE.jar:3.2.9.RELEASE]
at com.ibm.ws.uow.embeddable.EmbeddableUOWManagerImpl.runUnderCurrentUOW(EmbeddableUOWManagerImpl.java:987) ~[com.ibm.ws.runtime.jar:?]
at com.ibm.ws.uow.embeddable.EmbeddableUOWManagerImpl.runUnderUOW(EmbeddableUOWManagerImpl.java:374) ~[com.ibm.ws.runtime.jar:?]
at org.springframework.transaction.jta.WebSphereUowTransactionManager.execute(WebSphereUowTransactionManager.java:287) ~[spring-tx-3.2.9.RELEASE.jar:3.2.9.RELEASE]
at org.springframework.transaction.support.TransactionTemplate.execute(TransactionTemplate.java:125) ~[spring-tx-3.2.9.RELEASE.jar:3.2.9.RELEASE]
at org.activiti.spring.SpringTransactionInterceptor.execute(SpringTransactionInterceptor.java:40) ~[activiti-spring-5.11.jar:?]
at org.activiti.engine.impl.interceptor.LogInterceptor.execute(LogInterceptor.java:32) ~[activiti-engine-5.11.jar:5.11]
at org.activiti.engine.impl.AbstractQuery.singleResult(AbstractQuery.java:103) ~[activiti-engine-5.11.jar:5.11]

Outcomes