Problems to add assets in a contract
Hello to all,
last weekend we have updated SDP to 8207 build. Since this update, we have experience problems
to include new assets in the active contracts. Sometimes SDP doesn't allow to find assets and take more than 15 minutes to show "search panel" after click "add" in contract. Sometimes SDP stop suddenly and we need to restart service to work again with application.
This is a part of log when server go down:
[13:59:39:404]|[07-01-2013]|[SYSOUT]|[INFO]|[31]|: here inside Login.jsp---->|
[13:59:39:404]|[07-01-2013]|[com.adventnet.servicedesk.authentication.NTLMV2Filter]|[INFO]|[31]|: generateNTLMV2Script HttpServletRequest--->http://servicedesk.test.com:8080/HomePage.do|
[13:59:39:404]|[07-01-2013]|[com.adventnet.servicedesk.authentication.NTLMV2Filter]|[INFO]|[31]|: lurl--->HomePage.do|
[13:59:44:373]|[07-01-2013]|[SYSOUT]|[INFO]|[93]|: org.jboss.util.NestedSQLException: No ManagedConnections available within configured blocking timeout ( 30000 [ms] ); - nested throwable: (javax.resource.ResourceException: No ManagedConnections available within configured blocking timeout ( 30000 [ms] ))|
[13:59:44:373]|[07-01-2013]|[SYSOUT]|[INFO]|[93]|: at org.jboss.resource.adapter.jdbc.WrapperDataSource.getConnection(WrapperDataSource.java:106)|
[13:59:44:373]|[07-01-2013]|[SYSOUT]|[INFO]|[93]|: at com.adventnet.db.api.RelationalAPI.getConnection(RelationalAPI.java:181)|
[13:59:44:373]|[07-01-2013]|[SYSOUT]|[INFO]|[93]|: at com.adventnet.persistence.internal.GetUtil.get(GetUtil.java:88)|
[13:59:44:373]|[07-01-2013]|[SYSOUT]|[INFO]|[93]|: at com.adventnet.persistence.DataAccess.get(DataAccess.java:1162)|
[13:59:44:373]|[07-01-2013]|[SYSOUT]|[INFO]|[93]|: at com.adventnet.persistence.DataAccess.get(DataAccess.java:1018)|
[13:59:44:373]|[07-01-2013]|[SYSOUT]|[INFO]|[93]|: at com.adventnet.persistence.DataAccess.get(DataAccess.java:1011)|
[13:59:44:373]|[07-01-2013]|[SYSOUT]|[INFO]|[93]|: at com.adventnet.servicedesk.utils.DataAccessUtil.get(DataAccessUtil.java:128)|
[13:59:44:373]|[07-01-2013]|[SYSOUT]|[INFO]|[93]|: at com.adventnet.servicedesk.setup.util.SSOUtil.isSSOEnabled(SSOUtil.java:32)|
[13:59:44:373]|[07-01-2013]|[SYSOUT]|[INFO]|[93]|: at org.apache.jsp.Login_jsp._jspService(Login_jsp.java:149)|
[13:59:44:373]|[07-01-2013]|[SYSOUT]|[INFO]|[93]|: at org.apache.jasper.runtime.HttpJspBase.service(HttpJspBase.java:94)|
[13:59:44:373]|[07-01-2013]|[SYSOUT]|[INFO]|[93]|: at javax.servlet.http.HttpServlet.service(HttpServlet.java:810)|
[13:59:44:373]|[07-01-2013]|[SYSOUT]|[INFO]|[93]|: at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:237)|
[13:59:44:373]|[07-01-2013]|[SYSOUT]|[INFO]|[93]|: at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:157)|
[13:59:44:373]|[07-01-2013]|[SYSOUT]|[INFO]|[93]|: at com.adventnet.servicedesk.filter.EncodingFilter.doFilter(EncodingFilter.java:162)|
[13:59:44:373]|[07-01-2013]|[SYSOUT]|[INFO]|[93]|: at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:186)|
[13:59:44:373]|[07-01-2013]|[SYSOUT]|[INFO]|[93]|: at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:157)|
[13:59:44:373]|[07-01-2013]|[SYSOUT]|[INFO]|[93]|: at org.apache.catalina.core.ApplicationDispatcher.invoke(ApplicationDispatcher.java:704)|
[13:59:44:373]|[07-01-2013]|[SYSOUT]|[INFO]|[93]|: at org.apache.catalina.core.ApplicationDispatcher.processRequest(ApplicationDispatcher.java:474)|
[13:59:44:373]|[07-01-2013]|[SYSOUT]|[INFO]|[93]|: at org.apache.catalina.core.ApplicationDispatcher.doForward(ApplicationDispatcher.java:409)|
[13:59:44:373]|[07-01-2013]|[SYSOUT]|[INFO]|[93]|: at org.apache.catalina.core.ApplicationDispatcher.forward(ApplicationDispatcher.java:312)|
[13:59:44:373]|[07-01-2013]|[SYSOUT]|[INFO]|[93]|: at org.apache.catalina.authenticator.NMSFormAuthenticator.authenticate(NMSFormAuthenticator.java:247)|
[13:59:44:373]|[07-01-2013]|[SYSOUT]|[INFO]|[93]|: at org.apache.catalina.authenticator.AuthenticatorBase.invoke(AuthenticatorBase.java:504)|
[13:59:44:373]|[07-01-2013]|[SYSOUT]|[INFO]|[93]|: at org.apache.catalina.core.StandardValveContext.invokeNext(StandardValveContext.java:102)|
[13:59:44:373]|[07-01-2013]|[SYSOUT]|[INFO]|[93]|: at org.apache.catalina.core.StandardPipeline.invoke(StandardPipeline.java:520)|
[13:59:44:373]|[07-01-2013]|[SYSOUT]|[INFO]|[93]|: at org.apache.catalina.core.StandardHostValve.invoke(StandardHostValve.java:137)|
[13:59:44:373]|[07-01-2013]|[SYSOUT]|[INFO]|[93]|: at org.apache.catalina.core.StandardValveContext.invokeNext(StandardValveContext.java:104)|
[13:59:44:373]|[07-01-2013]|[SYSOUT]|[INFO]|[93]|: at org.apache.catalina.valves.ErrorReportValve.invoke(ErrorReportValve.java:118)|
[13:59:44:373]|[07-01-2013]|[SYSOUT]|[INFO]|[93]|: at org.apache.catalina.core.StandardValveContext.invokeNext(StandardValveContext.java:102)|
[13:59:44:373]|[07-01-2013]|[SYSOUT]|[INFO]|[93]|: at com.adventnet.authentication.CredentialAssociation.invoke(CredentialAssociation.java:75)|
[13:59:44:373]|[07-01-2013]|[SYSOUT]|[INFO]|[93]|: at org.apache.catalina.core.StandardValveContext.invokeNext(StandardValveContext.java:102)|
[13:59:44:373]|[07-01-2013]|[SYSOUT]|[INFO]|[93]|: at com.adventnet.client.util.LoginParameters.invoke(LoginParameters.java:53)|
[13:59:44:373]|[07-01-2013]|[SYSOUT]|[INFO]|[93]|: at org.apache.catalina.core.StandardValveContext.invokeNext(StandardValveContext.java:102)|
[13:59:44:373]|[07-01-2013]|[SYSOUT]|[INFO]|[93]|: at com.adventnet.servicedesk.tools.AuthenticateNtlm.invoke(AuthenticateNtlm.java:203)|
[13:59:44:373]|[07-01-2013]|[SYSOUT]|[INFO]|[93]|: at org.apache.catalina.core.StandardValveContext.invokeNext(StandardValveContext.java:102)|
[13:59:44:373]|[07-01-2013]|[SYSOUT]|[INFO]|[93]|: at org.apache.catalina.authenticator.SingleSignOn.invoke(SingleSignOn.java:417)|
[13:59:44:373]|[07-01-2013]|[SYSOUT]|[INFO]|[93]|: at org.apache.catalina.core.StandardValveContext.invokeNext(StandardValveContext.java:102)|
[13:59:44:373]|[07-01-2013]|[SYSOUT]|[INFO]|[93]|: at org.apache.catalina.core.StandardPipeline.invoke(StandardPipeline.java:520)|
[13:59:44:373]|[07-01-2013]|[SYSOUT]|[INFO]|[93]|: at org.apache.catalina.core.StandardEngineValve.invoke(StandardEngineValve.java:109)|
[13:59:44:373]|[07-01-2013]|[SYSOUT]|[INFO]|[93]|: at org.apache.catalina.core.StandardValveContext.invokeNext(StandardValveContext.java:104)|
[13:59:44:373]|[07-01-2013]|[SYSOUT]|[INFO]|[93]|: at org.apache.catalina.core.StandardPipeline.invoke(StandardPipeline.java:520)|
[13:59:44:373]|[07-01-2013]|[SYSOUT]|[INFO]|[93]|: at org.apache.catalina.core.ContainerBase.invoke(ContainerBase.java:929)|
[13:59:44:373]|[07-01-2013]|[SYSOUT]|[INFO]|[93]|: at org.apache.coyote.tomcat5.CoyoteAdapter.service(CoyoteAdapter.java:160)|
[13:59:44:373]|[07-01-2013]|[SYSOUT]|[INFO]|[93]|: at org.apache.coyote.http11.Http11Processor.process(Http11Processor.java:799)|
[13:59:44:373]|[07-01-2013]|[SYSOUT]|[INFO]|[93]|: at org.apache.coyote.http11.Http11Protocol$Http11ConnectionHandler.processConnection(Http11Protocol.java:705)|
[13:59:44:373]|[07-01-2013]|[SYSOUT]|[INFO]|[93]|: at org.apache.tomcat.util.net.TcpWorkerThread.runIt(PoolTcpEndpoint.java:577)|
[13:59:44:373]|[07-01-2013]|[SYSOUT]|[INFO]|[93]|: at org.apache.tomcat.util.threads.ThreadPool$ControlRunnable.run(ThreadPool.java:683)|
[13:59:44:373]|[07-01-2013]|[SYSOUT]|[INFO]|[93]|: at java.lang.Thread.run(Unknown Source)|
[13:59:44:373]|[07-01-2013]|[SYSOUT]|[INFO]|[93]|: Caused by: javax.resource.ResourceException: No ManagedConnections available within configured blocking timeout ( 30000 [ms] )|
[13:59:44:373]|[07-01-2013]|[SYSOUT]|[INFO]|[93]|: at org.jboss.resource.connectionmanager.InternalManagedConnectionPool.getConnection(InternalManagedConnectionPool.java:246)|
[13:59:44:373]|[07-01-2013]|[SYSOUT]|[INFO]|[93]|: at org.jboss.resource.connectionmanager.JBossManagedConnectionPool$BasePool.getConnection(JBossManagedConnectionPool.java:534)|
[13:59:44:373]|[07-01-2013]|[SYSOUT]|[INFO]|[93]|: at org.jboss.resource.connectionmanager.BaseConnectionManager2.getManagedConnection(BaseConnectionManager2.java:444)|
[13:59:44:373]|[07-01-2013]|[SYSOUT]|[INFO]|[93]|: at org.jboss.resource.connectionmanager.TxConnectionManager.getManagedConnection(TxConnectionManager.java:298)|
[13:59:44:373]|[07-01-2013]|[SYSOUT]|[INFO]|[93]|: at org.jboss.resource.connectionmanager.BaseConnectionManager2.allocateConnection(BaseConnectionManager2.java:496)|
[13:59:44:373]|[07-01-2013]|[SYSOUT]|[INFO]|[93]|: at org.jboss.resource.connectionmanager.BaseConnectionManager2$ConnectionManagerProxy.allocateConnection(BaseConnectionManager2.java:887)|
[13:59:44:373]|[07-01-2013]|[SYSOUT]|[INFO]|[93]|: at org.jboss.resource.adapter.jdbc.WrapperDataSource.getConnection(WrapperDataSource.java:102)|
[13:59:44:373]|[07-01-2013]|[SYSOUT]|[INFO]|[93]|: ... 46 more|
[13:59:44:373]|[07-01-2013]|[com.adventnet.servicedesk.setup.util.SSOUtil]|[INFO]|[93]|: User Domain Mapping Status Inside SSOUtil ---- false|
[13:59:44:685]|[07-01-2013]|[SYSOUT]|[INFO]|[78]|: [JBOSS] Engine: ApplicationDispatcher[] Servlet.service() for servlet ViewProcessor threw exceptioncom.adventnet.persistence.DataAccessException: org.jboss.util.NestedSQLException: No ManagedConnections available within configured blocking timeout ( 30000 [ms] ); - nested throwable: (javax.resource.ResourceException: No ManagedConnections available within configured blocking timeout ( 30000 [ms] ))
at com.adventnet.persistence.internal.GetUtil.get(GetUtil.java:102)
at com.adventnet.persistence.DataAccess.get(DataAccess.java:1162)
at com.adventnet.persistence.DataAccess.get(DataAccess.java:1018)
at com.adventnet.persistence.DataAccess.get(DataAccess.java:1011)
at com.adventnet.servicedesk.utils.DataAccessUtil.get(DataAccessUtil.java:128)
at com.adventnet.servicedesk.utils.DBUtilities.getRows(DBUtilities.java:85)
at com.adventnet.servicedesk.utils.DBUtilities.getResultVector(DBUtilities.java:253)
at com.adventnet.servicedesk.query.util.HdSelectQueryUtil.getSelectQuery(HdSelectQueryUtil.java:1142)
at com.adventnet.servicedesk.utils.WorkOrderUtil.getSelectQuery(WorkOrderUtil.java:6402)
at com.adventnet.servicedesk.helpdesk.workorder.action.WorkOrderListViewController.fetchAndCacheSelectQuery(WorkOrderListViewController.java:192)
at com.adventnet.servicedesk.helpdesk.workorder.action.WorkOrderListViewController.updateViewModel(WorkOrderListViewController.java:249)
at com.adventnet.client.view.web.ViewContext.createViewModel(ViewContext.java:372)
at com.adventnet.client.view.web.ViewProcessorServlet.includeView(ViewProcessorServlet.java:154)
at com.adventnet.client.view.web.ViewProcessorServlet.checkCacheAndIncludeView(ViewProcessorServlet.java:142)
at com.adventnet.client.view.web.ViewProcessorServlet.service(ViewProcessorServlet.java:87)
at javax.servlet.http.HttpServlet.service(HttpServlet.java:810)
at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:237)
at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:157)
at com.adventnet.servicedesk.filter.EncodingFilter.doFilter(EncodingFilter.java:162)
at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:186)
at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:157)
at org.apache.catalina.core.ApplicationDispatcher.invoke(ApplicationDispatcher.java:704)
at org.apache.catalina.core.ApplicationDispatcher.processRequest(ApplicationDispatcher.java:474)
at org.apache.catalina.core.ApplicationDispatcher.doForward(ApplicationDispatcher.java:409)
at org.apache.catalina.core.ApplicationDispatcher.forward(ApplicationDispatcher.java:312)
at com.adventnet.client.view.web.StateFilter.doFilter(StateFilter.java:38)
at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:186)
at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:157)
at com.adventnet.servicedesk.authentication.NTLMV2CredentialAssociationFilter.doFilter(NTLMV2CredentialAssociationFilter.java:30)
at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:186)
at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:157)
at SSO.http.HttpSecurityService.doFilter(HttpSecurityService.java:961)
at com.adventnet.servicedesk.authentication.NTLMV2Filter.doFilter(NTLMV2Filter.java:190)
at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:186)
at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:157)
at org.jboss.web.tomcat.filters.ReplyHeaderFilter.doFilter(ReplyHeaderFilter.java:75)
at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:186)
at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:157)
at org.apache.catalina.core.StandardWrapperValve.invoke(StandardWrapperValve.java:214)
at org.apache.catalina.core.StandardValveContext.invokeNext(StandardValveContext.java:104)
at org.apache.catalina.core.StandardPipeline.invoke(StandardPipeline.java:520)
at org.apache.catalina.core.StandardContextValve.invokeInternal(StandardContextValve.java:198)
at org.apache.catalina.core.StandardContextValve.invoke(StandardContextValve.java:152)
at org.apache.catalina.core.StandardValveContext.invokeNext(StandardValveContext.java:104)
at org.jboss.web.tomcat.security.CustomPrincipalValve.invoke(CustomPrincipalValve.java:66)
at org.apache.catalina.core.StandardValveContext.invokeNext(StandardValveContext.java:102)
at org.jboss.web.tomcat.security.SecurityAssociationValve.invoke(SecurityAssociationValve.java:158)
at org.apache.catalina.core.StandardValveContext.invokeNext(StandardValveContext.java:102)
at org.apache.catalina.authenticator.AuthenticatorBase.invoke(AuthenticatorBase.java:540)
at org.apache.catalina.core.StandardValveContext.invokeNext(StandardValveContext.java:102)
at org.apache.catalina.core.StandardPipeline.invoke(StandardPipeline.java:520)
at org.apache.catalina.core.StandardHostValve.invoke(StandardHostValve.java:137)
at org.apache.catalina.core.StandardValveContext.invokeNext(StandardValveContext.java:104)
at org.apache.catalina.valves.ErrorReportValve.invoke(ErrorReportValve.java:118)
at org.apache.catalina.core.StandardValveContext.invokeNext(StandardValveContext.java:102)
at com.adventnet.authentication.CredentialAssociation.invoke(CredentialAssociation.java:75)
at org.apache.catalina.core.StandardValveContext.invokeNext(StandardValveContext.java:102)
at com.adventnet.client.util.LoginParameters.invoke(LoginParameters.java:53)
at org.apache.catalina.core.StandardValveContext.invokeNext(StandardValveContext.java:102)
at com.adventnet.servicedesk.tools.AuthenticateNtlm.invoke(AuthenticateNtlm.java:203)
at org.apache.catalina.core.StandardValveContext.invokeNext(StandardValveContext.java:102)
at org.apache.catalina.authenticator.SingleSignOn.invoke(SingleSignOn.java:444)
at org.apache.catalina.core.StandardValveContext.invokeNext(StandardValveContext.java:102)
at org.apache.catalina.core.StandardPipeline.invoke(StandardPipeline.java:520)
at org.apache.catalina.core.StandardEngineValve.invoke(StandardEngineValve.java:109)
at org.apache.catalina.core.StandardValveContext.invokeNext(StandardValveContext.java:104)
at org.apache.catalina.core.StandardPipeline.invoke(StandardPipeline.java:520)
at org.apache.catalina.core.ContainerBase.invoke(ContainerBase.java:929)
at org.apache.coyote.tomcat5.CoyoteAdapter.service(CoyoteAdapter.java:160)
at org.apache.coyote.http11.Http11Processor.process(Http11Processor.java:799)
at org.apache.coyote.http11.Http11Protocol$Http11ConnectionHandler.processConnection(Http11Protocol.java:705)
at org.apache.tomcat.util.net.TcpWorkerThread.runIt(PoolTcpEndpoint.java:577)
at org.apache.tomcat.util.threads.ThreadPool$ControlRunnable.run(ThreadPool.java:683)
at java.lang.Thread.run(Unknown Source)
Caused by: org.jboss.util.NestedSQLException: No ManagedConnections available within configured blocking timeout ( 30000 [ms] ); - nested throwable: (javax.resource.ResourceException: No ManagedConnections available within configured blocking timeout ( 30000 [ms] ))
Could you tell us if there are any solution for this problem?
Thanks in advance
New to ADSelfService Plus?