DTR: The pool size has reached the maximum number of connections

[Former Member]

Hello everybody,

our developers are sometimes facing the follwing error:

VFS version: 7.00 645_VAL_REL 0010 (2008-09-17 15:04:57 CEST)] com.tssap.dtr.client.lib.vfs.VfsException: Checking path on repository failed (Failed to acquire connection [cause: The pool size has reached the maximum number of connections for destination 'http://saped760:50300/dtr/' [ID=0]]).

at com.tssap.dtr.client.lib.vfs.impl.VfsFolderItem.existsOnRepository(VfsFolderItem.java:1204)

at com.tssap.dtr.client.lib.vfs.impl.VfsActivityRecordedFolderItem.macroCreateAndCheckoutUnderActivityRecordedFolder(VfsActivityRecordedFolderItem.java:6977)

at com.tssap.dtr.client.lib.vfs.impl.VfsActivityRecordedFolderItem.createAndCheckout(VfsActivityRecordedFolderItem.java:1845)

at com.tssap.dtr.client.lib.vfs.impl.VfsActivityRecordedFolderItem.createAndCheckout(VfsActivityRecordedFolderItem.java:1715)

at com.tssap.dtr.client.lib.vfs.impl.VfsAddOperation.perform(VfsAddOperation.java:68)

at com.tssap.dtr.client.lib.vfs.impl.VFSOperationsGroup.performNew(VFSOperationsGroup.java:220)

at com.tssap.dtr.client.lib.vfs.impl.VFSOperationsGroup.perform(VFSOperationsGroup.java:115)

at com.tssap.dtr.client.lib.vfs.actions.AddAction.pureExecute(AddAction.java:192)

at com.tssap.dtr.client.lib.vfs.actions.AddAction.access$000(AddAction.java:30)

at com.tssap.dtr.client.lib.vfs.actions.AddAction$1.run(AddAction.java:136)

at com.tssap.dtr.client.lib.vfs.impl.VfsEventManager.run(VfsEventManager.java:146)

at com.tssap.dtr.client.lib.vfs.actions.AddAction.execute(AddAction.java:129)

at com.tssap.dtr.client.lib.vfs.actions.impl.WorkerThread.run(WorkerThread.java:56)

+++ Nested exception part 1/1

com.tssap.dtr.client.lib.deltavlib.CommunicationException: Failed to acquire connection [cause: The pool size has reached the maximum number of connections for destination 'http://saped760:50300/dtr/' [ID=0]]

at com.sap.dtr.client.lib.protocol.pool.ConnectionPool.checkCapacities(ConnectionPool.java:535)

at com.sap.dtr.client.lib.protocol.pool.ConnectionPool.createEntry(ConnectionPool.java:510)

at com.sap.dtr.client.lib.protocol.pool.ConnectionPool.addEntry(ConnectionPool.java:425)

at com.sap.dtr.client.lib.protocol.pool.ConnectionPool.aquireFreeEntry(ConnectionPool.java:388)

at com.sap.dtr.client.lib.protocol.pool.ConnectionPool.acquireConnection(ConnectionPool.java:289)

at com.tssap.dtr.client.lib.deltavlib.impl.DeltavCommand.uncheckedExecute(DeltavCommand.java:128)

at com.tssap.dtr.client.lib.deltavlib.impl.DeltavCommand.uncheckedExecute(DeltavCommand.java:167)

at com.tssap.dtr.client.lib.deltavlib.impl.DeltavCommand.execute(DeltavCommand.java:49)

at com.tssap.dtr.client.lib.deltavlib.impl.AbstractResource$PropFinder.load(AbstractResource.java:1216)

at com.tssap.dtr.client.lib.deltavlib.impl.cache.HashmapPropCache.refresh(HashmapPropCache.java:284)

at com.tssap.dtr.client.lib.deltavlib.impl.AbstractResource.refresh(AbstractResource.java:667)

at com.tssap.dtr.client.lib.deltavlib.impl.AbstractResource.refresh(AbstractResource.java:660)

at com.tssap.dtr.client.lib.deltavlib.impl.ResourceLocatorFactoryImpl.createResource(ResourceLocatorFactoryImpl.java:582)

at com.tssap.dtr.client.lib.deltavlib.impl.ResourceLocatorFactoryImpl.createResource(ResourceLocatorFactoryImpl.java:222)

at com.tssap.dtr.client.lib.vfs.impl.VfsFolderItem.existsOnRepository(VfsFolderItem.java:1200)

at com.tssap.dtr.client.lib.vfs.impl.VfsActivityRecordedFolderItem.macroCreateAndCheckoutUnderActivityRecordedFolder(VfsActivityRecordedFolderItem.java:6977)

... 11 more

It seems that a dtr connection pool ras reached it's limit, but I can not find where to extend it.

Do you have any hints which parameter has to be changed and where it can be found?

Many thanks in advance!

Kind Regards

Thomas Clemens

[former_member214355 · Accepted solution]

Hi Thomas

Did this solve the problem?

[former_member214355 · Accepted solution]

See SAP Note 1382179

Thanks

[former_member214355]

Hello Thomas

Are you sure that the DTR was really operational when the issue was

reproduced? You can check it in Visual Admin under:

server -> services -> deploy -> choose the radiobutton 'Application'

check the status icon of the application 'sap.com/tc_dtrenterpriseapp'.

Regarding connection pool: Did you check the sysDS.maximumConnections as

this document describes?

http://help.sap.com/saphelp_nw70/helpdata/en/2d/732441509fa831e10000000a

1550b0/frameset.htm

[former_member214355]

The error occurs when a file is added to the eclipse workspace, either

manually or by eclipse, and the DTR client as team provider detects the

change. The DTR client then presents the dialog "Add Files to DTR" and

the "Select Activity" dialog. Afterwards the mentioned error can be seen

in the DTR console.

Note that the problem is not related to the connection pool size of the

DTR server.

The problem is caused by a program error. It occurs because of

multithreading and is therefore not fully reproducible.

Solution

The problem will be fixed.

Before a patch or a SP with the fix is installed, there is the following

workaround: The files can be added afterwards to DTR via the context

menu from the corresponding eclipse view (e.g. package explorer or

Navigator) or from the DTR Repository Browser.