Re: [OFBiz] Dev - is non-required inventory still working? - minilang set
Posted by David E. Jones on
URL: http://ofbiz.116.s1.nabble.com/OFBiz-Dev-is-non-required-inventory-still-working-tp166093p166095.html
Thanks for reporting this Ray. I figured out why this was happening:
the type attribute in widget-screen.xsd and simple-methods.xsd was
specified to default as "String", which as would be expected really
messes things up...
This is fixed in SVN revision 5842.
-David
On Sep 27, 2005, at 4:42 PM, Ray wrote:
> an update on my initial findings this seems related to the new set
> changes in the minilang. I have rolled back the changes made to two
> files in r5827
> trunk/applications/product/script/org/ofbiz/product/inventory/
> InventoryServices.xml
> trunk/applications/product/script/org/ofbiz/product/store/
> ProductStoreServices.xml
>
> and now I get the correct display in the product detail page i.e. a
> quantity field and "add to basket" button. Also following on from
> that product selection I was able to complete and checkout the order.
>
> So either the "set" stuff is not working in the minilang or the
> updates applied to these two files has problems. I did review the
> SVN email for that revision and it did not look wrong but I
> wouldn't claim to have much (any) understanding of the minilang
> stuff, I try to avoid it myself.
>
> Ray
>
>
> Ray wrote:
>
>
>> Hi,
>>
>> Just looking at the product detail page for items on a site and
>> they are showing "This item is out of stock." for a webstore that
>> has "Require Inventory" set to "N". I've justed updated the site
>> using the latest svn version and that's when the troubles started
>> (that'll teach me) and there's hardly any mods on the site.
>>
>> Checking against a clean svn version it also shows the same out of
>> stock message, for example see the product detail page for item
>> GZ-1004 from the Large Gizmos category. The online demo site does
>> not show the same message, either I've got two dubious sites or
>> that is not using the latest svn.
>>
>> Any clues?
>>
>> That leads me onto the second problem, which does only occur on my
>> upgraded site, so I could believe I've more work to do on my data,
>> which is that I can't complete the checkout process as it
>> complains about "out of stock items". Although I've not put any
>> stock into the system or enabled it in anyway, that I'm aware of,
>> I was planning to do that soon, just wanted to update the site
>> first. Log message is listed below and it implies problems with
>> the column type in the DB, but there are no outstanding warning/
>> error messages during start up for that table?!
>>
>> svn st doesn't show anything beyond the simple mods to config
>> files and a few look and feel tweaks.
>>
>> Ray
>>
>> org.apache.tomcat.util.threads.ThreadPool$ControlRunnable.run
>> (ThreadPool.java:684)
>> java.lang.Thread.run(Thread.java:534)
>> org.ofbiz.entity.GenericEntityException: while updating:
>> [GenericEntity:InventoryItem][availableToPromiseTotal,-1
>> (java.lang.String)][binNumber,null()][comments,null()]
>> [containerId,null()][createdStamp,2005-09-27 19:12:27.046
>> (java.sql.Timestamp)][createdTxStamp,2005-09-27 19:12:24.82
>> (java.sql.Timestamp)][datetimeReceived,null()][expireDate,null()]
>> [facilityId,WebStoreWarehouse(java.lang.String)][inventoryItemId,
>> 11291(java.lang.String)][inventoryItemTypeId,NON_SERIAL_INV_ITEM
>> (java.lang.String)][lastUpdatedStamp,2005-09-27 19:12:27.081
>> (java.sql.Timestamp)][lastUpdatedTxStamp,2005-09-27 19:12:24.82
>> (java.sql.Timestamp)][locationSeqId,null()][lotId,null()]
>> [oldAvailableToPromise,null()][oldQuantityOnHand,null()]
>> [partyId,null()][productId,1010894(java.lang.String)]
>> [quantityOnHandTotal,null()][serialNumber,null()][statusId,null()]
>> [unitCost,null()][uomId,null()] (SQL Exception while executing the
>> following:UPDATE public.INVENTORY_ITEM SET
>> INVENTORY_ITEM_TYPE_ID=?, PRODUCT_ID=?, PARTY_I!
>> D=?, STATUS_ID=?, DATETIME_RECEIVED=?, EXPIRE_DATE=?,
>> FACILITY_ID=?, CONTAINER_ID=?, LOT_ID=?, UOM_ID=?, BIN_NUMBER=?,
>> LOCATION_SEQ_ID=?, COMMENTS=?, QUANTITY_ON_HAND_TOTAL=?,
>> AVAILABLE_TO_PROMISE_TOTAL=?, QUANTITY_ON_HAND=?,
>> AVAILABLE_TO_PROMISE=?, SERIAL_NUMBER=?, UNIT_COST=?,
>> LAST_UPDATED_STAMP=?, LAST_UPDATED_TX_STAMP=?, CREATED_STAMP=?,
>> CREATED_TX_STAMP=? WHERE INVENTORY_ITEM_ID=? (ERROR: column
>> "available_to_promise_total" is of type double precision but
>> expression is of type character varying))
>> org.ofbiz.entity.datasource.GenericDAO.singleUpdate
>> (GenericDAO.java:297)
>> org.ofbiz.entity.datasource.GenericDAO.customUpdate
>> (GenericDAO.java:236)
>> org.ofbiz.entity.datasource.GenericDAO.update(GenericDAO.java:230)
>> org.ofbiz.entity.datasource.GenericHelperDAO.store
>> (GenericHelperDAO.java:185)
>> org.ofbiz.entity.GenericDelegator.store(GenericDelegator.java:1018)
>> org.ofbiz.minilang.method.entityops.StoreValue.exec
>> (StoreValue.java:74)
>> org.ofbiz.minilang.SimpleMethod.runSubOps(SimpleMethod.java:927)
>> org.ofbiz.minilang.SimpleMethod.exec(SimpleMethod.java:569)
>> org.ofbiz.minilang.SimpleMethod.runSimpleMethod(SimpleMethod.java:
>> 116)
>> org.ofbiz.minilang.SimpleMethod.runSimpleService(SimpleMethod.java:
>> 98)
>> org.ofbiz.minilang.SimpleServiceEngine.serviceInvoker
>> (SimpleServiceEngine.java:86)
>> org.ofbiz.minilang.SimpleServiceEngine.runSync
>> (SimpleServiceEngine.java:61)
>> org.ofbiz.service.ServiceDispatcher.runSync(ServiceDispatcher.java:
>> 339)
>> org.ofbiz.service.ServiceDispatcher.runSync(ServiceDispatcher.java:
>> 213)
>> org.ofbiz.service.GenericDispatcher.runSync(GenericDispatcher.java:
>> 110)
>> org.ofbiz.entityext.eca.EntityEcaAction.runAction
>> (EntityEcaAction.java:103)
>> org.ofbiz.entityext.eca.EntityEcaRule.eval(EntityEcaRule.java:123)
>> org.ofbiz.entityext.eca.DelegatorEcaHandler.evalRules
>> (DelegatorEcaHandler.java:96)
>> org.ofbiz.entity.GenericDelegator.evalEcaRules
>> (GenericDelegator.java:2429)
>> org.ofbiz.entity.GenericDelegator.create(GenericDelegator.java:596)
>> org.ofbiz.minilang.method.entityops.CreateValue.exec
>> (CreateValue.java:73)
>> org.ofbiz.minilang.SimpleMethod.runSubOps(SimpleMethod.java:927)
>> org.ofbiz.minilang.SimpleMethod.exec(SimpleMethod.java:569)
>> org.ofbiz.minilang.SimpleMethod.runSimpleMethod(SimpleMethod.java:
>> 116)
>> org.ofbiz.minilang.SimpleMethod.runSimpleService(SimpleMethod.java:
>> 98)
>> org.ofbiz.minilang.SimpleServiceEngine.serviceInvoker
>> (SimpleServiceEngine.java:86)
>> org.ofbiz.minilang.SimpleServiceEngine.runSync
>> (SimpleServiceEngine.java:61)
>> org.ofbiz.service.ServiceDispatcher.runSync(ServiceDispatcher.java:
>> 339)
>> org.ofbiz.service.ServiceDispatcher.runSync(ServiceDispatcher.java:
>> 213)
>> org.ofbiz.service.GenericDispatcher.runSync(GenericDispatcher.java:
>> 110)
>> org.ofbiz.minilang.method.callops.CallService.exec
>> (CallService.java:218)
>> org.ofbiz.minilang.SimpleMethod.runSubOps(SimpleMethod.java:927)
>> org.ofbiz.minilang.method.ifops.IfNotEmpty.exec(IfNotEmpty.java:97)
>> org.ofbiz.minilang.SimpleMethod.runSubOps(SimpleMethod.java:927)
>> org.ofbiz.minilang.method.ifops.IfCompare.exec(IfCompare.java:128)
>> org.ofbiz.minilang.SimpleMethod.runSubOps(SimpleMethod.java:927)
>> org.ofbiz.minilang.method.ifops.IfCompare.exec(IfCompare.java:125)
>> org.ofbiz.minilang.SimpleMethod.runSubOps(SimpleMethod.java:927)
>> org.ofbiz.minilang.SimpleMethod.exec(SimpleMethod.java:569)
>> org.ofbiz.minilang.SimpleMethod.runSimpleMethod(SimpleMethod.java:
>> 116)
>> org.ofbiz.minilang.SimpleMethod.runSimpleService(SimpleMethod.java:
>> 98)
>> org.ofbiz.minilang.SimpleServiceEngine.serviceInvoker
>> (SimpleServiceEngine.java:86)
>> org.ofbiz.minilang.SimpleServiceEngine.runSync
>> (SimpleServiceEngine.java:61)
>> org.ofbiz.service.ServiceDispatcher.runSync(ServiceDispatcher.java:
>> 339)
>> org.ofbiz.service.ServiceDispatcher.runSync(ServiceDispatcher.java:
>> 213)
>> org.ofbiz.service.GenericDispatcher.runSync(GenericDispatcher.java:
>> 110)
>> org.ofbiz.minilang.method.callops.CallService.exec
>> (CallService.java:218)
>> org.ofbiz.minilang.SimpleMethod.runSubOps(SimpleMethod.java:927)
>> org.ofbiz.minilang.method.ifops.IfCompare.exec(IfCompare.java:125)
>> org.ofbiz.minilang.SimpleMethod.runSubOps(SimpleMethod.java:927)
>> org.ofbiz.minilang.SimpleMethod.exec(SimpleMethod.java:569)
>> org.ofbiz.minilang.SimpleMethod.runSimpleMethod(SimpleMethod.java:
>> 116)
>> org.ofbiz.minilang.SimpleMethod.runSimpleService(SimpleMethod.java:
>> 98)
>> org.ofbiz.minilang.SimpleServiceEngine.serviceInvoker
>> (SimpleServiceEngine.java:86)
>> org.ofbiz.minilang.SimpleServiceEngine.runSync
>> (SimpleServiceEngine.java:61)
>> org.ofbiz.service.ServiceDispatcher.runSync(ServiceDispatcher.java:
>> 339)
>> org.ofbiz.service.ServiceDispatcher.runSync(ServiceDispatcher.java:
>> 213)
>> org.ofbiz.service.GenericDispatcher.runSync(GenericDispatcher.java:
>> 110)
>> org.ofbiz.order.order.OrderServices.reserveInventory
>> (OrderServices.java:932)
>> org.ofbiz.order.order.OrderServices.createOrder(OrderServices.java:
>> 869)
>> 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:324)
>> org.ofbiz.service.engine.StandardJavaEngine.serviceInvoker
>> (StandardJavaEngine.java:101)
>> org.ofbiz.service.engine.StandardJavaEngine.runSync
>> (StandardJavaEngine.java:63)
>> org.ofbiz.service.ServiceDispatcher.runSync(ServiceDispatcher.java:
>> 339)
>> org.ofbiz.service.ServiceDispatcher.runSync(ServiceDispatcher.java:
>> 213)
>> org.ofbiz.service.GenericDispatcher.runSync(GenericDispatcher.java:
>> 110)
>> org.ofbiz.order.shoppingcart.CheckOutHelper.createOrder
>> (CheckOutHelper.java:511)
>> org.ofbiz.order.shoppingcart.CheckOutEvents.createOrder
>> (CheckOutEvents.java:382)
>> 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:324)
>> org.ofbiz.webapp.event.JavaEventHandler.invoke
>> (JavaEventHandler.java:99)
>> org.ofbiz.webapp.event.JavaEventHandler.invoke
>> (JavaEventHandler.java:85)
>> org.ofbiz.webapp.control.RequestHandler.runEvent
>> (RequestHandler.java:393)
>> org.ofbiz.webapp.control.RequestHandler.doRequest
>> (RequestHandler.java:250)
>> org.ofbiz.webapp.control.ControlServlet.doGet(ControlServlet.java:
>> 191)
>> javax.servlet.http.HttpServlet.service(HttpServlet.java:689)
>> 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.jk.server.JkCoyoteHandler.invoke(JkCoyoteHandler.java:307)
>> org.apache.jk.common.HandlerRequest.invoke(HandlerRequest.java:385)
>> org.apache.jk.common.ChannelSocket.invoke(ChannelSocket.java:748)
>> org.apache.jk.common.ChannelSocket.processConnection
>> (ChannelSocket.java:678)
>> org.apache.jk.common.SocketConnection.runIt(ChannelSocket.java:871)
>> org.apache.tomcat.util.threads.ThreadPool$ControlRunnable.run
>> (ThreadPool.java:684)
>> java.lang.Thread.run(Thread.java:534)
>> org.ofbiz.entity.GenericDataSourceException: SQL Exception while
>> executing the following:UPDATE public.INVENTORY_ITEM SET
>> INVENTORY_ITEM_TYPE_ID=?, PRODUCT_ID=?, PARTY_ID=?, STATUS_ID=?,
>> DATETIME_RECEIVED=?, EXPIRE_DATE=?, FACILITY_ID=?, CONTAINER_ID=?,
>> LOT_ID=?, UOM_ID=?, BIN_NUMBER=?, LOCATION_SEQ_ID=?, COMMENTS=?,
>> QUANTITY_ON_HAND_TOTAL=?, AVAILABLE_TO_PROMISE_TOTAL=?,
>> QUANTITY_ON_HAND=?, AVAILABLE_TO_PROMISE=?, SERIAL_NUMBER=?,
>> UNIT_COST=?, LAST_UPDATED_STAMP=?, LAST_UPDATED_TX_STAMP=?,
>> CREATED_STAMP=?, CREATED_TX_STAMP=? WHERE INVENTORY_ITEM_ID=?
>> (ERROR: column "available_to_promise_total" is of type double
>> precision but expression is of type character varying)
>> org.ofbiz.entity.jdbc.SQLProcessor.executeUpdate(SQLProcessor.java:
>> 438)
>> org.ofbiz.entity.datasource.GenericDAO.singleUpdate
>> (GenericDAO.java:294)
>> org.ofbiz.entity.datasource.GenericDAO.customUpdate
>> (GenericDAO.java:236)
>> org.ofbiz.entity.datasource.GenericDAO.update(GenericDAO.java:230)
>> org.ofbiz.entity.datasource.GenericHelperDAO.store
>> (GenericHelperDAO.java:185)
>> org.ofbiz.entity.GenericDelegator.store(GenericDelegator.java:1018)
>> org.ofbiz.minilang.method.entityops.StoreValue.exec
>> (StoreValue.java:74)
>> org.ofbiz.minilang.SimpleMethod.runSubOps(SimpleMethod.java:927)
>> org.ofbiz.minilang.SimpleMethod.exec(SimpleMethod.java:569)
>>
>>
>>
>>
>> _______________________________________________
>> Dev mailing list
>> [hidden email]
>> http://lists.ofbiz.org/mailman/listinfo/dev
>>
>>
> _______________________________________________
> Dev mailing list
> [hidden email]
> http://lists.ofbiz.org/mailman/listinfo/dev
>
_______________________________________________
Dev mailing list
[hidden email]
http://lists.ofbiz.org/mailman/listinfo/dev
URL: http://ofbiz.116.s1.nabble.com/OFBiz-Dev-is-non-required-inventory-still-working-tp166093p166095.html
Thanks for reporting this Ray. I figured out why this was happening:
the type attribute in widget-screen.xsd and simple-methods.xsd was
specified to default as "String", which as would be expected really
messes things up...
This is fixed in SVN revision 5842.
-David
On Sep 27, 2005, at 4:42 PM, Ray wrote:
> an update on my initial findings this seems related to the new set
> changes in the minilang. I have rolled back the changes made to two
> files in r5827
> trunk/applications/product/script/org/ofbiz/product/inventory/
> InventoryServices.xml
> trunk/applications/product/script/org/ofbiz/product/store/
> ProductStoreServices.xml
>
> and now I get the correct display in the product detail page i.e. a
> quantity field and "add to basket" button. Also following on from
> that product selection I was able to complete and checkout the order.
>
> So either the "set" stuff is not working in the minilang or the
> updates applied to these two files has problems. I did review the
> SVN email for that revision and it did not look wrong but I
> wouldn't claim to have much (any) understanding of the minilang
> stuff, I try to avoid it myself.
>
> Ray
>
>
> Ray wrote:
>
>
>> Hi,
>>
>> Just looking at the product detail page for items on a site and
>> they are showing "This item is out of stock." for a webstore that
>> has "Require Inventory" set to "N". I've justed updated the site
>> using the latest svn version and that's when the troubles started
>> (that'll teach me) and there's hardly any mods on the site.
>>
>> Checking against a clean svn version it also shows the same out of
>> stock message, for example see the product detail page for item
>> GZ-1004 from the Large Gizmos category. The online demo site does
>> not show the same message, either I've got two dubious sites or
>> that is not using the latest svn.
>>
>> Any clues?
>>
>> That leads me onto the second problem, which does only occur on my
>> upgraded site, so I could believe I've more work to do on my data,
>> which is that I can't complete the checkout process as it
>> complains about "out of stock items". Although I've not put any
>> stock into the system or enabled it in anyway, that I'm aware of,
>> I was planning to do that soon, just wanted to update the site
>> first. Log message is listed below and it implies problems with
>> the column type in the DB, but there are no outstanding warning/
>> error messages during start up for that table?!
>>
>> svn st doesn't show anything beyond the simple mods to config
>> files and a few look and feel tweaks.
>>
>> Ray
>>
>> org.apache.tomcat.util.threads.ThreadPool$ControlRunnable.run
>> (ThreadPool.java:684)
>> java.lang.Thread.run(Thread.java:534)
>> org.ofbiz.entity.GenericEntityException: while updating:
>> [GenericEntity:InventoryItem][availableToPromiseTotal,-1
>> (java.lang.String)][binNumber,null()][comments,null()]
>> [containerId,null()][createdStamp,2005-09-27 19:12:27.046
>> (java.sql.Timestamp)][createdTxStamp,2005-09-27 19:12:24.82
>> (java.sql.Timestamp)][datetimeReceived,null()][expireDate,null()]
>> [facilityId,WebStoreWarehouse(java.lang.String)][inventoryItemId,
>> 11291(java.lang.String)][inventoryItemTypeId,NON_SERIAL_INV_ITEM
>> (java.lang.String)][lastUpdatedStamp,2005-09-27 19:12:27.081
>> (java.sql.Timestamp)][lastUpdatedTxStamp,2005-09-27 19:12:24.82
>> (java.sql.Timestamp)][locationSeqId,null()][lotId,null()]
>> [oldAvailableToPromise,null()][oldQuantityOnHand,null()]
>> [partyId,null()][productId,1010894(java.lang.String)]
>> [quantityOnHandTotal,null()][serialNumber,null()][statusId,null()]
>> [unitCost,null()][uomId,null()] (SQL Exception while executing the
>> following:UPDATE public.INVENTORY_ITEM SET
>> INVENTORY_ITEM_TYPE_ID=?, PRODUCT_ID=?, PARTY_I!
>> D=?, STATUS_ID=?, DATETIME_RECEIVED=?, EXPIRE_DATE=?,
>> FACILITY_ID=?, CONTAINER_ID=?, LOT_ID=?, UOM_ID=?, BIN_NUMBER=?,
>> LOCATION_SEQ_ID=?, COMMENTS=?, QUANTITY_ON_HAND_TOTAL=?,
>> AVAILABLE_TO_PROMISE_TOTAL=?, QUANTITY_ON_HAND=?,
>> AVAILABLE_TO_PROMISE=?, SERIAL_NUMBER=?, UNIT_COST=?,
>> LAST_UPDATED_STAMP=?, LAST_UPDATED_TX_STAMP=?, CREATED_STAMP=?,
>> CREATED_TX_STAMP=? WHERE INVENTORY_ITEM_ID=? (ERROR: column
>> "available_to_promise_total" is of type double precision but
>> expression is of type character varying))
>> org.ofbiz.entity.datasource.GenericDAO.singleUpdate
>> (GenericDAO.java:297)
>> org.ofbiz.entity.datasource.GenericDAO.customUpdate
>> (GenericDAO.java:236)
>> org.ofbiz.entity.datasource.GenericDAO.update(GenericDAO.java:230)
>> org.ofbiz.entity.datasource.GenericHelperDAO.store
>> (GenericHelperDAO.java:185)
>> org.ofbiz.entity.GenericDelegator.store(GenericDelegator.java:1018)
>> org.ofbiz.minilang.method.entityops.StoreValue.exec
>> (StoreValue.java:74)
>> org.ofbiz.minilang.SimpleMethod.runSubOps(SimpleMethod.java:927)
>> org.ofbiz.minilang.SimpleMethod.exec(SimpleMethod.java:569)
>> org.ofbiz.minilang.SimpleMethod.runSimpleMethod(SimpleMethod.java:
>> 116)
>> org.ofbiz.minilang.SimpleMethod.runSimpleService(SimpleMethod.java:
>> 98)
>> org.ofbiz.minilang.SimpleServiceEngine.serviceInvoker
>> (SimpleServiceEngine.java:86)
>> org.ofbiz.minilang.SimpleServiceEngine.runSync
>> (SimpleServiceEngine.java:61)
>> org.ofbiz.service.ServiceDispatcher.runSync(ServiceDispatcher.java:
>> 339)
>> org.ofbiz.service.ServiceDispatcher.runSync(ServiceDispatcher.java:
>> 213)
>> org.ofbiz.service.GenericDispatcher.runSync(GenericDispatcher.java:
>> 110)
>> org.ofbiz.entityext.eca.EntityEcaAction.runAction
>> (EntityEcaAction.java:103)
>> org.ofbiz.entityext.eca.EntityEcaRule.eval(EntityEcaRule.java:123)
>> org.ofbiz.entityext.eca.DelegatorEcaHandler.evalRules
>> (DelegatorEcaHandler.java:96)
>> org.ofbiz.entity.GenericDelegator.evalEcaRules
>> (GenericDelegator.java:2429)
>> org.ofbiz.entity.GenericDelegator.create(GenericDelegator.java:596)
>> org.ofbiz.minilang.method.entityops.CreateValue.exec
>> (CreateValue.java:73)
>> org.ofbiz.minilang.SimpleMethod.runSubOps(SimpleMethod.java:927)
>> org.ofbiz.minilang.SimpleMethod.exec(SimpleMethod.java:569)
>> org.ofbiz.minilang.SimpleMethod.runSimpleMethod(SimpleMethod.java:
>> 116)
>> org.ofbiz.minilang.SimpleMethod.runSimpleService(SimpleMethod.java:
>> 98)
>> org.ofbiz.minilang.SimpleServiceEngine.serviceInvoker
>> (SimpleServiceEngine.java:86)
>> org.ofbiz.minilang.SimpleServiceEngine.runSync
>> (SimpleServiceEngine.java:61)
>> org.ofbiz.service.ServiceDispatcher.runSync(ServiceDispatcher.java:
>> 339)
>> org.ofbiz.service.ServiceDispatcher.runSync(ServiceDispatcher.java:
>> 213)
>> org.ofbiz.service.GenericDispatcher.runSync(GenericDispatcher.java:
>> 110)
>> org.ofbiz.minilang.method.callops.CallService.exec
>> (CallService.java:218)
>> org.ofbiz.minilang.SimpleMethod.runSubOps(SimpleMethod.java:927)
>> org.ofbiz.minilang.method.ifops.IfNotEmpty.exec(IfNotEmpty.java:97)
>> org.ofbiz.minilang.SimpleMethod.runSubOps(SimpleMethod.java:927)
>> org.ofbiz.minilang.method.ifops.IfCompare.exec(IfCompare.java:128)
>> org.ofbiz.minilang.SimpleMethod.runSubOps(SimpleMethod.java:927)
>> org.ofbiz.minilang.method.ifops.IfCompare.exec(IfCompare.java:125)
>> org.ofbiz.minilang.SimpleMethod.runSubOps(SimpleMethod.java:927)
>> org.ofbiz.minilang.SimpleMethod.exec(SimpleMethod.java:569)
>> org.ofbiz.minilang.SimpleMethod.runSimpleMethod(SimpleMethod.java:
>> 116)
>> org.ofbiz.minilang.SimpleMethod.runSimpleService(SimpleMethod.java:
>> 98)
>> org.ofbiz.minilang.SimpleServiceEngine.serviceInvoker
>> (SimpleServiceEngine.java:86)
>> org.ofbiz.minilang.SimpleServiceEngine.runSync
>> (SimpleServiceEngine.java:61)
>> org.ofbiz.service.ServiceDispatcher.runSync(ServiceDispatcher.java:
>> 339)
>> org.ofbiz.service.ServiceDispatcher.runSync(ServiceDispatcher.java:
>> 213)
>> org.ofbiz.service.GenericDispatcher.runSync(GenericDispatcher.java:
>> 110)
>> org.ofbiz.minilang.method.callops.CallService.exec
>> (CallService.java:218)
>> org.ofbiz.minilang.SimpleMethod.runSubOps(SimpleMethod.java:927)
>> org.ofbiz.minilang.method.ifops.IfCompare.exec(IfCompare.java:125)
>> org.ofbiz.minilang.SimpleMethod.runSubOps(SimpleMethod.java:927)
>> org.ofbiz.minilang.SimpleMethod.exec(SimpleMethod.java:569)
>> org.ofbiz.minilang.SimpleMethod.runSimpleMethod(SimpleMethod.java:
>> 116)
>> org.ofbiz.minilang.SimpleMethod.runSimpleService(SimpleMethod.java:
>> 98)
>> org.ofbiz.minilang.SimpleServiceEngine.serviceInvoker
>> (SimpleServiceEngine.java:86)
>> org.ofbiz.minilang.SimpleServiceEngine.runSync
>> (SimpleServiceEngine.java:61)
>> org.ofbiz.service.ServiceDispatcher.runSync(ServiceDispatcher.java:
>> 339)
>> org.ofbiz.service.ServiceDispatcher.runSync(ServiceDispatcher.java:
>> 213)
>> org.ofbiz.service.GenericDispatcher.runSync(GenericDispatcher.java:
>> 110)
>> org.ofbiz.order.order.OrderServices.reserveInventory
>> (OrderServices.java:932)
>> org.ofbiz.order.order.OrderServices.createOrder(OrderServices.java:
>> 869)
>> 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:324)
>> org.ofbiz.service.engine.StandardJavaEngine.serviceInvoker
>> (StandardJavaEngine.java:101)
>> org.ofbiz.service.engine.StandardJavaEngine.runSync
>> (StandardJavaEngine.java:63)
>> org.ofbiz.service.ServiceDispatcher.runSync(ServiceDispatcher.java:
>> 339)
>> org.ofbiz.service.ServiceDispatcher.runSync(ServiceDispatcher.java:
>> 213)
>> org.ofbiz.service.GenericDispatcher.runSync(GenericDispatcher.java:
>> 110)
>> org.ofbiz.order.shoppingcart.CheckOutHelper.createOrder
>> (CheckOutHelper.java:511)
>> org.ofbiz.order.shoppingcart.CheckOutEvents.createOrder
>> (CheckOutEvents.java:382)
>> 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:324)
>> org.ofbiz.webapp.event.JavaEventHandler.invoke
>> (JavaEventHandler.java:99)
>> org.ofbiz.webapp.event.JavaEventHandler.invoke
>> (JavaEventHandler.java:85)
>> org.ofbiz.webapp.control.RequestHandler.runEvent
>> (RequestHandler.java:393)
>> org.ofbiz.webapp.control.RequestHandler.doRequest
>> (RequestHandler.java:250)
>> org.ofbiz.webapp.control.ControlServlet.doGet(ControlServlet.java:
>> 191)
>> javax.servlet.http.HttpServlet.service(HttpServlet.java:689)
>> 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.jk.server.JkCoyoteHandler.invoke(JkCoyoteHandler.java:307)
>> org.apache.jk.common.HandlerRequest.invoke(HandlerRequest.java:385)
>> org.apache.jk.common.ChannelSocket.invoke(ChannelSocket.java:748)
>> org.apache.jk.common.ChannelSocket.processConnection
>> (ChannelSocket.java:678)
>> org.apache.jk.common.SocketConnection.runIt(ChannelSocket.java:871)
>> org.apache.tomcat.util.threads.ThreadPool$ControlRunnable.run
>> (ThreadPool.java:684)
>> java.lang.Thread.run(Thread.java:534)
>> org.ofbiz.entity.GenericDataSourceException: SQL Exception while
>> executing the following:UPDATE public.INVENTORY_ITEM SET
>> INVENTORY_ITEM_TYPE_ID=?, PRODUCT_ID=?, PARTY_ID=?, STATUS_ID=?,
>> DATETIME_RECEIVED=?, EXPIRE_DATE=?, FACILITY_ID=?, CONTAINER_ID=?,
>> LOT_ID=?, UOM_ID=?, BIN_NUMBER=?, LOCATION_SEQ_ID=?, COMMENTS=?,
>> QUANTITY_ON_HAND_TOTAL=?, AVAILABLE_TO_PROMISE_TOTAL=?,
>> QUANTITY_ON_HAND=?, AVAILABLE_TO_PROMISE=?, SERIAL_NUMBER=?,
>> UNIT_COST=?, LAST_UPDATED_STAMP=?, LAST_UPDATED_TX_STAMP=?,
>> CREATED_STAMP=?, CREATED_TX_STAMP=? WHERE INVENTORY_ITEM_ID=?
>> (ERROR: column "available_to_promise_total" is of type double
>> precision but expression is of type character varying)
>> org.ofbiz.entity.jdbc.SQLProcessor.executeUpdate(SQLProcessor.java:
>> 438)
>> org.ofbiz.entity.datasource.GenericDAO.singleUpdate
>> (GenericDAO.java:294)
>> org.ofbiz.entity.datasource.GenericDAO.customUpdate
>> (GenericDAO.java:236)
>> org.ofbiz.entity.datasource.GenericDAO.update(GenericDAO.java:230)
>> org.ofbiz.entity.datasource.GenericHelperDAO.store
>> (GenericHelperDAO.java:185)
>> org.ofbiz.entity.GenericDelegator.store(GenericDelegator.java:1018)
>> org.ofbiz.minilang.method.entityops.StoreValue.exec
>> (StoreValue.java:74)
>> org.ofbiz.minilang.SimpleMethod.runSubOps(SimpleMethod.java:927)
>> org.ofbiz.minilang.SimpleMethod.exec(SimpleMethod.java:569)
>>
>>
>>
>>
>> _______________________________________________
>> Dev mailing list
>> [hidden email]
>> http://lists.ofbiz.org/mailman/listinfo/dev
>>
>>
> _______________________________________________
> Dev mailing list
> [hidden email]
> http://lists.ofbiz.org/mailman/listinfo/dev
>
_______________________________________________
Dev mailing list
[hidden email]
http://lists.ofbiz.org/mailman/listinfo/dev
smime.p7s (3K) | Free forum by Nabble | Edit this page |