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
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.
SAP Knowledge Base Article - Preview