Symptom
SWW_MIGRATE_OUTBOX job run terminated with the following dump even the SWWLOGHIST table amount of data is on acceptable level.
Category Installation error Runtime Errors DBSQL_SQL_ERROR ABAP Program CX_SY_OPEN_SQL_DB |
Short text |
SQL error "SQL code: 1555" occurred while accessing table "SWWLOGHIST". |
What happened? |
Database error text: "SQL message: ORA-01555: snapshot too old: rollback segment number 23 with name "_SYSSMU23_2967998164$" too small" |
Source Code Extract |
>>>>> SELECT DISTINCT meth_user FROM swwloghist INTO TABLE lt_user WHERE method IN method AND timestamp IN timestamp AND meth_user IN user. SORT lt_user. DELETE lt_user WHERE table_line IS INITIAL. DELETE lt_user WHERE table_line = 'WF-BATCH'. |
Read more...
Environment
- SAP Business Workflow
- SAP NetWeaver
- SAP Web Application Server for SAP S/4 HANA
- ABAP PLATFORM - Application Server ABAP
- Oracle Database
Product
ABAP platform all versions ; SAP NetWeaver all versions ; SAP Web Application Server for SAP S/4HANA all versions
Keywords
WF_GDPR, SWF_WORKFLOW, RSWI_MIGRATE_OUTBOX, ORA 01555, SY-XFORM CONVERSION_EXIT, SQL dbsl rc: 99, delayed block cleanout, rollback segment or rollback/undo tablespace is too small, statement needs rollback information of an update, WORKITEM archiving , KBA , BC-BMT-WFM , Business Workflow , 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.