Skip to Content

Archived discussions are read-only. Learn more about SAP Q&A

Connection Leak

Hello,

We have developed a timesheet application using portal. We have closed all the connections properly in the application. We have created a separate pool with

initial connection 1

max connection 50

max time to wait for connection 20

connection life time 600

clean up thread 300

default connection isolation - default

All the connections are utilized and we get the following error in the log

1.5#0003BAD549FB0070000003160000066B000411E98B308A0A#1145594667108#com.sap.engine.services.dbpool#sap.com/irj#com.sap.engine.services.dbpool#z000000#14567####8bef86b0d0f011dac30b0003bad549fb#Thread[PRT-Async 4,5,PRT-Async]##0#0#Error#1#/System/Server#Java#dbpool_0300##ResourceException in method ConnectionFactoryImpl.getConnection(): com.sap.engine.services.connector.exceptions.BaseResourceException: Cannot get connection for 20 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 "<null>" 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

Kindly Help

Regards,

Rukmani

Former Member
Not what you were looking for? View more on this topic or Ask a question