SAP Knowledge Base Article - Preview

2475457 - Real Time Replication Task conversion errors when using Oracle Log Reader - SAP HANA Smart Data Integration

Symptom

  • Failed to process or send log operation(s). Error: Error processing operation <0006.7f06a672.0000:0001.00000578.0000212d.0010> for table <MY_SCHEMA>.<MY_ORACLE_TABLE> because the value <12885,75> for column <MY_COLUMN_DECIMAL> with datatype <NUMBER> could not be determined. The operation locator is <000000067f06a67200000001000005780000212d001000067f068bfe00000001>. Please contact SAP Technical Support for assistance.
  • [ERROR] com.sap.hana.dp.oraclelogreaderadapter.MultiCDCRowSetSender$AssembleTask.run[252] - Assembler encountered an exception when processing operation [0006.7fadc495.0000:0001.000005cc.000157c9.0010].
    Error processing operation <0006.7fadc495.0000:0001.000005cc.000157c9.0010> for table <SCHEMA>.<TABLE_NAME> because the value <1111111,1111> for column <COLUMN_NAME> with datatype <NUMBER> could not be determined. The operation locator is <000000067fadc49500010001000005cc000157c9001000067fadc49500000001>. Please contact SAP Technical Support for assistance.
    at com.sybase.ds.oracle.logmnr.op.LogMinerDictChangeData.initialize(LogMinerDictChangeData.java:175)
    at com.sybase.ds.oracle.logmnr.op.LogMinerDictChangeData.iterator(LogMinerDictChangeData.java:439)
    at com.sap.hana.dp.oraclelogreaderadapter.CDCRowSender.prepareUpdateColumns(CDCRowSender.java:964)
    at com.sap.hana.dp.oraclelogreaderadapter.CDCRowSender.processUpdate(CDCRowSender.java:603)
    at com.sap.hana.dp.oraclelogreaderadapter.CDCRowSender.processUpdate(CDCRowSender.java:595)
    at com.sap.hana.dp.oraclelogreaderadapter.CDCRowSender.processTableChangeOperation(CDCRowSender.java:258)
    at com.sap.hana.dp.oraclelogreaderadapter.MultiCDCRowSetSender$AssembleTask.assembleTableChangeOperation(MultiCDCRowSetSender.java:353)
    at com.sap.hana.dp.oraclelogreaderadapter.MultiCDCRowSetSender$AssembleTask.assemble(MultiCDCRowSetSender.java:295)
    at com.sap.hana.dp.oraclelogreaderadapter.MultiCDCRowSetSender$AssembleTask.run(MultiCDCRowSetSender.java:242)
    at java.util.concurrent.ThreadPoolExecutor.runWorker(ThreadPoolExecutor.java:1145)
    at java.util.concurrent.ThreadPoolExecutor$Worker.run(ThreadPoolExecutor.java:615)
    at java.lang.Thread.run(Thread.java:812)
    Caused by: java.lang.NumberFormatException
    at java.math.BigDecimal.<init>(BigDecimal.java:470)
    at java.math.BigDecimal.<init>(BigDecimal.java:739)
    at com.sybase.ds.oracle.log.OracleNumber.<init>(OracleNumber.java:180)
    at com.sybase.ds.oracle.logmnr.op.LogMinerDictChangeData.initialize(LogMinerDictChangeData.java:154)
    ... 11 more


Read more...

Environment

  • SAP HANA Version 1.00.122.08
  • DPAgent 1.3.7.0

Product

SAP HANA 1.0 smart data integration ; SAP HANA smart data integration 2.0

Keywords

han-dp-sdi, SDI, IM, characterset, codepage, realtime, decimal separator , 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.