Category Archives: activiti

Activi BPM Throwing Exception Error querying database. Cause: java.sql.SQLException: addSync: caught Exception

I have queried DB only single record exists into DB while We want to update the DB .Every Time For few of the applications activiti is throughing exception.

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]

Activiti BPM works with Eclipse neon?

I am new to Java development and working with Activiti BPM. I am getting started with them.

Activiti BPM says its verified with Eclipse Kepler. However I am using Eclipse Neon currently. I am trying to install Activiti plugin. It says it has to uninstall some plugins like Hana Cloud Plugins to continue with installation.

However I need both the plugins. So thought of using Eclipse Kepler to use Activiti BPM. But it supports till Apache Server 7 only ( and I have Apache 9 with Eclipse Neon )

Please suggest me a possible solution 1) Use Different eclipses to work with Hana Cloud Platform tools, Activiti BPM (Is it possible to setup multiple Apache Servers in same pc like Apache7 and Apache 9) 2) Can be done in Same Eclipse

May be its a quite silly question, please guide me as i am beginner.