SAP Knowledge Base Article - Preview

3061989 - SWW_MIGRATE_OUTBOX job cancelled with DBSQL_SQL_ERROR dump

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 ONE Support launchpad (Login required).

Search for additional results

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