DBIF_RSQL_SQL_ERROR run time error

[Former Member]

HI All,

I am working on windows server ,DB2 database, ECC6.0

I am getting this run time error more oftenly, it shows

Runtime Errors DBIF_RSQL_SQL_ERROR

Exception CX_SY_OPEN_SQL_DB

Date and Time 07.05.2010 20:44:42

Short text

SQL error in the database when accessing a table.

How to correct the error

Database error text........: "SQL0101N The statement is too long or too

complex. SQLSTATE=54001"

Internal call code.........: "[RSQL/OPEN/EKKO ]"

Please check the entries in the system log (Transaction SM21).

If the error occures in a non-modified SAP program, you may be able to

find an interim solution in an SAP Note.

If you have access to SAP Notes, carry out a search with the following

keywords:

"DBIF_RSQL_SQL_ERROR" "CX_SY_OPEN_SQL_DB"

"SAPLMEPOLDB" or "LMEPOLDBU02"

"ME_READ_EKKO_MULTIPLE"

And in sm21 log report shows

19:24:52 DIA 001 900 ACCOUNTS BY 4 Database error -101 at SEL access to table EKKO

19:24:52 DIA 001 900 ACCOUNTS BY 0 > SQL0101N The statement is too long or too complex.

19:24:52 DIA 001 900 ACCOUNTS BY 0 > SQLSTATE=54001

19:24:52 DIA 001 900 ACCOUNTS R6 8 Perform rollback

19:24:52 DIA 001 900 ACCOUNTS AB 0 Run-time error "DBIF_RSQL_SQL_ERROR" occurred

1

I checked the tablespace size some of them showing 99 % full but auto resize is enabled for all tablespaces.

Is this problem with EKKO table or tablespace.

i am unbale to find root cause for this issue,please suggest me

Thanks

Shashi

[Former Member · Accepted solution]

HI,

Check if this note is relevant

Note 1429354 - DBIF_RSQL_SQL_ERROR during package compilation on DB6

Regards,

[Former Member]

HI

Only solution i knew is sit with your ABAP Team and Ask them to analyse the Program.

Thanks

[Former Member]

Hi,

Please check and maintain your table space at 80% level

Regards

D.Mukunthan

[Former Member]

Hi,

The first thing check the disk or tablespace is full.

Please check that.

[Former Member]

Hi all,

Thanks for your response..

@ Gokul,

i go through your link. it sounds good is there only way for this is Increase the DB2 Statement Heap Size or any other way is there

so from sap can i change stmt heap size through parameter dbs/db6/dbsl_max_stmt_size.

pls suggest me

@ Raj,

As i said Auto resize is a enabled for all tablespaces.still u think the problem with tablespace.

Thanks in Advance

Regards

Shashi

[Former Member]

HI,

Procedure to increase heap size is given in link itself

http://www-01.ibm.com/support/docview.wss?rs=767&context=SSVJJU&dc=DB520&uid=swg21230096&loc=en_US&c...

Regards,

[Former Member]

Hi ,

Below link and Sap NOTE will help you to resolve the issue

[http://www-01.ibm.com/support/docview.wss?rs=767&context=SSVJJU&dc=DB520&uid=swg21230096&loc=en_US&cs=UTF-8&lang=en]

Sap Note 1418685 - DB6: Maximum SQL statement length

Edited by: Gokul Bhogabandi SP4Z127A283B on May 8, 2010 10:12 AM