Crashes
ServiceDesk has crashed numerous times lately, mostly random. Here is a piece of the log file.
[09:42:33:695]|[10-24-2006]|[com.adventnet.servicedesk.helpdesk.sla.util.SLAEscalation]|[SEVERE]|[23]|: Exception while trying to get the unpicked requests.|com.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:1153)
at com.adventnet.persistence.DataAccess.get(DataAccess.java:1143)
at com.adventnet.persistence.ejb.interceptor.CorePersistenceInterceptor.process(CorePersistenceInterceptor.java:110)
at com.adventnet.authorization.AuthorizationInterceptor.process(AuthorizationInterceptor.java:232)
at com.adventnet.persistence.ejb.interceptor.NotificationPersistenceInterceptor.process(NotificationPersistenceInterceptor.java:148)
at com.adventnet.cis.ejb.CISPersistenceInterceptor.process(CISPersistenceInterceptor.java:59)
at com.adventnet.persistence.ejb.PersistenceBean.get(PersistenceBean.java:225)
at sun.reflect.GeneratedMethodAccessor91.invoke(Unknown Source)
at sun.reflect.DelegatingMethodAccessorImpl.invoke(Unknown Source)
at java.lang.reflect.Method.invoke(Unknown Source)
at org.jboss.ejb.StatelessSessionContainer$ContainerInterceptor.invoke(StatelessSessionContainer.java:683)
at com.adventnet.authorization.AuthorizationInterceptor.invoke(AuthorizationInterceptor.java:88)
at com.adventnet.authentication.interceptor.SecurityInterceptor.invoke(SecurityInterceptor.java:108)
at org.jboss.resource.connectionmanager.CachedConnectionInterceptor.invoke(CachedConnectionInterceptor.java:186)
at org.jboss.ejb.plugins.StatelessSessionInstanceInterceptor.invoke(StatelessSessionInstanceInterceptor.java:72)
at org.jboss.ejb.plugins.AbstractTxInterceptor.invokeNext(AbstractTxInterceptor.java:84)
at org.jboss.ejb.plugins.TxInterceptorCMT.runWithTransactions(TxInterceptorCMT.java:315)
at org.jboss.ejb.plugins.TxInterceptorCMT.invoke(TxInterceptorCMT.java:148)
at org.jboss.ejb.plugins.LogInterceptor.invoke(LogInterceptor.java:191)
at org.jboss.ejb.plugins.ProxyFactoryFinderInterceptor.invoke(ProxyFactoryFinderInterceptor.java:122)
at org.jboss.ejb.StatelessSessionContainer.internalInvoke(StatelessSessionContainer.java:331)
at org.jboss.ejb.Container.invoke(Container.java:709)
at sun.reflect.GeneratedMethodAccessor45.invoke(Unknown Source)
at sun.reflect.DelegatingMethodAccessorImpl.invoke(Unknown Source)
at java.lang.reflect.Method.invoke(Unknown Source)
at org.jboss.mx.server.ReflectedDispatcher.dispatch(ReflectedDispatcher.java:60)
at org.jboss.mx.server.Invocation.dispatch(Invocation.java:62)
at org.jboss.mx.server.Invocation.dispatch(Invocation.java:54)
at org.jboss.mx.server.Invocation.invoke(Invocation.java:82)
at org.jboss.mx.server.AbstractMBeanInvoker.invoke(AbstractMBeanInvoker.java:197)
at org.jboss.mx.server.MBeanServerImpl.invoke(MBeanServerImpl.java:473)
at org.jboss.invocation.local.LocalInvoker.invoke(LocalInvoker.java:97)
at org.jboss.invocation.InvokerInterceptor.invoke(InvokerInterceptor.java:90)
at org.jboss.proxy.TransactionInterceptor.invoke(TransactionInterceptor.java:46)
at com.adventnet.authentication.interceptor.ClientPrincipalAssociator.invoke(ClientPrincipalAssociator.java:47)
at org.jboss.proxy.ejb.StatelessSessionInterceptor.invoke(StatelessSessionInterceptor.java:100)
at com.adventnet.persistence.ejb.interceptor.ConstructDOProxyInterceptor.invoke(ConstructDOProxyInterceptor.java:37)
at org.jboss.proxy.ClientContainer.invoke(ClientContainer.java:85)
at $Proxy65.get(Unknown Source)
at com.adventnet.servicedesk.utils.DBUtilities.getRows(DBUtilities.java:77)
at com.adventnet.servicedesk.utils.DBUtilities.getResultVector(DBUtilities.java:245)
at com.adventnet.servicedesk.helpdesk.sla.util.SLAEscalation.getUnpickedCriteria(SLAEscalation.java:486)
at com.adventnet.servicedesk.helpdesk.sla.util.SLAEscalation.getUnpickedWO(SLAEscalation.java:470)
at com.adventnet.servicedesk.helpdesk.sla.util.SLAEscalation.checkForUnpickedQueueRequest(SLAEscalation.java:393)
at com.adventnet.servicedesk.helpdesk.sla.task.SLAEscalationTask.executeTask(SLAEscalationTask.java:35)
at com.adventnet.workengine.task.internal.TaskManagerImpl.executeTask(TaskManagerImpl.java:706)
at com.adventnet.workengine.executor.internal.WorkFlowExecutor.executeStartingTask(WorkFlowExecutor.java:160)
at com.adventnet.workengine.executor.internal.WorkFlowExecutor.executeWorkFlowTemplate(WorkFlowExecutor.java:115)
at com.adventnet.workengine.executor.internal.WorkFlowExecutor.executeWorkFlow(WorkFlowExecutor.java:105)
at com.adventnet.workengine.workflow.ejb.internal.WorkFlowExecutorBean.executeWorkFlow(WorkFlowExecutorBean.java:105)
at sun.reflect.GeneratedMethodAccessor107.invoke(Unknown Source)
at sun.reflect.DelegatingMethodAccessorImpl.invoke(Unknown Source)
at java.lang.reflect.Method.invoke(Unknown Source)
at org.jboss.ejb.StatelessSessionContainer$ContainerInterceptor.invoke(StatelessSessionContainer.java:683)
at org.jboss.resource.connectionmanager.CachedConnectionInterceptor.invoke(CachedConnectionInterceptor.java:186)
at org.jboss.ejb.plugins.AbstractInterceptor.invoke(AbstractInterceptor.java:94)
at org.jboss.ejb.plugins.StatelessSessionInstanceInterceptor.invoke(StatelessSessionInstanceInterceptor.java:72)
at org.jboss.ejb.plugins.AbstractTxInterceptor.invokeNext(AbstractTxInterceptor.java:84)
at org.jboss.ejb.plugins.TxInterceptorCMT.runWithTransactions(TxInterceptorCMT.java:315)
at org.jboss.ejb.plugins.TxInterceptorCMT.invoke(TxInterceptorCMT.java:148)
at com.adventnet.authorization.AuthorizationInterceptor.invoke(AuthorizationInterceptor.java:88)
at com.adventnet.authentication.interceptor.SecurityInterceptor.invoke(SecurityInterceptor.java:108)
at com.adventnet.audit.interceptor.AuditInterceptor.invoke(AuditInterceptor.java:128)
at org.jboss.ejb.plugins.LogInterceptor.invoke(LogInterceptor.java:191)
at com.adventnet.logging.tracing.TracingInterceptor.invoke(TracingInterceptor.java:136)
at org.jboss.ejb.plugins.ProxyFactoryFinderInterceptor.invoke(ProxyFactoryFinderInterceptor.java:122)
at org.jboss.ejb.StatelessSessionContainer.internalInvoke(StatelessSessionContainer.java:331)
at org.jboss.ejb.Container.invoke(Container.java:709)
at org.jboss.ejb.plugins.local.BaseLocalProxyFactory.invoke(BaseLocalProxyFactory.java:419)
at org.jboss.ejb.plugins.local.StatelessSessionProxy.invoke(StatelessSessionProxy.java:83)
at $Proxy98.executeWorkFlow(Unknown Source)
at com.adventnet.workengine.executor.internal.RemoteWorkFlowExecutionHandler.execute(RemoteWorkFlowExecutionHandler.java:77)
at com.adventnet.workengine.internal.WorkEngineImpl$WorkFlowExecutorThread.run(WorkEngineImpl.java:923)
at com.adventnet.workengine.service.ThreadPoolService$WorkerThread.run(ThreadPoolService.java:256)
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] ))
at org.jboss.resource.adapter.jdbc.WrapperDataSource.getConnection(WrapperDataSource.java:106)
at com.adventnet.db.api.RelationalAPI.getConnection(RelationalAPI.java:183)
at com.adventnet.persistence.internal.GetUtil.get(GetUtil.java:88)
... 75 more
Caused by: javax.resource.ResourceException: No ManagedConnections available within configured blocking timeout ( 30000 [ms] )
at org.jboss.resource.connectionmanager.InternalManagedConnectionPool.getConnection(InternalManagedConnectionPool.java:246)
at org.jboss.resource.connectionmanager.JBossManagedConnectionPool$BasePool.getConnection(JBossManagedConnectionPool.java:534)
at org.jboss.resource.connectionmanager.BaseConnectionManager2.getManagedConnection(BaseConnectionManager2.java:444)
at org.jboss.resource.connectionmanager.TxConnectionManager.getManagedConnection(TxConnectionManager.java:298)
at org.jboss.resource.connectionmanager.BaseConnectionManager2.allocateConnection(BaseConnectionManager2.java:496)
at org.jboss.resource.connectionmanager.BaseConnectionManager2$ConnectionManagerProxy.allocateConnection(BaseConnectionManager2.java:887)
at org.jboss.resource.adapter.jdbc.WrapperDataSource.getConnection(WrapperDataSource.java:102)
... 77 more
[09:42:33:695]|[10-24-2006]|[com.adventnet.servicedesk.helpdesk.sla.util.SLAEscalation]|[SEVERE]|[23]|: Exception while trying to get the unpicked requests.|com.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:1153)
at com.adventnet.persistence.DataAccess.get(DataAccess.java:1143)
at com.adventnet.persistence.ejb.interceptor.CorePersistenceInterceptor.process(CorePersistenceInterceptor.java:110)
at com.adventnet.authorization.AuthorizationInterceptor.process(AuthorizationInterceptor.java:232)
at com.adventnet.persistence.ejb.interceptor.NotificationPersistenceInterceptor.process(NotificationPersistenceInterceptor.java:148)
at com.adventnet.cis.ejb.CISPersistenceInterceptor.process(CISPersistenceInterceptor.java:59)
at com.adventnet.persistence.ejb.PersistenceBean.get(PersistenceBean.java:225)
at sun.reflect.GeneratedMethodAccessor91.invoke(Unknown Source)
at sun.reflect.DelegatingMethodAccessorImpl.invoke(Unknown Source)
at java.lang.reflect.Method.invoke(Unknown Source)
at org.jboss.ejb.StatelessSessionContainer$ContainerInterceptor.invoke(StatelessSessionContainer.java:683)
at com.adventnet.authorization.AuthorizationInterceptor.invoke(AuthorizationInterceptor.java:88)
at com.adventnet.authentication.interceptor.SecurityInterceptor.invoke(SecurityInterceptor.java:108)
at org.jboss.resource.connectionmanager.CachedConnectionInterceptor.invoke(CachedConnectionInterceptor.java:186)
at org.jboss.ejb.plugins.StatelessSessionInstanceInterceptor.invoke(StatelessSessionInstanceInterceptor.java:72)
at org.jboss.ejb.plugins.AbstractTxInterceptor.invokeNext(AbstractTxInterceptor.java:84)
at org.jboss.ejb.plugins.TxInterceptorCMT.runWithTransactions(TxInterceptorCMT.java:315)
at org.jboss.ejb.plugins.TxInterceptorCMT.invoke(TxInterceptorCMT.java:148)
at org.jboss.ejb.plugins.LogInterceptor.invoke(LogInterceptor.java:191)
at org.jboss.ejb.plugins.ProxyFactoryFinderInterceptor.invoke(ProxyFactoryFinderInterceptor.java:122)
at org.jboss.ejb.StatelessSessionContainer.internalInvoke(StatelessSessionContainer.java:331)
at org.jboss.ejb.Container.invoke(Container.java:709)
at sun.reflect.GeneratedMethodAccessor45.invoke(Unknown Source)
at sun.reflect.DelegatingMethodAccessorImpl.invoke(Unknown Source)
at java.lang.reflect.Method.invoke(Unknown Source)
at org.jboss.mx.server.ReflectedDispatcher.dispatch(ReflectedDispatcher.java:60)
at org.jboss.mx.server.Invocation.dispatch(Invocation.java:62)
at org.jboss.mx.server.Invocation.dispatch(Invocation.java:54)
at org.jboss.mx.server.Invocation.invoke(Invocation.java:82)
at org.jboss.mx.server.AbstractMBeanInvoker.invoke(AbstractMBeanInvoker.java:197)
at org.jboss.mx.server.MBeanServerImpl.invoke(MBeanServerImpl.java:473)
at org.jboss.invocation.local.LocalInvoker.invoke(LocalInvoker.java:97)
at org.jboss.invocation.InvokerInterceptor.invoke(InvokerInterceptor.java:90)
at org.jboss.proxy.TransactionInterceptor.invoke(TransactionInterceptor.java:46)
at com.adventnet.authentication.interceptor.ClientPrincipalAssociator.invoke(ClientPrincipalAssociator.java:47)
at org.jboss.proxy.ejb.StatelessSessionInterceptor.invoke(StatelessSessionInterceptor.java:100)
at com.adventnet.persistence.ejb.interceptor.ConstructDOProxyInterceptor.invoke(ConstructDOProxyInterceptor.java:37)
at org.jboss.proxy.ClientContainer.invoke(ClientContainer.java:85)
at $Proxy65.get(Unknown Source)
at com.adventnet.servicedesk.utils.DBUtilities.getRows(DBUtilities.java:77)
at com.adventnet.servicedesk.utils.DBUtilities.getResultVector(DBUtilities.java:245)
at com.adventnet.servicedesk.helpdesk.sla.util.SLAEscalation.getUnpickedCriteria(SLAEscalation.java:486)
at com.adventnet.servicedesk.helpdesk.sla.util.SLAEscalation.getUnpickedWO(SLAEscalation.java:470)
at com.adventnet.servicedesk.helpdesk.sla.util.SLAEscalation.checkForUnpickedQueueRequest(SLAEscalation.java:393)
at com.adventnet.servicedesk.helpdesk.sla.task.SLAEscalationTask.executeTask(SLAEscalationTask.java:35)
at com.adventnet.workengine.task.internal.TaskManagerImpl.executeTask(TaskManagerImpl.java:706)
at com.adventnet.workengine.executor.internal.WorkFlowExecutor.executeStartingTask(WorkFlowExecutor.java:160)
at com.adventnet.workengine.executor.internal.WorkFlowExecutor.executeWorkFlowTemplate(WorkFlowExecutor.java:115)
at com.adventnet.workengine.executor.internal.WorkFlowExecutor.executeWorkFlow(WorkFlowExecutor.java:105)
at com.adventnet.workengine.workflow.ejb.internal.WorkFlowExecutorBean.executeWorkFlow(WorkFlowExecutorBean.java:105)
at sun.reflect.GeneratedMethodAccessor107.invoke(Unknown Source)
at sun.reflect.DelegatingMethodAccessorImpl.invoke(Unknown Source)
at java.lang.reflect.Method.invoke(Unknown Source)
at org.jboss.ejb.StatelessSessionContainer$ContainerInterceptor.invoke(StatelessSessionContainer.java:683)
at org.jboss.resource.connectionmanager.CachedConnectionInterceptor.invoke(CachedConnectionInterceptor.java:186)
at org.jboss.ejb.plugins.AbstractInterceptor.invoke(AbstractInterceptor.java:94)
at org.jboss.ejb.plugins.StatelessSessionInstanceInterceptor.invoke(StatelessSessionInstanceInterceptor.java:72)
at org.jboss.ejb.plugins.AbstractTxInterceptor.invokeNext(AbstractTxInterceptor.java:84)
at org.jboss.ejb.plugins.TxInterceptorCMT.runWithTransactions(TxInterceptorCMT.java:315)
at org.jboss.ejb.plugins.TxInterceptorCMT.invoke(TxInterceptorCMT.java:148)
at com.adventnet.authorization.AuthorizationInterceptor.invoke(AuthorizationInterceptor.java:88)
at com.adventnet.authentication.interceptor.SecurityInterceptor.invoke(SecurityInterceptor.java:108)
at com.adventnet.audit.interceptor.AuditInterceptor.invoke(AuditInterceptor.java:128)
at org.jboss.ejb.plugins.LogInterceptor.invoke(LogInterceptor.java:191)
at com.adventnet.logging.tracing.TracingInterceptor.invoke(TracingInterceptor.java:136)
at org.jboss.ejb.plugins.ProxyFactoryFinderInterceptor.invoke(ProxyFactoryFinderInterceptor.java:122)
at org.jboss.ejb.StatelessSessionContainer.internalInvoke(StatelessSessionContainer.java:331)
at org.jboss.ejb.Container.invoke(Container.java:709)
at org.jboss.ejb.plugins.local.BaseLocalProxyFactory.invoke(BaseLocalProxyFactory.java:419)
at org.jboss.ejb.plugins.local.StatelessSessionProxy.invoke(StatelessSessionProxy.java:83)
at $Proxy98.executeWorkFlow(Unknown Source)
at com.adventnet.workengine.executor.internal.RemoteWorkFlowExecutionHandler.execute(RemoteWorkFlowExecutionHandler.java:77)
at com.adventnet.workengine.internal.WorkEngineImpl$WorkFlowExecutorThread.run(WorkEngineImpl.java:923)
at com.adventnet.workengine.service.ThreadPoolService$WorkerThread.run(ThreadPoolService.java:256)
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] ))
at org.jboss.resource.adapter.jdbc.WrapperDataSource.getConnection(WrapperDataSource.java:106)
at com.adventnet.db.api.RelationalAPI.getConnection(RelationalAPI.java:183)
at com.adventnet.persistence.internal.GetUtil.get(GetUtil.java:88)
... 75 more
Caused by: javax.resource.ResourceException: No ManagedConnections available within configured blocking timeout ( 30000 [ms] )
at org.jboss.resource.connectionmanager.InternalManagedConnectionPool.getConnection(InternalManagedConnectionPool.java:246)
at org.jboss.resource.connectionmanager.JBossManagedConnectionPool$BasePool.getConnection(JBossManagedConnectionPool.java:534)
at org.jboss.resource.connectionmanager.BaseConnectionManager2.getManagedConnection(BaseConnectionManager2.java:444)
at org.jboss.resource.connectionmanager.TxConnectionManager.getManagedConnection(TxConnectionManager.java:298)
at org.jboss.resource.connectionmanager.BaseConnectionManager2.allocateConnection(BaseConnectionManager2.java:496)
at org.jboss.resource.connectionmanager.BaseConnectionManager2$ConnectionManagerProxy.allocateConnection(BaseConnectionManager2.java:887)
at org.jboss.resource.adapter.jdbc.WrapperDataSource.getConnection(WrapperDataSource.java:102)
... 77 more