SQLServerException: The server supports a maximum of 2100 parameters


I have created an customized bulk upload, and where I’m able to select entities from the gird to bulk edit them.

I’m facing a problem when the selection is higher than 2100 entities and getting the error below :

SQLServerException: The incoming request has too many parameters. The server supports a maximum of 2100 parameters. Reduce the number of parameters and resend the request.

Can anyone suggest any configuration, or… should I modify the code?

The error is caused by :

<b>protected </b>List<Entity> loadItems(View view) //BulkEditorWindow


I had to override function and apply some modifications.
Basically I split the query to avoid the 2100 limit of params.

Let me know if anyone is having any better idea. Thanks :slight_smile: