Symptom
When executing an SAP HANA Smart Data Integration (SDI) replication task the following error message appears:
2017-05-24 15:45:14,105 [INFO ] com.sap.hana.dp.hanaadapter.trans.TransSystemObjectManager.truncateTriggerQueue[464] - Start to truncate trigger queue and shadow tables to location: [SCAN_NUMBER=5876248,TRANS_NUMBER=247817437,LOCATOR_ID=1]
2017-05-24 15:45:14,775 [INFO ] com.sap.hana.dp.hanaadapter.trans.TransSystemObjectManager.truncateTriggerQueue[489] - Truncating shadow tables...
2017-05-24 15:45:14,789 [WARN ] com.sap.hana.dp.cdcadaptercommons.triggerbased.TriggerBasedReplicationAdmin$TruncateTask.run[388] - Error occurred when truncating trigger queue. Truncation point is SequenceId [value=[89, -86, 24, 0, 0, 0, 0, 14, -59, 100, -35, 0, 1]]
... com.sap.hana.dp.cdcadaptercommons.triggerbased.TriggerBasedReplicationAdmin$TruncateTask.run(TriggerBasedReplicationAdmin.java:386)
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: com.sap.db.jdbc.exceptions.JDBCDriverException: SAP DBTech JDBC: [259]: invalid table name: Could not find table/view HADP_CNP_OT_PHASE2_NON_UNIQUE_SHADOW_Z_SAPMEINT_ME_MESSAGE in schema WIP: line 1 col 19 (at pos 18)
at com.sap.db.jdbc.exceptions.SQLExceptionSapDB.createException(SQLExceptionSapDB.java:345)
...
Read more...
Environment
- SAP HANA Smart Data Integration
- HanaAdapter
Product
Keywords
SDI; trigger; WIP; could not find table/view , 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.