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.
SAP Knowledge Base Article - Preview