You are viewing a plain text version of this content. The canonical link for it is here.
Posted to user@ofbiz.apache.org by Case Torres <Ca...@casetorrestech.com> on 2008/02/20 00:56:04 UTC
getting same error message on 3 separate revisions of ofbiz
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
RE: getting same error message on 3 separate revisions of ofbiz
Posted by Case Torres <Ca...@casetorrestech.com>.
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
case@casetorrestech.com
> -----Original Message-----
> From: Jacques Le Roux [mailto:jacques.le.roux@les7arts.com]
> Sent: Wednesday, February 20, 2008 2:50 AM
> To: user@ofbiz.apache.org; Case@casetorrestech.com
> 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" <Ca...@casetorrestech.com>
> > 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
> >
>
Re: getting same error message on 3 separate revisions of ofbiz
Posted by Jacques Le Roux <ja...@les7arts.com>.
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" <Ca...@casetorrestech.com>
> 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
>