You are viewing a plain text version of this content. The canonical link for it is here.
Posted to user@ofbiz.apache.org by carlj <ma...@carl-johansson.com> on 2006/07/17 09:57:35 UTC

Re: [OFBiz] Users - order and invoice

Hey Hao,

I am new to ofbiz but I'm learning. How ever I can't complete any orders. If
you find a resolution (guess it's very simple) please let me know.

Carl
-- 
View this message in context: http://www.nabble.com/-OFBiz--Users---order-and-invoice-tf149487.html#a5356983
Sent from the OFBiz - User forum at Nabble.com.


Re: [OFBiz] Users - order and invoice

Posted by BJ Freeman <bj...@free-man.net>.
this is main error:

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.]


This is not DB related but is an accounting function.



carlj sent the following on 7/25/2006 1:39 AM:
> 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]]

Re: [OFBiz] Users - order and invoice

Posted by carlj <ma...@carl-johansson.com>.
Si,

will do!

Carl
-- 
View this message in context: http://www.nabble.com/-OFBiz--Users---order-and-invoice-tf149487.html#a5499422
Sent from the OFBiz - User forum at Nabble.com.


Re: [OFBiz] Users - order and invoice

Posted by carlj <ma...@carl-johansson.com>.
Si,

will do!

Carl


Si Chen-2 wrote:
> 
> 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
> 
-- 
View this message in context: http://www.nabble.com/-OFBiz--Users---order-and-invoice-tf149487.html#a5499444
Sent from the OFBiz - User forum at Nabble.com.


Re: [OFBiz] Users - order and invoice

Posted by Si Chen <si...@opensourcestrategies.com>.
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" <ma...@carl-johansson.com>
>> To: <of...@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.
>>
>>
>>
> -- 
> 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.


Re: [OFBiz] Users - order and invoice

Posted by carlj <ma...@carl-johansson.com>.
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" <ma...@carl-johansson.com>
> To: <of...@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.
> 
> 
> 
-- 
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.


Re: [OFBiz] Users - order and invoice

Posted by Jacques Le Roux <ja...@les7arts.com>.
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" <ma...@carl-johansson.com>
To: <of...@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.


Re: [OFBiz] Users - order and invoice

Posted by carlj <ma...@carl-johansson.com>.
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.


Re: [OFBiz] Users - order and invoice

Posted by Si Chen <si...@opensourcestrategies.com>.
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.


Re: [OFBiz] Users - order and invoice

Posted by Midhat Ali <mi...@gmail.com>.
well it has to do somwthing with the db. the exception is abt rolling back.
i dont know the framework code very well as yet (learning) so i cant shed
light on the cause. but try changing ur db.

On 7/25/06, carlj <ma...@carl-johansson.com> 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.
>
>

Re: [OFBiz] Users - order and invoice

Posted by carlj <ma...@carl-johansson.com>.
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.


Re: [OFBiz] Users - order and invoice

Posted by carlj <ma...@carl-johansson.com>.
Actually I am running the built in db since I haven't been able to change to
MySQL. I have exhausted all of the documentation trying to solve all of
these problems. Perhaps I should post a new thread for the db problem.
Anyway, I think this error message is some what correct since it contains
the same message shown in the UI. This isn't the exact message I told you
about earlier but I went through the same steps using the demo data.



Midhat Ali wrote:
> 
> also check if ur db supports transactions. try repairing ur DB if u think
> it
> is transactional
> 
> On 7/25/06, Midhat Ali <mi...@gmail.com> wrote:
>>
>> I once get this msg due to a ClassCastException in one of my customized
>> code snippets.
>>
>>
>> On 7/25/06, Si Chen < sichen@opensourcestrategies.com> wrote:
>> >
>> > Carl,
>> >
>> > This error message you posted is unfortunately not going to help us
>> > because it just means that a service triggered by what you called
>> > failed.  You need to go to the log file and find where the error
>> > message began and post the first error message after calling your
>> > service in the log file.  Sorry, but this message is a general
>> > problem of the system right now.
>> >
>> > Si
>> >
>> >
>> > On Jul 24, 2006, at 3:14 PM, carlj wrote:
>> >
>> > >
>> > > David,
>> > >
>> > > I'm currently running Opentaps 0.9 on an Ubuntu box.
>> > >
>> > > First of all I create a customer and supplier party group and a
>> > > product
>> > > connected to the supplier in inventory. Once all of this is done I
>> > > enter a
>> > > purchase order. But when I try to quck receive or make a new
>> > > shipment I get
>> > > the following error message
>> > >
>> > > Error calling event: org.ofbiz.webapp.event.EventHandlerException:
>> > > Service
>> > > invocation error (null)
>> > >
>> > > At the moment I am still just checking OFBiz out but I have already
>> > > realized
>> > > the use of it. However I can't really finish anything even though I
>> > > have
>> > > read every piece of avalible documentation. In the end I want to be
>> > > able to
>> > > contribute to the project.
>> > >
>> > > Carl
>> > > --
>> > > View this message in context: http://www.nabble.com/-OFBiz--Users---
>> > > order-and-invoice-tf149487.html#a5476410
>> > > 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#a5481667
Sent from the OFBiz - User forum at Nabble.com.


Re: [OFBiz] Users - order and invoice

Posted by Midhat Ali <mi...@gmail.com>.
also check if ur db supports transactions. try repairing ur DB if u think it
is transactional

