Details
-
Bug Report
-
Resolution: Fixed
-
L3 - Default
-
7.14.0, 7.13.5
-
None
Description
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.
- Create 3000 process instances
- Go to Batch Operations in Cockpit
- Select the "Set retries of Jobs belonging to the Process Instances" operation
- Set Retries to "2"
- Click on Confirm
- 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.