2478487 - Could not find table/view HADP_CNP_OT_PHASE2_NON_UNIQUE_SHADOW_Z_SAPMEINT_ME_MESSAGE in schema WIP - SAP HANA Smart Data Integration | SAP Knowledge Base Article

SAP Knowledge Base Article - Preview

2478487 - Could not find table/view HADP_CNP_OT_PHASE2_NON_UNIQUE_SHADOW_Z_SAPMEINT_ME_MESSAGE in schema WIP - 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)
  • SAP HANA Data Provisioning Agent (DP agent)
  • HANA Adapter
  • Any supported database platform

Product

SAP HANA 1.0, platform edition

Keywords

HADP_CNP_OT_PHASE2_NON_UNIQUE_SHADOW_Z_SAPMEINT_ME_MESSAGE; SDI; trigger; WIP; could not find table/view , KBA , HAN-DP-SDI , SAP HANA smart data integration , Problem

About this page

This is a preview of a SAP Knowledge Base Article. Click more to access the full version on SAP ONE Support launchpad (Login required).

Search for additional results

Visit SAP Support Portal's SAP Notes and KBA Search.