Upgraded OD Server to 2021.2.7727 running into an error when using the deployments endpoint. Trying to get the latest deployment id for a specific environment with the following
I’m getting the following error, subtracted 100’s of @taskid parameters
Exception occurred while executing a reader for SELECT *\r\nFROM [dbo].[Deployment]\r\nWHERE ((([SpaceId] = ‘Spaces-1’)))\r\nAND ([ProjectId] IN (@projectid1))\r\nAND ([EnvironmentId] IN (@environmentid1))\r\nAND ([TaskId] IN (@taskid1, @taskid2, … \r\nORDER BY [Created] DESC
\r\nSQL Error 8003 - The incoming request has too many parameters. The server supports a maximum of 2100 parameters. Reduce the number of parameters and resend the request.
This has been working perfectly fine until we upgraded. Any idea what is wrong?