Skip to Content

Archived discussions are read-only. Learn more about SAP Q&A

SUM - Failure DBSQL_STMNT_TOO_LARGE

Hello,

i have an Issue in running SUM. At Step "MAIN_SHDIMP/SUBMOD_SHD2_RUN/RUN_RSDROPCDSBAS" the Batchjob RSDROPCDSBAS is aborted with the Error "DBSQL_STMNT_TOO_LARGE".

I have read that this Error occurs when the Report tries to select wirh a huge WHERE Condition. But in the Debugging mode we can see that the select table for where condition has only 3672 entrys. Is there any ProfileParameter to fix this issue?

Application Server: 742

OS: Windows x64 / 8Gb RAM / 2 CPUs

Database Server: MaxDB 7.9

OS: Windows x64 / 8 GB RAM / 2 CPUs

Tags:
Former Member
Former Member replied

Martin

These 2 parameters need to be increased. 

1. SAP instance parameter

dbs/ada/input_parameters=10000

2.In Maxdb

CommandBufferSize   262144

0 View this answer in context
Not what you were looking for? View more on this topic or Ask a question