[OFBiz] Dev - is non-required inventory still working?
Locked
[OFBiz] Dev - is non-required inventory still working?
 
|
Re: [OFBiz] Dev - is non-required inventory still working? - minilang set
|
|
Re: [OFBiz] Dev - is non-required inventory still working? - minilang set
|
|
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 |