SAP Knowledge Base Article - Preview

3141395 - ORA-01555 with table QCMACCTIT or QCMCOEP

Symptom

ORA-01555 issue occurs like below in the alert.log:

|ORA-01555 caused by SQL statement below (SQL ID: 6apx9hwd0ytta, Query Duration=3128 sec, SCN: 0x00000006b79e643f):
|SELECT * FROM "QCMACCTIT"                                                                                                                                                                 
|Completed checkpoint up to RBA [0x1c327.2.10], SCN: 28851427742                                                                                                           

or

|ORA-01555 caused by SQL statement below (SQL ID: f8wtz5mm2c5jn, Query Duration=3130 sec, SCN: 0x00000006b7204d0e):                     
|SELECT * FROM "QCMCOEP"
|ALTER SYSTEM ARCHIVE LOG   

Also ST22 Dump is reported, like:

Category                  Installation error
Runtime Errors         DBSQL_SQL_ERROR
Except.                    CX_SY_OPEN_SQL_DB
Date and Time      

 Short Text
     SQL error "SQL code: 1555" occurred while accessing table "QCMACCTIT".

 What happened?
     Database error text: "SQL message: ORA-01555: snapshot too old: rollback
      segment number 2 with name "_SYSSMU2_2781832465$" too small"
                                               


Read more...

Environment

Oracle Database

Keywords

ORA-01555, QCMACCTIT, QCMCOEP , KBA , BC-DB-ORA , Oracle , Problem

About this page

This is a preview of a SAP Knowledge Base Article. Click more to access the full version on SAP for Me (Login required).

Search for additional results

Visit SAP Support Portal's SAP Notes and KBA Search.