Jasper Report with Governance Reports: The server supports a maximum of 2100 parameters
Article ID: 269127
Updated On:
Products
Issue/Introduction
Trying to generate a Certified Resources with Violations Highlighted report in Governance using Jasper Reports version 7
When selecting Select All under Application Name results in the Error message:
There was an error on the server. Try again or contact site administrators. (Error UID: 8d4a3163-XXXX-XXXX-XXXX-70cfe1341f9c)
This particular campaign has 2405 Application Names and you can select the first 2000+ and it runs fine, then you can select the remainder and it generates an empty report
Logging into the Jasper server directly and selecting 2200 records out of 2906 shown as available generates this error message:
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.
Environment
Release : 14.4
Cause
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
Resolution
The MS SQL parameters are documented here,
There is not really anything that can be done from Identity Governance. You'll need to check with your Database Adminstrator. If the size limit cannot be increased, try breaking up your reports into smaller pieces, if possible.
Feedback
