SAP Knowledge Base Article - Preview

2809408 - No Connection to datasource SmartopsPool - SAP EIS

Symptom

  • An SAP Enterprise Inventory and Service-Level Optimization (EIS) model fails
  • Error messages like the following are reported in the application log:

    Caused by: javax.resource.ResourceException: (Failed in component: dbpool, BC-JAS-TRH) Cannot create connection. Possible reasons: 1)Maximum allowed connections to DB or EIS is reached. You can apply CSN Note 719778 in order to check and resolve connection leaks. 2) Configuration to DB/EIS is wrong or DB/EIS is temporary unreachable. 3) Connections are not enough for current load.

    Caused by: com.sap.engine.services.dbpool.exceptions.BaseResourceException: SQLException is thrown by the pooled connection: com.sap.sql.log.OpenSQLException: No connection to data source SmartOpsPool available. All 40 pooled connections are in use and 10 connection requests are currently waiting. The connection pool size might need to be adjusted.

    Caused by: com.sap.sql.log.OpenSQLException: No connection to data source SmartOpsPool available. All 40 pooled connections are in use and 10 connection requests are currently waiting. The connection pool size might need to be adjusted.

 


Read more...

Environment

SAP Enterprise Inventory and Service-Level Optimization (EIS)

Product

SAP Enterprise Inventory and Service-Level Optimization all versions

Keywords

SmartOps, MIPO, EIO, EIS, jdbc, Netweaver, DIM, demand intelligence, closed, connection pool, dbpool, data source , KBA , SCM-EIS , SAP Enterprise Inventory and Service-Level Optimization , 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.