javax.servlet.jsp.el.ELException

[kumarsrs]

javax.servlet.jsp.el.ELException: An error occurred while getting property "result" from an instance of class com.tonbeller.jpivot.tags.OlapModelProxy

javax.servlet.jsp.el.ELException: An error occurred while getting property "result" from an instance of class com.tonbeller.jpivot.tags.OlapModelProxy
at org.apache.commons.el.Logger.logError(Logger.java:484)
at org.apache.commons.el.Logger.logError(Logger.java:588)
at org.apache.commons.el.ArraySuffix.evaluate(ArraySuffix.java:318)
at org.apache.commons.el.ComplexValue.evaluate(ComplexValue.java:145)
at org.apache.commons.el.ExpressionEvaluatorImpl.evaluate(ExpressionEvaluatorImpl.java:263)
at org.apache.commons.el.ExpressionEvaluatorImpl.evaluate(ExpressionEvaluatorImpl.java:190)
at org.apache.jasper.runtime.PageContextImpl.proprietaryEvaluate(PageContextImpl.java:917)
at org.apache.jsp.WEB_002dINF.jsp.olap.viewOlap_jsp._jspx_meth_c_if_5(viewOlap_jsp.java:2556)
at org.apache.jsp.WEB_002dINF.jsp.olap.viewOlap_jsp._jspService(viewOlap_jsp.java:408)
at org.apache.jasper.runtime.HttpJspBase.service(HttpJspBase.java:97)
at javax.servlet.http.HttpServlet.service(HttpServlet.java:802)
at org.apache.jasper.servlet.JspServletWrapper.service(JspServletWrapper.java:334)
at org.apache.jasper.servlet.JspServlet.serviceJspFile(JspServlet.java:314)
at org.apache.jasper.servlet.JspServlet.service(JspServlet.java:264)
 

Attached the schema.xml, Please let know the reason for the above exeception. I had used JasperAnaalyis Schema Workbench for the creation of schema, when i try to execute the mdx query, i can get the output.

 

[kumarsrs]

Corrected the MDX Query

 From

SELECT
[Measures].AllMembers ON COLUMNS,
Hierarchize(([Dim_Curr].[All Dim_Currs]*[Dim_Name].[All Dim_Names])) ON ROWS
FROM [sales]

to

SELECT
{[Measures].Invoiced_Amount,[Measures].Qty_Ordered} ON COLUMNS,
Hierarchize(([Dim_Curr].[All Dim_Currs] * [Dim_Name].[All Dim_Names])) ON ROWS
FROM [sales]

---

Thanks

Kumar SRS

 

Post Edited by kumarsrs at 07/30/2009 09:53

[englbrechtful]

Hi Kumar,

Im currently having the same problems/errors. Did you find any way to fix this issue?

 

I dont know wether my schema and query are good, but both did work with the JS Workbench.

 

Thanks,

Stefan

[kumarsrs]

Followed the following steps to retify the problem.

Checked the query in  JS workbench, once it is successful,

Tried in ireport, checked whether for desired result.

then tried in server.
 

---

Thanks

Kumar SRS

 

[swood]

Have a look at http://jasperforge.org/projects/jasperserver/tracker/view.php?id=4247

 

Sherman

Jaspersoft