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

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 , Problem

About this page

This is a preview of a SAP Knowledge Base Article. Click more to access the full version on SAP ONE Support launchpad (Login required).

Search for additional results

Visit SAP Support Portal's SAP Notes and KBA Search.