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

Unable to set retries using the batch operation when more than 2100 instances selected

XMLWordPrintable

    • Icon: Bug Report Bug Report
    • Resolution: Fixed
    • Icon: L3 - Default L3 - Default
    • 7.14.5, 7.15.0-alpha4, 7.15.0
    • 7.14.0, 7.13.5
    • None

      What are the steps to reproduce your problem?

      Reproduced this issue in both the customers environment 7.13.5-ee and 7.14.0-ee.

      1. Create 3000 process instances
      2. Go to Batch Operations in Cockpit
      3. Select the "Set retries of Jobs belonging to the Process Instances" operation
      4. Set Retries to "2"
      5. Click on Confirm
      6. Click on Execute Operation

      What is the problem?

      You will see the "Cause: com.microsoft.sqlserver.jdbc.SQLServerException: The incoming request has too many parameters. The server supports a maximum of 2100 parameters. Reduce the number of parameters and resend the request." Error

       

      What would be the expected behavior:

      That it works

       

      Hints (optional):

      Divide the fetch of jobs by processInstanceIds in smaller chunks, executing several jobQueries requests with a chunks of the processInstanceIds. (ref: https://github.com/camunda/camunda-bpm-platform/blob/b59f7b8487b670eacbbe2f9f0f3930157da5585e/engine/src/main/java/org/camunda/bpm/engine/impl/persistence/entity/JobManager.java#L265)
      That way will cover most of the batch operations that might failed due to too many process instances passed in the request.

        This is the controller panel for Smart Panels app

              nikola.koevski Nikola Koevski
              richard.kohl Richard Kohl
              Votes:
              0 Vote for this issue
              Watchers:
              1 Start watching this issue

                Created:
                Updated:
                Resolved: