DBIF_RSQL_SQL_ERROR run time error

95 Views

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