In Cockpit, I cannot set retries for external tasks for more than 1000 running process instances

XMLWordPrintable

      Steps to reproduce the problem

      1. go to Cockpit
      2. open Batch Operation View
      3. select batch operation "Set retries of external tasks belonging to process instances"
      4. select more than 1000 process instances
      5. 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

            Assignee:
            Nikola Koevski
            Reporter:
            Svetlana Dorokhova
            Votes:
            0 Vote for this issue
            Watchers:
            5 Start watching this issue

              Created:
              Updated:
              Resolved: