Error: The IN clause exceeds the limit of 1024 elements. Modify the query. (4376908)

When rejecting attestations in the portal, the following error message will be displayed:

VI.DB.InClauseLimitException: The IN clause exceeds the limit of 1024 elements. Modify the query.

Starting in Identity Manager version 8.2 and up, VI.DB ISqlFormatter.InClauseLimit has been changed from 8000 to 1024. The limit was intentionally reduced to avoid SQL Server query failures and stability issues caused by very large parameterized IN (...) lists. SQL Server enforces hard constraints in this area, so increasing the limit or making it configurable from Identity Manager is unfortunately not a functional solution.  

WORKAROUND:

To work within the constraints of SQL, the supported and reliable approach when a request exceeds this limit is to split it into multiple queries or refactor the filter logic so large IN lists are avoided. 

STATUS:

The Identity Manager Product Team are working on enhancing our documentation to include best practices on breaking up requests using the existing limit and merging them as required.