Problem during checkout with Billing Account

Previous Topic Next Topic
 
classic Classic list List threaded Threaded
7 messages Options
Reply | Threaded
Open this post in threaded view
|

Problem during checkout with Billing Account

Alexander1893
Hi all,

I'm doing a checkout using a billing account and get the following error. I already checked old tickets / messages for this, but could not find a solution:

---- exception report ----------------------------------------------------------
[TransactionUtil.setRollbackOnly] Calling transaction setRollbackOnly; this stack trace shows where this is happening:
Exception: java.lang.Exception
Message: Error in simple-method [Convert UOM values [file:/E:/projekte/clone-it/ofbiz/ofbiz-trunk/framework/common/script/org/ofbiz/common/CommonServices.xml#convertUom]]: ; [UOM Conversion Relationship Not Found]
---- stack trace ---------------------------------------------------------------
java.lang.Exception: Error in simple-method [Convert UOM values [file:/E:/projekte/clone-it/ofbiz/ofbiz-trunk/framework/common/script/org/ofbiz/common/CommonServices.xml#convertUom]]: ; [UOM Conversion Relationship Not Found]
org.ofbiz.entity.transaction.TransactionUtil.setRollbackOnly(TransactionUtil.java:371)
org.ofbiz.entity.transaction.TransactionUtil.rollback(TransactionUtil.java:318)
org.ofbiz.minilang.SimpleMethod.exec(SimpleMethod.java:833)
org.ofbiz.minilang.SimpleMethod.runSimpleMethod(SimpleMethod.java:160)
org.ofbiz.minilang.SimpleMethod.runSimpleService(SimpleMethod.java:142)
org.ofbiz.minilang.SimpleServiceEngine.serviceInvoker(SimpleServiceEngine.java:78)
org.ofbiz.minilang.SimpleServiceEngine.runSync(SimpleServiceEngine.java:53)
org.ofbiz.service.ModelServiceReader$GenericInvokerImpl.runSync(ModelServiceReader.java:785)
_$gen.file_58$.E_58$.projekte.clone_45$it.ofbiz.ofbiz_45$trunk.framework.common.servicedef.services_46$xml_35$convertUom.runSync(file:/E:/projekte/clone-it/ofbiz/ofbiz-trunk/framework/common/servicedef/services.xml#convertUom:293)
org.ofbiz.service.ServiceDispatcher.runSync(ServiceDispatcher.java:392)
org.ofbiz.service.ServiceDispatcher.runSync(ServiceDispatcher.java:221)
org.ofbiz.service.GenericDispatcher.runSync(GenericDispatcher.java:173)
org.ofbiz.minilang.method.callops.CallService.exec(CallService.java:245)
org.ofbiz.minilang.SimpleMethod.runSubOps(SimpleMethod.java:883)
org.ofbiz.minilang.method.ifops.IfCompareField.exec(IfCompareField.java:154)
org.ofbiz.minilang.SimpleMethod.runSubOps(SimpleMethod.java:883)
org.ofbiz.minilang.method.ifops.IfNotEmpty.exec(IfNotEmpty.java:101)
org.ofbiz.minilang.SimpleMethod.runSubOps(SimpleMethod.java:883)
org.ofbiz.minilang.method.ifops.IfEmpty.exec(IfEmpty.java:96)
org.ofbiz.minilang.SimpleMethod.runSubOps(SimpleMethod.java:883)
org.ofbiz.minilang.method.ifops.IfEmpty.exec(IfEmpty.java:99)
org.ofbiz.minilang.SimpleMethod.runSubOps(SimpleMethod.java:883)
org.ofbiz.minilang.method.ifops.IfEmpty.exec(IfEmpty.java:99)
org.ofbiz.minilang.SimpleMethod.runSubOps(SimpleMethod.java:883)
org.ofbiz.minilang.method.envops.Iterate.exec(Iterate.java:118)
org.ofbiz.minilang.SimpleMethod.runSubOps(SimpleMethod.java:883)
org.ofbiz.minilang.SimpleMethod.exec(SimpleMethod.java:702)
org.ofbiz.minilang.SimpleMethod.runSimpleMethod(SimpleMethod.java:160)
org.ofbiz.minilang.SimpleMethod.runSimpleService(SimpleMethod.java:142)
org.ofbiz.minilang.SimpleServiceEngine.serviceInvoker(SimpleServiceEngine.java:78)
org.ofbiz.minilang.SimpleServiceEngine.runSync(SimpleServiceEngine.java:53)
org.ofbiz.service.ModelServiceReader$GenericInvokerImpl.runSync(ModelServiceReader.java:785)
_$gen.file_58$.E_58$.projekte.clone_45$it.ofbiz.ofbiz_45$trunk.applications.accounting.servicedef.services_95$ledger_46$xml_35$createAcctgTransAndEntries.runSync(file:/E:/projekte/clone-it/ofbiz/ofbiz-trunk/applications/accounting/servicedef/services_ledger.xml#createAcctgTransAndEntries:259)
org.ofbiz.service.ServiceDispatcher.runSync(ServiceDispatcher.java:392)
org.ofbiz.service.ServiceDispatcher.runSync(ServiceDispatcher.java:221)
org.ofbiz.service.GenericDispatcher.runSync(GenericDispatcher.java:173)
org.ofbiz.minilang.method.callops.CallService.exec(CallService.java:245)
org.ofbiz.minilang.SimpleMethod.runSubOps(SimpleMethod.java:883)
org.ofbiz.minilang.method.ifops.IfCompare.exec(IfCompare.java:132)
org.ofbiz.minilang.SimpleMethod.runSubOps(SimpleMethod.java:883)
org.ofbiz.minilang.SimpleMethod.exec(SimpleMethod.java:702)
org.ofbiz.minilang.SimpleMethod.runSimpleMethod(SimpleMethod.java:160)
org.ofbiz.minilang.SimpleMethod.runSimpleService(SimpleMethod.java:142)
org.ofbiz.minilang.SimpleServiceEngine.serviceInvoker(SimpleServiceEngine.java:78)
org.ofbiz.minilang.SimpleServiceEngine.runSync(SimpleServiceEngine.java:53)
org.ofbiz.service.ModelServiceReader$GenericInvokerImpl.runSync(ModelServiceReader.java:785)
_$gen.file_58$.E_58$.projekte.clone_45$it.ofbiz.ofbiz_45$trunk.applications.accounting.servicedef.services_95$ledger_46$xml_35$createAcctgTransForSalesInvoice.runSync(file:/E:/projekte/clone-it/ofbiz/ofbiz-trunk/applications/accounting/servicedef/services_ledger.xml#createAcctgTransForSalesInvoice:498)
org.ofbiz.service.ServiceDispatcher.runSync(ServiceDispatcher.java:392)
org.ofbiz.service.ServiceDispatcher.runSync(ServiceDispatcher.java:221)
org.ofbiz.service.GenericDispatcher.runSync(GenericDispatcher.java:159)
org.ofbiz.service.eca.ServiceEcaAction.runAction(ServiceEcaAction.java:135)
org.ofbiz.service.eca.ServiceEcaRule.eval(ServiceEcaRule.java:152)
org.ofbiz.service.eca.ServiceEcaUtil.evalRules(ServiceEcaUtil.java:157)
org.ofbiz.service.ServiceDispatcher.runSync(ServiceDispatcher.java:490)
org.ofbiz.service.ServiceDispatcher.runSync(ServiceDispatcher.java:221)
org.ofbiz.service.GenericDispatcher.runSync(GenericDispatcher.java:159)
org.ofbiz.accounting.invoice.InvoiceServices.createInvoiceForOrder(InvoiceServices.java:784)
sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method)
sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:39)
sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:25)
java.lang.reflect.Method.invoke(Method.java:597)
org.ofbiz.service.engine.StandardJavaEngine.serviceInvoker(StandardJavaEngine.java:98)
org.ofbiz.service.engine.StandardJavaEngine.runSync(StandardJavaEngine.java:56)
org.ofbiz.service.ModelServiceReader$GenericInvokerImpl.runSync(ModelServiceReader.java:785)
_$gen.file_58$.E_58$.projekte.clone_45$it.ofbiz.ofbiz_45$trunk.applications.accounting.servicedef.services_95$invoice_46$xml_35$createInvoiceForOrder.runSync(file:/E:/projekte/clone-it/ofbiz/ofbiz-trunk/applications/accounting/servicedef/services_invoice.xml#createInvoiceForOrder:147)
org.ofbiz.service.ServiceDispatcher.runSync(ServiceDispatcher.java:392)
org.ofbiz.service.ServiceDispatcher.runSync(ServiceDispatcher.java:221)
org.ofbiz.service.GenericDispatcher.runSync(GenericDispatcher.java:159)
org.ofbiz.order.order.OrderServices.checkDigitalItemFulfillment(OrderServices.java:3003)
sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method)
sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:39)
sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:25)
java.lang.reflect.Method.invoke(Method.java:597)
org.ofbiz.service.engine.StandardJavaEngine.serviceInvoker(StandardJavaEngine.java:98)
org.ofbiz.service.engine.StandardJavaEngine.runSync(StandardJavaEngine.java:56)
org.ofbiz.service.ModelServiceReader$GenericInvokerImpl.runSync(ModelServiceReader.java:785)
_$gen.file_58$.E_58$.projekte.clone_45$it.ofbiz.ofbiz_45$trunk.applications.order.servicedef.services_46$xml_35$checkDigitalItemFulfillment.runSync(file:/E:/projekte/clone-it/ofbiz/ofbiz-trunk/applications/order/servicedef/services.xml#checkDigitalItemFulfillment:458)
org.ofbiz.service.ServiceDispatcher.runSync(ServiceDispatcher.java:392)
org.ofbiz.service.ServiceDispatcher.runSync(ServiceDispatcher.java:221)
org.ofbiz.service.GenericDispatcher.runSync(GenericDispatcher.java:159)
org.ofbiz.service.eca.ServiceEcaAction.runAction(ServiceEcaAction.java:135)
org.ofbiz.service.eca.ServiceEcaRule.eval(ServiceEcaRule.java:152)
org.ofbiz.service.eca.ServiceEcaUtil.evalRules(ServiceEcaUtil.java:157)
org.ofbiz.service.ServiceDispatcher.runSync(ServiceDispatcher.java:490)
org.ofbiz.service.ServiceDispatcher.runSync(ServiceDispatcher.java:221)
org.ofbiz.service.GenericDispatcher.runSync(GenericDispatcher.java:159)
org.ofbiz.order.order.OrderChangeHelper.orderStatusChanges(OrderChangeHelper.java:166)
org.ofbiz.order.order.OrderChangeHelper.approveOrder(OrderChangeHelper.java:72)
org.ofbiz.order.shoppingcart.CheckOutHelper.processPayment(CheckOutHelper.java:1086)
org.ofbiz.order.shoppingcart.CheckOutHelper.processPayment(CheckOutHelper.java:885)
org.ofbiz.order.shoppingcart.CheckOutEvents.processPayment(CheckOutEvents.java:573)
org.ofbiz.order.shoppingcart.CheckOutEvents.processPayment(CheckOutEvents.java:537)
sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method)
sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:39)
sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:25)
java.lang.reflect.Method.invoke(Method.java:597)
org.ofbiz.webapp.event.JavaEventHandler.invoke(JavaEventHandler.java:92)
org.ofbiz.webapp.event.JavaEventHandler.invoke(JavaEventHandler.java:78)
org.ofbiz.webapp.control.RequestHandler.runEvent(RequestHandler.java:611)
org.ofbiz.webapp.control.RequestHandler.doRequest(RequestHandler.java:374)
org.ofbiz.webapp.control.RequestHandler.doRequest(RequestHandler.java:515)
org.ofbiz.webapp.control.RequestHandler.doRequest(RequestHandler.java:515)
org.ofbiz.webapp.control.ControlServlet.doGet(ControlServlet.java:214)
javax.servlet.http.HttpServlet.service(HttpServlet.java:690)
javax.servlet.http.HttpServlet.service(HttpServlet.java:803)
org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:290)
org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:206)
org.ofbiz.webapp.control.ContextFilter.doFilter(ContextFilter.java:264)
org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:235)
org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:206)
org.apache.catalina.core.StandardWrapperValve.invoke(StandardWrapperValve.java:233)
org.apache.catalina.core.StandardContextValve.invoke(StandardContextValve.java:175)
org.apache.catalina.core.StandardHostValve.invoke(StandardHostValve.java:128)
org.apache.catalina.valves.ErrorReportValve.invoke(ErrorReportValve.java:102)
org.apache.catalina.core.StandardEngineValve.invoke(StandardEngineValve.java:109)
org.apache.catalina.valves.AccessLogValve.invoke(AccessLogValve.java:568)
org.apache.catalina.connector.CoyoteAdapter.service(CoyoteAdapter.java:286)
org.apache.coyote.http11.Http11Processor.process(Http11Processor.java:844)
org.apache.coyote.http11.Http11Protocol$Http11ConnectionHandler.process(Http11Protocol.java:583)
org.apache.tomcat.util.net.JIoEndpoint$Worker.run(JIoEndpoint.java:447)
java.lang.Thread.run(Thread.java:619)
-------------------------------------------

