You are right, i apologize for having confused the troubleshooting. But still playing with the page of the Shopping List I have found that if I enter an invalid product code in the text box of the "Quick Add to shopping list" and press the "Add to Shopping List" button an unformatted error string is displayed as follow:
The Following Errors Occurred: ERROR: Could not complete the Create a ShoppingList Item [file:/opt/j2ee/domains/hotwaxmedia.com/demo/deployments/demo.hotwaxmedia.com/applications/order/script/org/ofbiz/order/shoppinglist/ShoppingListServices.xml#createShoppingListItem] process [problem creating the newEntity value: Error while inserting: [GenericEntity:ShoppingListItem][createdStamp,2008-03-07 14:45:50.442( java.sql.Timestamp)][createdTxStamp,2008-03-07 14:45:50.324( java.sql.Timestamp)][lastUpdatedStamp,2008-03-07 14:45:50.442( java.sql.Timestamp)][lastUpdatedTxStamp,2008-03-07 14:45:50.324( java.sql.Timestamp)][productId,qqq(java.lang.String)][quantity,1.0( java.lang.Double)][shoppingListId,10001(java.lang.String )][shoppingListItemSeqId,00004(java.lang.String)] (SQL Exception while executing the following:INSERT INTO OFBIZ.SHOPPING_LIST_ITEM(SHOPPING_LIST_ID, SHOPPING_LIST_ITEM_SEQ_ID, PRODUCT_ID, QUANTITY, RESERV_START, RESERV_LENGTH, RESERV_PERSONS, QUANTITY_PURCHASED, CONFIG_ID, LAST_UPDATED_STAMP, LAST_UPDATED_TX_STAMP, CREATED_STAMP, CREATED_TX_STAMP) VALUES (?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?) (INSERT on table 'SHOPPING_LIST_ITEM' caused a violation of foreign key constraint 'SHLIST_ITEM_PROD' for key (qqq). The statement has been rolled back.))] 2008/3/7, BJ Freeman <[EMAIL PROTECTED]>: > > your error is different than the previous reported error. > I would say not all data was put in the form > from this part of the error. > > > > [in-validate] got false for condition: > > [shippingMethodString][is-not-empty][true][String] > > ServiceEcaRule.java:127:INFO ] For Service ECA [updateShoppingList] > on > > [in-validate] got false for condition: > > [frequency][is-not-empty][true][String] > > > > Bruno Busco sent the following on 3/7/2008 12:20 AM: > > > Hi, > > i cannot save (create) a Shopping List as well. > > When i press the save button nothing happens. > > I agree with Vikas that having the revision label printed somewhere will > be > > a of great help. > > I am running trunk rev. 634426 and what i get in debug.log is the > following: > > > > > ---------------------------------------------------------------------------- > > CoyoteAdapter.java:403:DEBUG] Requested cookie session id is > > 49674BE0BDE845CB5FDCA4AF7B13D1D8.jvm1 > > StandardWrapper.java:804:TRACE] Returning non-STM instance > > ControlServlet.java:93 :INFO ] The character encoding of the request > is: > > [null]. The character encoding we will use for the request and response > is: > > [UTF-8] > > ControlServlet.java:126:DEBUG] [[[updateShoppingList] Servlet > Starting, > > doing setup- total:0.0,since last(Begin):0.0]] > > ControlServlet.java:185:DEBUG] [[[updateShoppingList] Setup done, > doing > > Event(s) and View(s)- total:0.0,since last([updateShoppingLi...):0.0]] > > UtilXml.java:241:DEBUG] XML Read 0.047s: > > jndi:/0.0.0.0/ecommerce/WEB-INF/controller.xml > > ConfigXMLReader.java:564:INFO ] ConfigMap Created: (5) records in 0.0s > > ConfigXMLReader.java:722:INFO ] HandlerMap Created: (4) view handlers > and > > (7) request/event handlers in 0.0s > > ConfigXMLReader.java:297:INFO ] RequestMap Created: (246) records in > > 0.016s > > ConfigXMLReader.java:391:INFO ] ViewMap Created: (89) records in 0.0s > > RequestHandler.java:243:INFO ] [Processing Request]: > updateShoppingList > > sessionId=49674BE0BDE845CB5FDCA4AF7B13D1D8.jvm1 > > ServiceEcaRule.java:127:INFO ] For Service ECA [updateShoppingList] > on > > [in-validate] got false for condition: > > [shippingMethodString][is-not-empty][true][String] > > ServiceEcaRule.java:127:INFO ] For Service ECA [updateShoppingList] > on > > [in-validate] got false for condition: > > [frequency][is-not-empty][true][String] > > WebappClassLoader.java:1049:DEBUG] > > getResource(org/ofbiz/order/shoppinglist/ShoppingListServices.xml) > > WebappClassLoader.java:927:DEBUG] > > findResource(org/ofbiz/order/shoppinglist/ShoppingListServices.xml) > > WebappClassLoader.java:946:DEBUG] --> Resource not found, returning > null > > WebappClassLoader.java:1099:DEBUG] --> Returning > > > 'file:/F:/ofbiz/applications/order/script/org/ofbiz/order/shoppinglist/ShoppingListServices.xml' > > UtilXml.java:241:DEBUG] XML Read 0.031s: > > > file:/F:/ofbiz/applications/order/script/org/ofbiz/order/shoppinglist/ShoppingListServices.xml > > RequestHandler.java:433:INFO ] [RequestHandler.doRequest]: Response > is a > > view. sessionId=49674BE0BDE845CB5FDCA4AF7B13D1D8.jvm1 > > RequestHandler.java:584:INFO ] servletName=control, > view=editShoppingList > > sessionId=49674BE0BDE845CB5FDCA4AF7B13D1D8.jvm1 > > UtilXml.java:241:DEBUG] XML Read 0.0s: > > file:/F:/ofbiz/applications/ecommerce/widget/ShoppingListScreens.xml > > ScreenFactory.java:118:INFO ] Got 1 screens in 0.016s from: > > file:/F:/ofbiz/applications/ecommerce/widget/ShoppingListScreens.xml > > UtilXml.java:241:DEBUG] XML Read 0.015s: > > file:/F:/ofbiz/applications/ecommerce/widget/CommonScreens.xml > > ScreenFactory.java:118:INFO ] Got 14 screens in 0.015s from: > > file:/F:/ofbiz/applications/ecommerce/widget/CommonScreens.xml > > UtilXml.java:241:DEBUG] XML Read 0.016s: > > file:/F:/ofbiz/applications/ecommerce/widget/CartScreens.xml > > ScreenFactory.java:118:INFO ] Got 7 screens in 0.016s from: > > file:/F:/ofbiz/applications/ecommerce/widget/CartScreens.xml > > ModelScreenWidget.java:463:INFO ] In the include-screen tag the screen > name > > was empty, ignoring include; in screen [main-decorator] > > UtilXml.java:241:DEBUG] XML Read 0.016s: > > file:/F:/ofbiz/applications/ecommerce/widget/CatalogScreens.xml > > ScreenFactory.java:118:INFO ] Got 26 screens in 0.016s from: > > file:/F:/ofbiz/applications/ecommerce/widget/CatalogScreens.xml > > UtilXml.java:241:DEBUG] XML Read 0.0s: > > file:/F:/ofbiz/applications/ecommerce/widget/ContentScreens.xml > > ScreenFactory.java:118:INFO ] Got 8 screens in 0.0s from: > > file:/F:/ofbiz/applications/ecommerce/widget/ContentScreens.xml > > WebappClassLoader.java:1239:DEBUG] loadClass( > > org.ofbiz.product.price.PriceServices, false) > > WebappClassLoader.java:1324:DEBUG] Searching local repositories > > WebappClassLoader.java:843:DEBUG] findClass( > > org.ofbiz.product.price.PriceServices) > > WebappClassLoader.java:871:TRACE] findClassInternal( > > org.ofbiz.product.price.PriceServices) > > WebappClassLoader.java:903:TRACE] --> Passing on > ClassNotFoundException > > WebappClassLoader.java:1341:DEBUG] Delegating to parent classloader at > > end: org.ofbiz.base.util.CachedClassLoader(__globalContext) / > > [EMAIL PROTECTED] > > WebappClassLoader.java:1349:DEBUG] Loading class from parent > > ControlServlet.java:291:DEBUG] [[[updateShoppingList] Done rendering > > page, Servlet Finished- total:0.5,since last([updateShoppingLi...):0.5]] > > > > > > > > 2008/3/7, Vikas Mayur <[EMAIL PROTECTED]>: > >> If its a revision before the fix goes in (that might be because it is > >> updated in some regular intervals, might be day or two or more), than I > am > >> not sure why this (creating shopping list) was working on the Demo > Site. > >> > >> IMO it would be good to have the revision number along with the label > >> Trunk > >> Demo and Release 4.0 Branch Demo so that it will help in testing things > >> against the Demo and that because most of the time we do (I do ...) > this > >> to > >> verify things if some things goes wrong on the local instance. > >> > >> > >> > >> Vikas > >> > >> > >> On Thu, Mar 6, 2008 at 11:49 PM, BJ Freeman <[EMAIL PROTECTED]> > wrote: > >> > >>> your are using a rev before the fix he put in. > >>> you code does not match the latest trunk used on the demo > >>> > >>> > >>> Vikas Mayur sent the following on 3/6/2008 5:51 AM: > >>>> Bilgin, Thanks for looking at it. > >>>> Tomorrow I will give it a try and let you know how it goes. > >>>> > >>>> I am not sure why this is working on Demo Ecommerce Site, if they run > >> on > >>>> latest trunk. > >>>> > >>>> Vikas > >>>> > >>>> On Thu, Mar 6, 2008 at 4:05 PM, Bilgin Ibryam <[EMAIL PROTECTED]> > >>> wrote: > >>>>> Hi Vikas, > >>>>> > >>>>> You can check rev630718 and OFBIZ-1590 for details about these new > >>>>> fields. > >>>>> > >>>>> I just committed a fix for it in rev634211. You can update and tell > >> me > >>>>> if the bug still exists. > >>>>> > >>>>> Regards, > >>>>> Bilgin Ibryam > >>>>> > >>>>> > >>> > > > >
