Carl,
If you want less problems in production try rather PostGres. For development, demo, etc. I use HSQL : faster (a lot more : using
memory)
Jacques
----- Original Message -----
From: "carlj" <mail@carl-johansson.com>
To: <ofbiz-user@incubator.apache.org>
Sent: Tuesday, July 25, 2006 11:06 PM
Subject: Re: [OFBiz] Users - order and invoice
>
> I just tested the same steps on the demo site and it went like a charm.
> Perhaps the issue will be walked around while changing to MySQL or
> PostgreSQL?
>
>
> Si Chen-2 wrote:
> >
> > You need to go further back to the first error message you found,
> > right below the last "good" part of your log file. This says that
> > debits and credits don't equal, but for an automated transaction that
> > should never happen.
> >
> > Also, can you replicate the problem on our demo server? http://
> > demo.opensourcestrategies.com:8085/
> >
> > Si
> >
> >
> > On Jul 25, 2006, at 1:39 AM, carlj wrote:
> >
> >>
> >> The error message of course, how embarrassing.
> >>
> >> ---- exception report
> >> ----------------------------------------------------------
> >> [TransactionUtil.rollback]
> >> Exception: java.lang.Exception
> >> Message: Stack Trace
> >> ---- stack trace
> >> ---------------------------------------------------------------
> >> java.lang.Exception: Stack Trace
> >> org.ofbiz.entity.transaction.TransactionUtil.rollback
> >> (TransactionUtil.java:242)
> >> org.ofbiz.entity.transaction.TransactionUtil.rollback
> >> (TransactionUtil.java:224)
> >> org.ofbiz.webapp.event.ServiceMultiEventHandler.invoke
> >> (ServiceMultiEventHandler.java:334)
> >> org.ofbiz.webapp.control.RequestHandler.runEvent
> >> (RequestHandler.java:416)
> >> org.ofbiz.webapp.control.RequestHandler.doRequest
> >> (RequestHandler.java:252)
> >> org.ofbiz.webapp.control.ControlServlet.doGet(ControlServlet.java:191)
> >> org.ofbiz.webapp.control.ControlServlet.doPost(ControlServlet.java:87)
> >> javax.servlet.http.HttpServlet.service(HttpServlet.java:709)
> >> javax.servlet.http.HttpServlet.service(HttpServlet.java:802)
> >> org.apache.catalina.core.ApplicationFilterChain.internalDoFilter
> >> (ApplicationFilterChain.java:252)
> >> org.apache.catalina.core.ApplicationFilterChain.doFilter
> >> (ApplicationFilterChain.java:173)
> >> org.ofbiz.webapp.control.ContextFilter.doFilter(ContextFilter.java:
> >> 258)
> >> org.apache.catalina.core.ApplicationFilterChain.internalDoFilter
> >> (ApplicationFilterChain.java:202)
> >> org.apache.catalina.core.ApplicationFilterChain.doFilter
> >> (ApplicationFilterChain.java:173)
> >> org.apache.catalina.core.StandardWrapperValve.invoke
> >> (StandardWrapperValve.java:213)
> >> org.apache.catalina.core.StandardContextValve.invoke
> >> (StandardContextValve.java:178)
> >> org.apache.catalina.core.StandardHostValve.invoke
> >> (StandardHostValve.java:126)
> >> org.apache.catalina.valves.ErrorReportValve.invoke
> >> (ErrorReportValve.java:105)
> >> org.apache.catalina.core.StandardEngineValve.invoke
> >> (StandardEngineValve.java:107)
> >> org.apache.catalina.valves.AccessLogValve.invoke
> >> (AccessLogValve.java:526)
> >> org.apache.catalina.connector.CoyoteAdapter.service
> >> (CoyoteAdapter.java:148)
> >> org.apache.coyote.http11.Http11Processor.process
> >> (Http11Processor.java:856)
> >> org.apache.coyote.http11.Http11Protocol
> >> $Http11ConnectionHandler.processConnection(Http11Protocol.java:744)
> >> org.apache.tomcat.util.net.PoolTcpEndpoint.processSocket
> >> (PoolTcpEndpoint.java:527)
> >> org.apache.tomcat.util.net.LeaderFollowerWorkerThread.runIt
> >> (LeaderFollowerWorkerThread.java:80)
> >> org.apache.tomcat.util.threads.ThreadPool$ControlRunnable.run
> >> (ThreadPool.java:684)
> >> java.lang.Thread.run(Thread.java:534)
> >> ----------------------------------------------------------------------
> >> ----------
> >>
> >> 567715 (http-0.0.0.0-8443-Processor4) [ TransactionUtil.java:
> >> 253:INFO ]
> >> [TransactionUtil.rollback] transaction rolled back
> >> 567716 (http-0.0.0.0-8443-Processor4) [ RequestHandler.java:
> >> 283:ERROR]
> >> Request receiveInventoryProduct caused an error with the following
> >> message:
> >> Service invocation error on row (0):
> >> org.ofbiz.entity.transaction.GenericTransactionException: The current
> >> transaction is marked for rollback, not beginning a new transaction
> >> and
> >> aborting current operation; the rollbackOnly was caused by: Error in
> >> simple-method [Verifies and posts a set of AcctgTransEntries
> >> [file:/usr/opentaps/applications/accounting/script/org/ofbiz/
> >> accounting/ledger/
> >> GeneralLedgerServices.xml#createAcctgTransAndEntries]]:
> >> ; [Debit and Credit Totals must be equal to post to GL., Debit and
> >> Credit
> >> Totals must be equal to post to GL.]
> >>
> >>
> >> 567717 (http-0.0.0.0-8443-Processor4) [ RequestHandler.java:
> >> 395:INFO ]
> >> [RequestHandler.doRequest]: Response is a view.
> >> 567717 (http-0.0.0.0-8443-Processor4) [ RequestHandler.java:
> >> 547:INFO ]
> >> servletName=control, view=ReceiveInventory
> >> 567747 (http-0.0.0.0-8443-Processor4) [ UtilXml.java:
> >> 242:DEBUG]
> >> XML Read 0.028s:
> >> file:/usr/opentaps/applications/product/widget/facility/
> >> FacilityScreens.xml
> >> 567752 (http-0.0.0.0-8443-Processor4) [ ScreenFactory.java:
> >> 127:INFO ]
> >> Got 25 screens in 0.033s from:
> >> file:/usr/opentaps/applications/product/widget/facility/
> >> FacilityScreens.xml
> >> 567780 (invoker-Thread-10) [ ServiceDispatcher.java:450:DEBUG] [[Sync
> >> service finished- total:0.01,since last(Begin):0.01]] - 'entity-
> >> default /
> >> checkProductInventoryDiscontinuation'
> >> 567785 (invoker-Thread-11) [ ServiceDispatcher.java:450:DEBUG] [[Sync
> >> service finished- total:0.017,since last(Begin):0.017]] - 'entity-
> >> default /
> >> checkProductInventoryDiscontinuation'
> >> 567840 (http-0.0.0.0-8443-Processor4) [ UtilXml.java:
> >> 242:DEBUG]
> >> XML Read 0.028s: jndi:/0.0.0.0/facility/WEB-INF/controller.xml
> >> 567843 (http-0.0.0.0-8443-Processor4) [ ConfigXMLReader.java:
> >> 552:INFO ]
> >> ConfigMap Created: (4) records in 0.0020s
> >> 567845 (http-0.0.0.0-8443-Processor4) [ ConfigXMLReader.java:
> >> 622:INFO ]
> >> HandlerMap Created: (2) records in 0.0010s
> >> 567853 (http-0.0.0.0-8443-Processor4) [ ConfigXMLReader.java:
> >> 302:INFO ]
> >> RequestMap Created: (149) records in 0.0070s
> >> 567855 (http-0.0.0.0-8443-Processor4) [ ConfigXMLReader.java:
> >> 411:INFO ]
> >> ViewMap Created: (49) records in 0.0010s
> >> 568039 (http-0.0.0.0-8443-Processor4) [ ModelScreenWidget.java:
> >> 371:INFO ]
> >> In the include-screen tag the screen name was empty, ignoring
> >> include; in
> >> screen [GlobalDecorator]
> >> 568135 (http-0.0.0.0-8443-Processor4) [ ControlServlet.java:
> >> 258:DEBUG]
> >> [[[receiveInventoryProduct] Done rendering page, Servlet Finished-
> >> total:1.033,since last([receiveInventory...):1.033]]
> >> --
> >> View this message in context:
http://www.nabble.com/-OFBiz--Users---
> >> order-and-invoice-tf149487.html#a5481731
> >> Sent from the OFBiz - User forum at Nabble.com.
> >
> >
> >
> --
> View this message in context:
http://www.nabble.com/-OFBiz--Users---order-and-invoice-tf149487.html#a5493370> Sent from the OFBiz - User forum at Nabble.com.