Transaction error on bank reconciliation
Locked
Transaction error on bank reconciliation
 
|
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] (303) 493-6723 office (303) 523-4843 cell |
Re: Transaction error on bank reconciliation
|
|
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] > (303) 493-6723 office > (303) 523-4843 cell > |
Re: Transaction error on bank reconciliation
|
|
Thanks Vince for posting this and David for your suggestion, I'll look
at it soon and try to find the scope where I can optimize the code and try my best to fix it. -- Thanks And Regards Sumit Pandit On 26-Aug-09, at 9:14 PM, David E Jones wrote: > > 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] >> (303) 493-6723 office >> (303) 523-4843 cell >> > |
Re: Transaction error on bank reconciliation
|
|
In reply to this post by Vince Clark
Thanks Sumit. One more piece of info that might be helpful.
The reconciliation that I tried to complete had two batch deposits on it. Each of these deposits had a large number of payments associated with them, totalling over 300 transactions. Previous reconciliations we have done did not have nearly that many. Furthermore, this volume was only one day. Over the course of a month we could easily have over 10,000 transactions accumulate. So by the time a user completes the rec it needs to handle quite a few postings. Vince Clark www.globalera.com [hidden email] (303) 493-6723 office (303) 523-4843 cell ----- Original Message ----- From: "Sumit Pandit" <[hidden email]> To: [hidden email] Cc: "Sumit Pandit" <[hidden email]> Sent: Wednesday, August 26, 2009 10:29:11 PM GMT -07:00 US/Canada Mountain Subject: Re: Transaction error on bank reconciliation Thanks Vince for posting this and David for your suggestion, I'll look at it soon and try to find the scope where I can optimize the code and try my best to fix it. -- Thanks And Regards Sumit Pandit On 26-Aug-09, at 9:14 PM, David E Jones wrote: > > 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] >> (303) 493-6723 office >> (303) 523-4843 cell >> > |
«
Return to OFBiz - User
|
1 view|%1 views
| Free forum by Nabble | Edit this page |