SAP Knowledge Base Article - Preview

1600085 - Dbpool of AS JAVA causing application related issues

Symptom

Application is not accessible or server nodes hang. The dbpool connection error below logged into the server default traces.  

SAP Netweaver AS JAVA 640/70X

"Caused by:com.sap.engine.services.connector.exceptions.BaseResourceException: Cannot get connection for 60 seconds. Possible reasons:1) Connections are cached within SystemThread(can be any server service or any code invoked within SystemThread in the SAP J2EE Engine), 2) The pool size of adapter "SAPFactory" is not enough according to the current load of the system or 3) The specified time to wait for connection is not enough according to the pool size and current load of the system. In case 1) the solution is to check for cached connections using the Connector Service list-conns command, in case 2) to increase the size of the pool and in case 3) to increase the time to wait for connection property. In case of application thread, there is an automatic mechanism which detects unclosed connections and unfinished transactions."

SAP Netweaver AS JAVA 71X/72X/73X/74X/75X

"com.sap.engine.services.dbpool.exceptions.BaseSQLException: ResourceException occurred in method ConnectionFactoryImpl.getConnection(): 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"


Read more...

Environment

SAP Netweaver AS JAVA release independent

Product

SAP NetWeaver 2004 ; SAP NetWeaver 7.0 ; SAP NetWeaver 7.3 ; SAP NetWeaver 7.4 ; SAP NetWeaver 7.5 ; SAP NetWeaver Application Server for Java 7.1 ; SAP NetWeaver Application Server for Java 7.2 ; SAP enhancement package 1 for SAP NetWeaver 7.0 ; SAP enhancement package 1 for SAP NetWeaver 7.3 ; SAP enhancement package 1 for SAP NetWeaver Application Server for Java 7.1 ; SAP enhancement package 2 for SAP NetWeaver 7.0 ; SAP enhancement package 3 for SAP NetWeaver 7.0

Keywords

ICM running but no server with HTTP connected, SQLException occured while creating ManagedConnection: com.sap.sql.log.OpenSQLException: No connection to data source,  com.sap.engine.services.dbpool.exceptions.BaseResourceException: SQLException is thrown by the pooled connection:, com.sap.security.api.UMRuntimeException: ResourceException occurred in method ConnectionFactoryImpl.getConnection(): , KBA , BC-JAS-TRH , Transactions and Resource Handling , SV-PERF-JAS , Performance Incidents related to NW AS Java , 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.