Connection Leak

[Former Member]

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]

Hi Rukmani,

Refer to SAP Note No - 719778 DataSource fails to return connection

It refers about Changing the maximum number of connections or wait time, etc...

Thanks,

Samta

[Former Member]

Hello Samta,

Any idea what is the difference between system thread and application thread.

Regards,

Rukmani