Problem with approvals after upgrade to 7.0
I upgraded our production system to 7.0 last night without incident, but now today, somebody tried to respond to an approval notice, and got the error shown below. I clear the browser cache and tried several times on both IE6 and IE7, but the error still appears.
What's interesting is that the approval does go through, and in fact did so 10 times, once for every attempt. It appears that what's not working is the response to the user that tells them their approval has been submitted. The key phrase in the error output seems to be "Deadlock found when trying to get lock; try restarting transaction".
I am listing the browser error output below, and attaching the support file as well.
What's interesting is that the approval does go through, and in fact did so 10 times, once for every attempt. It appears that what's not working is the response to the user that tells them their approval has been submitted. The key phrase in the error output seems to be "Deadlock found when trying to get lock; try restarting transaction".
I am listing the browser error output below, and attaching the support file as well.
HTTP Status 500 -
________________________________________
type Exception report
message
description The server encountered an internal error () that prevented it from fulfilling this request.
exception
javax.servlet.ServletException: [ApprovalDetails] null, message from server: "Deadlock found when trying to get lock; try restarting transaction"
org.apache.jasper.runtime.PageContextImpl.doHandlePageException(PageContextImpl.java:825)
org.apache.jasper.runtime.PageContextImpl.handlePageException(PageContextImpl.java:758)
org.apache.jsp.approval.ApproveRequest_jsp._jspService(ApproveRequest_jsp.java:235)
org.apache.jasper.runtime.HttpJspBase.service(HttpJspBase.java:94)
javax.servlet.http.HttpServlet.service(HttpServlet.java:810)
com.adventnet.servicedesk.filter.EncodingFilter.doFilter(EncodingFilter.java:92)
com.adventnet.authentication.ContextChangeDetector.doFilter(ContextChangeDetector.java:113)
org.jboss.web.tomcat.filters.ReplyHeaderFilter.doFilter(ReplyHeaderFilter.java:75)
root cause
com.adventnet.persistence.DataAccessException: [ApprovalDetails] null, message from server: "Deadlock found when trying to get lock; try restarting transaction"
com.adventnet.persistence.DataAccess.createDataAccessException(DataAccess.java:2574)
com.adventnet.persistence.DataAccess.processUpdateRows(DataAccess.java:444)
com.adventnet.persistence.DataAccess.update(DataAccess.java:680)
com.adventnet.persistence.DataAccess.update(DataAccess.java:648)
com.adventnet.persistence.ejb.interceptor.CorePersistenceInterceptor.process(CorePersistenceInterceptor.java:74)
com.adventnet.authorization.AuthorizationInterceptor.process(AuthorizationInterceptor.java:232)
com.adventnet.persistence.ejb.interceptor.NotificationPersistenceInterceptor.process(NotificationPersistenceInterceptor.java:148)
com.adventnet.cis.ejb.CISPersistenceInterceptor.process(CISPersistenceInterceptor.java:59)
com.adventnet.persistence.ejb.PersistenceBean.update(PersistenceBean.java:418)
sun.reflect.GeneratedMethodAccessor92.invoke(Unknown Source)
sun.reflect.DelegatingMethodAccessorImpl.invoke(Unknown Source)
java.lang.reflect.Method.invoke(Unknown Source)
org.jboss.ejb.StatelessSessionContainer$ContainerInterceptor.invoke(StatelessSessionContainer.java:683)
com.adventnet.authorization.AuthorizationInterceptor.invoke(AuthorizationInterceptor.java:88)
com.adventnet.authentication.interceptor.SecurityInterceptor.invoke(SecurityInterceptor.java:108)
org.jboss.resource.connectionmanager.CachedConnectionInterceptor.invoke(CachedConnectionInterceptor.java:186)
org.jboss.ejb.plugins.StatelessSessionInstanceInterceptor.invoke(StatelessSessionInstanceInterceptor.java:72)
org.jboss.ejb.plugins.AbstractTxInterceptor.invokeNext(AbstractTxInterceptor.java:84)
org.jboss.ejb.plugins.TxInterceptorCMT.runWithTransactions(TxInterceptorCMT.java:315)
org.jboss.ejb.plugins.TxInterceptorCMT.invoke(TxInterceptorCMT.java:148)
org.jboss.ejb.plugins.LogInterceptor.invoke(LogInterceptor.java:191)
org.jboss.ejb.plugins.ProxyFactoryFinderInterceptor.invoke(ProxyFactoryFinderInterceptor.java:122)
org.jboss.ejb.StatelessSessionContainer.internalInvoke(StatelessSessionContainer.java:331)
org.jboss.ejb.Container.invoke(Container.java:709)
sun.reflect.GeneratedMethodAccessor46.invoke(Unknown Source)
sun.reflect.DelegatingMethodAccessorImpl.invoke(Unknown Source)
java.lang.reflect.Method.invoke(Unknown Source)
org.jboss.mx.server.ReflectedDispatcher.dispatch(ReflectedDispatcher.java:60)
org.jboss.mx.server.Invocation.dispatch(Invocation.java:62)
org.jboss.mx.server.Invocation.dispatch(Invocation.java:54)
org.jboss.mx.server.Invocation.invoke(Invocation.java:82)
org.jboss.mx.server.AbstractMBeanInvoker.invoke(AbstractMBeanInvoker.java:197)
org.jboss.mx.server.MBeanServerImpl.invoke(MBeanServerImpl.java:473)
org.jboss.invocation.local.LocalInvoker.invoke(LocalInvoker.java:97)
org.jboss.invocation.InvokerInterceptor.invoke(InvokerInterceptor.java:90)
org.jboss.proxy.TransactionInterceptor.invoke(TransactionInterceptor.java:46)
com.adventnet.authentication.interceptor.ClientPrincipalAssociator.invoke(ClientPrincipalAssociator.java:47)
org.jboss.proxy.ejb.StatelessSessionInterceptor.invoke(StatelessSessionInterceptor.java:100)
com.adventnet.persistence.ejb.interceptor.ConstructDOProxyInterceptor.invoke(ConstructDOProxyInterceptor.java:37)
org.jboss.proxy.ClientContainer.invoke(ClientContainer.java:85)
$Proxy65.update(Unknown Source)
com.adventnet.servicedesk.helpdesk.util.ApprovalUtil.updateApprovalDetails(ApprovalUtil.java:222)
org.apache.jsp.approval.ApproveRequest_jsp._jspService(ApproveRequest_jsp.java:196)
org.apache.jasper.runtime.HttpJspBase.service(HttpJspBase.java:94)
javax.servlet.http.HttpServlet.service(HttpServlet.java:810)
com.adventnet.servicedesk.filter.EncodingFilter.doFilter(EncodingFilter.java:92)
com.adventnet.authentication.ContextChangeDetector.doFilter(ContextChangeDetector.java:113)
org.jboss.web.tomcat.filters.ReplyHeaderFilter.doFilter(ReplyHeaderFilter.java:75)
note The full stack trace of the root cause is available in the Apache Tomcat/5.0.28 logs.
________________________________________
Apache Tomcat/5.0.28