Re: Transaction error on bank reconciliation

Posted by Sumit Pandit-3 on
URL: http://ofbiz.116.s1.nabble.com/Transaction-error-on-bank-reconciliation-tp164741p164744.html

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]
>> [phone] office
>> [phone] cell
>>
>