DBIF_RSQL_SQL_ERROR error occuring only in DEV system

[Former Member]

Hello Experts,

I am facing this strange error in DEV.

As I said in DEV is I am able to execute the same program in Quality and production without any issues or any errors.

I am running this program in BackGround only.

I am getting this error only in DEV. As i went thorugh some other similar questions here and checked to see the ABAP/4 buffer size via RZ10.

Please suggest me what I need to do.

The exception must either be prevented, caught within the procedure

"GET_CO_RECORDS"

"(FORM)", or declared in the procedure's RAISING clause.

To prevent the exception, note the following:

Database error text........: "ORA-01555: snapshot too old: rollback segment

number 5 with name "PRS_5" too small"

Internal call code.........: "[RSQL/FTCH/COVP ]"

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

You may able to find an interim solution to the problem

in the SAP note system. If you have access to the note system yourself,

use the following search criteria:

"DBIF_RSQL_SQL_ERROR" CX_SY_OPEN_SQL_DBC

"ZLCP0101" or "ZLCP0101"

"GET_CO_RECORDS"

Regards,

Seenu.

Edited by: Sreenivasulu N on Nov 4, 2009 2:11 PM

[Former Member]

There is a very good OSS note which explains this error message, oss note 60233

https://websmp230.sap-ag.de/sap(bD1lbiZjPTAwMQ==)/bc/bsp/spn/sapnotes/index2.htm?numm=60233

There is also a note 185822 which explains how to analysis where the error is occuring

https://websmp230.sap-ag.de/sap(bD1lbiZjPTAwMQ==)/bc/bsp/spn/sapnotes/index2.htm?numm=185822

[Former Member]

Hi

Several causes can get that dump, u should show it to your basis, one problem can be due to too small tablespace for the rollback.

Max