Jacques, thank you for the tip. I have been using the HSQL trying to learn ofbiz but as I wrote earlier I really haven't completed anything yet and I don't want to trouble this mailing list. I hope that I may pay it forward some day :)
jacques.le.roux wrote: > > 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" <[EMAIL PROTECTED]> > To: <[email protected]> > 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. > > > -- View this message in context: http://www.nabble.com/-OFBiz--Users---order-and-invoice-tf149487.html#a5493928 Sent from the OFBiz - User forum at Nabble.com.
