Solution : https://service.sap.com/sap/support/notes/13607 (SAP Service marketplace login required)
Summary :
An ABAP program terminates due to a SELECT statement leading to a DBIF_RSQL_INVALID_RSQL error, with the system log showing "The SQL statement came across a restriction of the database system". The issue stems from Open SQL statements in ABAP being translated to native SQL by the SAP database interface, violating database restrictions. The error often arises when range tables are used in the WHERE clause of a SELECT statement resulting in SQL statements that exceed database constraints like the maximum number of values in an IN clause, host-variables, or statement length. To resolve, diagnostics are made via dev_w[i] trace files and adjusting the Open SQL statement accordingly, possibly rewriting using FOR ALL ENTRIES.
Key words :
55 dia 2 se38 r68 roll-back ausführen14, describe table range_tab lines lines, 56 dia 2 se38 ab0 laufzeitfehler, 56 dia 2 se38 ab1 > kurzdump, big marker count = 6938 > max, previous open sql statement, case 'eq range_tab-low', open sql select statement, marker count = 3000with, operand range_tab-low
Related Notes :
| 1582026 | Dump when displaying last 10 documents in BAiO POWL |
| 1427036 | Extraction 0TB_CN_BCFC1 terminates with a dump |
| 1400234 | AMON: short dump when deleting heuristic planning alerts |
| 1383091 | AMON: Short dump when evaluating heuristic planning alerts |
| 1293704 | AMON: Open SQL dump (max. no. of input variables exceeded) |
| 940588 | Extraction: 0CRM_TGBP dumps - max SQL statement |
| 924948 | RPR_TRIP_HEADER_DATA: Short dump DBIF_RSQL_INVALID_RSQL |
| 859756 | |
| 798729 | Short dump when distributing material master |
| 791034 | DBIF_RSQL_INVALID_RSQL when you create wave picks |
| 730794 | VXA3: Runtime error DBIF_RSQL_INVALID_RSQL |
| 693170 | O3O_CT05 gives "RSQL error 13" |
| 667408 | RSNAST00: DBIF_RSQL_INVALID_RSQL Dump |
| 607468 | VT20: Termination with DBIF_RSQL_INVALID_RSQL |
| 575721 | Transaction ST03N terminates with DBIF_RSQL_INVALID_RSQL |
| 506722 | MIR6: Short dump when selecting the invoice |
| 502809 | DBIF_RSQL_INVALID_RSQL in RV_MESSAGE_READ |
| 442816 | Collective avail. check: Short dump DBIF_RSQL_INVALID_RSQL |
| 407622 | DBIF_RSQL_INVALID_RSQL in RV60SBAT |
| 397043 | Program termination during dynamic selections in PNP |
| 391373 | Short dump when releasing standing orders |
| 380377 | RSQL error 13, ANEP_READ_BWAGR_MULTI_AFABE, AB08 |
| 330416 | Sel.cond.>8kbytes: ABAP dump SAPSQL_WHERE_CANT_SCAN |
| 306587 | SCS:internal table too large for service charge key |
| 199668 | REP: Termintn.reporting upon single selection loan |
| 193481 | Termination of TA MDVP w/ DBIF_RSQL_INVALID_REQUEST |
| 179578 | Allocations: Runtime error with DBIF_RSQL_INVALID_RSQL |
| 178220 | COGI: Termination with RSQL ERROR 13 |
| 163650 | Int.calc.run:Dump DBIF_RSQL_INVALID_RSQL in DFKKOPW |
| 155284 | Dump aktuelle Bestandsliste |
| 144464 | VL10, RSQL error 22 in access to table ... |
| 124586 | RCATSTAL DBIF_RSQL_INVALID_RSQL error |
| 99201 | DBIF_RSQL_INVALID_RSQL for SELECT FOR ALL ENTRIES |
| 71654 | FI-LC: Document intervals in RGCSHD00 are too high |
| 63037 | AS/400: Deleting SQL Packages |
| 54028 | IBM i: SQL0 904 reason code 7, overflow in SQL package |