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.