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 )
CA Business Intelligence (CABI) 3.x or 4.1
SQL Server CA Service Desk Manager MDB
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:
Redesign the custom CABI WEBI report so that it does not contain more than 2100 parameters.