Uploaded image for project: 'camunda BPM'
  1. camunda BPM
  2. CAM-8738

In Cockpit, I cannot delete more than 1000 running process instances

    Details

    • Type: Bug Report
    • Status: Closed
    • Priority: L3 - Default
    • Resolution: Fixed
    • Affects Version/s: 7.8.0
    • Fix Version/s: 7.9.0, 7.8.2, 7.9.0-alpha2
    • Component/s: engine
    • Labels:

      Description

      Steps to reproduce:

      1. go to Cockpit
      2. open Batch Operation View
      3. select batch operation "Delete running process instances"
      4. select more than 1000 process instances to delete
      5. 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.

        Activity

        There are no comments yet on this issue.

          People

          • Assignee:
            yana.vasileva Yana Vasileva
            Reporter:
            roman.smirnov Smirnov Roman
          • Votes:
            0 Vote for this issue
            Watchers:
            3 Start watching this issue

            Dates

            • Created:
              Updated:
              Resolved:

              Development