-
Type:
Bug Report
-
Resolution: Fixed
-
Priority:
L3 - Default
-
Affects Version/s: 7.13.0
-
Component/s: None
-
None
root cause:
- MSSQL has a fixed max limit of 2100 parameters per statement.
- Several test jobs fail consistently because they exceed 2100 parameters
- https://ci.cambpm.camunda.cloud/view/Seed-Jobs/job/7.13/job/7.13-platform-PERFORMANCE-large-data-sqlserver-2012/
- https://ci.cambpm.camunda.cloud/view/Seed-Jobs/job/7.13/job/7.13-platform-PERFORMANCE-large-data-sqlserver-2016/
- https://ci.cambpm.camunda.cloud/view/Seed-Jobs/job/7.13/job/7.13-platform-PERFORMANCE-large-data-sqlserver-2017/
solution:
- Break down query parameters into chunks smaller than 2100. See
CAM-10513.
### 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.