Symptom
Dump DBSQL_STMNT_TOO_LARGE occurs while accessing tables (especially large tables with huge number of entries, such as BSEG) using transaction SE16, for example:
| Category | ABAP program Error |
| Runtime Error | DBSQL_STMNT_TOO_LARGE |
| ABAP Program | /1BCDWB/* |
| Application Component |
no assignment |
In section "Error analysis" of the dump, the following (or similar) can be found:
| Number of DBSL marker exceeded |
| Current = 45687 |
| "Maximum = 32767"
In the devlopper traces the following can be found :
C *** ERROR => too many input values (<...>) - maximum is 32767
B ***LOG BYK=> current SQL statement exceeds a database limit
Important! The solution in this document is for dump DBSQL_STMNT_TOO_LARGE with error 'Number of DBSL marker exceeded', however it can also be used for the other type of errors when the dump name is DBIF_RSQL_INVALID_RSQL or DBIF_RSQL_INVALID_REQUEST. Since all these dumps mean that the SQL statement came across a restriction of the database system.
Read more...
Environment
SAP NetWeaver release independent.
Product
Keywords
statement too big, no. of entries, SE16, DBIF_RSQL_INVALID_RSQL, DBIF_RSQL_INVALID_REQUEST, DBSQL_STMNT_TOO_LARGE, /1BCDWB/, marker ,Open SQL command is too big , KBA , BC-DB-DBI , DB Independent Database Interface , BC-DWB-UTL-BRD , Data Browser , Problem
About this page
This is a preview of a SAP Knowledge Base Article. Click more to access the full version on SAP for Me (Login required).Search for additional results
Visit SAP Support Portal's SAP Notes and KBA Search.
SAP Knowledge Base Article - Preview