TDM Portal returns error: The incoming request has too many parameters.

Products

• CA Test Data Manager (Data Finder / Grid Tools)

Issue/Introduction

The following error is seen in the TDM Portal logs:

"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

TDM Portal - all supported releases

Cause

This is a SQL Server database limitation. SQL Server supports a maximum of 2100 parameters for statements.

Resolution

Work with a MS SQL Server DBA to determine how this condition was reached, and what can be done to prevent hitting the SQL Server limitation in the future.

There are two SQL Server settings at 2100, but the MS SQL DBA needs to determine which one is relevant:

• Parameters per stored procedure
• Parameters per user-defined function

This is not a TDM issue.

Additional Information

The MS SQL parameters are documented here:

• Maximum capacity specifications for SQL Server