SAP Knowledge Base Article - Preview

2488260 - Replication Agent is not in REPLICATE state. LogReader is in ERROR state [Expected <where> at 209 of DECLARE- OracleLogReaderAdapter SDI

Symptom

"Image/data in this KBA is from SAP internal systems, sample data, or demo systems. Any resemblance to real data is purely coincidental."

  • Remote subscription in error state. Replication is in Replication down state.
  • RETRY or IGNORE of exception from the REMOTE_SUBSCRIPTION_EXCEPTIONS does not help
  • RESET of the errored subscription or DROP of the remote subscription does not help
  • Framework.trc will show messages as follows:
    532 [ERROR] com.sap.hana.dp.oraclelogreaderadapter.OracleRepAgentWrapper$2.run[789]    - Replication Agent is not in REPLICATE state. State: REPLICATION DOWN.
    2017-05-23 09:20:32,532 [INFO ] com.sap.hana.dp.oraclelogreaderadapter.MultiCDCRowSetSender$AssembleTask.run[262]    - Assembler stopped.
    2017-05-23 09:20:32,532 [ERROR] com.sap.hana.dp.adapter.framework.core.ReceiverImpl.sendError[411]    - LogReader is in ERROR state [Expected <where> at 209 of ***. Check Replication Agent log for details. Context: null
    2017-05-23 09:20:32,532 [INFO ] com.sap.hana.dp.oraclelogreaderadapter.MultiCDCRowSetSender$DistributionTask.run[426]    - Distributor stopped.
  • Remote source instance log shows messages like below
    I. 2017/05/23 09:24:21.959   INFORMATION     com.sybase.ds.oracle.logmnr.record.LogMinerRe Error parsing sql statement for LogMiner row <OPID <0x0715.f6ec522c.0000:0001.0000d521.00315ff8.00b4>, Timestamp <2017-05-22 15:55:34.0>, XID <0x0064.000b.000e8a28>, Serial# <45653>, Session# <267>, Session Info <UNKNOWN>, User Name <SPLX2113>, Object ID <158338>, REL_FILE# <0>, DATA_BLK# <0>, DATA_OBJD#<0>, Operation <SEL_LOB_LOCATOR>, Op Code <9> Rollback <0> SSN <0> CSF <0> Seg_Owner <xxxx_OWNER> Seg_Name <<TABLE_NAME>> INFO <LOB sql_redo not re-executable> SQL Redo <DECLARE
    I. 2017/05/23 09:24:21.959   INFORMATION     com.sybase.ds.oracle.logmnr.record.LogMinerRe  select "CANONICAL_DETAILS" into loc_c from "xxxx_OWNER"."<TABLE_NAME>" for update;
    E. 2017/05/23 09:24:21.959   ERROR           com.sybase.ra.lr.oracle.RAOTranReader         com.sybase.ds.oracle.logmnr.parser.ParseException: Expected <where> at 209 of DECLARE
    E. 2017/05/23 09:24:21.959   ERROR           com.sybase.ra.lr.oracle.RAOTranReader          **_c CLOB;
    E. 2017/05/23 09:24:21.959   ERROR           com.sybase.ra.lr.oracle.RAOTranReader          **_c VARCHAR2(6144);
    E. 2017/05/23 09:24:21.959   ERROR           com.sybase.ra.lr.oracle.RAOTranReader          **_b BLOB;
    E. 2017/05/23 09:24:21.959   ERROR           com.sybase.ra.lr.oracle.RAOTranReader          **_b RAW(6144);
    E. 2017/05/23 09:24:21.959   ERROR           com.sybase.ra.lr.oracle.RAOTranReader          **_nc NCLOB;
    E. 2017/05/23 09:24:21.959   ERROR           com.sybase.ra.lr.oracle.RAOTranReader          **_nc NVARCHAR2(6144);
    E. 2017/05/23 09:24:21.959   ERROR           com.sybase.ra.lr.oracle.RAOTranReader         BEGIN
    E. 2017/05/23 09:24:21.959   ERROR           com.sybase.ra.lr.oracle.RAOTranReader          select "CANONICAL_DETAILS" into loc_c from "xxxx_OWNER"."<TABLE_NAME>" for update;
    E. 2017/05/23 09:24:21.959   ERROR           com.sybase.ra.lr.oracle.RAOTranReader         java.lang.RuntimeException: com.sybase.ds.oracle.logmnr.parser.ParseException: Expected <where> at 209 of DECLARE
    E. 2017/05/23 09:24:21.959   ERROR           com.sybase.ra.lr.oracle.RAOTranReader          **_c CLOB;
    E. 2017/05/23 09:24:21.959   ERROR           com.sybase.ra.lr.oracle.RAOTranReader          **_c VARCHAR2(6144);
    E. 2017/05/23 09:24:21.959   ERROR           com.sybase.ra.lr.oracle.RAOTranReader          **_b BLOB;
    E. 2017/05/23 09:24:21.959   ERROR           com.sybase.ra.lr.oracle.RAOTranReader          **_b RAW(6144);
    E. 2017/05/23 09:24:21.959   ERROR           com.sybase.ra.lr.oracle.RAOTranReader          **_nc NCLOB;
    E. 2017/05/23 09:24:21.959   ERROR           com.sybase.ra.lr.oracle.RAOTranReader          **_nc NVARCHAR2(6144);
    E. 2017/05/23 09:24:21.959   ERROR           com.sybase.ra.lr.oracle.RAOTranReader         BEGIN
    E. 2017/05/23 09:24:21.959   ERROR           com.sybase.ra.lr.oracle.RAOTranReader          select "CANONICAL_DETAILS" into loc_c from "xxxx_OWNER"."<TABLE_NAME>" for update;
    E. 2017/05/23 09:24:21.959   ERROR           com.sybase.ra.lr.oracle.RAOTranReader          com.sybase.ds.oracle.logmnr.record.LogMinerRecord.parseRedoSQL(LogMinerRecord.java:252)
    E. 2017/05/23 09:24:21.959   ERROR           com.sybase.ra.lr.oracle.RAOTranReader          com.sybase.ds.oracle.logmnr.record.LogMinerRecord.parseRedoSQL(LogMinerRecord.java:197)
    E. 2017/05/23 09:24:21.959   ERROR           com.sybase.ra.lr.oracle.RAOTranReader          com.sybase.ds.oracle.logmnr.record.LogMinerRecord.getLob(LogMinerRecord.java:335)


Read more...

Environment

  • SAP HANA Smart Data Integration
  • OracleLogReaderAdapter

Product

SAP HANA 1.0 smart data integration ; SAP HANA 1.0, platform edition ; SAP HANA smart data integration 2.0

Keywords

REPLICATION DOWN, LogReader in error state, SDI , KBA , HAN-DP-SDI , SAP HANA smart data integration (SDI) , 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.