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.
