Exception occurred while executing a reader for SELECT * FROM dbo.[Project] WHERE ([Id] IN (@id0_0, @id1_1, @id2_2... @id5127_5127)) ORDER BY [Id]
SQL 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 occurred when attempting to delete a Variable Set contained by multiple projects.
Hi Louis,
Thanks for getting in touch! I’ll need to grab some further information from you here. I have some questions below which should help with troubleshooting.
Would you be able to let me know what version of Octopus deploy you are currently using?
Would you be able to attach a screenshot of where you see this error?
Does it occur when trying to delete the variable set via the Octopus web portal UI?
Could you please attach a copy of your most recent Octopus server log after seeing this error? (C:\Octopus\Logs in a default installation)
Looking forward to hearing from you and getting to the bottom of this. 
Best regards,
This topic was automatically closed 30 days after the last reply. New replies are no longer allowed.