Thanks for responding Jacques. My trunk version is OOTB as well. Also, I haven't made any changes to all 3 versions to give me the same error message.
What do you mean when you say, "I just find that Cncld is not clear for Cancelled, I would > propose Cancld. (Cncld is not near to Incld)." ?? Do you have any ideas as to where to start looking for what the problem may be? >From the error messages in the log file and the webtools error message I can't make out a next step to uncover the problem. Also, this error message seems to point to a sql statement error but if that were true then others would be experiencing the same error. (ERROR: column "oh.order_date" must appear in the GROUP BY clause or be used in an aggregate function) (Sourced file:component://webtools/webapp/webtools/WEB-INF/actions/entity/FindGeneric .bsh: TargetError) (Error running BSH script at [component://webtools/webapp/webtools/WEB-INF/actions/entity/FindGeneric.bsh ], line [148]: Sourced file: component://webtools/webapp/webtools/WEB-INF/actions/entity/FindGeneric.bshT argetError : at Line: 148 : in file:component://webtools/webapp/webtools/WEB-INF/actions/entity/FindGeneric .bsh: throw e ; Thanks, Case Torres [EMAIL PROTECTED] > -----Original Message----- > From: Jacques Le Roux [mailto:[EMAIL PROTECTED] > Sent: Wednesday, February 20, 2008 2:50 AM > To: [email protected]; [EMAIL PROTECTED] > Subject: Re: getting same error message on 3 separate > revisions of ofbiz > > Tested locally, works well OOTB > > I get in PDF > > Purchases by Product Report > For Status: ORDER_CREATED > Product Store Id Facility Id TerminalId ProductId Product > Name Qty Qty Cncld > 9000 GZ-1000 Tiny Gizmo 1 > > I just find that Cncld is not clear for Cancelled, I would > propose Cancld. (Cncld is not near to Incld). Anway in french > will be Annulée :o) > > Jacques > > From: "Case Torres" <[EMAIL PROTECTED]> > > Hi, > > > > I've searched the mailing list but didn't find anything regarding > > these errors. If you have any clues to the problem I'd greatly > > appreciate your input. > > > > I have 2 development versions and 1 production version of ofbiz > > running on 3 separate machines. > > I receive the same error message when trying to run the > "Purchases by > > Organization Report" and I get an error message on all > three servers > > when trying to view the entity (thru webtools) > > OrderReportPurchasesGroupByProduct > > which is the entity used for this report. > > > > dev1 - trunk revision: 619674 > > dev2 - Release 4 Revision: 614387 > > Production - Release 4 Revision: 602199 > > > > I have quite a few orders in my production version but when > I try and > > run the order report, "Purchases by Organization Report" I get the > > following > > error: > > "No Order Found with ID." > > I get this same error on all 3 servers. > > > > The log file states: > > last([PurchasesByOrgan...):0.0]] > > 2008-02-19 16:38:58,185 (http-0.0.0.0-8443-Processor8) [ > > RequestHandler.java:236:INFO ] [Processing Request]: > > PurchasesByOrganizationReport.pdf > > sessionId=C3365D7933CD2949B5ED81D1657 > > 82485.jvm1 > > 2008-02-19 16:38:58,186 (http-0.0.0.0-8443-Processor8) [ > > RequestManager.java:116:INFO ] [RequestManager.getRequestAttribute] > > Value for attribute "null" of uri "PurchasesByOrganizati > onReport.pdf" > > not found > > 2008-02-19 16:38:58,187 (http-0.0.0.0-8443-Processor8) [ > > RequestHandler.java:425:INFO ] [RequestHandler.doRequest]: > Response is > > a view. sessionId=C3365D7933CD2949B5ED81D165782485.jv > > m1 > > 2008-02-19 16:38:58,188 (http-0.0.0.0-8443-Processor8) [ > > RequestHandler.java:578:INFO ] servletName=control, > > view=PurchasesByOrganizationReport > > sessionId=C3365D7933CD2949B5ED81D1657 > > 82485.jvm1 > > > > When trying to view the table, > OrderReportPurchasesGroupByProduct, I > > get an error message on: > > Production server: > > > > > > > > org.ofbiz.base.util.GeneralException: Error rendering screen > > [component://webtools/widget/EntityScreens.xml#FindGeneric]: > > org.ofbiz.base.util.GeneralException: Error running BSH script at > > location > > > [component://webtools/webapp/webtools/WEB-INF/actions/entity/FindGener > > ic.bsh > > ]: org.ofbiz.base.util.GeneralException: Error running BSH > script at > > > [component://webtools/webapp/webtools/WEB-INF/actions/entity/FindGener > > ic.bsh > > ], line [148]: Sourced file: > > > component://webtools/webapp/webtools/WEB-INF/actions/entity/FindGeneri > > c.bsh > > : TargetError : at Line: 148 : in file: > > > component://webtools/webapp/webtools/WEB-INF/actions/entity/FindGeneri > > c.bsh > > : throw e ; > > > > Target exception: org.ofbiz.entity.GenericDataSourceException: SQL > > Exception while executing the following:SELECT OI.PRODUCT_ID, > > PR.INTERNAL_NAME, OH.ORDER_DATE, OH.STATUS_ID, OI.STATUS_ID, > > OH.ORDER_TYPE_ID, RT.PARTY_ID, RT.ROLE_TYPE_ID, RF.PARTY_ID, > > RF.ROLE_TYPE_ID, SUM(OI.QUANTITY), > > SUM(OI.UNIT_PRICE) FROM (((public.ORDER_HEADER OH INNER JOIN > > public.ORDER_ITEM OI ON OH.ORDER_ID = OI.ORDER_ID) INNER JOIN > > public.ORDER_ROLE RT ON OH.ORDER_ID = RT.ORDER_ID) INNER JOIN > > public.ORDER_ROLE RF ON OH.ORDER_ID = RF.ORDER_ID) INNER JOIN > > public.PRODUCT PR ON OI.PRODUCT_ID = PR.PRODUCT_ID GROUP BY > > OI.PRODUCT_ID, PR.INTERNAL_NAME > > (ERROR: column "oh.order_date" must appear in the GROUP BY > clause or > > be used in an aggregate function) (Sourced file: > > > component://webtools/webapp/webtools/WEB-INF/actions/entity/FindGeneri > > c.bsh > > : TargetError) (Error running BSH script at > > > [component://webtools/webapp/webtools/WEB-INF/actions/entity/FindGener > > ic.bsh > > ], line [148]: Sourced file: > > > component://webtools/webapp/webtools/WEB-INF/actions/entity/FindGeneri > > c.bsh > > : TargetError : at Line: 148 : in file: > > > component://webtools/webapp/webtools/WEB-INF/actions/entity/FindGeneri > > c.bsh > > : throw e ; > > > > Target exception: org.ofbiz.entity.GenericDataSourceException: SQL > > Exception while executing the following:SELECT OI.PRODUCT_ID, > > PR.INTERNAL_NAME, OH.ORDER_DATE, OH.STATUS_ID, OI.STATUS_ID, > > OH.ORDER_TYPE_ID, RT.PARTY_ID, RT.ROLE_TYPE_ID, RF.PARTY_ID, > > RF.ROLE_TYPE_ID, SUM(OI.QUANTITY), > > SUM(OI.UNIT_PRICE) FROM (((public.ORDER_HEADER OH INNER JOIN > > public.ORDER_ITEM OI ON OH.ORDER_ID = OI.ORDER_ID) INNER JOIN > > public.ORDER_ROLE RT ON OH.ORDER_ID = RT.ORDER_ID) INNER JOIN > > public.ORDER_ROLE RF ON OH.ORDER_ID = RF.ORDER_ID) INNER JOIN > > public.PRODUCT PR ON OI.PRODUCT_ID = PR.PRODUCT_ID GROUP BY > > OI.PRODUCT_ID, PR.INTERNAL_NAME > > (ERROR: column "oh.order_date" must appear in the GROUP BY > clause or > > be used in an aggregate function) (Sourced file: > > > component://webtools/webapp/webtools/WEB-INF/actions/entity/FindGeneri > > c.bsh > > : TargetError)) (Error running BSH script at location > > > [component://webtools/webapp/webtools/WEB-INF/actions/entity/FindGener > > ic.bsh > > ]: org.ofbiz.base.util.GeneralException: Error running BSH > script at > > > [component://webtools/webapp/webtools/WEB-INF/actions/entity/FindGener > > ic.bsh > > ], line [148]: Sourced file: > > > component://webtools/webapp/webtools/WEB-INF/actions/entity/FindGeneri > > c.bsh > > : TargetError : at Line: 148 : in file: > > > component://webtools/webapp/webtools/WEB-INF/actions/entity/FindGeneri > > c.bsh > > : throw e ; > > > > Target exception: org.ofbiz.entity.GenericDataSourceException: SQL > > Exception while executing the following:SELECT OI.PRODUCT_ID, > > PR.INTERNAL_NAME, OH.ORDER_DATE, OH.STATUS_ID, OI.STATUS_ID, > > OH.ORDER_TYPE_ID, RT.PARTY_ID, RT.ROLE_TYPE_ID, RF.PARTY_ID, > > RF.ROLE_TYPE_ID, SUM(OI.QUANTITY), > > SUM(OI.UNIT_PRICE) FROM (((public.ORDER_HEADER OH INNER JOIN > > public.ORDER_ITEM OI ON OH.ORDER_ID = OI.ORDER_ID) INNER JOIN > > public.ORDER_ROLE RT ON OH.ORDER_ID = RT.ORDER_ID) INNER JOIN > > public.ORDER_ROLE RF ON OH.ORDER_ID = RF.ORDER_ID) INNER JOIN > > public.PRODUCT PR ON OI.PRODUCT_ID = PR.PRODUCT_ID GROUP BY > > OI.PRODUCT_ID, PR.INTERNAL_NAME > > (ERROR: column "oh.order_date" must appear in the GROUP BY > clause or > > be used in an aggregate function) (Sourced file: > > > component://webtools/webapp/webtools/WEB-INF/actions/entity/FindGeneri > > c.bsh > > : TargetError) (Error running BSH script at > > > [component://webtools/webapp/webtools/WEB-INF/actions/entity/FindGener > > ic.bsh > > ], line [148]: Sourced file: > > > component://webtools/webapp/webtools/WEB-INF/actions/entity/FindGeneri > > c.bsh > > : TargetError : at Line: 148 : in file: > > > component://webtools/webapp/webtools/WEB-INF/actions/entity/FindGeneri > > c.bsh > > : throw e ; > > > > Target exception: org.ofbiz.entity.GenericDataSourceException: SQL > > Exception while executing the following:SELECT OI.PRODUCT_ID, > > PR.INTERNAL_NAME, OH.ORDER_DATE, OH.STATUS_ID, OI.STATUS_ID, > > OH.ORDER_TYPE_ID, RT.PARTY_ID, RT.ROLE_TYPE_ID, RF.PARTY_ID, > > RF.ROLE_TYPE_ID, SUM(OI.QUANTITY), > > SUM(OI.UNIT_PRICE) FROM (((public.ORDER_HEADER OH INNER JOIN > > public.ORDER_ITEM OI ON OH.ORDER_ID = OI.ORDER_ID) INNER JOIN > > public.ORDER_ROLE RT ON OH.ORDER_ID = RT.ORDER_ID) INNER JOIN > > public.ORDER_ROLE RF ON OH.ORDER_ID = RF.ORDER_ID) INNER JOIN > > public.PRODUCT PR ON OI.PRODUCT_ID = PR.PRODUCT_ID GROUP BY > > OI.PRODUCT_ID, PR.INTERNAL_NAME > > (ERROR: column "oh.order_date" must appear in the GROUP BY > clause or > > be used in an aggregate function) (Sourced file: > > > component://webtools/webapp/webtools/WEB-INF/actions/entity/FindGeneri > > c.bsh > > : TargetError))) > > > > > > > > Thanks much, Case > > >
