SUM - Failure DBSQL_STMNT_TOO_LARGE

[Former Member]

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

[Former Member · Accepted solution]

Martin,

I got the same error yesterday evening.

Running

Kernel 742

Linux RH

MaxDB 7.9

Database version 7.9.8.023

SAP DB version 742

Have you raised a message with SAP yet?  I am building a Demo system so response in my case may be slower but will be raising a message in the next hour.

Thanks

Matthew  Gardiner

[Former Member · Accepted solution]

Hi Matthew,

in my case the System is also an Demo System. I will raise a message this evening to sap.

[Former Member · Accepted solution]

Martin

These 2 parameters need to be increased. 

1. SAP instance parameter

dbs/ada/input_parameters=10000

2.In Maxdb

CommandBufferSize   262144

[Former Member · Accepted solution]

Thanks a lot!

[Former Member · Accepted solution]

Did it work? My upgrade finished last night.

[Former Member · Accepted solution]

Yes, it worked

Now i have a new issue at the Import ABAP Step a second Server. SAP Netweaver 7.5 as Gateway