-
Type:
Bug Report
-
Resolution: Fixed
-
Priority:
L3 - Default
-
Affects Version/s: None
-
Component/s: engine
Steps to reproduce the problem
- go to Cockpit
- open Batch Operation View
- select batch operation "Set retries of external tasks belonging to process instances"
- select more than 1000 process instances
- submit the batch operation
Current behaviour:
When Oracle is used as database, then the following exception is thrown:
### Cause: java.sql.SQLSyntaxErrorException: ORA-01795: maximum number of expressions in a list is 1000
at org.apache.ibatis.exceptions.ExceptionFactory.wrapException(ExceptionFactory.java:30)
at org.apache.ibatis.session.defaults.DefaultSqlSession.selectList(DefaultSqlSession.java:150)
at org.apache.ibatis.session.defaults.DefaultSqlSession.selectList(DefaultSqlSession.java:141)
at org.camunda.bpm.engine.impl.db.sql.DbSqlSession.selectList(DbSqlSession.java:95)
at org.camunda.bpm.engine.impl.db.entitymanager.DbEntityManager.selectListWithRawParameter(DbEntityManager.java:177)
at org.camunda.bpm.engine.impl.db.entitymanager.DbEntityManager.selectList(DbEntityManager.java:169)
at org.camunda.bpm.engine.impl.persistence.entity.ExternalTaskManager.findExternalTaskIdsByQueryCriteria(ExternalTaskManager.java:88)
at org.camunda.bpm.engine.impl.ExternalTaskQueryImpl.executeIdsList(ExternalTaskQueryImpl.java:227)
at org.camunda.bpm.engine.impl.AbstractQuery.evaluateExpressionsAndExecuteIdsList(AbstractQuery.java:330)
at org.camunda.bpm.engine.impl.AbstractQuery.listIds(AbstractQuery.java:324)
at org.camunda.bpm.engine.impl.cmd.AbstractSetExternalTaskRetriesCmd$1.call(AbstractSetExternalTaskRetriesCmd.java:74)
at org.camunda.bpm.engine.impl.cmd.AbstractSetExternalTaskRetriesCmd$1.call(AbstractSetExternalTaskRetriesCmd.java:69)
at org.camunda.bpm.engine.impl.interceptor.CommandContext.runWithoutAuthorization(CommandContext.java:473)
at org.camunda.bpm.engine.impl.cmd.AbstractSetExternalTaskRetriesCmd.collectExternalTaskIds(AbstractSetExternalTaskRetriesCmd.java:69)
at org.camunda.bpm.engine.impl.cmd.SetExternalTasksRetriesBatchCmd.execute(SetExternalTasksRetriesBatchCmd.java:26)
at org.camunda.bpm.engine.impl.cmd.SetExternalTasksRetriesBatchCmd.execute(SetExternalTasksRetriesBatchCmd.java:18)
at org.camunda.bpm.engine.impl.interceptor.CommandExecutorImpl.execute(CommandExecutorImpl.java:24)
at org.camunda.bpm.engine.impl.interceptor.CommandContextInterceptor.execute(CommandContextInterceptor.java:104)
... 56 more
Expected behaviour: operation is executed without exceptions.
Hint: fix from CAM-8004 can be also applied here