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

"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)

• SAP HANA Smart Data Integration
• OracleLogReaderAdapter

REPLICATION DOWN, LogReader in error state, SDI , KBA , HAN-DP-SDI , SAP HANA smart data integration (SDI) , Problem