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 entire log file?

Si


On Jul 25, 2006, at 2:42 PM, carlj wrote:


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.

Reply via email to