DBIF_RSQL_SQL_ERROR - SQL error 1555 occurred when accessing table "BKPF "

[Former Member]

hi guys,

I have been getting this error from last three months,

This ERROR is getting occured when the archiving job for the object FI_DOCUMNT is scheduled in the background.

DBIF_RSQL_SQL_ERROR - SQL error 1555 occurred when accessing table "BKPF "

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

number 16 with name "PRS_56" too small#"

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

kindly suggest some solution ASAP.

[former_member204746 · Accepted solution]

you posted an Oracle question in the SQL server forum...

anyways, your solution is to convert to PSAPUNDO if not already done, then increase PSAPUNDO's size.

more about this with SAP note 600141 - Oracle9i: Automatic UNDO Management

[Former Member · Accepted solution]

Do we need to install the OSS note or the DBA admin will do it for us.

[markus_doehr2 · Accepted solution]

This is not a SAP coding correction but a database configuration problem.

I suggest your DBA to switch from the "old" rollback segments to the new automatic undo management using the given note.

Markus

[Former Member · Accepted solution]

Moved to SAP on Oracle forum...

Please do not duplicate post!

Cheers,

Julius

[Former Member · Accepted solution]

Is there any SAP standard solution for such kinds of errors,

[markus_doehr2 · Accepted solution]

Did you read the note given?

Markus

[former_member204746 · Accepted solution]

read SAP note 600141 - Oracle9i: Automatic UNDO Management

[Former Member]

can you post the full contents of the dump

Rohit

[Former Member]

ABAP runtime errors DBIF_RSQL_SQL_ERROR

Occurred on 18.04.2009 at 23:40:05

-

---

>> Short dump has not been completely stored. It is too big.

-

---

SQL error 1555 occurred when accessing table "BKPF ".

-

---

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 16 with name "PRS_56" too small

"

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

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"

"SAPF048 " or "SAPF048 "

"ARCHIVE_DOCUMENTS"

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.

-

---

System environment

-

---

SAP Release.............. "46C"

Application server....... "logas5p"

Network address.......... "139.160.126.240"

Operating system......... "SunOS"

Release.................. "5.8"

Hardware type............ "sun4u"

Database server.......... "bac"

Database type............ "ORACLE"

Database name............ "PR3"

Database owner........... "SAPR3"

Character set............ "fr"

SAP kernel............... "46D"

Created on............... "Jul 25 2006 21:57:02"

Created in............... "SunOS 5.8 Generic_108528-05 sun4us"

Database version......... "OCI_920__OCI_7_API "

Patch level.............. "2265"

Patch text............... " "

Supported environment....

Database................. "ORACLE 8.0.5.., ORACLE 8.0.6.., ORACLE

8.1.6.., ORACLE 8.1.7.., ORACLE 9.2.0.., ORACLE 10.2.0.."

SAP database version..... "46D"

Operating system......... "SunOS 5.6, SunOS 5.7, SunOS 5.8, SunOS 5.9, SunOS

5.10, , System build information:, -

---

, LCHN

: "

-

---

User, transaction...

-

---

Client.............. 400

User................ "TNG_PR3"

Language key........ "F"

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

Program............. "SAPF048 "

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

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

-

---

Information on where termination occurred

-

---

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

ARCHIVE_DOCUMENTS.

The main program was "SAPF048 ".

The termination occurred in line 1638

of the source code of program "SAPF048 " (when calling the editor 16380).

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

-

---

Source code extract

-

---

016080 IMPORTING

016090 ARCHIVE_HANDLE = ARCHIVE_HANDLE.

016100 * endif. " <<<<<<<<<< delete - Note 316283

16110

016120 * -

---

Prepare reading document headers from database

016130 IF X_DETAIL = TRUE.

016140 * select sorted documents from database, no "better selection"

016150 OPEN CURSOR WITH HOLD CURSOR_BKPF

016160 FOR SELECT * FROM BKPF

016170 WHERE (TIMESEL) AND

016180 BUKRS IN BUKRSX AND """"""" t070/t071

016190 BLART IN BLARTX AND """"""" t070/t071

016200 BELNR IN BELNRX AND

016210 BUDAT LE N_STICHTAG

016220 ORDER BY BUKRS GJAHR BUDAT.

016230 ELSE.

016240 * no sorted select sorted documents from database

016250 OPEN CURSOR WITH HOLD CURSOR_BKPF

016260 FOR SELECT * FROM BKPF

016270 WHERE (TIMESEL) AND

016280 * (documentsel) and "better selection"

016290 BUKRS IN BUKRSX AND "" t070/t071 s.o.

016300 BLART IN BLARTX AND "" t070/t071 s.o.

016310 BELNR IN BELNRX AND

016320 BUDAT LE N_STICHTAG.

016330 ENDIF.

16340

016350 * -

---

Read documents in packages

016360 DO.

016370 FETCH NEXT CURSOR CURSOR_BKPF INTO TABLE YBKPF

-

---

> PACKAGE SIZE SELPACKAGE.

016390 IF SY-SUBRC = 4.

016400 EXIT.

016410 ENDIF.

016420 LOOP AT YBKPF.

016430 PERFORM ARCHIVE_ONE_DOCUMENT USING YBKPF ARCHIVE_HANDLE.

16440

016450 IF FLAG = 'I'.

016460 EXIT.

016470 ENDIF.

016480 ENDLOOP.

016490 CALL FUNCTION 'DB_COMMIT'.

16500

016510 IF FLAG = 'I'.

016520 EXIT.

016530 ENDIF.

016540 ENDDO.

16550

016560 * -

---

close archive

016570 * <<<<<<<<<< begin of deletion - Note 316283

-

---

Contents of system fields

-

---

SY field contents..................... SY field contents.....................

-

---

-

---

-

---

-

---

SY-SUBRC 0 SY-INDEX 2279

SY-TABIX 1 SY-DBCNT 1

SY-FDPOS 70 SY-LSIND 0

SY-PAGNO 2 SY-LINNO 1

SY-COLNO 1

[Former Member]

check the size of data files,if you have your Oracle DBA show him this error

there is problem with roll back segments size

ORA-01555: snapshot too old: rollback segment number 16 with name "PRS_56" too small " Internal call code.........: [RSQL/FTCH/BKPF ]"""

you can refer to the following link for more info

http://www.dbmotive.com/oracle_error_codes.php?errcode=01555

Also I would prefer if you show this to your Oracle DBA

Rohit