Error when viewing violations in Angular Web Portal: "IN clause exceeds the limit of 1024 elements" (4381748)

When using the Angular Web Portal, an HTTP 500 error may occur while searching for policy violations if the result set is large.

This issue is observed when:

1. Logging into the Angular Web Portal
2. Navigating to Policy Violations
3. Entering a value into the search field

Instead of returning filtered results, the portal displays an "An error occurred while processing your request" message.

In the logs the following error message is visible: 

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

This problem occurs with out-of-the-box queries, with no customizations whatsoever.

The error is caused by a database limitation on the maximum number of elements allowed in an SQL IN clause.

When a search is performed and the number of matching policy violations is high, the backend query exceeds the database limit of 1024 elements in an IN clause. As a result, the API server fails to process the request and returns an HTTP 500 error.

This has been acknowledged as product defect #467077.

If you encounter this issue, please contact Support and request for Hotfix #467077.