-
Bug Report
-
Resolution: Fixed
-
L3 - Default
-
7.8.0
Steps to reproduce:
- go to Cockpit
- open Batch Operation View
- select batch operation "Delete running process instances"
- select more than 1000 process instances to delete
- submit the batch operation
Observed Behavior:
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) [mybatis-3.4.4.jar:3.4.4] at org.apache.ibatis.session.defaults.DefaultSqlSession.selectList(DefaultSqlSession.java:150) [mybatis-3.4.4.jar:3.4.4] at org.apache.ibatis.session.defaults.DefaultSqlSession.selectList(DefaultSqlSession.java:141) [mybatis-3.4.4.jar:3.4.4] at org.camunda.bpm.engine.impl.db.sql.DbSqlSession.selectList(DbSqlSession.java:95) [camunda-engine-7.8.0-ee.jar:7.8.0-ee] at org.camunda.bpm.engine.impl.db.entitymanager.DbEntityManager.selectListWithRawParameter(DbEntityManager.java:173) [camunda-engine-7.8.0-ee.jar:7.8.0-ee] at org.camunda.bpm.engine.impl.db.entitymanager.DbEntityManager.selectList(DbEntityManager.java:165) [camunda-engine-7.8.0-ee.jar:7.8.0-ee] at org.camunda.bpm.engine.impl.db.entitymanager.DbEntityManager.selectList(DbEntityManager.java:161) [camunda-engine-7.8.0-ee.jar:7.8.0-ee] at org.camunda.bpm.engine.impl.db.entitymanager.DbEntityManager.selectList(DbEntityManager.java:145) [camunda-engine-7.8.0-ee.jar:7.8.0-ee] at org.camunda.bpm.engine.impl.persistence.entity.DeploymentManager.findDeploymentIdsByProcessInstances(DeploymentManager.java:235) [camunda-engine-7.8.0-ee.jar:7.8.0-ee] at org.camunda.bpm.engine.impl.batch.deletion.DeleteProcessInstancesJobHandler$1.call(DeleteProcessInstancesJobHandler.java:103) [camunda-engine-7.8.0-ee.jar:7.8.0-ee] at org.camunda.bpm.engine.impl.batch.deletion.DeleteProcessInstancesJobHandler$1.call(DeleteProcessInstancesJobHandler.java:100) [camunda-engine-7.8.0-ee.jar:7.8.0-ee] at org.camunda.bpm.engine.impl.interceptor.CommandContext.runWithoutAuthorization(CommandContext.java:473) [camunda-engine-7.8.0-ee.jar:7.8.0-ee] at org.camunda.bpm.engine.impl.batch.deletion.DeleteProcessInstancesJobHandler.createJobs(DeleteProcessInstancesJobHandler.java:100) [camunda-engine-7.8.0-ee.jar:7.8.0-ee] at org.camunda.bpm.engine.impl.batch.BatchSeedJobHandler.execute(BatchSeedJobHandler.java:51) [camunda-engine-7.8.0-ee.jar:7.8.0-ee] at org.camunda.bpm.engine.impl.batch.BatchSeedJobHandler.execute(BatchSeedJobHandler.java:32) [camunda-engine-7.8.0-ee.jar:7.8.0-ee] at org.camunda.bpm.engine.impl.persistence.entity.JobEntity.execute(JobEntity.java:129) [camunda-engine-7.8.0-ee.jar:7.8.0-ee] at org.camunda.bpm.engine.impl.cmd.ExecuteJobsCmd.execute(ExecuteJobsCmd.java:99) [camunda-engine-7.8.0-ee.jar:7.8.0-ee] at org.camunda.bpm.engine.impl.cmd.ExecuteJobsCmd.execute(ExecuteJobsCmd.java:36) [camunda-engine-7.8.0-ee.jar:7.8.0-ee] at org.camunda.bpm.engine.impl.interceptor.CommandExecutorImpl.execute(CommandExecutorImpl.java:24) [camunda-engine-7.8.0-ee.jar:7.8.0-ee] at org.camunda.bpm.engine.impl.interceptor.CommandContextInterceptor.execute(CommandContextInterceptor.java:104) [camunda-engine-7.8.0-ee.jar:7.8.0-ee] at org.camunda.bpm.engine.impl.interceptor.JtaTransactionInterceptor.execute(JtaTransactionInterceptor.java:58) [camunda-engine-7.8.0-ee.jar:7.8.0-ee] at org.camunda.bpm.engine.impl.interceptor.ProcessApplicationContextInterceptor.execute(ProcessApplicationContextInterceptor.java:66) [camunda-engine-7.8.0-ee.jar:7.8.0-ee] at org.camunda.bpm.engine.impl.interceptor.LogInterceptor.execute(LogInterceptor.java:30) [camunda-engine-7.8.0-ee.jar:7.8.0-ee] at org.camunda.bpm.engine.impl.jobexecutor.ExecuteJobHelper.executeJob(ExecuteJobHelper.java:36) [camunda-engine-7.8.0-ee.jar:7.8.0-ee] at org.camunda.bpm.engine.impl.jobexecutor.ExecuteJobHelper.executeJob(ExecuteJobHelper.java:29) [camunda-engine-7.8.0-ee.jar:7.8.0-ee] at org.camunda.bpm.engine.impl.jobexecutor.ExecuteJobsRunnable.executeJob(ExecuteJobsRunnable.java:88) [camunda-engine-7.8.0-ee.jar:7.8.0-ee] at org.camunda.bpm.engine.impl.jobexecutor.ExecuteJobsRunnable.run(ExecuteJobsRunnable.java:57) [camunda-engine-7.8.0-ee.jar:7.8.0-ee] at org.jboss.threads.SimpleDirectExecutor.execute(SimpleDirectExecutor.java:33) at org.jboss.threads.QueueExecutor.runTask(QueueExecutor.java:808) at org.jboss.threads.QueueExecutor.access$100(QueueExecutor.java:45) at org.jboss.threads.QueueExecutor$Worker.run(QueueExecutor.java:849) at java.lang.Thread.run(Thread.java:745) [rt.jar:1.8.0_65] at org.jboss.threads.JBossThread.run(JBossThread.java:122)
Expected Behavior:
The batch operation can be executed whithout any exception.
Hint:
The fix of CAM-8004 can be applied here.