SAP Knowledge Base Article - Preview

3390243 - "org.apache.commons.dbcp.SQLNestedException: Borrow prepareStatement from pool failed" during HanaAdapter replication - SAP HANA Smart Data Integration

Symptom

  • Replication from HanaAdapter remote source failed with error intermittently.
  • Error below.
    " [ERROR] Applier | Applier.run  - Applier encountered error.
    com.sap.hana.dp.cdcadaptercommons.scanapply.WorkerException: Task execution exception occurred.
      at com.sap.hana.dp.cdcadaptercommons.scanapply.Applier.runLoop(Applier.java:161)
      at com.sap.hana.dp.cdcadaptercommons.scanapply.Applier.run(Applier.java:68)
      at java.util.concurrent.ThreadPoolExecutor.runWorker(ThreadPoolExecutor.java:1149)
      at java.util.concurrent.ThreadPoolExecutor$Worker.run(ThreadPoolExecutor.java:624)
      at java.lang.Thread.run(Thread.java:836)
    Caused by: java.util.concurrent.ExecutionException: org.apache.commons.dbcp.SQLNestedException: Borrow prepareStatement from pool failed
      at java.util.concurrent.FutureTask.report(FutureTask.java:122)
      at java.util.concurrent.FutureTask.get(FutureTask.java:192)
      at com.sap.hana.dp.cdcadaptercommons.scanapply.Applier.runLoop(Applier.java:92)
      ... 4 more"


Read more...

Environment

SAP HANA Smart Data Integration

Product

SAP HANA smart data integration 2.0

Keywords

DP Agent, HANAAdapter, remote source, pool, Borrow prepareStatement, conn_pool_size , 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.