BI error

[BJ Freeman]

I decided to look at the bi section.
I clicked on the init link
I then selected some fields, sorry don't remember which ones.
got this error.

ERROR rendering error page [/error/error.jsp], but here is the error
text: org.ofbiz.widget.screen.ScreenRenderException: Error rendering
screen
[component://bi/widget/BiScreens.xml#ReportBuilderRenderStarSchemaReport]:
org.ofbiz.base.util.GeneralException: Error running BSH script at
location
[component://bi/webapp/bi/WEB-INF/actions/reportbuilder/runStarSchemaQuery.bsh]
(Error running BSH script at
[component://bi/webapp/bi/WEB-INF/actions/reportbuilder/runStarSchemaQuery.bsh],
line [41]: Sourced file:
component://bi/webapp/bi/WEB-INF/actions/reportbuilder/runStarSchemaQuery.bsh
: Typed variable declaration : at Line: 41 : in file:
component://bi/webapp/bi/WEB-INF/actions/reportbuilder/runStarSchemaQuery.bsh
: List selectFields = UtilMisc .toSetArray ( selectedFields ) Target
exception: java.lang.ClassCastException: Cannot cast
javolution.util.FastSet to java.util.List (Sourced file:
component://bi/webapp/bi/WEB-INF/actions/reportbuilder/runStarSchemaQuery.bsh
: Typed variable declaration)) (Error running BSH script at location
[component://bi/webapp/bi/WEB-INF/actions/reportbuilder/runStarSchemaQuery.bsh]
(Error running BSH script at
[component://bi/webapp/bi/WEB-INF/actions/reportbuilder/runStarSchemaQuery.bsh],
line [41]: Sourced file:
component://bi/webapp/bi/WEB-INF/actions/reportbuilder/runStarSchemaQuery.bsh
: Typed variable declaration : at Line: 41 : in file:
component://bi/webapp/bi/WEB-INF/actions/reportbuilder/runStarSchemaQuery.bsh
: List selectFields = UtilMisc .toSetArray ( selectedFields ) Target
exception: java.lang.ClassCastException: Cannot cast
javolution.util.FastSet to java.util.List (Sourced file:
component://bi/webapp/bi/WEB-INF/actions/reportbuilder/runStarSchemaQuery.bsh
: Typed variable declaration)))

[Scott Gray]

Thanks BJ, fixed in rev. 677244

Regards
Scott

2008/7/16 BJ Freeman <[hidden email]>:

> I decided to look at the bi section.
> I clicked on the init link
> I then selected some fields, sorry don't remember which ones.
> got this error.
>
> ERROR rendering error page [/error/error.jsp], but here is the error
> text: org.ofbiz.widget.screen.ScreenRenderException: Error rendering
> screen
> [component://bi/widget/BiScreens.xml#ReportBuilderRenderStarSchemaReport]:
> org.ofbiz.base.util.GeneralException: Error running BSH script at
> location
> [component://bi/webapp/bi/WEB-INF/actions/reportbuilder/runStarSchemaQuery.bsh]
> (Error running BSH script at
> [component://bi/webapp/bi/WEB-INF/actions/reportbuilder/runStarSchemaQuery.bsh],
> line [41]: Sourced file:
> component://bi/webapp/bi/WEB-INF/actions/reportbuilder/runStarSchemaQuery.bsh
> : Typed variable declaration : at Line: 41 : in file:
> component://bi/webapp/bi/WEB-INF/actions/reportbuilder/runStarSchemaQuery.bsh
> : List selectFields = UtilMisc .toSetArray ( selectedFields ) Target
> exception: java.lang.ClassCastException: Cannot cast
> javolution.util.FastSet to java.util.List (Sourced file:
> component://bi/webapp/bi/WEB-INF/actions/reportbuilder/runStarSchemaQuery.bsh
> : Typed variable declaration)) (Error running BSH script at location
> [component://bi/webapp/bi/WEB-INF/actions/reportbuilder/runStarSchemaQuery.bsh]
> (Error running BSH script at
> [component://bi/webapp/bi/WEB-INF/actions/reportbuilder/runStarSchemaQuery.bsh],
> line [41]: Sourced file:
> component://bi/webapp/bi/WEB-INF/actions/reportbuilder/runStarSchemaQuery.bsh
> : Typed variable declaration : at Line: 41 : in file:
> component://bi/webapp/bi/WEB-INF/actions/reportbuilder/runStarSchemaQuery.bsh
> : List selectFields = UtilMisc .toSetArray ( selectedFields ) Target
> exception: java.lang.ClassCastException: Cannot cast
> javolution.util.FastSet to java.util.List (Sourced file:
> component://bi/webapp/bi/WEB-INF/actions/reportbuilder/runStarSchemaQuery.bsh
> : Typed variable declaration)))
>
>

[BJ Freeman]

thanks will check it out.

Scott Gray sent the following on 7/16/2008 4:28 AM:

> Thanks BJ, fixed in rev. 677244
>
> Regards
> Scott
>
> 2008/7/16 BJ Freeman <[hidden email]>:
>> I decided to look at the bi section.
>> I clicked on the init link
>> I then selected some fields, sorry don't remember which ones.
>> got this error.
>>
>> ERROR rendering error page [/error/error.jsp], but here is the error
>> text: org.ofbiz.widget.screen.ScreenRenderException: Error rendering
>> screen
>> [component://bi/widget/BiScreens.xml#ReportBuilderRenderStarSchemaReport]:
>> org.ofbiz.base.util.GeneralException: Error running BSH script at
>> location
>> [component://bi/webapp/bi/WEB-INF/actions/reportbuilder/runStarSchemaQuery.bsh]
>> (Error running BSH script at
>> [component://bi/webapp/bi/WEB-INF/actions/reportbuilder/runStarSchemaQuery.bsh],
>> line [41]: Sourced file:
>> component://bi/webapp/bi/WEB-INF/actions/reportbuilder/runStarSchemaQuery.bsh
>> : Typed variable declaration : at Line: 41 : in file:
>> component://bi/webapp/bi/WEB-INF/actions/reportbuilder/runStarSchemaQuery.bsh
>> : List selectFields = UtilMisc .toSetArray ( selectedFields ) Target
>> exception: java.lang.ClassCastException: Cannot cast
>> javolution.util.FastSet to java.util.List (Sourced file:
>> component://bi/webapp/bi/WEB-INF/actions/reportbuilder/runStarSchemaQuery.bsh
>> : Typed variable declaration)) (Error running BSH script at location
>> [component://bi/webapp/bi/WEB-INF/actions/reportbuilder/runStarSchemaQuery.bsh]
>> (Error running BSH script at
>> [component://bi/webapp/bi/WEB-INF/actions/reportbuilder/runStarSchemaQuery.bsh],
>> line [41]: Sourced file:
>> component://bi/webapp/bi/WEB-INF/actions/reportbuilder/runStarSchemaQuery.bsh
>> : Typed variable declaration : at Line: 41 : in file:
>> component://bi/webapp/bi/WEB-INF/actions/reportbuilder/runStarSchemaQuery.bsh
>> : List selectFields = UtilMisc .toSetArray ( selectedFields ) Target
>> exception: java.lang.ClassCastException: Cannot cast
>> javolution.util.FastSet to java.util.List (Sourced file:
>> component://bi/webapp/bi/WEB-INF/actions/reportbuilder/runStarSchemaQuery.bsh
>> : Typed variable declaration)))
>>
>>
>
>
>

[BJ Freeman]

Scott:
the errors do not happen on the UI but the logs report

java.lang.Thread.run(Thread.java:595)
Sourced file:
component://bi/webapp/bi/WEB-INF/actions/reportbuilder/runStarSchemaQuery.bsh
: Method Invocation delegator.findList : at Line: 55 : in file:
component://bi/webapp/bi/WEB-INF/actions/reportbuilder/runStarSchemaQuery.bsh
: delegator .findList ( starSchemaName , condition , selectFields ,
orderByFields , findOptions , false )
Target exception: org.ofbiz.entity.GenericModelException: In
selectListIteratorByCondition invalid field names specified: [[orderId,
invoiceDateMonthName, invoiceDateYearName, productProductType, quantity,
extNetAmount]]
bsh.BSHMethodInvocation.eval(Unknown Source)
bsh.BSHPrimaryExpression.eval(Unknown Source)
bsh.BSHPrimaryExpression.eval(Unknown Source)
bsh.BSHAssignment.eval(Unknown Source)
bsh.Interpreter.evalParsedScript(Unknown Source)
bsh.Interpreter.evalParsedScript(Unknown Source)
org.ofbiz.base.util.BshUtil.runBshAtLocation(BshUtil.java:157)

also
2008-07-16 08:42:03,953 (http-0.0.0.0-8443-1) [
ControlServlet.java:215:ERROR] An error occurred, going to the
errorPage: /error/error.jsp
2008-07-16 08:42:03,968 (http-0.0.0.0-8443-1) [
ControlServlet.java:222:ERROR] Including errorPage: /error/error.jsp
2008-07-16 08:42:03,984 (http-0.0.0.0-8443-1)
[ApplicationDispatcher.java:662:ERROR] Servlet.service() for servlet jsp
threw exception
javax.servlet.ServletException: File "/error/error.jsp" not found

will look at the Jsp error and see if I can fix it.

BJ Freeman sent the following on 7/16/2008 8:31 AM:

> thanks will check it out.
>
> Scott Gray sent the following on 7/16/2008 4:28 AM:
>> Thanks BJ, fixed in rev. 677244
>>
>> Regards
>> Scott
>>
>> 2008/7/16 BJ Freeman <[hidden email]>:
>>> I decided to look at the bi section.
>>> I clicked on the init link
>>> I then selected some fields, sorry don't remember which ones.
>>> got this error.
>>>
>>> ERROR rendering error page [/error/error.jsp], but here is the error
>>> text: org.ofbiz.widget.screen.ScreenRenderException: Error rendering
>>> screen
>>> [component://bi/widget/BiScreens.xml#ReportBuilderRenderStarSchemaReport]:
>>> org.ofbiz.base.util.GeneralException: Error running BSH script at
>>> location
>>> [component://bi/webapp/bi/WEB-INF/actions/reportbuilder/runStarSchemaQuery.bsh]
>>> (Error running BSH script at
>>> [component://bi/webapp/bi/WEB-INF/actions/reportbuilder/runStarSchemaQuery.bsh],
>>> line [41]: Sourced file:
>>> component://bi/webapp/bi/WEB-INF/actions/reportbuilder/runStarSchemaQuery.bsh
>>> : Typed variable declaration : at Line: 41 : in file:
>>> component://bi/webapp/bi/WEB-INF/actions/reportbuilder/runStarSchemaQuery.bsh
>>> : List selectFields = UtilMisc .toSetArray ( selectedFields ) Target
>>> exception: java.lang.ClassCastException: Cannot cast
>>> javolution.util.FastSet to java.util.List (Sourced file:
>>> component://bi/webapp/bi/WEB-INF/actions/reportbuilder/runStarSchemaQuery.bsh
>>> : Typed variable declaration)) (Error running BSH script at location
>>> [component://bi/webapp/bi/WEB-INF/actions/reportbuilder/runStarSchemaQuery.bsh]
>>> (Error running BSH script at
>>> [component://bi/webapp/bi/WEB-INF/actions/reportbuilder/runStarSchemaQuery.bsh],
>>> line [41]: Sourced file:
>>> component://bi/webapp/bi/WEB-INF/actions/reportbuilder/runStarSchemaQuery.bsh
>>> : Typed variable declaration : at Line: 41 : in file:
>>> component://bi/webapp/bi/WEB-INF/actions/reportbuilder/runStarSchemaQuery.bsh
>>> : List selectFields = UtilMisc .toSetArray ( selectedFields ) Target
>>> exception: java.lang.ClassCastException: Cannot cast
>>> javolution.util.FastSet to java.util.List (Sourced file:
>>> component://bi/webapp/bi/WEB-INF/actions/reportbuilder/runStarSchemaQuery.bsh
>>> : Typed variable declaration)))
>>>
>>>
>>
>>
>
>
>
>