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

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

    XMLWordPrintable

Details

    Description

      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

      mgm-controller-panel

        This is the controller panel for Smart Panels app

        Attachments

          Activity

            People

              nikola.koevski Nikola Koevski
              svetlana.dorokhova Svetlana Dorokhova
              Votes:
              0 Vote for this issue
              Watchers:
              5 Start watching this issue

              Dates

                Created:
                Updated:
                Resolved:

                Salesforce