SQL query error when viewing a Variable Set or Script Module

When viewing a Variable Set or Script Module (within Library), the following error occurs:

Exception occured while executing a reader for SELECT * FROM dbo.[Machine] WHERE ([Id] IN (@id0, @id1, @id2, @id3, ... , @id2421, @id2422, @id2423, @id2424, @id2425, @id2426)) 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.

(I’ve escaped out most of the long Id list)

We have 2427 machines


Hi Leslie,

Thanks for getting in touch.

I have create a GitHub issue that you can track and contribute to: https://github.com/OctopusDeploy/Issues/issues/4442

I am to get a fix out soon.