SQL query error when viewing a Variable Set or Script Module

performance

(leslie.lintott) #1

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

Cheers
Leslie


SQL error when connecting project to tenant
(Shane Gill) #3

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.

Cheers,
Shane