ST22 Runtime error DBIF_RSQL_INVALID_RSQL

Issue:

Runtime error DBIF_RSQL_INVALID_RSQL occurs.
The error analysis shows: Possible error causes:
 
1. The maximum size of an SQL statement was exceeded.

2. The statement contains too many input variables.

3. The input data requires more space than is available.
 
The developer trace file shows:

B *** ERROR => dbtran (prepare_bulk_cond): FOR ALL ENTRIES statement on table '' is too complex [dbtran.c 15294] B *** ERROR => Computed size of input values (78140) exceeds max. input buffer size (40960) [dbtran.c 15318] In later kernel releases, 7.41 and higher, the problem produces a runtime error with the code DBSQL_FAE_STATEMENT_TO_BIG, and the internal information shows something similar to:

The value of "values_sz" is 44892. This is greater than value 40960 of "buffersize".

Possible errors.

DBIF_RSQL_INVALID_RSQL, FOR ALL ENTRIES, FAE, complex, 40960, MAX_ARRAY_BUF_SIZE

Reason and Prerequisites:

DBSL parameter MAX_ARRAY_BUF_SIZE (the maximum size of the input/output buffer for array operations) for SQL Server has the value of 40960. 

Resolution:

A new DBSL patch has been provided where this value can be increased by setting profile parameter dbs/mss/array_buf_size. The parameter is specified in bytes. It is recommended to set it to a multiple of 40960.


Note: This parameter is now available in all kernel versions 7.00 and higher.






more details SAP KBA: 1414232