search cancel

TDM Find API returns Error: The incoming request has too many parameters.

book

Article ID: 134067

calendar_today

Updated On:

Products

CA Test Data Manager (Data Finder / Grid Tools)

Issue/Introduction

I have a Find & Reserve form with 69 model keys which was created using the legacy model.
It returns only 100 records on finding data whereas the expected result should have more than 100 rows.
I tried reducing the number of model keys and observed that when I reduced it to 64 model keys the result set refreshes with next set of records upon scrolling down and works as expected.
Can this issue be fixed, please advise?

Few additional details:
Version: CA TDM 4.7
All the model keys are columns from a single table in SQL server database.
Model keys are selected to be either dropdowns, text filters, some of them are displayed on self service and the rest are hidden to be only part of the result set.

 

Below is the error message that I get when I use TDM Find API to access the form and try to fetch the next hundred rows of data,

{
    "status": 500,
   "errorCode": "500",
    "errorMsg": "The incoming request has too many parameters. The server supports a maximum of 2100 parameters. Reduce the number of parameters and resend the request.",
    "errorDetail": "",
    "timestamp": "2019-07-01T14:45+0000"

}

Environment

Test Data Manager
TDM

Resolution

I ran this error by our developers, and they said you are hitting a Database limitation.
SQL Server supports a maximum of 2100 parameters for in statements.
You will need to work with your DBA to determine how you have reached these conditions, and what can be done to prevent you from hitting the SQL Server limit.
This is not a TDM issue.