Symptom
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 DECLARE
loc_c CLOB;
buf_c VARCHAR2(6144);
loc_b BLOB;
buf_b RAW(6144);
loc_nc NCLOB;
buf_nc NVARCHAR2(6144);
BEGIN
select "CANONICAL_DETAILS" into loc_c from "xxxxxx_OWNER"."<TABLE NAME>" for update;]. 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.
RepAgent log (aka Instance log) will show messages like:
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 loc_c CLOB;
E. 2017/05/23 09:24:21.959 ERROR com.sybase.ra.lr.oracle.RAOTranReader buf_c VARCHAR2(6144);
E. 2017/05/23 09:24:21.959 ERROR com.sybase.ra.lr.oracle.RAOTranReader loc_b BLOB;
E. 2017/05/23 09:24:21.959 ERROR com.sybase.ra.lr.oracle.RAOTranReader buf_b RAW(6144);
E. 2017/05/23 09:24:21.959 ERROR com.sybase.ra.lr.oracle.RAOTranReader loc_nc NCLOB;
E. 2017/05/23 09:24:21.959 ERROR com.sybase.ra.lr.oracle.RAOTranReader buf_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 loc_c CLOB;
E. 2017/05/23 09:24:21.959 ERROR com.sybase.ra.lr.oracle.RAOTranReader buf_c VARCHAR2(6144);
E. 2017/05/23 09:24:21.959 ERROR com.sybase.ra.lr.oracle.RAOTranReader loc_b BLOB;
E. 2017/05/23 09:24:21.959 ERROR com.sybase.ra.lr.oracle.RAOTranReader buf_b RAW(6144);
E. 2017/05/23 09:24:21.959 ERROR com.sybase.ra.lr.oracle.RAOTranReader loc_nc NCLOB;
E. 2017/05/23 09:24:21.959 ERROR com.sybase.ra.lr.oracle.RAOTranReader buf_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)
E. 2017/05/23 09:24:21.959 ERROR com.sybase.ra.lr.oracle.RAOTranReader com.sybase.ds.oracle.logmnr.lob.state.OffRowLobOpsCollectingState.processPendingLobWrites(OffRowLobOpsCollectingState.java:1124)
E. 2017/05/23 09:24:21.959 ERROR com.sybase.ra.lr.oracle.RAOTranReader com.sybase.ds.oracle.logmnr.lob.state.OffRowLobOpsCollectingState.process(OffRowLobOpsCollectingState.java:108)
E. 2017/05/23 09:24:21.959 ERROR com.sybase.ra.lr.oracle.RAOTranReader com.sybase.ds.oracle.logmnr.lob.LobContext.process(LobContext.java:365)
E. 2017/05/23 09:24:21.959 ERROR com.sybase.ra.lr.oracle.RAOTranReader com.sybase.ds.oracle.logmnr.lob.LobHelpContext.processLOB(LobHelpContext.java:419)
E. 2017/05/23 09:24:21.959 ERROR com.sybase.ra.lr.oracle.RAOTranReader com.sybase.ds.oracle.logmnr.lob.LobHelpContext.processInternalOp(LobHelpContext.java:150)
E. 2017/05/23 09:24:21.959 ERROR com.sybase.ra.lr.oracle.RAOTranReader com.sybase.ds.oracle.logmnr.txctx.TransactionProcessor.processInternalOp(TransactionProcessor.java:1612)
E. 2017/05/23 09:24:21.959 ERROR com.sybase.ra.lr.oracle.RAOTranReader com.sybase.ds.oracle.logmnr.txctx.TransactionProcessor.processGeneral(TransactionProcessor.java:775)
E. 2017/05/23 09:24:21.959 ERROR com.sybase.ra.lr.oracle.RAOTranReader com.sybase.ds.oracle.logmnr.txctx.TransactionProcessor.process(TransactionProcessor.java:253)
E. 2017/05/23 09:24:21.959 ERROR com.sybase.ra.lr.oracle.RAOTranReader com.sybase.ds.oracle.logmnr.txctx.OracleTransactionContext.addOperation(OracleTransactionContext.java:293)
E. 2017/05/23 09:24:21.959 ERROR com.sybase.ra.lr.oracle.RAOTranReader com.sybase.ds.oracle.logmnr.OracleOperationProcessor.process(OracleOperationProcessor.java:1154)
E. 2017/05/23 09:24:21.959 ERROR com.sybase.ra.lr.oracle.RAOTranReader com.sybase.ds.oracle.logmnr.OracleOperationProcessor.nextOperation(OracleOperationProcessor.java:1355)
E. 2017/05/23 09:24:21.959 ERROR com.sybase.ra.lr.oracle.RAOTranReader com.sybase.ra.lr.oracle.RAOTranReader.processScan(RAOTranReader.java:695)
E. 2017/05/23 09:24:21.959 ERROR com.sybase.ra.lr.oracle.RAOTranReader com.sybase.ra.lr.oracle.RAOTranReader.run(RAOTranReader.java:360)
E. 2017/05/23 09:24:21.959 ERROR com.sybase.ra.lr.oracle.RAOTranReader com.sybase.ra.util.thread.RunnableTask.run(RunnableTask.java:114)
E. 2017/05/23 09:24:21.959 ERROR com.sybase.ra.lr.oracle.RAOTranReader com.sybase.ra.util.thread.TPWorker.run(TPWorker.java:264)
E. 2017/05/23 09:24:21.959 ERROR com.sybase.ra.lr.oracle.RAOTranReader java.lang.Thread.run(Thread.java:812)
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 loc_c CLOB;
E. 2017/05/23 09:24:21.959 ERROR com.sybase.ra.lr.oracle.RAOTranReader buf_c VARCHAR2(6144);
E. 2017/05/23 09:24:21.959 ERROR com.sybase.ra.lr.oracle.RAOTranReader loc_b BLOB;
E. 2017/05/23 09:24:21.959 ERROR com.sybase.ra.lr.oracle.RAOTranReader buf_b RAW(6144);
E. 2017/05/23 09:24:21.959 ERROR com.sybase.ra.lr.oracle.RAOTranReader loc_nc NCLOB;
E. 2017/05/23 09:24:21.959 ERROR com.sybase.ra.lr.oracle.RAOTranReader buf_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.parser.ParseException.throwParseException(ParseException.java:57)
E. 2017/05/23 09:24:21.959 ERROR com.sybase.ra.lr.oracle.RAOTranReader com.sybase.ds.oracle.logmnr.parser.command.AbstractParseCommand.mandatoried(AbstractParseCommand.java:28)
E. 2017/05/23 09:24:21.959 ERROR com.sybase.ra.lr.oracle.RAOTranReader com.sybase.ds.oracle.logmnr.parser.state.KeywordState.parse(KeywordState.java:35)
E. 2017/05/23 09:24:21.959 ERROR com.sybase.ra.lr.oracle.RAOTranReader com.sybase.ds.oracle.logmnr.parser.AbstractParser.parse(AbstractParser.java:51)
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:233)
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)
E. 2017/05/23 09:24:21.959 ERROR com.sybase.ra.lr.oracle.RAOTranReader com.sybase.ds.oracle.logmnr.lob.state.OffRowLobOpsCollectingState.processPendingLobWrites(OffRowLobOpsCollectingState.java:1124)
E. 2017/05/23 09:24:21.959 ERROR com.sybase.ra.lr.oracle.RAOTranReader com.sybase.ds.oracle.logmnr.lob.state.OffRowLobOpsCollectingState.process(OffRowLobOpsCollectingState.java:108)
E. 2017/05/23 09:24:21.959 ERROR com.sybase.ra.lr.oracle.RAOTranReader com.sybase.ds.oracle.logmnr.lob.LobContext.process(LobContext.java:365)
E. 2017/05/23 09:24:21.959 ERROR com.sybase.ra.lr.oracle.RAOTranReader com.sybase.ds.oracle.logmnr.lob.LobHelpContext.processLOB(LobHelpContext.java:419)
E. 2017/05/23 09:24:21.959 ERROR com.sybase.ra.lr.oracle.RAOTranReader com.sybase.ds.oracle.logmnr.lob.LobHelpContext.processInternalOp(LobHelpContext.java:150)
E. 2017/05/23 09:24:21.959 ERROR com.sybase.ra.lr.oracle.RAOTranReader com.sybase.ds.oracle.logmnr.txctx.TransactionProcessor.processInternalOp(TransactionProcessor.java:1612)
E. 2017/05/23 09:24:21.959 ERROR com.sybase.ra.lr.oracle.RAOTranReader com.sybase.ds.oracle.logmnr.txctx.TransactionProcessor.processGeneral(TransactionProcessor.java:775)
E. 2017/05/23 09:24:21.959 ERROR com.sybase.ra.lr.oracle.RAOTranReader com.sybase.ds.oracle.logmnr.txctx.TransactionProcessor.process(TransactionProcessor.java:253)
E. 2017/05/23 09:24:21.959 ERROR com.sybase.ra.lr.oracle.RAOTranReader com.sybase.ds.oracle.logmnr.txctx.OracleTransactionContext.addOperation(OracleTransactionContext.java:293)
E. 2017/05/23 09:24:21.959 ERROR com.sybase.ra.lr.oracle.RAOTranReader com.sybase.ds.oracle.logmnr.OracleOperationProcessor.process(OracleOperationProcessor.java:1154)
E. 2017/05/23 09:24:21.959 ERROR com.sybase.ra.lr.oracle.RAOTranReader com.sybase.ds.oracle.logmnr.OracleOperationProcessor.nextOperation(OracleOperationProcessor.java:1355)
E. 2017/05/23 09:24:21.959 ERROR com.sybase.ra.lr.oracle.RAOTranReader com.sybase.ra.lr.oracle.RAOTranReader.processScan(RAOTranReader.java:695)
E. 2017/05/23 09:24:21.959 ERROR com.sybase.ra.lr.oracle.RAOTranReader com.sybase.ra.lr.oracle.RAOTranReader.run(RAOTranReader.java:360)
E. 2017/05/23 09:24:21.959 ERROR com.sybase.ra.lr.oracle.RAOTranReader com.sybase.ra.util.thread.RunnableTask.run(RunnableTask.java:114)
E. 2017/05/23 09:24:21.959 ERROR com.sybase.ra.lr.oracle.RAOTranReader com.sybase.ra.util.thread.TPWorker.run(TPWorker.java:264)
E. 2017/05/23 09:24:21.959 ERROR com.sybase.ra.lr.oracle.RAOTranReader java.lang.Thread.run(Thread.java:812)
E. 2017/05/23 09:24:21.959 ERROR com.sybase.ra.lr.oracle.RAOTranReader
T. 2017/05/23 09:24:21.974 AbstractOracleL Scan Manager <LogMinerScanner> requested to stop immediately.
T. 2017/05/23 09:24:21.974 ParallelLogMine Parallel LogMiner Scanner is requested to stop immediately.
I. 2017/05/23 09:24:21.974 INFORMATION com.sybase.ra.lr.oracle.RAOLogReader Transaction LogReader is Quiescing operations.
I. 2017/05/23 09:24:21.974 INFORMATION com.sybase.ds.oracle.lobcache.OracleInstanceL LOB Cache load thread <LOBCacheLoadThrd_1> stopped.
T. 2017/05/23 09:24:22.240 LogMinerScanner Fails to close LogMiner PreparedStatement Object:Closed Connection
Read more...
Environment
-
SAP HANA Smart Data Integration
-
OracleLogReaderAdapter
Product
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.