When i have select the multiple reports and click the print button after sometime its throwging 500 error on the browser,have seen the below exceptions on the logs.


As of now I did some steps which is mentioned on below links

1.akhilesh-humbe.blogspot.in/2015/03/1-man...
2.

blog.163.com/briskyun@126/blog/static/13...

Can someone please help on this?

6/8/15 10:04:08:072 EDT] 00000043 PoolManager   W   Exceeded the number of allowable managed connection on thread 00000043.  1 managed connections are already being used on this thread.    Managed connection being used on this thread

  MCWrapper id e117e2cb  Managed connection WSRdbManagedConnectionImpl@36b2d5ed  State:STATE_TRAN_WRAPPER_INUSE Thread Id: 00000043 Thread Name: WebContainer : 0 Used with transaction com.ibm.ws.LocalTransaction.LocalTranCoordImpl@f511c443;SUSPENDED;

     Start time inuse Mon Jun 08 10:03:06 EDT 2015 Time inuse 62 (seconds)

     Last allocation time Mon Jun 08 10:03:10 EDT 2015

       getConnection stack trace information:

          com.ibm.ws.rsadapter.jdbc.WSJdbcDataSource.getConnection(WSJdbcDataSource.java:636)

          com.adp.util.db.DBConnectionUtil.getPortalConnection(DBConnectionUtil.java:183)

          com.adp.util.db.DBConnectionUtil.getPortalConnection(DBConnectionUtil.java:98)

          com.adp.windward.fmwk.dao.BusinessFacadeDAO.getSORProductNameFromDB(BusinessFacadeDAO.java:181)

          com.adp.windward.fmwk.dao.BusinessFacadeDAO.getSORProductName(BusinessFacadeDAO.java:156)

          com.adp.windward.fmwk.struts.action.ADPBaseAction.getSORProductName(ADPBaseAction.java:965)

          com.adp.windward.fmwk.struts.action.ADPBaseAction.getSORProductName(ADPBaseAction.java:957)

          com.adp.windward.fmwk.struts.action.ADPBaseAction.setSorVersion(ADPBaseAction.java:1028)

          com.adp.windward.fmwk.struts.action.ADPBaseAction.preActionProcessing(ADPBaseAction.java:1095)

          com.adp.windward.fmwk.struts.action.WindwardAction.execute(WindwardAction.java:57)

          org.apache.struts.action.RequestProcessor.processActionPerform(RequestProcessor.java:484)

          org.apache.struts.action.RequestProcessor.process(RequestProcessor.java:274)

          org.apache.struts.action.ActionServlet.process(ActionServlet.java:1482)

          org.apache.struts.action.ActionServlet.doPost(ActionServlet.java:525)

          javax.servlet.http.HttpServlet.service(HttpServlet.java:595)

          javax.servlet.http.HttpServlet.service(HttpServlet.java:668)

          com.ibm.ws.webcontainer.servlet.ServletWrapper.service(ServletWrapper.java:1230)

          com.ibm.ws.webcontainer.servlet.ServletWrapper.handleRequest(ServletWrapper.java:779)

          com.ibm.ws.webcontainer.servlet.ServletWrapper.handleRequest(ServletWrapper.java:478)

          com.ibm.ws.webcontainer.servlet.ServletWrapperImpl.handleRequest(ServletWrapperImpl.java:178)

          com.ibm.ws.webcontainer.filter.WebAppFilterManager.invokeFilters(WebAppFilterManager.java:1071)

          com.ibm.ws.webcontainer.servlet.CacheServletWrapper.handleRequest(CacheServletWrapper.java:87)

          com.ibm.ws.webcontainer.WebContainer.handleRequest(WebContainer.java:909)

          com.ibm.ws.webcontainer.WSWebContainer.handleRequest(WSWebContainer.java:1662)

          com.ibm.ws.webcontainer.channel.WCChannelLink.ready(WCChannelLink.java:200)

          com.ibm.ws.http.channel.inbound.impl.HttpInboundLink.handleDiscrimination(HttpInboundLink.java:453)

          com.ibm.ws.http.channel.inbound.impl.HttpInboundLink.handleNewRequest(HttpInboundLink.java:515)

          com.ibm.ws.http.channel.inbound.impl.HttpInboundLink.processRequest(HttpInboundLink.java:306)

          com.ibm.ws.http.channel.inbound.impl.HttpICLReadCallback.complete(HttpICLReadCallback.java:84)

          com.ibm.ws.tcp.channel.impl.AioReadCompletionListener.futureCompleted(AioReadCompletionListener.java:175)

          com.ibm.io.async.AbstractAsyncFuture.invokeCallback(AbstractAsyncFuture.java:217)

          com.ibm.io.async.AsyncChannelFuture.fireCompletionActions(AsyncChannelFuture.java:161)

          com.ibm.io.async.AsyncFuture.completed(AsyncFuture.java:138)

          com.ibm.io.async.ResultHandler.complete(ResultHandler.java:204)

          com.ibm.io.async.ResultHandler.runEventProcessingLoop(ResultHandler.java:775)

          com.ibm.io.async.ResultHandler$2.run(ResultHandler.java:905)

          com.ibm.ws.util.ThreadPool$Worker.run(ThreadPool.java:1700)

 

Hi sampath,

  You can check if you are having "MultiThreaded access to a connection" enabling "enableMultithreadedAccessDetection" in administrative console
 
  Administrative console, navigate to Resources > JDBC > JDBC providers > JDBC_provider > Data sources > data_source name > WebSphere Application Server data source properties, and select the check box to enable this property
 
  If you are having the issue follow the steps or your first link

  akhilesh-humbe.blogspot.in/2015/03/1-man...
 
  For documentation purpose
  Understanding connection transitions: Avoiding multi-threaded access to a JCA connection in WebSphere Application Server
  www.ibm.com/developerworks/websphere/tec...
 
  Hope this helps. Tell us if you need more support
 
Regards

Thank you..!! Gabriel .Appriciate for your help

I have followed the below link but still getting the same error.


 akhilesh-humbe.blogspot.in/2015/03/1-man...
  
the property ""enableMultithreadedAccessDetection" " is alreday enabled in the datasource.

not sure what is causing my issue. 

sampath
 
  Have you seen any DSRA8720W message (f it detects multi-threaded access to JDBC objects) in your systemout.log?
 
Regards