topic DBIF_RSQL_SQL_ERROR in Application Development and Automation Discussions

DBIF_RSQL_SQL_ERROR

Former Member — Tue, 12 Sep 2006 19:19:50 GMT

Hi,

In SM37, I found various jobs with DBIF_RSQL_SQL_ERROR error status.

Job log details : SQL error 1555 occurred when accessing table "EDIDC"

Database error 1555 at FET access to table EDIDC

Database error text........: "ORA-01555: snapshot too old: rollback segment number 22 with name "_SYSSMU22$" too small#"

Please tell me the reason and trouble shooting this issue.

Thanks in advance

Regards

Srinivas

Re: DBIF_RSQL_SQL_ERROR

Former Member — Tue, 12 Sep 2006 19:28:02 GMT

Hi,

When you run a program in the foreground or in the background, there is some time limit set for the request to run, is the time limit exceeds this will occur, run the program again then this might not happen

I guess it is related to table space issue. Show the short dump to your Basis person and tell me to adjust/increase the respective tablespace ..

You can read <b>OSS Note 3155</b> for some more info

Regards

Sudheer

Re: DBIF_RSQL_SQL_ERROR

Former Member — Tue, 12 Sep 2006 19:31:47 GMT

Hi Srinivas,

Check out this thread:

http://www.fors.com/orasupp/rdbms/dba/40689_1.HTM

Regards,

Vivek

Re: DBIF_RSQL_SQL_ERROR

Former Member — Tue, 12 Sep 2006 19:36:49 GMT

I've seen this error before. I think it means that while the program was running, users were updating one or more of the tables used by your program. If the program runs too long, then the rollback segment becomes outdated and the program dumps.

I got around this by running the program overnight when there was less chance of the tables being updated.

Rob

Re: DBIF_RSQL_SQL_ERROR

Former Member — Tue, 12 Sep 2006 19:41:27 GMT

Yes it is not related to fore or background. Right now I found large no.of DBIF_RSQL_SQL_ERROR in ST22.Can you tell me the reason based on this detail report please?

ABAP runtime errors DBIF_RSQL_SQL_ERROR

Occurred on 09/12/2006 at 14:43:33

SQL error 1555 occurred when accessing table "EDIDC ".

What happened?

What can you do?

Please make a note of the actions and input which caused the error.

To resolve the problem, contact your

SAP system administrator.

Choose "Print" for a hard coopy of the termination message. You can

display and adminster short dump messages using Transaction ST22.

Error analysis

How to correct the error

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

number 23 with name "_SYSSMU23$" too small#"

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

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

If the error occurred in a non-modified SAP program, you may be

able to find a solution in the SAP note system.

If you have access to the note system yourself, use the following

search criteria:

"DBIF_RSQL_SQL_ERROR"

"RBDAPP01 " or "RBDAPP01 "

"START-OF-SELECTION"

If you cannot solve the problem yourself, please send the

following documents to SAP:

1. A hard copy print describing the problem.

To obtain this, select the "Print" function on the current screen.

2. A suitable hardcopy prinout of the system log.

To obtain this, call the system log with Transaction SM21

and select the "Print" function to print out the relevant

part.

3. If the programs are your own programs or modified SAP programs,

supply the source code.

To do this, you can either use the "PRINT" command in the editor or

print the programs using the report RSINCL00.

4. Details regarding the conditions under which the error occurred

or which actions and input led to the error.

User, transaction...

Client.............. 010

User................ "USI0CR"

Language key........ "E"

Transaction......... " "

Program............. "RBDAPP01 "

Screen.............. "SAPMSSY0 1000"

Screen line......... 6

Information on where termination occurred

The termination occurred in the ABAP/4 program "RBDAPP01 " in

"START-OF-SELECTION".

The main program was "RBDAPP01 ".

The termination occurred in line 141

of the source code of program "RBDAPP01 " (when calling the editor 1410).

The program "RBDAPP01 " was started as a background job.

Re: DBIF_RSQL_SQL_ERROR

Former Member — Tue, 12 Sep 2006 20:16:24 GMT

Thanks Vivek, Rob and Sudheer. Sorry, I asked same issue two weeeks back. I Would like to search before post an issue here.

Regards

Srinivas.

Re: DBIF_RSQL_SQL_ERROR

Former Member — Tue, 12 Sep 2006 20:20:38 GMT

Hi Srinivas,

You may need to ask BASIS to increase roll area or extended memory.

Regards,

Ferry Lianto