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:07,023 [INFO ] com.sap.hana.dp.hanaadapter.trans.TransSystemObjectManager.truncateTriggerQueue[464]    - Start to truncate trigger queue and shadow tables to location: [SCAN_NUMBER=19526813,TRANS_NUMBER=1091154976,LOCATOR_ID=2]
2017-05-24 15:45:07,028 [INFO ] com.sap.hana.dp.hanaadapter.trans.TransSystemObjectManager.truncateTriggerQueue[489]    - Truncating shadow tables...
2017-05-24 15:45:07,590 [INFO ] com.sap.hana.dp.hanaadapter.trans.TransSystemObjectManager.truncateTriggerQueue[512]    - Complete to truncate shadow tables.
2017-05-24 15:45:07,590 [INFO ] com.sap.hana.dp.hanaadapter.trans.TransSystemObjectManager.truncateTriggerQueue[516]    - Truncate trigger queue table...
2017-05-24 15:45:07,796 [INFO ] com.sap.hana.dp.hanaadapter.trans.TransSystemObjectManager.truncateTriggerQueue[524]    - Complete to truncate trigger queue table.
2017-05-24 15:45:07,796 [INFO ] com.sap.hana.dp.hanaadapter.trans.TransSystemObjectManager.truncateTriggerQueue[527]    - Complete to truncate trigger queue and shadow tables to location: [SCAN_NUMBER=19526813,TRANS_NUMBER=1091154976,LOCATOR_ID=2]
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]]
                                org.apache.commons.dbcp.SQLNestedException: Borrow prepareStatement from pool failed
                                 at org.apache.commons.dbcp.PoolingConnection.prepareStatement(PoolingConnection.java:113)
                                 at org.apache.commons.dbcp.DelegatingConnection.prepareStatement(DelegatingConnection.java:281)
                                 at org.apache.commons.dbcp.PoolingDataSource$PoolGuardConnectionWrapper.prepareStatement(PoolingDataSource.java:313)
                                 at com.sap.hana.dp.cdcadaptercommons.util.JdbcTemplate.executeUpdate(JdbcTemplate.java:108)
                                 at com.sap.hana.dp.hanaadapter.trans.TransSystemObjectManager.truncateTriggerQueue(TransSystemObjectManager.java:501)
                                 at 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)
                                 at com.sap.db.jdbc.exceptions.SQLExceptionSapDB.generateDatabaseException(SQLExceptionSapDB.java:185)
                                 at com.sap.db.jdbc.packet.ReplyPacket.buildExceptionChain(ReplyPacket.java:102)
                                 at com.sap.db.jdbc.ConnectionSapDB.execute(ConnectionSapDB.java:1033)
                                 at com.sap.db.jdbc.CallableStatementSapDB.sendCommand(CallableStatementSapDB.java:1790)
                                 at com.sap.db.jdbc.StatementSapDB.sendSQL(StatementSapDB.java:945)
                                 at com.sap.db.jdbc.CallableStatementSapDB.doParse(CallableStatementSapDB.java:185)
                                 at com.sap.db.jdbc.CallableStatementSapDB.constructor(CallableStatementSapDB.java:144)
                                 at com.sap.db.jdbc.CallableStatementSapDB.<init>(CallableStatementSapDB.java:89)
                                 at com.sap.db.jdbc.CallableStatementSapDBFinalize.<init>(CallableStatementSapDBFinalize.java:31)
                                 at com.sap.db.jdbc.ConnectionSapDB.prepareStatement(ConnectionSapDB.java:1268)
                                 at com.sap.db.jdbc.trace.Connection.prepareStatement(Connection.java:416)
                                 at org.apache.commons.dbcp.PoolingConnection.makeObject(PoolingConnection.java:285)
                                 at org.apache.commons.pool.impl.GenericKeyedObjectPool.borrowObject(GenericKeyedObjectPool.java:1220)
                                 at org.apache.commons.dbcp.PoolingConnection.prepareStatement(PoolingConnection.java:107)
                                 ... 8 more

 


Read more...

Environment

  • SAP HANA Smart Data Integration (SDI)
  • 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.