Hyland Connect

miloszpp · ‎06-17-2013

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 · ‎06-17-2013

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

Best regards,

miloszpp · ‎06-17-2013

Yes I did.

I only noticed this bug when I left the app working over the weekend so I guess it might be related to job execution (I've got some timers in my process).

<code>
<bean id="processEngineConfiguration" class="org.activiti.spring.SpringProcessEngineConfiguration">
<property name="dataSource" ref="dataSource" />
<property name="databaseType" value="db2" />
</code>

trademak · ‎06-17-2013

Would it be possible to test this against the 5.12.1 or the 5.13 that will be release in a few days? Really strange.

Best regards,

miloszpp · ‎06-17-2013

Got it, my fault. I recently upgraded to 5.10 and forgot to remove a workaround to http://jira.codehaus.org/browse/ACT-1170.

Sorry and thanks for your reply.

<code>
addDatabaseSpecificStatement("db2", "selectExclusiveJobsToExecute", "selectExclusiveJobsToExecute_oracle");
</code>