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/FindGeneric.bsh ]: org.ofbiz.base.util.GeneralException: 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.bsh : TargetError : at Line: 148 : in file: component://webtools/webapp/webtools/WEB-INF/actions/entity/FindGeneric.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/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.bsh : TargetError : at Line: 148 : in file: component://webtools/webapp/webtools/WEB-INF/actions/entity/FindGeneric.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/FindGeneric.bsh : TargetError)) (Error running BSH script at location [component://webtools/webapp/webtools/WEB-INF/actions/entity/FindGeneric.bsh ]: org.ofbiz.base.util.GeneralException: 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.bsh : TargetError : at Line: 148 : in file: component://webtools/webapp/webtools/WEB-INF/actions/entity/FindGeneric.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/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.bsh : TargetError : at Line: 148 : in file: component://webtools/webapp/webtools/WEB-INF/actions/entity/FindGeneric.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/FindGeneric.bsh : TargetError))) Thanks much, Case
