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