Thanks a lot!
Best regards
Alexander
Reply | Threaded
Open this post in threaded view
|

Re: Problem during checkout with Billing Account

Bilgin Ibryam-2
Hi Alexander,

the problems seems to be caused due to missing currency exchange rate.
May be you created the order in different currency than the one
specified in accounting.
You can enter exchange rates from accounting->global gl
settings->foreign exchange rates and see if the problem goes away.

Bilgin


Alexander1893 wrote:

> Hi all,
>
> I'm doing a checkout using a billing account and get the following error. I
> already checked old tickets / messages for this, but could not find a
> solution:
>
> ---- exception report
> ----------------------------------------------------------
> [TransactionUtil.setRollbackOnly] Calling transaction setRollbackOnly; this
> stack trace shows where this is happening:
> Exception: java.lang.Exception
> Message: Error in simple-method [Convert UOM values
> [file:/E:/projekte/clone-it/ofbiz/ofbiz-trunk/framework/common/script/org/ofbiz/common/CommonServices.xml#convertUom]]:
> ; [UOM Conversion Relationship Not Found]
> ---- stack trace
> ---------------------------------------------------------------
> java.lang.Exception: Error in simple-method [Convert UOM values
> [file:/E:/projekte/clone-it/ofbiz/ofbiz-trunk/framework/common/script/org/ofbiz/common/CommonServices.xml#convertUom]]:
> ; [UOM Conversion Relationship Not Found]
> org.ofbiz.entity.transaction.TransactionUtil.setRollbackOnly(TransactionUtil.java:371)
> org.ofbiz.entity.transaction.TransactionUtil.rollback(TransactionUtil.java:318)
> org.ofbiz.minilang.SimpleMethod.exec(SimpleMethod.java:833)
> org.ofbiz.minilang.SimpleMethod.runSimpleMethod(SimpleMethod.java:160)
> org.ofbiz.minilang.SimpleMethod.runSimpleService(SimpleMethod.java:142)
> org.ofbiz.minilang.SimpleServiceEngine.serviceInvoker(SimpleServiceEngine.java:78)
> org.ofbiz.minilang.SimpleServiceEngine.runSync(SimpleServiceEngine.java:53)
> org.ofbiz.service.ModelServiceReader$GenericInvokerImpl.runSync(ModelServiceReader.java:785)
> _$gen.file_58$.E_58$.projekte.clone_45$it.ofbiz.ofbiz_45$trunk.framework.common.servicedef.services_46$xml_35$convertUom.runSync(file:/E:/projekte/clone-it/ofbiz/ofbiz-trunk/framework/common/servicedef/services.xml#convertUom:293)
> org.ofbiz.service.ServiceDispatcher.runSync(ServiceDispatcher.java:392)
> org.ofbiz.service.ServiceDispatcher.runSync(ServiceDispatcher.java:221)
> org.ofbiz.service.GenericDispatcher.runSync(GenericDispatcher.java:173)
> org.ofbiz.minilang.method.callops.CallService.exec(CallService.java:245)
> org.ofbiz.minilang.SimpleMethod.runSubOps(SimpleMethod.java:883)
> org.ofbiz.minilang.method.ifops.IfCompareField.exec(IfCompareField.java:154)
> org.ofbiz.minilang.SimpleMethod.runSubOps(SimpleMethod.java:883)
> org.ofbiz.minilang.method.ifops.IfNotEmpty.exec(IfNotEmpty.java:101)
> org.ofbiz.minilang.SimpleMethod.runSubOps(SimpleMethod.java:883)
> org.ofbiz.minilang.method.ifops.IfEmpty.exec(IfEmpty.java:96)
> org.ofbiz.minilang.SimpleMethod.runSubOps(SimpleMethod.java:883)
> org.ofbiz.minilang.method.ifops.IfEmpty.exec(IfEmpty.java:99)
> org.ofbiz.minilang.SimpleMethod.runSubOps(SimpleMethod.java:883)
> org.ofbiz.minilang.method.ifops.IfEmpty.exec(IfEmpty.java:99)
> org.ofbiz.minilang.SimpleMethod.runSubOps(SimpleMethod.java:883)
> org.ofbiz.minilang.method.envops.Iterate.exec(Iterate.java:118)
> org.ofbiz.minilang.SimpleMethod.runSubOps(SimpleMethod.java:883)
> org.ofbiz.minilang.SimpleMethod.exec(SimpleMethod.java:702)
> org.ofbiz.minilang.SimpleMethod.runSimpleMethod(SimpleMethod.java:160)
> org.ofbiz.minilang.SimpleMethod.runSimpleService(SimpleMethod.java:142)
> org.ofbiz.minilang.SimpleServiceEngine.serviceInvoker(SimpleServiceEngine.java:78)
> org.ofbiz.minilang.SimpleServiceEngine.runSync(SimpleServiceEngine.java:53)
> org.ofbiz.service.ModelServiceReader$GenericInvokerImpl.runSync(ModelServiceReader.java:785)
> _$gen.file_58$.E_58$.projekte.clone_45$it.ofbiz.ofbiz_45$trunk.applications.accounting.servicedef.services_95$ledger_46$xml_35$createAcctgTransAndEntries.runSync(file:/E:/projekte/clone-it/ofbiz/ofbiz-trunk/applications/accounting/servicedef/services_ledger.xml#createAcctgTransAndEntries:259)
> org.ofbiz.service.ServiceDispatcher.runSync(ServiceDispatcher.java:392)
> org.ofbiz.service.ServiceDispatcher.runSync(ServiceDispatcher.java:221)
> org.ofbiz.service.GenericDispatcher.runSync(GenericDispatcher.java:173)
> org.ofbiz.minilang.method.callops.CallService.exec(CallService.java:245)
> org.ofbiz.minilang.SimpleMethod.runSubOps(SimpleMethod.java:883)
> org.ofbiz.minilang.method.ifops.IfCompare.exec(IfCompare.java:132)
> org.ofbiz.minilang.SimpleMethod.runSubOps(SimpleMethod.java:883)
> org.ofbiz.minilang.SimpleMethod.exec(SimpleMethod.java:702)
> org.ofbiz.minilang.SimpleMethod.runSimpleMethod(SimpleMethod.java:160)
> org.ofbiz.minilang.SimpleMethod.runSimpleService(SimpleMethod.java:142)
> org.ofbiz.minilang.SimpleServiceEngine.serviceInvoker(SimpleServiceEngine.java:78)
> org.ofbiz.minilang.SimpleServiceEngine.runSync(SimpleServiceEngine.java:53)
> org.ofbiz.service.ModelServiceReader$GenericInvokerImpl.runSync(ModelServiceReader.java:785)
> _$gen.file_58$.E_58$.projekte.clone_45$it.ofbiz.ofbiz_45$trunk.applications.accounting.servicedef.services_95$ledger_46$xml_35$createAcctgTransForSalesInvoice.runSync(file:/E:/projekte/clone-it/ofbiz/ofbiz-trunk/applications/accounting/servicedef/services_ledger.xml#createAcctgTransForSalesInvoice:498)
> org.ofbiz.service.ServiceDispatcher.runSync(ServiceDispatcher.java:392)
> org.ofbiz.service.ServiceDispatcher.runSync(ServiceDispatcher.java:221)
> org.ofbiz.service.GenericDispatcher.runSync(GenericDispatcher.java:159)
> org.ofbiz.service.eca.ServiceEcaAction.runAction(ServiceEcaAction.java:135)
> org.ofbiz.service.eca.ServiceEcaRule.eval(ServiceEcaRule.java:152)
> org.ofbiz.service.eca.ServiceEcaUtil.evalRules(ServiceEcaUtil.java:157)
> org.ofbiz.service.ServiceDispatcher.runSync(ServiceDispatcher.java:490)
> org.ofbiz.service.ServiceDispatcher.runSync(ServiceDispatcher.java:221)
> org.ofbiz.service.GenericDispatcher.runSync(GenericDispatcher.java:159)
> org.ofbiz.accounting.invoice.InvoiceServices.createInvoiceForOrder(InvoiceServices.java:784)
> sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method)
> sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:39)
> sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:25)
> java.lang.reflect.Method.invoke(Method.java:597)
> org.ofbiz.service.engine.StandardJavaEngine.serviceInvoker(StandardJavaEngine.java:98)
> org.ofbiz.service.engine.StandardJavaEngine.runSync(StandardJavaEngine.java:56)
> org.ofbiz.service.ModelServiceReader$GenericInvokerImpl.runSync(ModelServiceReader.java:785)
> _$gen.file_58$.E_58$.projekte.clone_45$it.ofbiz.ofbiz_45$trunk.applications.accounting.servicedef.services_95$invoice_46$xml_35$createInvoiceForOrder.runSync(file:/E:/projekte/clone-it/ofbiz/ofbiz-trunk/applications/accounting/servicedef/services_invoice.xml#createInvoiceForOrder:147)
> org.ofbiz.service.ServiceDispatcher.runSync(ServiceDispatcher.java:392)
> org.ofbiz.service.ServiceDispatcher.runSync(ServiceDispatcher.java:221)
> org.ofbiz.service.GenericDispatcher.runSync(GenericDispatcher.java:159)
> org.ofbiz.order.order.OrderServices.checkDigitalItemFulfillment(OrderServices.java:3003)
> sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method)
> sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:39)
> sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:25)
> java.lang.reflect.Method.invoke(Method.java:597)
> org.ofbiz.service.engine.StandardJavaEngine.serviceInvoker(StandardJavaEngine.java:98)
> org.ofbiz.service.engine.StandardJavaEngine.runSync(StandardJavaEngine.java:56)
> org.ofbiz.service.ModelServiceReader$GenericInvokerImpl.runSync(ModelServiceReader.java:785)
> _$gen.file_58$.E_58$.projekte.clone_45$it.ofbiz.ofbiz_45$trunk.applications.order.servicedef.services_46$xml_35$checkDigitalItemFulfillment.runSync(file:/E:/projekte/clone-it/ofbiz/ofbiz-trunk/applications/order/servicedef/services.xml#checkDigitalItemFulfillment:458)
> org.ofbiz.service.ServiceDispatcher.runSync(ServiceDispatcher.java:392)
> org.ofbiz.service.ServiceDispatcher.runSync(ServiceDispatcher.java:221)
> org.ofbiz.service.GenericDispatcher.runSync(GenericDispatcher.java:159)
> org.ofbiz.service.eca.ServiceEcaAction.runAction(ServiceEcaAction.java:135)
> org.ofbiz.service.eca.ServiceEcaRule.eval(ServiceEcaRule.java:152)
> org.ofbiz.service.eca.ServiceEcaUtil.evalRules(ServiceEcaUtil.java:157)
> org.ofbiz.service.ServiceDispatcher.runSync(ServiceDispatcher.java:490)
> org.ofbiz.service.ServiceDispatcher.runSync(ServiceDispatcher.java:221)
> org.ofbiz.service.GenericDispatcher.runSync(GenericDispatcher.java:159)
> org.ofbiz.order.order.OrderChangeHelper.orderStatusChanges(OrderChangeHelper.java:166)
> org.ofbiz.order.order.OrderChangeHelper.approveOrder(OrderChangeHelper.java:72)
> org.ofbiz.order.shoppingcart.CheckOutHelper.processPayment(CheckOutHelper.java:1086)
> org.ofbiz.order.shoppingcart.CheckOutHelper.processPayment(CheckOutHelper.java:885)
> org.ofbiz.order.shoppingcart.CheckOutEvents.processPayment(CheckOutEvents.java:573)
> org.ofbiz.order.shoppingcart.CheckOutEvents.processPayment(CheckOutEvents.java:537)
> sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method)
> sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:39)
> sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:25)
> java.lang.reflect.Method.invoke(Method.java:597)
> org.ofbiz.webapp.event.JavaEventHandler.invoke(JavaEventHandler.java:92)
> org.ofbiz.webapp.event.JavaEventHandler.invoke(JavaEventHandler.java:78)
> org.ofbiz.webapp.control.RequestHandler.runEvent(RequestHandler.java:611)
> org.ofbiz.webapp.control.RequestHandler.doRequest(RequestHandler.java:374)
> org.ofbiz.webapp.control.RequestHandler.doRequest(RequestHandler.java:515)
> org.ofbiz.webapp.control.RequestHandler.doRequest(RequestHandler.java:515)
> org.ofbiz.webapp.control.ControlServlet.doGet(ControlServlet.java:214)
> javax.servlet.http.HttpServlet.service(HttpServlet.java:690)
> javax.servlet.http.HttpServlet.service(HttpServlet.java:803)
> org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:290)
> org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:206)
> org.ofbiz.webapp.control.ContextFilter.doFilter(ContextFilter.java:264)
> org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:235)
> org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:206)
> org.apache.catalina.core.StandardWrapperValve.invoke(StandardWrapperValve.java:233)
> org.apache.catalina.core.StandardContextValve.invoke(StandardContextValve.java:175)
> org.apache.catalina.core.StandardHostValve.invoke(StandardHostValve.java:128)
> org.apache.catalina.valves.ErrorReportValve.invoke(ErrorReportValve.java:102)
> org.apache.catalina.core.StandardEngineValve.invoke(StandardEngineValve.java:109)
> org.apache.catalina.valves.AccessLogValve.invoke(AccessLogValve.java:568)
> org.apache.catalina.connector.CoyoteAdapter.service(CoyoteAdapter.java:286)
> org.apache.coyote.http11.Http11Processor.process(Http11Processor.java:844)
> org.apache.coyote.http11.Http11Protocol$Http11ConnectionHandler.process(Http11Protocol.java:583)
> org.apache.tomcat.util.net.JIoEndpoint$Worker.run(JIoEndpoint.java:447)
> java.lang.Thread.run(Thread.java:619)
> -------------------------------------------
>
> Thanks a lot!
> Best regards
> Alexander
>  

