09-12-2006 8:19 PM
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
09-12-2006 8:28 PM
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
09-12-2006 8:28 PM
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
09-12-2006 8:41 PM
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.
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.
09-12-2006 8:31 PM
09-12-2006 8:36 PM
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
09-12-2006 9:16 PM
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.
09-12-2006 9:20 PM
Hi Srinivas,
You may need to ask BASIS to increase roll area or extended memory.
Regards,
Ferry Lianto