SAP Note 1552952 - Parameter maxmarkercnt increased to 10000

Component : Microsoft SQL Server -

Solution : https://service.sap.com/sap/support/notes/1552952 (SAP Service marketplace login required)

Summary :
An ABAP runtime error, DBIF_RSQL_INVALID_RSQL, indicates an excessive number of input variables exceeds the SQL Server limit of 2090 parameters. This issue arises from the database interface's maximum marker count limit. To remedy this, the DBSL interface for SQL Server has been adjusted in SAP kernel releases 7.10, 7.11, and 7.20. Latest updates involve incrementing the maxmarkercnt to 10000 and integrating runtime library changes. For a complete resolution, systems running on SQL Server 2005 or newer can employ literal value substitutions in their statements and utilize the updated lib_dbsl in specified kernel versions.

Key words :
symptom abap runtime error dbif_rsql_invalid_rsql occurs indicating, support database hints &substitute literals&, big marker count = 3000 > max, kernel/dbsl versions mentioned, error => dbtran error, dll runtime library, marker count = 2090 reason, maximum marker count, developer trace file, latest lib_dbsl dbmssslib

Related Notes :

1567871SUIM| Performance optimization for RSUSR020
133381Database-Hints in Open SQL for MS SQL Server
129385Database hints in Open SQL