Reply | Threaded
Open this post in threaded view
|

Re: Problem during checkout with Billing Account

Alexander1893
Hi Bilgin,
thanks a lot for your reply!

I added an exchange-rate for Euro to USD and now it works.
But I don't understand the following:
> The currency of the store is Euro
> The currency of the billing account of the customer is Euro
> The currency of the product's price is Euro
> The currency of "company" (in the demo data) was changed by me to Euro - also the currencies of the accounts.

What for do I then need an exchange rate?

Thanks a lot for any further information.
Alexander

Bilgin Ibryam-2 wrote
Hi Alexander,

the problems seems to be caused due to missing currency exchange rate.
May be you created the order in different currency than the one
specified in accounting.
You can enter exchange rates from accounting->global gl
settings->foreign exchange rates and see if the problem goes away.

Bilgin


Alexander1893 wrote:
> Hi all,
>
> I'm doing a checkout using a billing account and get the following error. I
> already checked old tickets / messages for this, but could not find a
> solution:
>
> ---- exception report
> ----------------------------------------------------------
> [TransactionUtil.setRollbackOnly] Calling transaction setRollbackOnly; this
> stack trace shows where this is happening:
> Exception: java.lang.Exception
> Message: Error in simple-method [Convert UOM values
> [file:/E:/projekte/clone-it/ofbiz/ofbiz-trunk/framework/common/script/org/ofbiz/common/CommonServices.xml#convertUom]]:
> ; [UOM Conversion Relationship Not Found]
> ---- stack trace
> ---------------------------------------------------------------
> java.lang.Exception: Error in simple-method [Convert UOM values
> [file:/E:/projekte/clone-it/ofbiz/ofbiz-trunk/framework/common/script/org/ofbiz/common/CommonServices.xml#convertUom]]:
> ; [UOM Conversion Relationship Not Found]
> org.ofbiz.entity.transaction.TransactionUtil.setRollbackOnly(TransactionUtil.java:371)
> org.ofbiz.entity.transaction.TransactionUtil.rollback(TransactionUtil.java:318)
> org.ofbiz.minilang.SimpleMethod.exec(SimpleMethod.java:833)
> org.ofbiz.minilang.SimpleMethod.runSimpleMethod(SimpleMethod.java:160)
> org.ofbiz.minilang.SimpleMethod.runSimpleService(SimpleMethod.java:142)
> org.ofbiz.minilang.SimpleServiceEngine.serviceInvoker(SimpleServiceEngine.java:78)
> org.ofbiz.minilang.SimpleServiceEngine.runSync(SimpleServiceEngine.java:53)
> org.ofbiz.service.ModelServiceReader$GenericInvokerImpl.runSync(ModelServiceReader.java:785)
> _$gen.file_58$.E_58$.projekte.clone_45$it.ofbiz.ofbiz_45$trunk.framework.common.servicedef.services_46$xml_35$convertUom.runSync(file:/E:/projekte/clone-it/ofbiz/ofbiz-trunk/framework/common/servicedef/services.xml#convertUom:293)
> org.ofbiz.service.ServiceDispatcher.runSync(ServiceDispatcher.java:392)
> org.ofbiz.service.ServiceDispatcher.runSync(ServiceDispatcher.java:221)
> org.ofbiz.service.GenericDispatcher.runSync(GenericDispatcher.java:173)
> org.ofbiz.minilang.method.callops.CallService.exec(CallService.java:245)
> org.ofbiz.minilang.SimpleMethod.runSubOps(SimpleMethod.java:883)
> org.ofbiz.minilang.method.ifops.IfCompareField.exec(IfCompareField.java:154)
> org.ofbiz.minilang.SimpleMethod.runSubOps(SimpleMethod.java:883)
> org.ofbiz.minilang.method.ifops.IfNotEmpty.exec(IfNotEmpty.java:101)
> org.ofbiz.minilang.SimpleMethod.runSubOps(SimpleMethod.java:883)
> org.ofbiz.minilang.method.ifops.IfEmpty.exec(IfEmpty.java:96)
> org.ofbiz.minilang.SimpleMethod.runSubOps(SimpleMethod.java:883)
> org.ofbiz.minilang.method.ifops.IfEmpty.exec(IfEmpty.java:99)
> org.ofbiz.minilang.SimpleMethod.runSubOps(SimpleMethod.java:883)
> org.ofbiz.minilang.method.ifops.IfEmpty.exec(IfEmpty.java:99)
> org.ofbiz.minilang.SimpleMethod.runSubOps(SimpleMethod.java:883)
> org.ofbiz.minilang.method.envops.Iterate.exec(Iterate.java:118)
> org.ofbiz.minilang.SimpleMethod.runSubOps(SimpleMethod.java:883)
> org.ofbiz.minilang.SimpleMethod.exec(SimpleMethod.java:702)
> org.ofbiz.minilang.SimpleMethod.runSimpleMethod(SimpleMethod.java:160)
> org.ofbiz.minilang.SimpleMethod.runSimpleService(SimpleMethod.java:142)
> org.ofbiz.minilang.SimpleServiceEngine.serviceInvoker(SimpleServiceEngine.java:78)
> org.ofbiz.minilang.SimpleServiceEngine.runSync(SimpleServiceEngine.java:53)
> org.ofbiz.service.ModelServiceReader$GenericInvokerImpl.runSync(ModelServiceReader.java:785)
> _$gen.file_58$.E_58$.projekte.clone_45$it.ofbiz.ofbiz_45$trunk.applications.accounting.servicedef.services_95$ledger_46$xml_35$createAcctgTransAndEntries.runSync(file:/E:/projekte/clone-it/ofbiz/ofbiz-trunk/applications/accounting/servicedef/services_ledger.xml#createAcctgTransAndEntries:259)
> org.ofbiz.service.ServiceDispatcher.runSync(ServiceDispatcher.java:392)
> org.ofbiz.service.ServiceDispatcher.runSync(ServiceDispatcher.java:221)
> org.ofbiz.service.GenericDispatcher.runSync(GenericDispatcher.java:173)
> org.ofbiz.minilang.method.callops.CallService.exec(CallService.java:245)
> org.ofbiz.minilang.SimpleMethod.runSubOps(SimpleMethod.java:883)
> org.ofbiz.minilang.method.ifops.IfCompare.exec(IfCompare.java:132)
> org.ofbiz.minilang.SimpleMethod.runSubOps(SimpleMethod.java:883)
> org.ofbiz.minilang.SimpleMethod.exec(SimpleMethod.java:702)
> org.ofbiz.minilang.SimpleMethod.runSimpleMethod(SimpleMethod.java:160)
> org.ofbiz.minilang.SimpleMethod.runSimpleService(SimpleMethod.java:142)
> org.ofbiz.minilang.SimpleServiceEngine.serviceInvoker(SimpleServiceEngine.java:78)
> org.ofbiz.minilang.SimpleServiceEngine.runSync(SimpleServiceEngine.java:53)
> org.ofbiz.service.ModelServiceReader$GenericInvokerImpl.runSync(ModelServiceReader.java:785)
> _$gen.file_58$.E_58$.projekte.clone_45$it.ofbiz.ofbiz_45$trunk.applications.accounting.servicedef.services_95$ledger_46$xml_35$createAcctgTransForSalesInvoice.runSync(file:/E:/projekte/clone-it/ofbiz/ofbiz-trunk/applications/accounting/servicedef/services_ledger.xml#createAcctgTransForSalesInvoice:498)
> org.ofbiz.service.ServiceDispatcher.runSync(ServiceDispatcher.java:392)
> org.ofbiz.service.ServiceDispatcher.runSync(ServiceDispatcher.java:221)
> org.ofbiz.service.GenericDispatcher.runSync(GenericDispatcher.java:159)
> org.ofbiz.service.eca.ServiceEcaAction.runAction(ServiceEcaAction.java:135)
> org.ofbiz.service.eca.ServiceEcaRule.eval(ServiceEcaRule.java:152)
> org.ofbiz.service.eca.ServiceEcaUtil.evalRules(ServiceEcaUtil.java:157)
> org.ofbiz.service.ServiceDispatcher.runSync(ServiceDispatcher.java:490)
> org.ofbiz.service.ServiceDispatcher.runSync(ServiceDispatcher.java:221)
> org.ofbiz.service.GenericDispatcher.runSync(GenericDispatcher.java:159)
> org.ofbiz.accounting.invoice.InvoiceServices.createInvoiceForOrder(InvoiceServices.java:784)
> sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method)
> sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:39)
> sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:25)
> java.lang.reflect.Method.invoke(Method.java:597)
> org.ofbiz.service.engine.StandardJavaEngine.serviceInvoker(StandardJavaEngine.java:98)
> org.ofbiz.service.engine.StandardJavaEngine.runSync(StandardJavaEngine.java:56)
> org.ofbiz.service.ModelServiceReader$GenericInvokerImpl.runSync(ModelServiceReader.java:785)
> _$gen.file_58$.E_58$.projekte.clone_45$it.ofbiz.ofbiz_45$trunk.applications.accounting.servicedef.services_95$invoice_46$xml_35$createInvoiceForOrder.runSync(file:/E:/projekte/clone-it/ofbiz/ofbiz-trunk/applications/accounting/servicedef/services_invoice.xml#createInvoiceForOrder:147)
> org.ofbiz.service.ServiceDispatcher.runSync(ServiceDispatcher.java:392)
> org.ofbiz.service.ServiceDispatcher.runSync(ServiceDispatcher.java:221)
> org.ofbiz.service.GenericDispatcher.runSync(GenericDispatcher.java:159)
> org.ofbiz.order.order.OrderServices.checkDigitalItemFulfillment(OrderServices.java:3003)
> sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method)
> sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:39)
> sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:25)
> java.lang.reflect.Method.invoke(Method.java:597)
> org.ofbiz.service.engine.StandardJavaEngine.serviceInvoker(StandardJavaEngine.java:98)
> org.ofbiz.service.engine.StandardJavaEngine.runSync(StandardJavaEngine.java:56)
> org.ofbiz.service.ModelServiceReader$GenericInvokerImpl.runSync(ModelServiceReader.java:785)
> _$gen.file_58$.E_58$.projekte.clone_45$it.ofbiz.ofbiz_45$trunk.applications.order.servicedef.services_46$xml_35$checkDigitalItemFulfillment.runSync(file:/E:/projekte/clone-it/ofbiz/ofbiz-trunk/applications/order/servicedef/services.xml#checkDigitalItemFulfillment:458)
> org.ofbiz.service.ServiceDispatcher.runSync(ServiceDispatcher.java:392)
> org.ofbiz.service.ServiceDispatcher.runSync(ServiceDispatcher.java:221)
> org.ofbiz.service.GenericDispatcher.runSync(GenericDispatcher.java:159)
> org.ofbiz.service.eca.ServiceEcaAction.runAction(ServiceEcaAction.java:135)
> org.ofbiz.service.eca.ServiceEcaRule.eval(ServiceEcaRule.java:152)
> org.ofbiz.service.eca.ServiceEcaUtil.evalRules(ServiceEcaUtil.java:157)
> org.ofbiz.service.ServiceDispatcher.runSync(ServiceDispatcher.java:490)
> org.ofbiz.service.ServiceDispatcher.runSync(ServiceDispatcher.java:221)
> org.ofbiz.service.GenericDispatcher.runSync(GenericDispatcher.java:159)
> org.ofbiz.order.order.OrderChangeHelper.orderStatusChanges(OrderChangeHelper.java:166)
> org.ofbiz.order.order.OrderChangeHelper.approveOrder(OrderChangeHelper.java:72)
> org.ofbiz.order.shoppingcart.CheckOutHelper.processPayment(CheckOutHelper.java:1086)
> org.ofbiz.order.shoppingcart.CheckOutHelper.processPayment(CheckOutHelper.java:885)
> org.ofbiz.order.shoppingcart.CheckOutEvents.processPayment(CheckOutEvents.java:573)
> org.ofbiz.order.shoppingcart.CheckOutEvents.processPayment(CheckOutEvents.java:537)
> sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method)
> sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:39)
> sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:25)
> java.lang.reflect.Method.invoke(Method.java:597)
> org.ofbiz.webapp.event.JavaEventHandler.invoke(JavaEventHandler.java:92)
> org.ofbiz.webapp.event.JavaEventHandler.invoke(JavaEventHandler.java:78)
> org.ofbiz.webapp.control.RequestHandler.runEvent(RequestHandler.java:611)
> org.ofbiz.webapp.control.RequestHandler.doRequest(RequestHandler.java:374)
> org.ofbiz.webapp.control.RequestHandler.doRequest(RequestHandler.java:515)
> org.ofbiz.webapp.control.RequestHandler.doRequest(RequestHandler.java:515)
> org.ofbiz.webapp.control.ControlServlet.doGet(ControlServlet.java:214)
> javax.servlet.http.HttpServlet.service(HttpServlet.java:690)
> javax.servlet.http.HttpServlet.service(HttpServlet.java:803)
> org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:290)
> org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:206)
> org.ofbiz.webapp.control.ContextFilter.doFilter(ContextFilter.java:264)
> org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:235)
> org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:206)
> org.apache.catalina.core.StandardWrapperValve.invoke(StandardWrapperValve.java:233)
> org.apache.catalina.core.StandardContextValve.invoke(StandardContextValve.java:175)
> org.apache.catalina.core.StandardHostValve.invoke(StandardHostValve.java:128)
> org.apache.catalina.valves.ErrorReportValve.invoke(ErrorReportValve.java:102)
> org.apache.catalina.core.StandardEngineValve.invoke(StandardEngineValve.java:109)
> org.apache.catalina.valves.AccessLogValve.invoke(AccessLogValve.java:568)
> org.apache.catalina.connector.CoyoteAdapter.service(CoyoteAdapter.java:286)
> org.apache.coyote.http11.Http11Processor.process(Http11Processor.java:844)
> org.apache.coyote.http11.Http11Protocol$Http11ConnectionHandler.process(Http11Protocol.java:583)
> org.apache.tomcat.util.net.JIoEndpoint$Worker.run(JIoEndpoint.java:447)
> java.lang.Thread.run(Thread.java:619)
> -------------------------------------------
>
> Thanks a lot!
> Best regards
> Alexander
>  
Reply | Threaded
Open this post in threaded view
|

