topic Re: DBIF_RSQL_SQL_ERROR error occuring only in DEV system in Application Development and Automation Discussions

DBIF_RSQL_SQL_ERROR error occuring only in DEV system

Former Member — Wed, 04 Nov 2009 13:10:38 GMT

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 — Wed, 04 Nov 2009 13:15:57 GMT

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

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

Former Member — Wed, 04 Nov 2009 13:16:07 GMT

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