cancel
Showing results for 
Search instead for 
Did you mean: 

JCO Pool connections exhausted

Former Member
0 Kudos

Hi all,

we have implemented ESS 60.2 on EPSP13 (WAS 6.40).

I am facing a peculiar problem ..The problem is when i login with ESS us/pd, after accessing several links on the ESS iviews...i get the below error saying that the connection pool is exhausted...Can anyone plz help on this issue....

Right now we have not implemented SSO and we are going on UserID/Password

Also, what should be the maximum Connection Pool size ?

and how do i refresh or clear the connection pools??

Error is as follows :

Connection pool SAP_R3_SelfServiceGenerics_P00200004_EN_useDefinedUser is exhausted. The current pool size limit is 10 connections.com.sap.mw.jco.JCO$Exception: (106) JCO_ERROR_RESOURCE: Connection pool

SAP_R3_SelfServiceGenerics_P00200004_EN_useDefinedUser is exhausted. The current pool size limit is 10 connections.

at com.sap.mw.jco.JCO$Pool.getClient(JCO.java:5284)

at com.sap.mw.jco.JCO$PoolManager.getClient(JCO.java:5985)

at com.sap.mw.jco.JCO$PoolManager.getClient(JCO.java:5935)

at com.sap.mw.jco.JCO.getClient(JCO.java:8216)

at com.sap.tc.webdynpro.serverimpl.core.sl.AbstractJCOClientConnection.getClient(AbstractJCOClientConnection.java:415)

at com.sap.pcuigp.xssfpm.wd.BackendConnections.connectModelInternal(BackendConnections.java:261)

at com.sap.pcuigp.xssfpm.wd.BackendConnections.connectModel(BackendConnections.java:161)

at com.sap.pcuigp.xssfpm.wd.wdp.InternalBackendConnections.connectModel(InternalBackendConnections.java:183)

at com.sap.pcuigp.xssfpm.wd.FPMComponent$FPM.connectModel(FPMComponent.java:703)

at com.sap.xss.ser.xssmenu.fc.ModelHandler.onInit(ModelHandler.java:203)

at com.sap.xss.ser.xssmenu.fc.wdp.InternalModelHandler.onInit(InternalModelHandler.java:398)

at com.sap.xss.ser.xssmenu.fc.FcXssMenu.onInit(FcXssMenu.java:255)

at com.sap.xss.ser.xssmenu.fc.wdp.InternalFcXssMenu.onInit(InternalFcXssMenu.java:443)

at com.sap.xss.ser.xssmenu.fc.FcXssMenuInterface.onInit(FcXssMenuInterface.java:169)

at com.sap.xss.ser.xssmenu.fc.wdp.InternalFcXssMenuInterface.onInit(InternalFcXssMenuInterface.java:386)

at com.sap.xss.ser.xssmenu.fc.wdp.InternalFcXssMenuInterface$External.onInit(InternalFcXssMenuInterface.java:531)

at com.sap.pcuigp.xssfpm.wd.FPMComponent$FPM.attachComponentToUsage(FPMComponent.java:774)

at com.sap.xss.ser.xssmenu.vc.header.VcXssMenuHeader.onInit(VcXssMenuHeader.java:196)

at com.sap.xss.ser.xssmenu.vc.header.wdp.InternalVcXssMenuHeader.onInit(InternalVcXssMenuHeader.java:225)

at com.sap.xss.ser.xssmenu.vc.header.VcXssMenuHeaderInterface.onInit(VcXssMenuHeaderInterface.java:162)

at com.sap.xss.ser.xssmenu.vc.header.wdp.InternalVcXssMenuHeaderInterface.onInit(InternalVcXssMenuHeaderInterface.java:144)

at com.sap.xss.ser.xssmenu.vc.header.wdp.InternalVcXssMenuHeaderInterface$External.onInit(InternalVcXssMenuHeaderInterface.java:220)

at com.sap.pcuigp.xssfpm.wd.FPMComponent.doProcessEvent(FPMComponent.java:466)

at com.sap.pcuigp.xssfpm.wd.FPMComponent.doEventLoop(FPMComponent.java:354)

