getting same error message on 3 separate revisions of ofbiz

[CaseT]

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

[Jacques Le Roux]

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" <[hidden email]>

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

[CaseT]

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
[hidden email]

 

> -----Original Message-----
> From: Jacques Le Roux [mailto:[hidden email]]
> Sent: Wednesday, February 20, 2008 2:50 AM
> To: [hidden email]; [hidden email]
> 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" <[hidden email]>
> > 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
> >
>

[Bilgin Ibryam]

Hi Case,

In latest trunk Purchases by Organization Reports are working.
Not sure that this is your case, but if you create purchase order w/o
supplier party, and then use change party and add a supplier to the
order, the order will be created w/o BILL_FROM_VENDOR role. And these
orders are not shown in Purchases by Organization Report.
In rev629396 i fixed this bug.

Some entities (probably OrderReportPurchasesGroupByProduct entity too)
cannot be viewed from webtools.

Bilgin

[CaseT]

Belgin,

Thank you for this reply. It looks like the sql error I am receiving is a
false positive error.
But your reply makes me wonder if I'm interpreting the Title of the report
incorrectly.
Is the Purchases by Organization Report only for Purchases made by my
company?

I was thinking that it would list purchases of my products made by other
Organizations.
I am in need of a report such as this. One that lists customer name,
product, price.
Guess I'll have to build from scratch.

Thanks again,


Case Torres
[hidden email]

 

> -----Original Message-----
> From: Bilgin Ibryam [mailto:[hidden email]]
> Sent: Wednesday, February 20, 2008 11:04 AM
> To: [hidden email]
> Subject: Re: getting same error message on 3 separate
> revisions of ofbiz
>
> Hi Case,
>
> In latest trunk Purchases by Organization Reports are working.
> Not sure that this is your case, but if you create purchase
> order w/o supplier party, and then use change party and add a
> supplier to the order, the order will be created w/o
> BILL_FROM_VENDOR role. And these orders are not shown in
> Purchases by Organization Report.
> In rev629396 i fixed this bug.
>
> Some entities (probably OrderReportPurchasesGroupByProduct
> entity too) cannot be viewed from webtools.
>
> Bilgin
>
>