Diese Seite ist nur auf Englisch verfügbar.

Maximum 2100 parameter support of MSSQL can lead to query failure

In MSSQL we have the problem, maximal 2100 parameters are allowed . (In Oracle it is fine.) With a large set of facilities and solution group Ids, the number of the parameters can exceed this limitation and cause db errors during ticket searching. Reference to MSSQL: https://learn.microsoft.com/en-us/sql/sql-server/maximum-capacity-specifications-for-sql-server?view=sql-server-ver16

This is a restriction from the db provider. Because of support of fine-grained-access-control, this possibility for this error to occur gets lower. For a normal user who has limited access to tickets from granted facilities, this problem might normally not happen. For an Admin User who has access to all tickets, the possible of this problem to occur is higher.

Possible solution:

Edit this pageDiese Seite bearbeiten

Feedback on this pageFeedback zu dieser Seite