Re: Transaction error on bank reconciliation

Posted by David E. Jones-2 on
URL: http://ofbiz.116.s1.nabble.com/Transaction-error-on-bank-reconciliation-tp164741p164743.html


This looks like a good old case of taking too long to run. Your main  
options are:

1. change the code or related things to run faster (optimize the code,  
optimize queries, add indexes, etc)

2. increase the timeout on whatever service begins the transaction,  
and any other long-running services it calls

-David


On Aug 26, 2009, at 9:32 AM, Vince Clark wrote:

> I updated code yesterday to r807673. Now when I try to complete a  
> reconciliation by pressing the "Reconcile" button I get the  
> following error.
>
> The Following Errors Occurred:
>
> Error calling event: org.ofbiz.webapp.event.EventHandlerException:  
> Commit multi-service global transaction failed
>
> Stack from error.log
> ---------------
> 2009-08-26 11:27:46,556 (http-0.0.0.0-8443-1)  
> [ServiceMultiEventHandler.java:387:ERROR]
> ---- exception report  
> ----------------------------------------------------------
> Could not commit multi-service global transaction
> Exception: org.ofbiz.entity.transaction.GenericTransactionException
> Message: Roll back error (with no rollbackOnly cause found), could  
> not commit transaction, was rolled back instead:  
> javax.transaction.RollbackException: Transaction timeout  
> (Transaction timeout)
> ---- cause  
> ---------------------------------------------------------------------
> Exception: javax.transaction.RollbackException
> Message: Transaction timeout
> ---- stack trace  
> ---------------------------------------------------------------
> javax.transaction.RollbackException: Transaction timeout
> org
> .apache
> .geronimo
> .transaction.manager.TransactionImpl.commit(TransactionImpl.java:269)
> org
> .apache
> .geronimo
> .transaction
> .manager.TransactionManagerImpl.commit(TransactionManagerImpl.java:
> 245)
> org
> .ofbiz
> .entity.transaction.TransactionUtil.commit(TransactionUtil.java:209)
> org
> .ofbiz
> .entity.transaction.TransactionUtil.commit(TransactionUtil.java:195)
> org
> .ofbiz
> .webapp
> .event.ServiceMultiEventHandler.invoke(ServiceMultiEventHandler.java:
> 385)
> org.ofbiz.webapp.control.RequestHandler.runEvent(RequestHandler.java:
> 611)
> org
> .ofbiz.webapp.control.RequestHandler.doRequest(RequestHandler.java:
> 375)
> org.ofbiz.webapp.control.ControlServlet.doGet(ControlServlet.java:215)
> org.ofbiz.webapp.control.ControlServlet.doPost(ControlServlet.java:81)
> javax.servlet.http.HttpServlet.service(HttpServlet.java:710)
> javax.servlet.http.HttpServlet.service(HttpServlet.java:803)
> org
> .apache
> .catalina
> .core
> .ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:
> 290)
> org
> .apache
> .catalina
> .core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:206)
> org.ofbiz.webapp.control.ContextFilter.doFilter(ContextFilter.java:
> 265)
> org
> .apache
> .catalina
> .core
> .ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:
> 235)
> org
> .apache
> .catalina
> .core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:206)
> org
> .apache
> .catalina.core.StandardWrapperValve.invoke(StandardWrapperValve.java:
> 233)
> org
> .apache
> .catalina.core.StandardContextValve.invoke(StandardContextValve.java:
> 175)
> org
> .apache
> .catalina.core.StandardHostValve.invoke(StandardHostValve.java:128)
> org
> .apache
> .catalina.valves.ErrorReportValve.invoke(ErrorReportValve.java:102)
> org
> .apache
> .catalina.core.StandardEngineValve.invoke(StandardEngineValve.java:
> 109)
> org.apache.catalina.valves.AccessLogValve.invoke(AccessLogValve.java:
> 568)
> org
> .apache.catalina.connector.CoyoteAdapter.service(CoyoteAdapter.java:
> 286)
> org
> .apache.coyote.http11.Http11Processor.process(Http11Processor.java:
> 844)
> org.apache.coyote.http11.Http11Protocol
> $Http11ConnectionHandler.process(Http11Protocol.java:583)
> org.apache.tomcat.util.net.JIoEndpoint$Worker.run(JIoEndpoint.java:
> 447)
> java.lang.Thread.run(Thread.java:619)
> --------------------------------------------------------------------------------
>
> 2009-08-26 11:27:46,588 (http-0.0.0.0-8443-1) [ RequestHandler.java:
> 412:ERROR] Request callReconcileFinAccountTrans caused an error with  
> the following message: Error calling event:  
> org.ofbiz.webapp.event.EventHandlerException: Commit multi-service  
> global transaction failed
>
>
>
> Vince Clark
> www.globalera.com
> [hidden email]
> [phone] office
> [phone] cell
>