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.