Details
-
Bug Report
-
Resolution: Fixed
-
L3 - Default
-
None
Description
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