Re: Problem during checkout with Billing Account

Bilgin Ibryam-2
Alexander1893 wrote:

> Hi Bilgin,
> thanks a lot for your reply!
>
> I added an exchange-rate for Euro to USD and now it works.
> But I don't understand the following:
>  
>> The currency of the store is Euro
>> The currency of the billing account of the customer is Euro
>> The currency of the product's price is Euro
>> The currency of "company" (in the demo data) was changed by me to Euro -
>> also the currencies of the accounts.
>>    
>
> What for do I then need an exchange rate?
>  

These changes are enough, but it is still possible to create an order
using a different currency. Most probably this is the reason for the error.

Bilgin
Reply | Threaded
Open this post in threaded view
|

Re: Problem during checkout with Billing Account

Jacques Le Roux
Administrator
I know it's an old thread, but I stumbled upon this also, so this might help people in the future.

It turned I forgot to change the currency of the product inventory item in relation with the product price (not obvious). Then you don't need to set
an exchange rate

Jacques


Le 27/11/2009 10:14, Bilgin Ibryam a écrit :

> Alexander1893 wrote:
>> Hi Bilgin,
>> thanks a lot for your reply!
>>
>> I added an exchange-rate for Euro to USD and now it works.
>> But I don't understand the following:
>>> The currency of the store is Euro
>>> The currency of the billing account of the customer is Euro
>>> The currency of the product's price is Euro
>>> The currency of "company" (in the demo data) was changed by me to Euro -
>>> also the currencies of the accounts.
>>
>> What for do I then need an exchange rate?
>
> These changes are enough, but it is still possible to create an order using a different currency. Most probably this is the reason for the error.
>
> Bilgin
>
Reply | Threaded
Open this post in threaded view
|

