You are viewing a plain text version of this content. The canonical link for it is here.
Posted to user@ofbiz.apache.org by "Vince M. Clark" <vc...@globalera.com> on 2008/12/04 02:21:02 UTC
webpos - how to over ride price?
I tried going to manager screen and using "Modify Price". Doesn't seem to do anything. Is there any way to over ride prices on the fly?
Re: webpos - how to over ride price?
Posted by Richard Fleming <ri...@thebva.com>.
I don't think the code in webpos is complete for a lookup on good_identification. The form invokes additem in shoppingcartevents and that method requires the passing of a product_id - it doesn't appear to do any kind of lookup. It seems reasonable to do the lookup first and then call the additem method with the correct product_id parameter.
Rick
--- On Thu, 12/4/08, Vince M. Clark <vc...@globalera.com> wrote:
> From: Vince M. Clark <vc...@globalera.com>
> Subject: Re: webpos - how to over ride price?
> To: user@ofbiz.apache.org
> Date: Thursday, December 4, 2008, 3:37 PM
> I saw that. The value is for the SKU. I verified that value
> in the Product ID tab. There is definitely a line for SKU
> with that value. So not sure why it isn't finding it.
>
> ----- Original Message -----
> From: "Scott Gray" <le...@gmail.com>
> To: user@ofbiz.apache.org
> Sent: Thursday, December 4, 2008 2:50:35 PM (GMT-0700)
> America/Denver
> Subject: Re: webpos - how to over ride price?
>
> If I were you I would focus on the log line directly above
> it:2008-12-04
> 15:12:25,096 (TP-Processor13) [
> WebPosTransaction.java:180:INFO ] Item not
> found 67890
> That means that for whatever reason the item isn't
> being found in the cart
> hence no price modify.
>
> Regards
> Scott
>
> 2008/12/5 Vince M. Clark <vc...@globalera.com>
>
> > I realized after I posted this that it was just a
> warning. The process
> > seems to complete, but the price is definitely not
> modified. I'll keep
> > digging.
> >
> > ----- Original Message -----
> > From: "David E Jones"
> <da...@hotwaxmedia.com>
> > To: user@ofbiz.apache.org
> > Sent: Thursday, December 4, 2008 2:30:30 PM (GMT-0700)
> America/Denver
> > Subject: Re: webpos - how to over ride price?
> >
> >
> > Are you sure that's causing this problem?
> That's just a warning
> > message that doesn't stop the code from running
> (part of the effort to
> > move from Double to BigDecimal, for which there is a
> branch going
> > right now).
> >
> > -David
> >
> >
> > On Dec 4, 2008, at 2:14 PM, Vince M. Clark wrote:
> >
> > > I found the error causing the Modify Price
> process to fail in webpos.
> > >
> > >
> > > 2008-12-04 15:12:25,096 (TP-Processor13) [
> WebPosTransaction.java:
> > > 175:INFO ] Modify item price 67890/22.0
> > > 2008-12-04 15:12:25,096 (TP-Processor13) [
> WebPosTransaction.java:
> > > 180:INFO ] Item not found 67890 2008-12-04
> 15:12:25,105 (TP-
> > > Processor13) [ EntityExpr.java:267:WARN ] ----
> exception report
> > >
> ----------------------------------------------------------
> =-=-=-=-=-
> > > =-=-=-= DATABASE TYPE ERROR in EntityExpr
> =-=-=-=-=-=-=-=-= In
> > > entity field
> [TaxAuthorityRateProduct.minItemPrice] set the value
> > > passed in [java.math.BigDecimal] is not
> compatible with the Java
> > > type of the field [Double] Exception:
> java.lang.Exception Message:
> > > Location of database type error ---- stack trace
> > >
> ------------------------------------------------/--------------
>
> > > java.lang.Exception: Location of database type
> error
> > >
> org.ofbiz.entity.condition.EntityExpr.checkRhsType(EntityExpr.java:
>
> > > 267)
> > > org
> > >
> .ofbiz.entity.condition.EntityExpr.makeWhereString(EntityExpr.java:
>
> > > 167)
> > > org
> > > .ofbiz
> > > .entity
> > >
> .condition.EntityJoinOperator.addSqlValue(EntityJoinOperator.java:
>
> > > 54)
> > > org
> > >
> .ofbiz.entity.condition.EntityExpr.makeWhereString(EntityExpr.java:
>
> > > 170)
> > > org
> > > .ofbiz
> > > .entity
> > >
> .condition.EntityJoinOperator.addSqlValue(EntityJoinOperator.java:
>
> > > 67)
> > > org
> > > .ofbiz
> > > .entity
> > > .condition
> > > .EntityConditionListBase
> > > .makeWhereString(EntityConditionListBase.java:89)
>
> > > org
> > > .ofbiz
> > > .entity
> > >
> .datasource.GenericDAO.selectListIteratorByCondition(GenericDAO.java:
>
> > > 676)
> > > org
> > > .ofbiz
> > > .entity
> > > .datasource
> > >
> .GenericHelperDAO.findListIteratorByCondition(GenericHelperDAO.java:
>
> > > 140)
> org.ofbiz.entity.GenericDelegator.find(GenericDelegator.java:
>
> > > 2273)
> > >
> org.ofbiz.entity.GenericDelegator.findList(GenericDelegator.java:
>
> > > 2314)
> > > org
> > > .ofbiz
> > > .accounting
> > > .tax
> > >
> .TaxAuthorityServices.getTaxAdjustments(TaxAuthorityServices.java:
>
> > > 309)
> > > org
> > > .ofbiz
> > > .accounting
> > > .tax
> > >
> .TaxAuthorityServices.rateProductTaxCalc(TaxAuthorityServices.java:
>
> > > 182)
> 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:585)
> > > org
> > > .ofbiz
> > > .service
> > >
> .engine.StandardJavaEngine.serviceInvoker(StandardJavaEngine.java:
>
> > > 96)
> > > org
> > > .ofbiz
> > >
> .service.engine.StandardJavaEngine.runSync(StandardJavaEngine.java:
>
> > > 54)
> > >
> org.ofbiz.service.ServiceDispatcher.runSync(ServiceDispatcher.java:
>
> > > 384)
> > >
> org.ofbiz.service.ServiceDispatcher.runSync(ServiceDispatcher.java:
>
> > > 213)
> > >
> org.ofbiz.service.GenericDispatcher.runSync(GenericDispatcher.java:
>
> > > 149)
> > > org
> > > .ofbiz
> > > .order
> > >
> .shoppingcart.CheckOutHelper.getTaxAdjustments(CheckOutHelper.java:
>
> > > 859)
> > > org
> > > .ofbiz
> > >
> .order.shoppingcart.CheckOutHelper.calcAndAddTax(CheckOutHelper.java:
>
> > > 764)
> > >
> > > ----- Original Message -----
> > > From: "Scott Gray"
> <le...@gmail.com>
> > > To: user@ofbiz.apache.org
> > > Sent: Wednesday, December 3, 2008 7:23:13 PM
> (GMT-0700) America/Denver
> > > Subject: Re: webpos - how to over ride price?
> > >
> > > oops, I missed the web part and thought we were
> talking about the
> > > standard
> > > pos.
> > > Sorry, I don't know much about webpos
> > >
> > > Regards
> > > Scott
> > >
> > > 2008/12/4 Vince M. Clark
> <vc...@globalera.com>
> > >
> > >> Nope. The price field on an item is not
> editable. If I go to
> > >> Manager, then
> > >> click on Modify Price I am presented with two
> fields, SKU and New
> > >> Price.
> > >> Selecting an item on the order makes no
> difference. If I enter the
> > >> product
> > >> code, for example GZ-1001, and a new price,
> then click Confirm,
> > >> nothing
> > >> happens.
> > >>
> > >> Note that I am trying this on
> demo.hotwaxmedia.com/webpos.
> > >>
> > >> ----- Original Message -----
> > >> From: "Scott Gray"
> <le...@gmail.com>
> > >> To: user@ofbiz.apache.org
> > >> Sent: Wednesday, December 3, 2008 6:37:30 PM
> (GMT-0700) America/
> > >> Denver
> > >> Subject: Re: webpos - how to over ride price?
>
> > >>
> > >> It should work, a quick look at the code says
> that an item needs to
> > >> be
> > >> selected, a new price entered and then modify
> price pressed.
> > >> Regards
> > >> Scott
> > >>
> > >> 2008/12/4 Vince M. Clark
> <vc...@globalera.com>
> > >>
> > >>> I tried going to manager screen and using
> "Modify Price". Doesn't
> > >>> seem to
> > >>> do anything. Is there any way to over
> ride prices on the fly?
> > >>>
> > >>
> >
> >
Re: webpos - how to over ride price?
Posted by "Vince M. Clark" <vc...@globalera.com>.
I saw that. The value is for the SKU. I verified that value in the Product ID tab. There is definitely a line for SKU with that value. So not sure why it isn't finding it.
----- Original Message -----
From: "Scott Gray" <le...@gmail.com>
To: user@ofbiz.apache.org
Sent: Thursday, December 4, 2008 2:50:35 PM (GMT-0700) America/Denver
Subject: Re: webpos - how to over ride price?
If I were you I would focus on the log line directly above it:2008-12-04
15:12:25,096 (TP-Processor13) [ WebPosTransaction.java:180:INFO ] Item not
found 67890
That means that for whatever reason the item isn't being found in the cart
hence no price modify.
Regards
Scott
2008/12/5 Vince M. Clark <vc...@globalera.com>
> I realized after I posted this that it was just a warning. The process
> seems to complete, but the price is definitely not modified. I'll keep
> digging.
>
> ----- Original Message -----
> From: "David E Jones" <da...@hotwaxmedia.com>
> To: user@ofbiz.apache.org
> Sent: Thursday, December 4, 2008 2:30:30 PM (GMT-0700) America/Denver
> Subject: Re: webpos - how to over ride price?
>
>
> Are you sure that's causing this problem? That's just a warning
> message that doesn't stop the code from running (part of the effort to
> move from Double to BigDecimal, for which there is a branch going
> right now).
>
> -David
>
>
> On Dec 4, 2008, at 2:14 PM, Vince M. Clark wrote:
>
> > I found the error causing the Modify Price process to fail in webpos.
> >
> >
> > 2008-12-04 15:12:25,096 (TP-Processor13) [ WebPosTransaction.java:
> > 175:INFO ] Modify item price 67890/22.0
> > 2008-12-04 15:12:25,096 (TP-Processor13) [ WebPosTransaction.java:
> > 180:INFO ] Item not found 67890 2008-12-04 15:12:25,105 (TP-
> > Processor13) [ EntityExpr.java:267:WARN ] ---- exception report
> > ---------------------------------------------------------- =-=-=-=-=-
> > =-=-=-= DATABASE TYPE ERROR in EntityExpr =-=-=-=-=-=-=-=-= In
> > entity field [TaxAuthorityRateProduct.minItemPrice] set the value
> > passed in [java.math.BigDecimal] is not compatible with the Java
> > type of the field [Double] Exception: java.lang.Exception Message:
> > Location of database type error ---- stack trace
> > ---------------------------------------------------------------
> > java.lang.Exception: Location of database type error
> > org.ofbiz.entity.condition.EntityExpr.checkRhsType(EntityExpr.java:
> > 267)
> > org
> > .ofbiz.entity.condition.EntityExpr.makeWhereString(EntityExpr.java:
> > 167)
> > org
> > .ofbiz
> > .entity
> > .condition.EntityJoinOperator.addSqlValue(EntityJoinOperator.java:
> > 54)
> > org
> > .ofbiz.entity.condition.EntityExpr.makeWhereString(EntityExpr.java:
> > 170)
> > org
> > .ofbiz
> > .entity
> > .condition.EntityJoinOperator.addSqlValue(EntityJoinOperator.java:
> > 67)
> > org
> > .ofbiz
> > .entity
> > .condition
> > .EntityConditionListBase
> > .makeWhereString(EntityConditionListBase.java:89)
> > org
> > .ofbiz
> > .entity
> > .datasource.GenericDAO.selectListIteratorByCondition(GenericDAO.java:
> > 676)
> > org
> > .ofbiz
> > .entity
> > .datasource
> > .GenericHelperDAO.findListIteratorByCondition(GenericHelperDAO.java:
> > 140) org.ofbiz.entity.GenericDelegator.find(GenericDelegator.java:
> > 2273)
> > org.ofbiz.entity.GenericDelegator.findList(GenericDelegator.java:
> > 2314)
> > org
> > .ofbiz
> > .accounting
> > .tax
> > .TaxAuthorityServices.getTaxAdjustments(TaxAuthorityServices.java:
> > 309)
> > org
> > .ofbiz
> > .accounting
> > .tax
> > .TaxAuthorityServices.rateProductTaxCalc(TaxAuthorityServices.java:
> > 182) 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:585)
> > org
> > .ofbiz
> > .service
> > .engine.StandardJavaEngine.serviceInvoker(StandardJavaEngine.java:
> > 96)
> > org
> > .ofbiz
> > .service.engine.StandardJavaEngine.runSync(StandardJavaEngine.java:
> > 54)
> > org.ofbiz.service.ServiceDispatcher.runSync(ServiceDispatcher.java:
> > 384)
> > org.ofbiz.service.ServiceDispatcher.runSync(ServiceDispatcher.java:
> > 213)
> > org.ofbiz.service.GenericDispatcher.runSync(GenericDispatcher.java:
> > 149)
> > org
> > .ofbiz
> > .order
> > .shoppingcart.CheckOutHelper.getTaxAdjustments(CheckOutHelper.java:
> > 859)
> > org
> > .ofbiz
> > .order.shoppingcart.CheckOutHelper.calcAndAddTax(CheckOutHelper.java:
> > 764)
> >
> > ----- Original Message -----
> > From: "Scott Gray" <le...@gmail.com>
> > To: user@ofbiz.apache.org
> > Sent: Wednesday, December 3, 2008 7:23:13 PM (GMT-0700) America/Denver
> > Subject: Re: webpos - how to over ride price?
> >
> > oops, I missed the web part and thought we were talking about the
> > standard
> > pos.
> > Sorry, I don't know much about webpos
> >
> > Regards
> > Scott
> >
> > 2008/12/4 Vince M. Clark <vc...@globalera.com>
> >
> >> Nope. The price field on an item is not editable. If I go to
> >> Manager, then
> >> click on Modify Price I am presented with two fields, SKU and New
> >> Price.
> >> Selecting an item on the order makes no difference. If I enter the
> >> product
> >> code, for example GZ-1001, and a new price, then click Confirm,
> >> nothing
> >> happens.
> >>
> >> Note that I am trying this on demo.hotwaxmedia.com/webpos.
> >>
> >> ----- Original Message -----
> >> From: "Scott Gray" <le...@gmail.com>
> >> To: user@ofbiz.apache.org
> >> Sent: Wednesday, December 3, 2008 6:37:30 PM (GMT-0700) America/
> >> Denver
> >> Subject: Re: webpos - how to over ride price?
> >>
> >> It should work, a quick look at the code says that an item needs to
> >> be
> >> selected, a new price entered and then modify price pressed.
> >> Regards
> >> Scott
> >>
> >> 2008/12/4 Vince M. Clark <vc...@globalera.com>
> >>
> >>> I tried going to manager screen and using "Modify Price". Doesn't
> >>> seem to
> >>> do anything. Is there any way to over ride prices on the fly?
> >>>
> >>
>
>
Re: webpos - how to over ride price?
Posted by Scott Gray <le...@gmail.com>.
If I were you I would focus on the log line directly above it:2008-12-04
15:12:25,096 (TP-Processor13) [ WebPosTransaction.java:180:INFO ] Item not
found 67890
That means that for whatever reason the item isn't being found in the cart
hence no price modify.
Regards
Scott
2008/12/5 Vince M. Clark <vc...@globalera.com>
> I realized after I posted this that it was just a warning. The process
> seems to complete, but the price is definitely not modified. I'll keep
> digging.
>
> ----- Original Message -----
> From: "David E Jones" <da...@hotwaxmedia.com>
> To: user@ofbiz.apache.org
> Sent: Thursday, December 4, 2008 2:30:30 PM (GMT-0700) America/Denver
> Subject: Re: webpos - how to over ride price?
>
>
> Are you sure that's causing this problem? That's just a warning
> message that doesn't stop the code from running (part of the effort to
> move from Double to BigDecimal, for which there is a branch going
> right now).
>
> -David
>
>
> On Dec 4, 2008, at 2:14 PM, Vince M. Clark wrote:
>
> > I found the error causing the Modify Price process to fail in webpos.
> >
> >
> > 2008-12-04 15:12:25,096 (TP-Processor13) [ WebPosTransaction.java:
> > 175:INFO ] Modify item price 67890/22.0
> > 2008-12-04 15:12:25,096 (TP-Processor13) [ WebPosTransaction.java:
> > 180:INFO ] Item not found 67890 2008-12-04 15:12:25,105 (TP-
> > Processor13) [ EntityExpr.java:267:WARN ] ---- exception report
> > ---------------------------------------------------------- =-=-=-=-=-
> > =-=-=-= DATABASE TYPE ERROR in EntityExpr =-=-=-=-=-=-=-=-= In
> > entity field [TaxAuthorityRateProduct.minItemPrice] set the value
> > passed in [java.math.BigDecimal] is not compatible with the Java
> > type of the field [Double] Exception: java.lang.Exception Message:
> > Location of database type error ---- stack trace
> > ---------------------------------------------------------------
> > java.lang.Exception: Location of database type error
> > org.ofbiz.entity.condition.EntityExpr.checkRhsType(EntityExpr.java:
> > 267)
> > org
> > .ofbiz.entity.condition.EntityExpr.makeWhereString(EntityExpr.java:
> > 167)
> > org
> > .ofbiz
> > .entity
> > .condition.EntityJoinOperator.addSqlValue(EntityJoinOperator.java:
> > 54)
> > org
> > .ofbiz.entity.condition.EntityExpr.makeWhereString(EntityExpr.java:
> > 170)
> > org
> > .ofbiz
> > .entity
> > .condition.EntityJoinOperator.addSqlValue(EntityJoinOperator.java:
> > 67)
> > org
> > .ofbiz
> > .entity
> > .condition
> > .EntityConditionListBase
> > .makeWhereString(EntityConditionListBase.java:89)
> > org
> > .ofbiz
> > .entity
> > .datasource.GenericDAO.selectListIteratorByCondition(GenericDAO.java:
> > 676)
> > org
> > .ofbiz
> > .entity
> > .datasource
> > .GenericHelperDAO.findListIteratorByCondition(GenericHelperDAO.java:
> > 140) org.ofbiz.entity.GenericDelegator.find(GenericDelegator.java:
> > 2273)
> > org.ofbiz.entity.GenericDelegator.findList(GenericDelegator.java:
> > 2314)
> > org
> > .ofbiz
> > .accounting
> > .tax
> > .TaxAuthorityServices.getTaxAdjustments(TaxAuthorityServices.java:
> > 309)
> > org
> > .ofbiz
> > .accounting
> > .tax
> > .TaxAuthorityServices.rateProductTaxCalc(TaxAuthorityServices.java:
> > 182) 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:585)
> > org
> > .ofbiz
> > .service
> > .engine.StandardJavaEngine.serviceInvoker(StandardJavaEngine.java:
> > 96)
> > org
> > .ofbiz
> > .service.engine.StandardJavaEngine.runSync(StandardJavaEngine.java:
> > 54)
> > org.ofbiz.service.ServiceDispatcher.runSync(ServiceDispatcher.java:
> > 384)
> > org.ofbiz.service.ServiceDispatcher.runSync(ServiceDispatcher.java:
> > 213)
> > org.ofbiz.service.GenericDispatcher.runSync(GenericDispatcher.java:
> > 149)
> > org
> > .ofbiz
> > .order
> > .shoppingcart.CheckOutHelper.getTaxAdjustments(CheckOutHelper.java:
> > 859)
> > org
> > .ofbiz
> > .order.shoppingcart.CheckOutHelper.calcAndAddTax(CheckOutHelper.java:
> > 764)
> >
> > ----- Original Message -----
> > From: "Scott Gray" <le...@gmail.com>
> > To: user@ofbiz.apache.org
> > Sent: Wednesday, December 3, 2008 7:23:13 PM (GMT-0700) America/Denver
> > Subject: Re: webpos - how to over ride price?
> >
> > oops, I missed the web part and thought we were talking about the
> > standard
> > pos.
> > Sorry, I don't know much about webpos
> >
> > Regards
> > Scott
> >
> > 2008/12/4 Vince M. Clark <vc...@globalera.com>
> >
> >> Nope. The price field on an item is not editable. If I go to
> >> Manager, then
> >> click on Modify Price I am presented with two fields, SKU and New
> >> Price.
> >> Selecting an item on the order makes no difference. If I enter the
> >> product
> >> code, for example GZ-1001, and a new price, then click Confirm,
> >> nothing
> >> happens.
> >>
> >> Note that I am trying this on demo.hotwaxmedia.com/webpos.
> >>
> >> ----- Original Message -----
> >> From: "Scott Gray" <le...@gmail.com>
> >> To: user@ofbiz.apache.org
> >> Sent: Wednesday, December 3, 2008 6:37:30 PM (GMT-0700) America/
> >> Denver
> >> Subject: Re: webpos - how to over ride price?
> >>
> >> It should work, a quick look at the code says that an item needs to
> >> be
> >> selected, a new price entered and then modify price pressed.
> >> Regards
> >> Scott
> >>
> >> 2008/12/4 Vince M. Clark <vc...@globalera.com>
> >>
> >>> I tried going to manager screen and using "Modify Price". Doesn't
> >>> seem to
> >>> do anything. Is there any way to over ride prices on the fly?
> >>>
> >>
>
>
cache and FTL and Timeout.
Posted by Fabien JALABERT <fa...@laposte.net>.
Hello, I've 2 questions on tuning ofbiz.
1) On a production site, the search page returns a list of numerous products (more than 200).
The main content view of the search result page call rendering of productsummary for each product in result set.
This view contains 2 calls:
- productsummary.bsh
- productsummary.ftl
I've put dates to make chrono in the productsummary. BSH execution needs only between 15 to 50 ms. But each execution of the bsh is separated with about 300 ms. So there seem to be a process that need 270ms between BSH: controler ? widget ? ftl ?
When I reload this page, using Shift+F5, the BSH has same duration (very fast) but no other process is done around.
Then I launch a new search and each summary need 300 ms.
So can somebody tell me what is done with in these 270ms and how to tune it like in the ShiftF5 approach ?
2) TIMEOUT
When a client request needs more that 60 sec. the DB links is off that many logs are displays (many thousands lines).
Do you know where I could configure this timeout to increase it ? Is this dangerous for production site ? Is there a solution to break display in console of these thousands of products.
Thanks a lot.
Re: webpos - how to over ride price?
Posted by "Vince M. Clark" <vc...@globalera.com>.
I realized after I posted this that it was just a warning. The process seems to complete, but the price is definitely not modified. I'll keep digging.
----- Original Message -----
From: "David E Jones" <da...@hotwaxmedia.com>
To: user@ofbiz.apache.org
Sent: Thursday, December 4, 2008 2:30:30 PM (GMT-0700) America/Denver
Subject: Re: webpos - how to over ride price?
Are you sure that's causing this problem? That's just a warning
message that doesn't stop the code from running (part of the effort to
move from Double to BigDecimal, for which there is a branch going
right now).
-David
On Dec 4, 2008, at 2:14 PM, Vince M. Clark wrote:
> I found the error causing the Modify Price process to fail in webpos.
>
>
> 2008-12-04 15:12:25,096 (TP-Processor13) [ WebPosTransaction.java:
> 175:INFO ] Modify item price 67890/22.0
> 2008-12-04 15:12:25,096 (TP-Processor13) [ WebPosTransaction.java:
> 180:INFO ] Item not found 67890 2008-12-04 15:12:25,105 (TP-
> Processor13) [ EntityExpr.java:267:WARN ] ---- exception report
> ---------------------------------------------------------- =-=-=-=-=-
> =-=-=-= DATABASE TYPE ERROR in EntityExpr =-=-=-=-=-=-=-=-= In
> entity field [TaxAuthorityRateProduct.minItemPrice] set the value
> passed in [java.math.BigDecimal] is not compatible with the Java
> type of the field [Double] Exception: java.lang.Exception Message:
> Location of database type error ---- stack trace
> ---------------------------------------------------------------
> java.lang.Exception: Location of database type error
> org.ofbiz.entity.condition.EntityExpr.checkRhsType(EntityExpr.java:
> 267)
> org
> .ofbiz.entity.condition.EntityExpr.makeWhereString(EntityExpr.java:
> 167)
> org
> .ofbiz
> .entity
> .condition.EntityJoinOperator.addSqlValue(EntityJoinOperator.java:
> 54)
> org
> .ofbiz.entity.condition.EntityExpr.makeWhereString(EntityExpr.java:
> 170)
> org
> .ofbiz
> .entity
> .condition.EntityJoinOperator.addSqlValue(EntityJoinOperator.java:
> 67)
> org
> .ofbiz
> .entity
> .condition
> .EntityConditionListBase
> .makeWhereString(EntityConditionListBase.java:89)
> org
> .ofbiz
> .entity
> .datasource.GenericDAO.selectListIteratorByCondition(GenericDAO.java:
> 676)
> org
> .ofbiz
> .entity
> .datasource
> .GenericHelperDAO.findListIteratorByCondition(GenericHelperDAO.java:
> 140) org.ofbiz.entity.GenericDelegator.find(GenericDelegator.java:
> 2273)
> org.ofbiz.entity.GenericDelegator.findList(GenericDelegator.java:
> 2314)
> org
> .ofbiz
> .accounting
> .tax
> .TaxAuthorityServices.getTaxAdjustments(TaxAuthorityServices.java:
> 309)
> org
> .ofbiz
> .accounting
> .tax
> .TaxAuthorityServices.rateProductTaxCalc(TaxAuthorityServices.java:
> 182) 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:585)
> org
> .ofbiz
> .service
> .engine.StandardJavaEngine.serviceInvoker(StandardJavaEngine.java:
> 96)
> org
> .ofbiz
> .service.engine.StandardJavaEngine.runSync(StandardJavaEngine.java:
> 54)
> org.ofbiz.service.ServiceDispatcher.runSync(ServiceDispatcher.java:
> 384)
> org.ofbiz.service.ServiceDispatcher.runSync(ServiceDispatcher.java:
> 213)
> org.ofbiz.service.GenericDispatcher.runSync(GenericDispatcher.java:
> 149)
> org
> .ofbiz
> .order
> .shoppingcart.CheckOutHelper.getTaxAdjustments(CheckOutHelper.java:
> 859)
> org
> .ofbiz
> .order.shoppingcart.CheckOutHelper.calcAndAddTax(CheckOutHelper.java:
> 764)
>
> ----- Original Message -----
> From: "Scott Gray" <le...@gmail.com>
> To: user@ofbiz.apache.org
> Sent: Wednesday, December 3, 2008 7:23:13 PM (GMT-0700) America/Denver
> Subject: Re: webpos - how to over ride price?
>
> oops, I missed the web part and thought we were talking about the
> standard
> pos.
> Sorry, I don't know much about webpos
>
> Regards
> Scott
>
> 2008/12/4 Vince M. Clark <vc...@globalera.com>
>
>> Nope. The price field on an item is not editable. If I go to
>> Manager, then
>> click on Modify Price I am presented with two fields, SKU and New
>> Price.
>> Selecting an item on the order makes no difference. If I enter the
>> product
>> code, for example GZ-1001, and a new price, then click Confirm,
>> nothing
>> happens.
>>
>> Note that I am trying this on demo.hotwaxmedia.com/webpos.
>>
>> ----- Original Message -----
>> From: "Scott Gray" <le...@gmail.com>
>> To: user@ofbiz.apache.org
>> Sent: Wednesday, December 3, 2008 6:37:30 PM (GMT-0700) America/
>> Denver
>> Subject: Re: webpos - how to over ride price?
>>
>> It should work, a quick look at the code says that an item needs to
>> be
>> selected, a new price entered and then modify price pressed.
>> Regards
>> Scott
>>
>> 2008/12/4 Vince M. Clark <vc...@globalera.com>
>>
>>> I tried going to manager screen and using "Modify Price". Doesn't
>>> seem to
>>> do anything. Is there any way to over ride prices on the fly?
>>>
>>
Re: webpos - how to over ride price?
Posted by David E Jones <da...@hotwaxmedia.com>.
Are you sure that's causing this problem? That's just a warning
message that doesn't stop the code from running (part of the effort to
move from Double to BigDecimal, for which there is a branch going
right now).
-David
On Dec 4, 2008, at 2:14 PM, Vince M. Clark wrote:
> I found the error causing the Modify Price process to fail in webpos.
>
>
> 2008-12-04 15:12:25,096 (TP-Processor13) [ WebPosTransaction.java:
> 175:INFO ] Modify item price 67890/22.0
> 2008-12-04 15:12:25,096 (TP-Processor13) [ WebPosTransaction.java:
> 180:INFO ] Item not found 67890 2008-12-04 15:12:25,105 (TP-
> Processor13) [ EntityExpr.java:267:WARN ] ---- exception report
> ---------------------------------------------------------- =-=-=-=-=-
> =-=-=-= DATABASE TYPE ERROR in EntityExpr =-=-=-=-=-=-=-=-= In
> entity field [TaxAuthorityRateProduct.minItemPrice] set the value
> passed in [java.math.BigDecimal] is not compatible with the Java
> type of the field [Double] Exception: java.lang.Exception Message:
> Location of database type error ---- stack trace
> ---------------------------------------------------------------
> java.lang.Exception: Location of database type error
> org.ofbiz.entity.condition.EntityExpr.checkRhsType(EntityExpr.java:
> 267)
> org
> .ofbiz.entity.condition.EntityExpr.makeWhereString(EntityExpr.java:
> 167)
> org
> .ofbiz
> .entity
> .condition.EntityJoinOperator.addSqlValue(EntityJoinOperator.java:
> 54)
> org
> .ofbiz.entity.condition.EntityExpr.makeWhereString(EntityExpr.java:
> 170)
> org
> .ofbiz
> .entity
> .condition.EntityJoinOperator.addSqlValue(EntityJoinOperator.java:
> 67)
> org
> .ofbiz
> .entity
> .condition
> .EntityConditionListBase
> .makeWhereString(EntityConditionListBase.java:89)
> org
> .ofbiz
> .entity
> .datasource.GenericDAO.selectListIteratorByCondition(GenericDAO.java:
> 676)
> org
> .ofbiz
> .entity
> .datasource
> .GenericHelperDAO.findListIteratorByCondition(GenericHelperDAO.java:
> 140) org.ofbiz.entity.GenericDelegator.find(GenericDelegator.java:
> 2273)
> org.ofbiz.entity.GenericDelegator.findList(GenericDelegator.java:
> 2314)
> org
> .ofbiz
> .accounting
> .tax
> .TaxAuthorityServices.getTaxAdjustments(TaxAuthorityServices.java:
> 309)
> org
> .ofbiz
> .accounting
> .tax
> .TaxAuthorityServices.rateProductTaxCalc(TaxAuthorityServices.java:
> 182) 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:585)
> org
> .ofbiz
> .service
> .engine.StandardJavaEngine.serviceInvoker(StandardJavaEngine.java:
> 96)
> org
> .ofbiz
> .service.engine.StandardJavaEngine.runSync(StandardJavaEngine.java:
> 54)
> org.ofbiz.service.ServiceDispatcher.runSync(ServiceDispatcher.java:
> 384)
> org.ofbiz.service.ServiceDispatcher.runSync(ServiceDispatcher.java:
> 213)
> org.ofbiz.service.GenericDispatcher.runSync(GenericDispatcher.java:
> 149)
> org
> .ofbiz
> .order
> .shoppingcart.CheckOutHelper.getTaxAdjustments(CheckOutHelper.java:
> 859)
> org
> .ofbiz
> .order.shoppingcart.CheckOutHelper.calcAndAddTax(CheckOutHelper.java:
> 764)
>
> ----- Original Message -----
> From: "Scott Gray" <le...@gmail.com>
> To: user@ofbiz.apache.org
> Sent: Wednesday, December 3, 2008 7:23:13 PM (GMT-0700) America/Denver
> Subject: Re: webpos - how to over ride price?
>
> oops, I missed the web part and thought we were talking about the
> standard
> pos.
> Sorry, I don't know much about webpos
>
> Regards
> Scott
>
> 2008/12/4 Vince M. Clark <vc...@globalera.com>
>
>> Nope. The price field on an item is not editable. If I go to
>> Manager, then
>> click on Modify Price I am presented with two fields, SKU and New
>> Price.
>> Selecting an item on the order makes no difference. If I enter the
>> product
>> code, for example GZ-1001, and a new price, then click Confirm,
>> nothing
>> happens.
>>
>> Note that I am trying this on demo.hotwaxmedia.com/webpos.
>>
>> ----- Original Message -----
>> From: "Scott Gray" <le...@gmail.com>
>> To: user@ofbiz.apache.org
>> Sent: Wednesday, December 3, 2008 6:37:30 PM (GMT-0700) America/
>> Denver
>> Subject: Re: webpos - how to over ride price?
>>
>> It should work, a quick look at the code says that an item needs to
>> be
>> selected, a new price entered and then modify price pressed.
>> Regards
>> Scott
>>
>> 2008/12/4 Vince M. Clark <vc...@globalera.com>
>>
>>> I tried going to manager screen and using "Modify Price". Doesn't
>>> seem to
>>> do anything. Is there any way to over ride prices on the fly?
>>>
>>
Re: webpos - how to over ride price?
Posted by "Vince M. Clark" <vc...@globalera.com>.
I found the error causing the Modify Price process to fail in webpos.
2008-12-04 15:12:25,096 (TP-Processor13) [ WebPosTransaction.java:175:INFO ] Modify item price 67890/22.0
2008-12-04 15:12:25,096 (TP-Processor13) [ WebPosTransaction.java:180:INFO ] Item not found 67890 2008-12-04 15:12:25,105 (TP-Processor13) [ EntityExpr.java:267:WARN ] ---- exception report ---------------------------------------------------------- =-=-=-=-=-=-=-=-= DATABASE TYPE ERROR in EntityExpr =-=-=-=-=-=-=-=-= In entity field [TaxAuthorityRateProduct.minItemPrice] set the value passed in [java.math.BigDecimal] is not compatible with the Java type of the field [Double] Exception: java.lang.Exception Message: Location of database type error ---- stack trace --------------------------------------------------------------- java.lang.Exception: Location of database type error org.ofbiz.entity.condition.EntityExpr.checkRhsType(EntityExpr.java:267) org.ofbiz.entity.condition.EntityExpr.makeWhereString(EntityExpr.java:167) org.ofbiz.entity.condition.EntityJoinOperator.addSqlValue(EntityJoinOperator.java:54) org.ofbiz.entity.condition.EntityExpr.makeWhereString(EntityExpr.java:170) org.ofbiz.entity.condition.EntityJoinOperator.addSqlValue(EntityJoinOperator.java:67) org.ofbiz.entity.condition.EntityConditionListBase.makeWhereString(EntityConditionListBase.java:89) org.ofbiz.entity.datasource.GenericDAO.selectListIteratorByCondition(GenericDAO.java:676) org.ofbiz.entity.datasource.GenericHelperDAO.findListIteratorByCondition(GenericHelperDAO.java:140) org.ofbiz.entity.GenericDelegator.find(GenericDelegator.java:2273) org.ofbiz.entity.GenericDelegator.findList(GenericDelegator.java:2314) org.ofbiz.accounting.tax.TaxAuthorityServices.getTaxAdjustments(TaxAuthorityServices.java:309) org.ofbiz.accounting.tax.TaxAuthorityServices.rateProductTaxCalc(TaxAuthorityServices.java:182) 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:585) org.ofbiz.service.engine.StandardJavaEngine.serviceInvoker(StandardJavaEngine.java:96) org.ofbiz.service.engine.StandardJavaEngine.runSync(StandardJavaEngine.java:54) org.ofbiz.service.ServiceDispatcher.runSync(ServiceDispatcher.java:384) org.ofbiz.service.ServiceDispatcher.runSync(ServiceDispatcher.java:213) org.ofbiz.service.GenericDispatcher.runSync(GenericDispatcher.java:149) org.ofbiz.order.shoppingcart.CheckOutHelper.getTaxAdjustments(CheckOutHelper.java:859) org.ofbiz.order.shoppingcart.CheckOutHelper.calcAndAddTax(CheckOutHelper.java:764)
----- Original Message -----
From: "Scott Gray" <le...@gmail.com>
To: user@ofbiz.apache.org
Sent: Wednesday, December 3, 2008 7:23:13 PM (GMT-0700) America/Denver
Subject: Re: webpos - how to over ride price?
oops, I missed the web part and thought we were talking about the standard
pos.
Sorry, I don't know much about webpos
Regards
Scott
2008/12/4 Vince M. Clark <vc...@globalera.com>
> Nope. The price field on an item is not editable. If I go to Manager, then
> click on Modify Price I am presented with two fields, SKU and New Price.
> Selecting an item on the order makes no difference. If I enter the product
> code, for example GZ-1001, and a new price, then click Confirm, nothing
> happens.
>
> Note that I am trying this on demo.hotwaxmedia.com/webpos.
>
> ----- Original Message -----
> From: "Scott Gray" <le...@gmail.com>
> To: user@ofbiz.apache.org
> Sent: Wednesday, December 3, 2008 6:37:30 PM (GMT-0700) America/Denver
> Subject: Re: webpos - how to over ride price?
>
> It should work, a quick look at the code says that an item needs to be
> selected, a new price entered and then modify price pressed.
> Regards
> Scott
>
> 2008/12/4 Vince M. Clark <vc...@globalera.com>
>
> > I tried going to manager screen and using "Modify Price". Doesn't seem to
> > do anything. Is there any way to over ride prices on the fly?
> >
>
Re: webpos - how to over ride price?
Posted by Scott Gray <le...@gmail.com>.
oops, I missed the web part and thought we were talking about the standard
pos.
Sorry, I don't know much about webpos
Regards
Scott
2008/12/4 Vince M. Clark <vc...@globalera.com>
> Nope. The price field on an item is not editable. If I go to Manager, then
> click on Modify Price I am presented with two fields, SKU and New Price.
> Selecting an item on the order makes no difference. If I enter the product
> code, for example GZ-1001, and a new price, then click Confirm, nothing
> happens.
>
> Note that I am trying this on demo.hotwaxmedia.com/webpos.
>
> ----- Original Message -----
> From: "Scott Gray" <le...@gmail.com>
> To: user@ofbiz.apache.org
> Sent: Wednesday, December 3, 2008 6:37:30 PM (GMT-0700) America/Denver
> Subject: Re: webpos - how to over ride price?
>
> It should work, a quick look at the code says that an item needs to be
> selected, a new price entered and then modify price pressed.
> Regards
> Scott
>
> 2008/12/4 Vince M. Clark <vc...@globalera.com>
>
> > I tried going to manager screen and using "Modify Price". Doesn't seem to
> > do anything. Is there any way to over ride prices on the fly?
> >
>
Re: webpos - how to over ride price?
Posted by "Vince M. Clark" <vc...@globalera.com>.
Nope. The price field on an item is not editable. If I go to Manager, then click on Modify Price I am presented with two fields, SKU and New Price. Selecting an item on the order makes no difference. If I enter the product code, for example GZ-1001, and a new price, then click Confirm, nothing happens.
Note that I am trying this on demo.hotwaxmedia.com/webpos.
----- Original Message -----
From: "Scott Gray" <le...@gmail.com>
To: user@ofbiz.apache.org
Sent: Wednesday, December 3, 2008 6:37:30 PM (GMT-0700) America/Denver
Subject: Re: webpos - how to over ride price?
It should work, a quick look at the code says that an item needs to be
selected, a new price entered and then modify price pressed.
Regards
Scott
2008/12/4 Vince M. Clark <vc...@globalera.com>
> I tried going to manager screen and using "Modify Price". Doesn't seem to
> do anything. Is there any way to over ride prices on the fly?
>
Re: webpos - how to over ride price?
Posted by Scott Gray <le...@gmail.com>.
It should work, a quick look at the code says that an item needs to be
selected, a new price entered and then modify price pressed.
Regards
Scott
2008/12/4 Vince M. Clark <vc...@globalera.com>
> I tried going to manager screen and using "Modify Price". Doesn't seem to
> do anything. Is there any way to over ride prices on the fly?
>