Error running custom CA Business Intelligence (CABI) report: AHD04199:An unexpected error occurred . Contact the administrator. [Microsoft OLE DB Provider for SQL Server] [ SQL Code=8003 SQL State=42000] The incoming request has too many parameters.

Document ID : KB000046084
Last Modified Date : 14/02/2018
Show Technical Document Details

Issue

When running a custom CA Business Intelligence (CABI) Web Intelligence (WEBI) report, receive an error message similar to the following:

[DataDirect][ODBC OpenAccess SDK driver][OpenAccess SDK SQL Engine]AHD12002:Error in QueryHandler in fetch_response method: AHD04199:An unexpected error occurred . Contact the administrator. [Microsoft OLE DB Provider for SQL Server] [ SQL Code=8003 SQL State=42000] The incoming request has too many parameters. The server supports a maximum of 2100 parameters. Reduce the number of parameters and resend the request.. (IES 10901) (Error: INF )

Environment

CA Business Intelligence (CABI) 3.x or 4.1

SQL Server CA Service Desk Manager MDB

Cause

Facing a SQL Server limitation since SQL Server has a limit of 2100 parameters in a single request.

This is documented at the following URL: 

https://social.msdn.microsoft.com/Forums/sqlserver/en-US/f2ec73eb-f1e0-4048-95d0-1b1ff6c6fdf3/maximum-parameters-in-where-clause

Workaround

Redesign the custom CABI WEBI report so that it does not contain more than 2100 parameters.