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/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
