SAP Knowledge Base Article - Preview

2541133 - ABAP shortdump SQL error "SQL code: 1555" occurred while accessing table "IUUC_RL_DATA".

Symptom

  • Daily ABAP shortdump noticed in st22
  • Shortdump is:

SQL error "SQL code: 1555" occurred while accessing table "IUUC_RL_DATA".

     Database error text: "SQL message: ORA-01555: snapshot too old: rollback
     segment number  with name "" too small
ORA-22924: snapshot too old"

  • Replication of data may not be impacted.

 

Category               Installation error

Runtime Errors         DBSQL_SQL_ERROR

Except.                CX_SY_OPEN_SQL_DB

 

    An exception has occurred which is explained in more detail below. The

    exception is assigned to class 'CX_SY_OPEN_SQL_DB' and was not caught in

     procedure

    "DEL_OUTDATED_DATA_MT_ID_TAB" "(METHOD)", nor was it propagated by a RAISING

     clause.

    Since the caller of the procedure could not have anticipated this

    exception, the current program was terminated.

    The reason for the exception is:

    Database error text: SQL message: ORA-01555: snapshot too old: rollback

     segment number  with name "" too small
ORA-22924: snapshot too old

    Return value of the database layer: "SQL dbsl rc: 99"

 

 

Information on where terminated

    The termination occurred in ABAP program or include

     "CL_IUUC_REPL_LOG_TRANSP=======CP", in "DEL_OUTDATED_DATA_MT_ID_TAB". The

    main program was "IUUC_HOUSEKEEPING".

 

    In the source code, the termination point is in line 15 of  program or

    include "CL_IUUC_REPL_LOG_TRANSP=======CM00G".

    Program "CL_IUUC_REPL_LOG_TRANSP=======CP" was started as a background job.

 

    Job name....... /1LT/IUC_HOUSKPNG

 

 


Read more...

Environment

DMIS 2011

SAP LT Replication Server

Product

SAP Landscape Transformation replication server 1.0 ; SAP Landscape Transformation replication server 2.0 ; SAP NetWeaver 7.5

Keywords

ORADB, nightly, frequent, exception, dumps , KBA , HAN-DP-LTR , SAP Landscape Transformation Replication Server , 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.