[residual_billing][ConnectionMgr][02/25 12:24:12.478][DEBUG][Severity 4] [] Not able to get the connection
com.ibm.websphere.ce.cm.ConnectionWaitTimeoutException: Connection not available, Timed out waiting for 180000
at com.ibm.ws.rsadapter.AdapterUtil.toSQLException(AdapterUtil.java(Compiled Code))
at com.ibm.ws.rsadapter.jdbc.WSJdbcDataSource.getConnection(WSJdbcDataSource.java(Compiled Code))
at com.ibm.ws.rsadapter.jdbc.WSJdbcDataSource.getConnection(WSJdbcDataSource.java:302)
at services.in.gdbilling.config.ConnectionMgr.getConnection(ConnectionMgr.java(Compiled Code))
at services.in.gdbilling.in.dao.ViewProjDAO.getProjInfo(ViewProjDAO.java:69)
at services.in.gdbilling.cc.helper.LogonHelper.createRBUser(LogonHelper.java:272)
at services.in.gdbilling.ui.logon.actions.LogonAction.execute(LogonAction.java:136)
at org.apache.struts.action.RequestProcessor.processActionPerform(RequestProcessor.java:484)
at org.apache.struts.action.RequestProcessor.process(RequestProcessor.java:274)
at org.apache.struts.action.ActionServlet.process(ActionServlet.java:1482)
at org.apache.struts.action.ActionServlet.doPost(ActionServlet.java:525)
at javax.servlet.http.HttpServlet.service(HttpServlet.java:763)
at javax.servlet.http.HttpServlet.service(HttpServlet.java:856)
at com.ibm.ws.webcontainer.servlet.ServletWrapper.service(ServletWrapper.java:1282)
at com.ibm.ws.webcontainer.servlet.ServletWrapper.handleRequest(ServletWrapper.java:673)
at com.ibm.ws.webcontainer.servlet.CacheServletWrapper.handleRequest(CacheServletWrapper.java:89)
at com.ibm.ws.webcontainer.WebContainer.handleRequest(WebContainer.java:1897)
at com.ibm.ws.webcontainer.channel.WCChannelLink.ready(WCChannelLink.java:84)
at com.ibm.ws.http.channel.inbound.impl.HttpInboundLink.handleDiscrimination(HttpInboundLink.java:472)
at com.ibm.ws.http.channel.inbound.impl.HttpInboundLink.handleNewInformation(HttpInboundLink.java:411)
at com.ibm.ws.http.channel.inbound.impl.HttpInboundLink.ready(HttpInboundLink.java:288)
at com.ibm.ws.tcp.channel.impl.NewConnectionInitialReadCallback.sendToDiscriminaters(NewConnectionInitialReadCallback.java:207)
at com.ibm.ws.tcp.channel.impl.NewConnectionInitialReadCallback.complete(NewConnectionInitialReadCallback.java:109)
at com.ibm.ws.tcp.channel.impl.WorkQueueManager.requestComplete(WorkQueueManager.java(Compiled Code))
at com.ibm.ws.tcp.channel.impl.WorkQueueManager.attemptIO(WorkQueueManager.java(Compiled Code))
at com.ibm.ws.tcp.channel.impl.WorkQueueManager.workerRun(WorkQueueManager.java(Compiled Code))
at com.ibm.ws.tcp.channel.impl.WorkQueueManager$Worker.run(WorkQueueManager.java(Compiled Code))
at com.ibm.ws.util.ThreadPool$Worker.run(ThreadPool.java(Compiled Code))
Caused by: com.ibm.websphere.ce.j2c.ConnectionWaitTimeoutException: Connection not available, Timed out waiting for 180000
at com.ibm.ejs.j2c.poolmanager.FreePool.createOrWaitForConnection(FreePool.java(Compiled Code))
at com.ibm.ejs.j2c.poolmanager.PoolManager.reserve(PoolManager.java(Compiled Code))
at com.ibm.ejs.j2c.ConnectionManager.allocateMCWrapper(ConnectionManager.java(Compiled Code))
at com.ibm.ejs.j2c.ConnectionManager.allocateConnection(ConnectionManager.java(Compiled Code))
... 27 more
[residual_billing][ConnectionMgr][02/25 12:24:12.488][INFO][Severity 4] [] Method Starts Here
[residual_billing][LogonAction][02/25 12:24:12.488][ERROR][Severity 2] [w3alpha.toronto.ca.ibm.com] Exception occured during logon
[residual_billing][LogonAction][02/25 12:24:12.488][DEBUG][Severity 4] [w3alpha.toronto.ca.ibm.com] execute(mapping,form,request,response)
[residual_billing][LogonAction][02/25 12:28:39.286][DEBUG][Severity 4] [w3alpha.toronto.ca.ibm.com] execute(mapping,form,request,response)
[residual_billing][LogonAction][02/25 12:28:57.215][DEBUG][Severity 4] [w3alpha.toronto.ca.ibm.com] execute(mapping,form,request,response)
[residual_billing][LogonAction][02/25 12:28:57.217][DEBUG][Severity 4] [w3alpha.toronto.ca.ibm.com] validateForm(form)
[residual_billing][LogonAction][02/25 12:28:57.217][DEBUG][Severity 4] [w3alpha.toronto.ca.ibm.com] validateForm(form)
?
esidual_billing][AccountInfoDAO][02/25 12:22:50.811][DEBUG][Severity 4] [w3alpha.toronto.ca.ibm.com] getAccountDetailsList(ProjPk projPk) ends
[residual_billing][ProjHelper][02/25 12:22:50.811][DEBUG][Severity 4] [w3alpha.toronto.ca.ibm.com] getAccountsList(form)
[residual_billing][ProjHelper][02/25 12:22:50.811][DEBUG][Severity 4] [w3alpha.toronto.ca.ibm.com] getLocationsMap()
[residual_billing][GlobalParamContext][02/25 12:22:50.811][DEBUG][Severity 4] [w3alpha.toronto.ca.ibm.com] getGlobalMap() method strats here
[residual_billing][ConnectionMgr][02/25 12:22:50.811][INFO][Severity 4] [] Method Starts Here
[residual_billing][GlobalParamContext][02/25 12:22:50.834][DEBUG][Severity 4] [w3alpha.toronto.ca.ibm.com] getGlobalMap() method ends here
[residual_billing][ProjHelper][02/25 12:22:50.834][DEBUG][Severity 4] [w3alpha.toronto.ca.ibm.com] getLocationsMap()
[residual_billing][ProjHelper][02/25 12:22:50.834][DEBUG][Severity 4] [w3alpha.toronto.ca.ibm.com] handleModifyRequest(projSetupForm,session,user)
[residual_billing][ProjModifyInitialAction][02/25 12:22:50.834][DEBUG][Severity 4] [w3alpha.toronto.ca.ibm.com] execute(mapping,form,request,response)
[residual_billing][ConnectionMgr][02/25 12:24:12.478][DEBUG][Severity 4] [] Not able to get the connection
com.ibm.websphere.ce.cm.ConnectionWaitTimeoutException: Connection not available, Timed out waiting for 180000
at com.ibm.ws.rsadapter.AdapterUtil.toSQLException(AdapterUtil.java(Compiled Code))
at com.ibm.ws.rsadapter.jdbc.WSJdbcDataSource.getConnection(WSJdbcDataSource.java(Compiled Code))
at com.ibm.ws.rsadapter.jdbc.WSJdbcDataSource.getConnection(WSJdbcDataSource.java:302)
at services.in.gdbilling.config.ConnectionMgr.getConnection(ConnectionMgr.java(Compiled Code))
at services.in.gdbilling.in.dao.ViewProjDAO.getProjInfo(ViewProjDAO.java:69)
at services.in.gdbilling.cc.helper.LogonHelper.createRBUser(LogonHelper.java:272)
at services.in.gdbilling.ui.logon.actions.LogonAction.execute(LogonAction.java:136)
at org.apache.struts.action.RequestProcessor.processActionPerform(RequestProcessor.java:484)
at org.apache.struts.action.RequestProcessor.process(RequestProcessor.java:274)
at org.apache.struts.action.ActionServlet.process(ActionServlet.java:1482)
at org.apache.struts.action.ActionServlet.doPost(ActionServlet.java:525)
at javax.servlet.http.HttpServlet.service(HttpServlet.java:763)
at javax.servlet.http.HttpServlet.service(HttpServlet.java:856)
at com.ibm.ws.webcontainer.servlet.ServletWrapper.service(ServletWrapper.java:1282)
at com.ibm.ws.webcontainer.servlet.ServletWrapper.handleRequest(ServletWrapper.java:673)
at com.ibm.ws.webcontainer.servlet.CacheServletWrapper.handleRequest(CacheServletWrapper.java:89)
at com.ibm.ws.webcontainer.WebContainer.handleRequest(WebContainer.java:1897)
at com.ibm.ws.webcontainer.channel.WCChannelLink.ready(WCChannelLink.java:84)
at com.ibm.ws.http.channel.inbound.impl.HttpInboundLink.handleDiscrimination(HttpInboundLink.java:472)
at com.ibm.ws.http.channel.inbound.impl.HttpInboundLink.handleNewInformation(HttpInboundLink.java:411)
at com.ibm.ws.http.channel.inbound.impl.HttpInboundLink.ready(HttpInboundLink.java:288)
at com.ibm.ws.tcp.channel.impl.NewConnectionInitialReadCallback.sendToDiscriminaters(NewConnectionInitialReadCallback.java:207)
at com.ibm.ws.tcp.channel.impl.NewConnectionInitialReadCallback.complete(NewConnectionInitialReadCallback.java:109)
at com.ibm.ws.tcp.channel.impl.WorkQueueManager.requestComplete(WorkQueueManager.java(Compiled Code))
at com.ibm.ws.tcp.channel.impl.WorkQueueManager.attemptIO(WorkQueueManager.java(Compiled Code))
at com.ibm.ws.tcp.channel.impl.WorkQueueManager.workerRun(WorkQueueManager.java(Compiled Code))
at com.ibm.ws.tcp.channel.impl.WorkQueueManager$Worker.run(WorkQueueManager.java(Compiled Code))
at com.ibm.ws.util.ThreadPool$Worker.run(ThreadPool.java(Compiled Code))
Caused by: com.ibm.websphere.ce.j2c.ConnectionWaitTimeoutException: Connection not available, Timed out waiting for 180000
at com.ibm.ejs.j2c.poolmanager.FreePool.createOrWaitForConnection(FreePool.java(Compiled Code))
at com.ibm.ejs.j2c.poolmanager.PoolManager.reserve(PoolManager.java(Compiled Code))
at com.ibm.ejs.j2c.ConnectionManager.allocateMCWrapper(ConnectionManager.java(Compiled Code))
at com.ibm.ejs.j2c.ConnectionManager.allocateConnection(ConnectionManager.java(Compiled Code))
... 27 more
[residual_billing][ConnectionMgr][02/25 12:24:12.488][INFO][Severity 4] [] Method Starts Here
[residual_billing][LogonAction][02/25 12:24:12.488][ERROR][Severity 2] [w3alpha.toronto.ca.ibm.com] Exception occured during logon
[residual_billing][LogonAction][02/25 12:24:12.488][DEBUG][Severity 4] [w3alpha.toronto.ca.ibm.com] execute(mapping,form,request,response)
[residual_billing][LogonAction][02/25 12:28:39.286][DEBUG][Severity 4] [w3alpha.toronto.ca.ibm.com] execute(mapping,form,request,response)
[residual_billing][LogonAction][02/25 12:28:57.215][DEBUG][Severity 4] [w3alpha.toronto.ca.ibm.com] execute(mapping,form,request,response)
[residual_billing][LogonAction][02/25 12:28:57.217][DEBUG][Severity 4] [w3alpha.toronto.ca.ibm.com] validateForm(form)
[residual_billing][LogonAction][02/25 12:28:57.217][DEBUG][Severity 4] [w3alpha.toronto.ca.ibm.com] validateForm(form)
[residual_billing][LogonHelper][02/25 12:28:57.218][DEBUG][Severity 4] [w3alpha.toronto.ca.ibm.com] processLogonRequest(intranetId,password)
[residual_billing][LogonHelper][02/25 12:28:57.218][DEBUG][Severity 4] [w3alpha.toronto.ca.ibm.com] checkUserCredentials(userName,password)
[residual_billing][LogonHelper][02/25 12:28:58.683][DEBUG][Severity 4] [w3alpha.toronto.ca.ibm.com] checkUserCredentials(userName,password)
[residual_billing][LogonHelper][02/25 12:28:58.683][DEBUG][Severity 4] [w3alpha.toronto.ca.ibm.com] processLogonRequest(intranetId,password)
[residual_billing][LogonHelper][02/25 12:28:58.684][DEBUG][Severity 4] [w3alpha.toronto.ca.ibm.com] retrieveUserAuthorizationInfo(intranetId,logondto)
[residual_billing][LogonHelper][02/25 12:28:58.684][DEBUG][Severity 4] [w3alpha.toronto.ca.ibm.com] getAllGroupsThatUserIsMemberOf(intranetId)
[residual_billing][LogonHelper][02/25 12:28:59.782][DEBUG][Severity 4] [w3alpha.toronto.ca.ibm.com] getAllGroupsThatUserIsMemberOf(intranetId)
[residual_billing][LogonHelper][02/25 12:28:59.782][DEBUG][Severity 4] [w3alpha.toronto.ca.ibm.com] checkIfUserIsApprover(intranetId,logondto,allActionEventsList)
[residual_billing][LogonDAO][02/25 12:28:59.782][DEBUG][Severity 4] [w3alpha.toronto.ca.ibm.com] isApprover(
String intranetid) starts
[residual_billing][ConnectionMgr][02/25 12:28:59.782][INFO][Severity 4] [] Method Starts Here
[residual_billing][ConnectionMgr][02/25 12:31:59.863][DEBUG][Severity 4] [] Not able to get the connection
com.ibm.websphere.ce.cm.ConnectionWaitTimeoutException: Connection not available, Timed out waiting for 180010
at com.ibm.ws.rsadapter.AdapterUtil.toSQLException(AdapterUtil.java(Compiled Code))
at com.ibm.ws.rsadapter.jdbc.WSJdbcDataSource.getConnection(WSJdbcDataSource.java(Compiled Code))
at com.ibm.ws.rsadapter.jdbc.WSJdbcDataSource.getConnection(WSJdbcDataSource.java:302)
at services.in.gdbilling.config.ConnectionMgr.getConnection(ConnectionMgr.java(Compiled Code))
at services.in.gdbilling.in.dao.LogonDAO.isApprover(LogonDAO.java(Compiled Code))
at services.in.gdbilling.cc.helper.LogonHelper.checkIfUserIsApprover(LogonHelper.java(Inlined Compiled Code))
at services.in.gdbilling.cc.helper.LogonHelper.retrieveUserAuthorizationInfo(LogonHelper.java(Compiled Code))
at services.in.gdbilling.cc.helper.LogonHelper.processLogonRequest(LogonHelper.java:91)
at services.in.gdbilling.ui.logon.actions.LogonAction.execute(LogonAction.java:115)
at org.apache.struts.action.RequestProcessor.processActionPerform(RequestProcessor.java:484)
at org.apache.struts.action.RequestProcessor.process(RequestProcessor.java:274)
at org.apache.struts.action.ActionServlet.process(ActionServlet.java:1482)
at org.apache.struts.action.ActionServlet.doPost(ActionServlet.java:525)
at javax.servlet.http.HttpServlet.service(HttpServlet.java:763)
at javax.servlet.http.HttpServlet.service(HttpServlet.java:856)
at com.ibm.ws.webcontainer.servlet.ServletWrapper.service(ServletWrapper.java:1282)
at com.ibm.ws.webcontainer.servlet.ServletWrapper.handleRequest(ServletWrapper.java:673)
at com.ibm.ws.webcontainer.servlet.CacheServletWrapper.handleRequest(CacheServletWrapper.java:89)
at com.ibm.ws.webcontainer.WebContainer.handleRequest(WebContainer.java:1897)
at com.ibm.ws.webcontainer.channel.WCChannelLink.ready(WCChannelLink.java:84)
at com.ibm.ws.http.channel.inbound.impl.HttpInboundLink.handleDiscrimination(HttpInboundLink.java:472)
at com.ibm.ws.http.channel.inbound.impl.HttpInboundLink.handleNewInformation(HttpInboundLink.java:411)
at com.ibm.ws.http.channel.inbound.impl.HttpInboundLink.ready(HttpInboundLink.java:288)
at com.ibm.ws.tcp.channel.impl.NewConnectionInitialReadCallback.sendToDiscriminaters(NewConnectionInitialReadCallback.java:207)
at com.ibm.ws.tcp.channel.impl.NewConnectionInitialReadCallback.complete(NewConnectionInitialReadCallback.java:109)
at com.ibm.ws.tcp.channel.impl.WorkQueueManager.requestComplete(WorkQueueManager.java(Compiled Code))
at com.ibm.ws.tcp.channel.impl.WorkQueueManager.attemptIO(WorkQueueManager.java(Compiled Code))
at com.ibm.ws.tcp.channel.impl.WorkQueueManager.workerRun(WorkQueueManager.java(Compiled Code))
at com.ibm.ws.tcp.channel.impl.WorkQueueManager$Worker.run(WorkQueueManager.java(Compiled Code))
at com.ibm.ws.util.ThreadPool$Worker.run(ThreadPool.java(Compiled Code))
Caused by: com.ibm.websphere.ce.j2c.ConnectionWaitTimeoutException: Connection not available, Timed out waiting for 180010
at com.ibm.ejs.j2c.poolmanager.FreePool.createOrWaitForConnection(FreePool.java(Compiled Code))
at com.ibm.ejs.j2c.poolmanager.PoolManager.reserve(PoolManager.java(Compiled Code))
at com.ibm.ejs.j2c.ConnectionManager.allocateMCWrapper(ConnectionManager.java(Compiled Code))
at com.ibm.ejs.j2c.ConnectionManager.allocateConnection(ConnectionManager.java(Compiled Code))
... 29 more
[residual_billing][ConnectionMgr][02/25 12:31:59.865][INFO][Severity 4] [] Method Starts Here
[residual_billing][LogonDAO][02/25 12:31:59.865][ERROR][Severity 2] [w3alpha.toronto.ca.ibm.com] Not able to execute the query
java.lang.NullPointerException
at services.in.gdbilling.in.dao.LogonDAO.isApprover(LogonDAO.java(Compiled Code))
at services.in.gdbilling.cc.helper.LogonHelper.checkIfUserIsApprover(LogonHelper.java(Inlined Compiled Code))
at services.in.gdbilling.cc.helper.LogonHelper.retrieveUserAuthorizationInfo(LogonHelper.java(Compiled Code))
at services.in.gdbilling.cc.helper.LogonHelper.processLogonRequest(LogonHelper.java:91)
at services.in.gdbilling.ui.logon.actions.LogonAction.execute(LogonAction.java:115)
at org.apache.struts.action.RequestProcessor.processActionPerform(RequestProcessor.java:484)
at org.apache.struts.action.RequestProcessor.process(RequestProcessor.java:274)
at org.apache.struts.action.ActionServlet.process(ActionServlet.java:1482)
at org.apache.struts.action.ActionServlet.doPost(ActionServlet.java:525)
at javax.servlet.http.HttpServlet.service(HttpServlet.java:763)
at javax.servlet.http.HttpServlet.service(HttpServlet.java:856)
at com.ibm.ws.webcontainer.servlet.ServletWrapper.service(ServletWrapper.java:1282)
at com.ibm.ws.webcontainer.servlet.ServletWrapper.handleRequest(ServletWrapper.java:673)
at com.ibm.ws.webcontainer.servlet.CacheServletWrapper.handleRequest(CacheServletWrapper.java:89)
at com.ibm.ws.webcontainer.WebContainer.handleRequest(WebContainer.java:1897)
at com.ibm.ws.webcontainer.channel.WCChannelLink.ready(WCChannelLink.java:84)
at com.ibm.ws.http.channel.inbound.impl.HttpInboundLink.handleDiscrimination(HttpInboundLink.java:472)
at com.ibm.ws.http.channel.inbound.impl.HttpInboundLink.handleNewInformation(HttpInboundLink.java:411)
at com.ibm.ws.http.channel.inbound.impl.HttpInboundLink.ready(HttpInboundLink.java:288)
at com.ibm.ws.tcp.channel.impl.NewConnectionInitialReadCallback.sendToDiscriminaters(NewConnectionInitialReadCallback.java:207)
at com.ibm.ws.tcp.channel.impl.NewConnectionInitialReadCallback.complete(NewConnectionInitialReadCallback.java:109)
at com.ibm.ws.tcp.channel.impl.WorkQueueManager.requestComplete(WorkQueueManager.java(Compiled Code))
at com.ibm.ws.tcp.channel.impl.WorkQueueManager.attemptIO(WorkQueueManager.java(Compiled Code))
at com.ibm.ws.tcp.channel.impl.WorkQueueManager.workerRun(WorkQueueManager.java(Compiled Code))
at com.ibm.ws.tcp.channel.impl.WorkQueueManager$Worker.run(WorkQueueManager.java(Compiled Code))
at com.ibm.ws.util.ThreadPool$Worker.run(ThreadPool.java(Compiled Code))
[residual_billing][LogonDAO][02/25 12:31:59.866][DEBUG][Severity 4] [w3alpha.toronto.ca.ibm.com] isApprover(String intranetid) ends
[residual_billing][LogonHelper][02/25 12:31:59.867][DEBUG][Severity 4] [w3alpha.toronto.ca.ibm.com] checkIfUserIsApprover(intranetId,logondto,allActionEventsList)
[residual_billing][LogonHelper][02/25 12:31:59.867][DEBUG][Severity 4] [w3alpha.toronto.ca.ibm.com] retrieveUserAuthorizationInfo(intranetId,logondto)
[residual_billing][LogonHelper][02/25 12:31:59.867][DEBUG][Severity 4] [w3alpha.toronto.ca.ibm.com] createRBUser(intranetId,logonDTO)
[residual_billing][BluePageHelper][02/25 12:31:59.868][DEBUG][Severity 4] [w3alpha.toronto.ca.ibm.com] getUserInfo(intranetId)
[residual_billing][BluePageHelper][02/25 12:32:00.291][DEBUG][Severity 4] [w3alpha.toronto.ca.ibm.com] getNotesMailId(str)
[residual_billing][BluePageHelper][02/25 12:32:00.291][DEBUG][Severity 4] [w3alpha.toronto.ca.ibm.com] getNotesMailId(str)
[residual_billing][BluePageHelper][02/25 12:32:00.912][DEBUG][Severity 4] [w3alpha.toronto.ca.ibm.com] getUserInfo(intranetId)
[residual_billing][ViewProjDAO][02/25 12:32:00.912][DEBUG][Severity 4] [w3alpha.toronto.ca.ibm.com] getProjInfo(String intranetId, String originalIntranetId) starts
[residual_billing][ConnectionMgr][02/25 12:32:00.912][INFO][Severity 4] [] Method Starts Here
$
$
[residual_billing][LogonHelper][02/25 12:28:57.218][DEBUG][Severity 4] [w3alpha.toronto.ca.ibm.com] processLogonRequest(intranetId,password)
[residual_billing][LogonHelper][02/25 12:28:57.218][DEBUG][Severity 4] [w3alpha.toronto.ca.ibm.com] checkUserCredentials(userName,password)
[residual_billing][LogonHelper][02/25 12:28:58.683][DEBUG][Severity 4] [w3alpha.toronto.ca.ibm.com] checkUserCredentials(userName,password)
[residual_billing][LogonHelper][02/25 12:28:58.683][DEBUG][Severity 4] [w3alpha.toronto.ca.ibm.com] processLogonRequest(intranetId,password)
[residual_billing][LogonHelper][02/25 12:28:58.684][DEBUG][Severity 4] [w3alpha.toronto.ca.ibm.com] retrieveUserAuthorizationInfo(intranetId,logondto)
[residual_billing][LogonHelper][02/25 12:28:58.684][DEBUG][Severity 4] [w3alpha.toronto.ca.ibm.com] getAllGroupsThatUserIsMemberOf(intranetId)
[residual_billing][LogonHelper][02/25 12:28:59.782][DEBUG][Severity 4] [w3alpha.toronto.ca.ibm.com] getAllGroupsThatUserIsMemberOf(intranetId)
[residual_billing][LogonHelper][02/25 12:28:59.782][DEBUG][Severity 4] [w3alpha.toronto.ca.ibm.com] checkIfUserIsApprover(intranetId,logondto,allActionEventsList)
[residual_billing][LogonDAO][02/25 12:28:59.782][DEBUG][Severity 4] [w3alpha.toronto.ca.ibm.com] isApprover(String intranetid) starts
[residual_billing][ConnectionMgr][02/25 12:28:59.782][INFO][Severity 4] [] Method Starts Here
[residual_billing][ConnectionMgr][02/25 12:31:59.863][DEBUG][Severity 4] [] Not able to get the connection
com.ibm.websphere.ce.cm.ConnectionWaitTimeoutException: Connection not available, Timed out waiting for 180010
at com.ibm.ws.rsadapter.AdapterUtil.toSQLException(AdapterUtil.java(Compiled Code))
at com.ibm.ws.rsadapter.jdbc.WSJdbcDataSource.getConnection(WSJdbcDataSource.java(Compiled Code))
at com.ibm.ws.rsadapter.jdbc.WSJdbcDataSource.getConnection(WSJdbcDataSource.java:302)
at services.in.gdbilling.config.ConnectionMgr.getConnection(ConnectionMgr.java(Compiled Code))
at services.in.gdbilling.in.dao.LogonDAO.isApprover(LogonDAO.java(Compiled Code))
at services.in.gdbilling.cc.helper.LogonHelper.checkIfUserIsApprover(LogonHelper.java(Inlined Compiled Code))
at services.in.gdbilling.cc.helper.LogonHelper.retrieveUserAuthorizationInfo(LogonHelper.java(Compiled Code))
at services.in.gdbilling.cc.helper.LogonHelper.processLogonRequest(LogonHelper.java:91)
at services.in.gdbilling.ui.logon.actions.LogonAction.execute(LogonAction.java:115)
at org.apache.struts.action.RequestProcessor.processActionPerform(RequestProcessor.java:484)
at org.apache.struts.action.RequestProcessor.process(RequestProcessor.java:274)
at org.apache.struts.action.ActionServlet.process(ActionServlet.java:1482)
at org.apache.struts.action.ActionServlet.doPost(ActionServlet.java:525)
at javax.servlet.http.HttpServlet.service(HttpServlet.java:763)
at javax.servlet.http.HttpServlet.service(HttpServlet.java:856)
at com.ibm.ws.webcontainer.servlet.ServletWrapper.service(ServletWrapper.java:1282)
at com.ibm.ws.webcontainer.servlet.ServletWrapper.handleRequest(ServletWrapper.java:673)
at com.ibm.ws.webcontainer.servlet.CacheServletWrapper.handleRequest(CacheServletWrapper.java:89)
at com.ibm.ws.webcontainer.WebContainer.handleRequest(WebContainer.java:1897)
at com.ibm.ws.webcontainer.channel.WCChannelLink.ready(WCChannelLink.java:84)
at com.ibm.ws.http.channel.inbound.impl.HttpInboundLink.handleDiscrimination(HttpInboundLink.java:472)
at com.ibm.ws.http.channel.inbound.impl.HttpInboundLink.handleNewInformation(HttpInboundLink.java:411)
at com.ibm.ws.http.channel.inbound.impl.HttpInboundLink.ready(HttpInboundLink.java:288)
at com.ibm.ws.tcp.channel.impl.NewConnectionInitialReadCallback.sendToDiscriminaters(NewConnectionInitialReadCallback.java:207)
at com.ibm.ws.tcp.channel.impl.NewConnectionInitialReadCallback.complete(NewConnectionInitialReadCallback.java:109)
at com.ibm.ws.tcp.channel.impl.WorkQueueManager.requestComplete(WorkQueueManager.java(Compiled Code))
at com.ibm.ws.tcp.channel.impl.WorkQueueManager.attemptIO(WorkQueueManager.java(Compiled Code))
at com.ibm.ws.tcp.channel.impl.WorkQueueManager.workerRun(WorkQueueManager.java(Compiled Code))
at com.ibm.ws.tcp.channel.impl.WorkQueueManager$Worker.run(WorkQueueManager.java(Compiled Code))
at com.ibm.ws.util.ThreadPool$Worker.run(ThreadPool.java(Compiled Code))
Caused by: com.ibm.websphere.ce.j2c.ConnectionWaitTimeoutException: Connection not available, Timed out waiting for 180010
at com.ibm.ejs.j2c.poolmanager.FreePool.createOrWaitForConnection(FreePool.java(Compiled Code))
at com.ibm.ejs.j2c.poolmanager.PoolManager.reserve(PoolManager.java(Compiled Code))
at com.ibm.ejs.j2c.ConnectionManager.allocateMCWrapper(ConnectionManager.java(Compiled Code))
at com.ibm.ejs.j2c.ConnectionManager.allocateConnection(ConnectionManager.java(Compiled Code))
... 29 more
[residual_billing][ConnectionMgr][02/25 12:31:59.865][INFO][Severity 4] [] Method Starts Here
[residual_billing][LogonDAO][02/25 12:31:59.865][ERROR][Severity 2] [w3alpha.toronto.ca.ibm.com] Not able to execute the query
java.lang.NullPointerException
at services.in.gdbilling.in.dao.LogonDAO.isApprover(LogonDAO.java(Compiled Code))
at services.in.gdbilling.cc.helper.LogonHelper.checkIfUserIsApprover(LogonHelper.java(Inlined Compiled Code))
at services.in.gdbilling.cc.helper.LogonHelper.retrieveUserAuthorizationInfo(LogonHelper.java(Compiled Code))
at services.in.gdbilling.cc.helper.LogonHelper.processLogonRequest(LogonHelper.java:91)
at services.in.gdbilling.ui.logon.actions.LogonAction.execute(LogonAction.java:115)
at org.apache.struts.action.RequestProcessor.processActionPerform(RequestProcessor.java:484)
at org.apache.struts.action.RequestProcessor.process(RequestProcessor.java:274)
at org.apache.struts.action.ActionServlet.process(ActionServlet.java:1482)
at org.apache.struts.action.ActionServlet.doPost(ActionServlet.java:525)
at javax.servlet.http.HttpServlet.service(HttpServlet.java:763)
at javax.servlet.http.HttpServlet.service(HttpServlet.java:856)
at com.ibm.ws.webcontainer.servlet.ServletWrapper.service(ServletWrapper.java:1282)
at com.ibm.ws.webcontainer.servlet.ServletWrapper.handleRequest(ServletWrapper.java:673)
at com.ibm.ws.webcontainer.servlet.CacheServletWrapper.handleRequest(CacheServletWrapper.java:89)
at com.ibm.ws.webcontainer.WebContainer.handleRequest(WebContainer.java:1897)
at com.ibm.ws.webcontainer.channel.WCChannelLink.ready(WCChannelLink.java:84)
at com.ibm.ws.http.channel.inbound.impl.HttpInboundLink.handleDiscrimination(HttpInboundLink.java:472)
at com.ibm.ws.http.channel.inbound.impl.HttpInboundLink.handleNewInformation(HttpInboundLink.java:411)
at com.ibm.ws.http.channel.inbound.impl.HttpInboundLink.ready(HttpInboundLink.java:288)
at com.ibm.ws.tcp.channel.impl.NewConnectionInitialReadCallback.sendToDiscriminaters(NewConnectionInitialReadCallback.java:207)
at com.ibm.ws.tcp.channel.impl.NewConnectionInitialReadCallback.complete(NewConnectionInitialReadCallback.java:109)
at com.ibm.ws.tcp.channel.impl.WorkQueueManager.requestComplete(WorkQueueManager.java(Compiled Code))
at com.ibm.ws.tcp.channel.impl.WorkQueueManager.attemptIO(WorkQueueManager.java(Compiled Code))
at com.ibm.ws.tcp.channel.impl.WorkQueueManager.workerRun(WorkQueueManager.java(Compiled Code))
at com.ibm.ws.tcp.channel.impl.WorkQueueManager$Worker.run(WorkQueueManager.java(Compiled Code))
at com.ibm.ws.util.ThreadPool$Worker.run(ThreadPool.java(Compiled Code))
[residual_billing][LogonDAO][02/25 12:31:59.866][DEBUG][Severity 4] [w3alpha.toronto.ca.ibm.com] isApprover(String intranetid) ends
[residual_billing][LogonHelper][02/25 12:31:59.867][DEBUG][Severity 4] [w3alpha.toronto.ca.ibm.com] checkIfUserIsApprover(intranetId,logondto,allActionEventsList)
[residual_billing][LogonHelper][02/25 12:31:59.867][DEBUG][Severity 4] [w3alpha.toronto.ca.ibm.com] retrieveUserAuthorizationInfo(intranetId,logondto)
[residual_billing][LogonHelper][02/25 12:31:59.867][DEBUG][Severity 4] [w3alpha.toronto.ca.ibm.com] createRBUser(intranetId,logonDTO)
[residual_billing][BluePageHelper][02/25 12:31:59.868][DEBUG][Severity 4] [w3alpha.toronto.ca.ibm.com] getUserInfo(intranetId)
[residual_billing][BluePageHelper][02/25 12:32:00.291][DEBUG][Severity 4] [w3alpha.toronto.ca.ibm.com] getNotesMailId(str)
[residual_billing][BluePageHelper][02/25 12:32:00.291][DEBUG][Severity 4] [w3alpha.toronto.ca.ibm.com] getNotesMailId(str)
[residual_billing][BluePageHelper][02/25 12:32:00.912][DEBUG][Severity 4] [w3alpha.toronto.ca.ibm.com] getUserInfo(intranetId)
[residual_billing][ViewProjDAO][02/25 12:32:00.912][DEBUG][Severity 4] [w3alpha.toronto.ca.ibm.com] getProjInfo(String intranetId, String originalIntranetId) starts
[residual_billing][ConnectionMgr][02/25 12:32:00.912][INFO][Severity 4] [] Method Starts Here
$
$