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.