Jasper Report with CABI Reports: The server supports a maximum of 2100 parameters

Products

• DX Unified Infrastructure Management (Nimsoft / UIM)

Issue/Introduction

We could see the data for server availability in cabi but while exporting the data we are getting error like showing in below image.

and jasperserver debug logs as below error:

Caused by: java.sql.SQLException: [TibcoSoftware][SQLServer JDBC Driver][SQLServer]The incoming request has too many parameters. The server supports a maximum of 2100 parameters. Reduce the number of parameters and resend the request.     at tibcosoftware.jdbc.sqlserverbase.ddcw.b(Unknown Source)

 

Environment

Release : UIM 20.3/ 20.4

Component: CABI

Resolution

The error refers to a limitation of the Sql Server database.

There are two settings at 2,100. but you should check with your MS SQL administrator to determine which one is relevant:

Parameters per stored procedure

Parameters per user-defined function

The MS SQL parameters are documented here,

https://learn.microsoft.com/en-us/sql/sql-server/maximum-capacity-specifications-for-sql-server?view=sql-server-ver16,

There is not really anything that can be done from UIM. You'll need to check with your Database Administrator. If the size limit cannot be increased, try breaking up your reports into smaller pieces, if possible.