SAP Knowledge Base Article - Preview

2478487 - Could not find table (shadow table) in schema - SAP HANA Smart Data Integration

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

SAP HANA 1.0, platform edition

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.