http://ofbiz.116.s1.nabble.com/OFBiz-Users-order-and-invoice-tp135079p135091.html
I wouldn't think it's due to the database. There must be something
else misconfigured. How about create a JIRA issue and paste your
>
> 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" <
[hidden email]>
>> To: <
[hidden email]>
>> 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.