IllegalArgumentException: Mapped Statements collection does not contain value for selectExclusiveJobsToExecute_oracle

As we transition to the new Hyland Community, some post links may be temporarily disrupted as we finalize redirects. We apologize for the inconvenience and are working to resolve this as quickly as possible. Details.

miloszpp

Hi!

I've just noticed these messages in the logfile for my application. It mentions Oracle (selectExclusiveJobsToExecute_oracle) although I'm using DB2 for the datasource. I'm using Activiti 5.10.

I found this: http://forums.activiti.org/content/mapped-statements-collection-does-not-contain-value-0 but it doesn't seem to be related.

2013-06-17 07:18:15 [ERROR] o.a.e.i.interceptor.CommandContext - Error while closing command context [CommandContext.java:129]
org.apache.ibatis.exceptions.PersistenceException: 
### Error querying database.  Cause: java.lang.IllegalArgumentException: Mapped Statements collection does not contain value for selectExclusiveJobsToExecute_oracle
### Cause: java.lang.IllegalArgumentException: Mapped Statements collection does not contain value for selectExclusiveJobsToExecute_oracle
   at org.apache.ibatis.exceptions.ExceptionFactory.wrapException(ExceptionFactory.java:8) ~[mybatis-3.0.6.jar:3.0.6]
   at org.apache.ibatis.session.defaults.DefaultSqlSession.selectList(DefaultSqlSession.java:81) ~[mybatis-3.0.6.jar:3.0.6]
   at org.activiti.engine.impl.db.DbSqlSession.selectList(DbSqlSession.java:213) ~[activiti-engine-5.10.jar:5.10]
   at org.activiti.engine.impl.db.DbSqlSession.selectList(DbSqlSession.java:200) ~[activiti-engine-5.10.jar:5.10]
   at org.activiti.engine.impl.db.DbSqlSession.selectList(DbSqlSession.java:181) ~[activiti-engine-5.10.jar:5.10]
   at org.activiti.engine.impl.persistence.entity.JobManager.findExclusiveJobsToExecute(JobManager.java:118) ~[activiti-engine-5.10.jar:5.10]
   at org.activiti.engine.impl.cmd.AcquireJobsCmd.execute(AcquireJobsCmd.java:62) ~[activiti-engine-5.10.jar:5.10]
   at org.activiti.engine.impl.cmd.AcquireJobsCmd.execute(AcquireJobsCmd.java:33) ~[activiti-engine-5.10.jar:5.10]
   at org.activiti.engine.impl.interceptor.CommandExecutorImpl.execute(CommandExecutorImpl.java:24) ~[activiti-engine-5.10.jar:5.10]
   at org.activiti.engine.impl.interceptor.CommandContextInterceptor.execute(CommandContextInterceptor.java:42) ~[activiti-engine-5.10.jar:5.10]
   at org.activiti.spring.SpringTransactionInterceptor$1.doInTransaction(SpringTransactionInterceptor.java:42) [activiti-spring-5.10.jar:na]
   at org.springframework.transaction.support.TransactionTemplate.execute(TransactionTemplate.java:130) [org.springframework.transaction.jar:3.1.1.RELEASE]
   at org.activiti.spring.SpringTransactionInterceptor.execute(SpringTransactionInterceptor.java:40) [activiti-spring-5.10.jar:na]
   at org.activiti.engine.impl.interceptor.LogInterceptor.execute(LogInterceptor.java:33) [activiti-engine-5.10.jar:5.10]
   at org.activiti.engine.impl.jobexecutor.AcquireJobsRunnable.run(AcquireJobsRunnable.java:57) [activiti-engine-5.10.jar:5.10]
   at java.lang.Thread.run(Thread.java:662) [na:1.6.0_27]
Caused by: java.lang.IllegalArgumentException: Mapped Statements collection does not contain value for selectExclusiveJobsToExecute_oracle
   at org.apache.ibatis.session.Configuration$StrictMap.get(Configuration.java:595) ~[mybatis-3.0.6.jar:3.0.6]
   at org.apache.ibatis.session.Configuration.getMappedStatement(Configuration.java:437) ~[mybatis-3.0.6.jar:3.0.6]
   at org.apache.ibatis.session.Configuration.getMappedStatement(Configuration.java:430) ~[mybatis-3.0.6.jar:3.0.6]
   at org.apache.ibatis.session.defaults.DefaultSqlSession.selectList(DefaultSqlSession.java:78) ~[mybatis-3.0.6.jar:3.0.6]
   … 14 common frames omitted
‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍

trademak

Did you set the databaseType to db2 in your process engine configuration?

Best regards,