Re: Problem during checkout with Billing Account

Pierre Smits
Hi Jacques,

Shouldn't it be so that when the user creates a new inventory item for a
product the currency should default to the currency of the organisation?

Regards,

Pierre Smits

*ORRTIZ.COM <http://www.orrtiz.com>*
Services & Solutions for Cloud-
Based Manufacturing, Professional
Services and Retail & Trade
http://www.orrtiz.com


On Tue, May 13, 2014 at 11:47 AM, Jacques Le Roux <
[hidden email]> wrote:

> I know it's an old thread, but I stumbled upon this also, so this might
> help people in the future.
>
> It turned I forgot to change the currency of the product inventory item in
> relation with the product price (not obvious). Then you don't need to set
> an exchange rate
>
> Jacques
>
>
> Le 27/11/2009 10:14, Bilgin Ibryam a écrit :
>
>  Alexander1893 wrote:
>>
>>> Hi Bilgin,
>>> thanks a lot for your reply!
>>>
>>> I added an exchange-rate for Euro to USD and now it works.
>>> But I don't understand the following:
>>>
>>>> The currency of the store is Euro
>>>> The currency of the billing account of the customer is Euro
>>>> The currency of the product's price is Euro
>>>> The currency of "company" (in the demo data) was changed by me to Euro -
>>>> also the currencies of the accounts.
>>>>
>>>
>>> What for do I then need an exchange rate?
>>>
>>
>> These changes are enough, but it is still possible to create an order
>> using a different currency. Most probably this is the reason for the error.
>>
>> Bilgin
>>
>>
Reply | Threaded
Open this post in threaded view
|

