SAP Knowledge Base Article - Preview

2355885 - RAO down with RecordProcessingException: Error during rollback processing: invalid rollback ID : RAO 15.7.1 SP208

Symptom

Replication Agent for Oracle (RAO) goes into REPLICATION DOWN state with an invalid rollback ID error on a non-LOB table:

com.sybase.ra.lr.oracle.RAOTranReader com.sybase.ds.oracle.OracleLog RecordProcessingException: Error during rollback processing for operation <LogMiner STARTSCN:10456580456287 LogMiner ENDSCN:10456580458655

LogMiner options:[SYS.DBMS_LOGMNR.CONTINUOUS_MINE, SYS.DBMS_LOGMNR.DICT_FROM_ONLINE_CATALOG, SYS.DBMS_LOGMNR.NO_ROWID_IN_STMT]

DDL Scanner:false OPID <0x0982.9cc38659.0000:0001.000244d8.000598d9.03b0>, Timestamp <2016-07-19 15:27:37.0>, XID <0x0018.001f.ffffffff>, Serial# <0>, Session# <0>, Session Info <UNKNOWN>, User Name <UNKNOWN>, Object ID <1762307>, REL_FILE# <213>, DATA_BLK# <633664>, DATA_OBJD#<1762307>, Operation <DELETE>, Op Code <2> Rollback <1> SSN <0> CSF <0> Seg_Owner <PCM> Seg_Name <TEST_T>

INFO <N/A> SQL Redo <delete from "DBO"."TEST_T" where ROWID = 'AAGuQDADVAACatAAAv';> >: invalid rollback ID. Record: <Current Record ID: [-1] First Record ID: [0]Stack top: [NULL] PendingRollbackLocator: [NULL] PendingRollback: [NULL]


Read more...

Environment

  • Oracle Source DB version 11.2.0.3
  • SAP Replication Server Heterogeneous Edition 15.7.1 SP208
  • SAP Replication Server Option for Oracle 15.7.1 SP208

Product

SAP Sybase Replication Server 15.7, heterogeneous edition

Keywords

RAO abort invalid rollback Timestamp record PendingRollbackLocator PendingRollback CR# 792484 792484 , KBA , BC-SYB-REP , Sybase Replication Server (standalone) , Bug Filed

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.