On 7/25/06, Midhat Ali <mi...@gmail.com> wrote:
>
> I once get this msg due to a ClassCastException in one of my customized
> code snippets.
>
>
> On 7/25/06, Si Chen < sichen@opensourcestrategies.com> wrote:
> >
> > Carl,
> >
> > This error message you posted is unfortunately not going to help us
> > because it just means that a service triggered by what you called
> > failed.  You need to go to the log file and find where the error
> > message began and post the first error message after calling your
> > service in the log file.  Sorry, but this message is a general
> > problem of the system right now.
> >
> > Si
> >
> >
> > On Jul 24, 2006, at 3:14 PM, carlj wrote:
> >
> > >
> > > David,
> > >
> > > I'm currently running Opentaps 0.9 on an Ubuntu box.
> > >
> > > First of all I create a customer and supplier party group and a
> > > product
> > > connected to the supplier in inventory. Once all of this is done I
> > > enter a
> > > purchase order. But when I try to quck receive or make a new
> > > shipment I get
> > > the following error message
> > >
> > > Error calling event: org.ofbiz.webapp.event.EventHandlerException:
> > > Service
> > > invocation error (null)
> > >
> > > At the moment I am still just checking OFBiz out but I have already
> > > realized
> > > the use of it. However I can't really finish anything even though I
> > > have
> > > read every piece of avalible documentation. In the end I want to be
> > > able to
> > > contribute to the project.
> > >
> > > Carl
> > > --
> > > View this message in context: http://www.nabble.com/-OFBiz--Users---
> > > order-and-invoice-tf149487.html#a5476410
> > > Sent from the OFBiz - User forum at Nabble.com.
> >
> >
>

Re: [OFBiz] Users - order and invoice

Posted by Midhat Ali <mi...@gmail.com>.
I once get this msg due to a ClassCastException in one of my customized code
snippets.

On 7/25/06, Si Chen <si...@opensourcestrategies.com> wrote:
>
> Carl,
>
> This error message you posted is unfortunately not going to help us
> because it just means that a service triggered by what you called
> failed.  You need to go to the log file and find where the error
> message began and post the first error message after calling your
> service in the log file.  Sorry, but this message is a general
> problem of the system right now.
>
> Si
>
>
> On Jul 24, 2006, at 3:14 PM, carlj wrote:
>
> >
> > David,
> >
> > I'm currently running Opentaps 0.9 on an Ubuntu box.
> >
> > First of all I create a customer and supplier party group and a
> > product
> > connected to the supplier in inventory. Once all of this is done I
> > enter a
> > purchase order. But when I try to quck receive or make a new
> > shipment I get
> > the following error message
> >
> > Error calling event: org.ofbiz.webapp.event.EventHandlerException:
> > Service
> > invocation error (null)
> >
> > At the moment I am still just checking OFBiz out but I have already
> > realized
> > the use of it. However I can't really finish anything even though I
> > have
> > read every piece of avalible documentation. In the end I want to be
> > able to
> > contribute to the project.
> >
> > Carl
> > --
> > View this message in context: http://www.nabble.com/-OFBiz--Users---
> > order-and-invoice-tf149487.html#a5476410
> > Sent from the OFBiz - User forum at Nabble.com.
>
>

Re: [OFBiz] Users - order and invoice

Posted by Si Chen <si...@opensourcestrategies.com>.
Carl,

This error message you posted is unfortunately not going to help us  
because it just means that a service triggered by what you called  
failed.  You need to go to the log file and find where the error  
message began and post the first error message after calling your  
service in the log file.  Sorry, but this message is a general  
problem of the system right now.

Si


On Jul 24, 2006, at 3:14 PM, carlj wrote:

>
> David,
>
> I'm currently running Opentaps 0.9 on an Ubuntu box.
>
> First of all I create a customer and supplier party group and a  
> product
> connected to the supplier in inventory. Once all of this is done I  
> enter a
> purchase order. But when I try to quck receive or make a new  
> shipment I get
> the following error message
>
> Error calling event: org.ofbiz.webapp.event.EventHandlerException:  
> Service
> invocation error (null)
>
> At the moment I am still just checking OFBiz out but I have already  
> realized
> the use of it. However I can't really finish anything even though I  
> have
> read every piece of avalible documentation. In the end I want to be  
> able to
> contribute to the project.
>
> Carl
> -- 
> View this message in context: http://www.nabble.com/-OFBiz--Users--- 
> order-and-invoice-tf149487.html#a5476410
> Sent from the OFBiz - User forum at Nabble.com.


Re: [OFBiz] Users - order and invoice

Posted by carlj <ma...@carl-johansson.com>.
David,

I'm currently running Opentaps 0.9 on an Ubuntu box.

First of all I create a customer and supplier party group and a product
connected to the supplier in inventory. Once all of this is done I enter a
purchase order. But when I try to quck receive or make a new shipment I get
the following error message

Error calling event: org.ofbiz.webapp.event.EventHandlerException: Service
invocation error (null)

At the moment I am still just checking OFBiz out but I have already realized
the use of it. However I can't really finish anything even though I have
read every piece of avalible documentation. In the end I want to be able to
contribute to the project.

Carl
-- 
View this message in context: http://www.nabble.com/-OFBiz--Users---order-and-invoice-tf149487.html#a5476410
Sent from the OFBiz - User forum at Nabble.com.


Re: [OFBiz] Users - order and invoice

Posted by David Welton <da...@gmail.com>.
> I am new to ofbiz but I'm learning. How ever I can't complete any orders. If
> you find a resolution (guess it's very simple) please let me know.

What version are you using, and what steps did you go through?

-- 
David N. Welton
 - http://www.dedasys.com/davidw/

Linux, Open Source Consulting
 - http://www.dedasys.com/