Re: Problem during checkout with Billing Account

Jacques Le Roux
Administrator
Hi Pierre,

Not sure, the org might have several  stores with different currencies, but yes could be a default way.

I must say it's currently a bit fragile. But not sure (rather not enough time to think about it) how to handle that in a generalised way. Like many
other parts in OFBiz which are open from an UI POV

Jacques


Le 14/05/2014 13:07, Pierre Smits a écrit :

> Hi Jacques,
>
> Shouldn't it be so that when the user creates a new inventory item for a
> product the currency should default to the currency of the organisation?
>
> Regards,
>
> Pierre Smits
>
> *ORRTIZ.COM <http://www.orrtiz.com>*
> Services & Solutions for Cloud-
> Based Manufacturing, Professional
> Services and Retail & Trade
> http://www.orrtiz.com
>
>
> On Tue, May 13, 2014 at 11:47 AM, Jacques Le Roux <
> [hidden email]> wrote:
>
>> I know it's an old thread, but I stumbled upon this also, so this might
>> help people in the future.
>>
>> It turned I forgot to change the currency of the product inventory item in
>> relation with the product price (not obvious). Then you don't need to set
>> an exchange rate
>>
>> Jacques
>>
>>
>> Le 27/11/2009 10:14, Bilgin Ibryam a écrit :
>>
>>   Alexander1893 wrote:
>>>> Hi Bilgin,
>>>> thanks a lot for your reply!
>>>>
>>>> I added an exchange-rate for Euro to USD and now it works.
>>>> But I don't understand the following:
>>>>
>>>>> The currency of the store is Euro
>>>>> The currency of the billing account of the customer is Euro
>>>>> The currency of the product's price is Euro
>>>>> The currency of "company" (in the demo data) was changed by me to Euro -
>>>>> also the currencies of the accounts.
>>>>>
>>>> What for do I then need an exchange rate?
>>>>
>>> These changes are enough, but it is still possible to create an order
>>> using a different currency. Most probably this is the reason for the error.
>>>
>>> Bilgin
>>>
>>>

--