We couldn't load all Actvitity tabs. Refresh the page to try again.
If the problem persists, contact your Jira admin.
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

      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

        This is the controller panel for Smart Panels app

            Loading...
            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

                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

                  This is the controller panel for Smart Panels app

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

                          Created:
                          Updated:
                          Resolved:

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

                                Created:
                                Updated:
                                Resolved: