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
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.