at com.sap.pcuigp.xssfpm.wd.FPMComponent.wdDoInit(FPMComponent.java:179)

at com.sap.pcuigp.xssfpm.wd.wdp.InternalFPMComponent.wdDoInit(InternalFPMComponent.java:110)

at com.sap.tc.webdynpro.progmodel.generation.DelegatingComponent.doInit(DelegatingComponent.java:95)

at com.sap.tc.webdynpro.progmodel.controller.Controller.initController(Controller.java:215)

at com.sap.tc.webdynpro.progmodel.controller.Controller.init(Controller.java:200)

at com.sap.tc.webdynpro.clientserver.cal.ClientComponent.init(ClientComponent.java:346)

at com.sap.tc.webdynpro.clientserver.cal.ClientApplication.init(ClientApplication.java:370)

at com.sap.tc.webdynpro.clientserver.task.WebDynproMainTask.execute(WebDynproMainTask.java:608)

at com.sap.tc.webdynpro.clientserver.cal.AbstractClient.executeTasks(AbstractClient.java:59)

at com.sap.tc.webdynpro.clientserver.cal.ClientManager.doProcessing(ClientManager.java:248)

at com.sap.tc.webdynpro.serverimpl.defaultimpl.DispatcherServlet.doWebDynproProcessing(DispatcherServlet.java:154)

at com.sap.tc.webdynpro.serverimpl.defaultimpl.DispatcherServlet.doContent(DispatcherServlet.java:116)

at com.sap.tc.webdynpro.serverimpl.defaultimpl.DispatcherServlet.doPost(DispatcherServlet.java:55)

at javax.servlet.http.HttpServlet.service(HttpServlet.java:760)

at javax.servlet.http.HttpServlet.service(HttpServlet.java:853)

at com.sap.engine.services.servlets_jsp.server.HttpHandlerImpl.runServlet(HttpHandlerImpl.java:390)

at com.sap.engine.services.servlets_jsp.server.HttpHandlerImpl.handleRequest(HttpHandlerImpl.java:264)

at com.sap.engine.services.httpserver.server.RequestAnalizer.startServlet(RequestAnalizer.java:347)

at com.sap.engine.services.httpserver.server.RequestAnalizer.startServlet(RequestAnalizer.java:325)

at com.sap.engine.services.httpserver.server.RequestAnalizer.invokeWebContainer(RequestAnalizer.java:887)

at com.sap.engine.services.httpserver.server.RequestAnalizer.handle(RequestAnalizer.java:241)

at com.sap.engine.services.httpserver.server.Client.handle(Client.java:92)

at com.sap.engine.services.httpserver.server.Processor.request(Processor.java:148)

at com.sap.engine.core.service630.context.cluster.session.ApplicationSessionMessageListener.process(ApplicationSessionMessageListener.java:33)

at com.sap.engine.core.cluster.impl6.session.MessageRunner.run(MessageRunner.java:41)

at com.sap.engine.core.thread.impl3.ActionObject.run(ActionObject.java:37)

at java.security.AccessController.doPrivileged(Native Method)

at com.sap.engine.core.thread.impl3.SingleThread.execute(SingleThread.java:95)

at com.sap.engine.core.thread.impl3.SingleThread.run(SingleThread.java:159)

Thanks and Regards

Reshma

Accepted Solutions (0)

Answers (3)

Answers (3)

former_member304001
Active Contributor
0 Kudos

Increase no of connections in allowed for pool

these setting can be changed in webdypro admin. -- jco pool config.

Former Member
0 Kudos

Thanks Theo,

That was a very helpful answer

Regards

Reshma

Former Member
0 Kudos

Hi

In order to fix this issue logon to your server with the following link

http://localhost:<port>/webdynpro/dispatcher/sap.com/tcwdtools/Explorer

Maintain your jco connection "SAP_R3_HumanResources"

increase your Maximum Connections to 20 or so

Thanks

Theo

rajnish_tiwari2
Advisor
Advisor
0 Kudos

Hi Former Member,

I have one query that

Is there any limit to Max Connections, Pool size ?

As I am facing the same issue mentioned above.


What is the defined max limit for the connections ?

If there is any documents kindly share it.



Regards,

Rajnish