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 for Me (Login required).

Search for additional results

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