http://ofbiz.116.s1.nabble.com/OFBiz-Dev-is-non-required-inventory-still-working-tp166093p166094.html
changes in the minilang. I have rolled back the changes made to two
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
applied to these two files has problems. I did review the SVN email for
> 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>