Posted by
Ray Barlow on
URL: http://ofbiz.116.s1.nabble.com/OFBiz-Dev-is-non-required-inventory-still-working-tp166093.html
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