SQL statement caused blocked and looping JWPs : The server supports a maximum of 2100 parameters

Products

• CA Automic Workload Automation - Automation Engine

Issue/Introduction

If a complex filter search filter is applied against the process monitoring and the resulting query contains more the 2100 bind parameters this may block the JWP.

In the JWP trace file the following message is found:

Caused by: 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.

Cause

The message "Caused by: 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." is passed from the JDBC driver, and is a limitation in the design of MSSQL Database.

If the user wants to have this limitation changed, he should contact the Vendor of their database.

 

Environment

Release : 12.3  Component : AUTOMATION ENGINE

Resolution

A improvement will be introduced in the near version that consists in:

-- A forced will be written when the problem occurs.

-- A message will pop up in AWI recommending to reduce the complexity of their search filter.

 

Additional Information

The problem is a third party problem, specifically related to the MS SQL Database, it is not due to the Automation Engine or to the Automic Web Interface.