ELException: Analysis View w/ Mondrian Connection

[leeyuiwah]

This was the first time I tried to create my own Analysis View. 

 

I was following the instruction on the JasperAnalysis-Pro-User-Guide.pdf, Section 3.2.1 "Creating an Analysis View with a Mondrian Connection" (pg 24-29).  All seemed to work fine.  Except that when I tried to run the view, I got the following exception (full stack trace is in the code section of this post)

 

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

javax.servlet.jsp.el.ELException: An error occurred while getting property "result" from an inst
ance 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:2
63)
 

I also included the schema that I used, as well as the MDX expression that I used when this Exception occured.

 

Help will be much appreciated.  Thanks!

 

Clement

Code:

javax.servlet.jsp.el.ELException: An error occurred while getting property "result" from an instance of class com.tonbeller.jpivot.tags.OlapModelProxyjavax.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:2528)	at org.apache.jsp.WEB_002dINF.jsp.olap.viewOlap_jsp._jspService(viewOlap_jsp.java:398)	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)	at javax.servlet.http.HttpServlet.service(HttpServlet.java:802)	at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:252)	at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:173)	at com.opensymphony.module.sitemesh.filter.PageFilter.parsePage(PageFilter.java:118)	at com.opensymphony.module.sitemesh.filter.PageFilter.doFilter(PageFilter.java:52)	at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:202)	at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:173)	at org.apache.catalina.core.ApplicationDispatcher.invoke(ApplicationDispatcher.java:672)	at org.apache.catalina.core.ApplicationDispatcher.processRequest(ApplicationDispatcher.java:463)	at org.apache.catalina.core.ApplicationDispatcher.doForward(ApplicationDispatcher.java:398)	at org.apache.catalina.core.ApplicationDispatcher.forward(ApplicationDispatcher.java:301)	at org.springframework.web.servlet.view.InternalResourceView.renderMergedOutputModel(InternalResourceView.java:142)	at org.springframework.web.servlet.view.AbstractView.render(AbstractView.java:247)	at org.springframework.web.servlet.DispatcherServlet.render(DispatcherServlet.java:1105)	at org.springframework.web.servlet.DispatcherServlet.doDispatch(DispatcherServlet.java:841)	at org.springframework.web.servlet.DispatcherServlet.doService(DispatcherServlet.java:755)	at org.springframework.web.servlet.FrameworkServlet.processRequest(FrameworkServlet.java:396)	at org.springframework.web.servlet.FrameworkServlet.doGet(FrameworkServlet.java:350)	at javax.servlet.http.HttpServlet.service(HttpServlet.java:689)	at javax.servlet.http.HttpServlet.service(HttpServlet.java:802)	at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:252)	at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:173)	at com.tonbeller.wcf.controller.RequestFilter$MyHandler.normalRequest(RequestFilter.java:141)	at com.tonbeller.wcf.controller.RequestSynchronizer.handleRequest(RequestSynchronizer.java:127)	at com.tonbeller.wcf.controller.RequestFilter.doFilter(RequestFilter.java:281)	at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:202)	at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:173)	at com.jaspersoft.jasperserver.war.common.UploadMultipartFilter.doFilter(UploadMultipartFilter.java:86)	at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:202)	at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:173)	at org.acegisecurity.util.FilterChainProxy$VirtualFilterChain.doFilter(FilterChainProxy.java:264)	at org.acegisecurity.ui.switchuser.SwitchUserProcessingFilter.doFilter(SwitchUserProcessingFilter.java:335)	at org.acegisecurity.util.FilterChainProxy$VirtualFilterChain.doFilter(FilterChainProxy.java:274)	at org.acegisecurity.intercept.web.FilterSecurityInterceptor.invoke(FilterSecurityInterceptor.java:107)	at org.acegisecurity.intercept.web.FilterSecurityInterceptor.doFilter(FilterSecurityInterceptor.java:72)	at org.acegisecurity.util.FilterChainProxy$VirtualFilterChain.doFilter(FilterChainProxy.java:274)	at org.acegisecurity.ui.ExceptionTranslationFilter.doFilter(ExceptionTranslationFilter.java:110)	at org.acegisecurity.util.FilterChainProxy$VirtualFilterChain.doFilter(FilterChainProxy.java:274)	at com.jaspersoft.ji.license.JILicenseFilter.doFilter(JILicenseFilter.java:107)	at org.acegisecurity.util.FilterChainProxy$VirtualFilterChain.doFilter(FilterChainProxy.java:274)	at org.acegisecurity.providers.anonymous.AnonymousProcessingFilter.doFilter(AnonymousProcessingFilter.java:125)	at org.acegisecurity.util.FilterChainProxy$VirtualFilterChain.doFilter(FilterChainProxy.java:274)	at com.jaspersoft.jasperserver.api.metadata.user.service.impl.MetadataAuthenticationProcessingFilter.doFilter(MetadataAuthenticationProcessingFilter.java:141)	at org.acegisecurity.util.FilterChainProxy$VirtualFilterChain.doFilter(FilterChainProxy.java:274)	at com.jaspersoft.jasperserver.war.util.RequestParameterAuthenticationFilter.doFilter(RequestParameterAuthenticationFilter.java:97)	at org.acegisecurity.util.FilterChainProxy$VirtualFilterChain.doFilter(FilterChainProxy.java:274)	at org.acegisecurity.ui.basicauth.BasicProcessingFilter.doFilter(BasicProcessingFilter.java:181)	at org.acegisecurity.util.FilterChainProxy$VirtualFilterChain.doFilter(FilterChainProxy.java:274)	at com.jaspersoft.jasperserver.war.UserPreferencesFilter.doFilter(UserPreferencesFilter.java:165)	at org.acegisecurity.util.FilterChainProxy$VirtualFilterChain.doFilter(FilterChainProxy.java:274)	at org.acegisecurity.ui.AbstractProcessingFilter.doFilter(AbstractProcessingFilter.java:217)	at org.acegisecurity.util.FilterChainProxy$VirtualFilterChain.doFilter(FilterChainProxy.java:274)	at com.jaspersoft.jasperserver.war.UserPreferencesFilter.doFilter(UserPreferencesFilter.java:165)	at org.acegisecurity.util.FilterChainProxy$VirtualFilterChain.doFilter(FilterChainProxy.java:274)	at org.acegisecurity.context.HttpSessionContextIntegrationFilter.doFilter(HttpSessionContextIntegrationFilter.java:191)	at org.acegisecurity.util.FilterChainProxy$VirtualFilterChain.doFilter(FilterChainProxy.java:274)	at org.acegisecurity.util.FilterChainProxy.doFilter(FilterChainProxy.java:148)	at org.acegisecurity.util.FilterToBeanProxy.doFilter(FilterToBeanProxy.java:90)	at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:202)	at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:173)	at com.jaspersoft.jasperserver.war.util.CharacterEncodingFilter.doFilter(CharacterEncodingFilter.java:70)	at org.springframework.web.filter.DelegatingFilterProxy.doFilter(DelegatingFilterProxy.java:138)	at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:202)	at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:173)	at org.apache.catalina.core.StandardWrapperValve.invoke(StandardWrapperValve.java:213)	at org.apache.catalina.core.StandardContextValve.invoke(StandardContextValve.java:178)	at org.apache.catalina.core.StandardHostValve.invoke(StandardHostValve.java:126)	at org.apache.catalina.valves.ErrorReportValve.invoke(ErrorReportValve.java:105)	at org.apache.catalina.core.StandardEngineValve.invoke(StandardEngineValve.java:107)	at org.apache.catalina.connector.CoyoteAdapter.service(CoyoteAdapter.java:148)	at org.apache.coyote.http11.Http11Processor.process(Http11Processor.java:869)	at org.apache.coyote.http11.Http11BaseProtocol$Http11ConnectionHandler.processConnection(Http11BaseProtocol.java:664)	at org.apache.tomcat.util.net.PoolTcpEndpoint.processSocket(PoolTcpEndpoint.java:527)	at org.apache.tomcat.util.net.LeaderFollowerWorkerThread.runIt(LeaderFollowerWorkerThread.java:80)	at org.apache.tomcat.util.threads.ThreadPool$ControlRunnable.run(ThreadPool.java:684)	at java.lang.Thread.run(Thread.java:595)======================================================<?xml version="1.0"?><Schema name="AwareDemo"><Cube name="All_Resources">  <Table name="Resource_Usage"/>  <Dimension name="Category" foreignKey="FK_Category">    <Hierarchy hasAll="true" allMemberName="All Categories" primaryKey="PK_Category">      <Table name="Category"/>      <Level name="Category" column="Category_Name" uniqueMembers="true"/>      <Level name="Type" column="Category_Type" uniqueMembers="false"/>    </Hierarchy>  </Dimension>  <Dimension name="Period" foreignKey="FK_Period">    <Hierarchy hasAll="true" allMemberName="All Period" primaryKey="PK_Period_Start">      <Table name="Period"/>      <Level name="Year" column="Year" type="Numeric" uniqueMembers="false"/>      <Level name="Quarter" column="Quarter" type="Numeric" uniqueMembers="false"/>      <Level name="Month" column="Month" type="Numeric" uniqueMembers="false"/>      <Level name="Week" column="Week" type="Numeric" uniqueMembers="false"/>      <Level name="Day" column="Day" type="Numeric" uniqueMembers="false"/>      <Level name="Hour" column="Hour" nameColumn="Period_Start_Name" type="Numeric" uniqueMembers="false"/>      <Level name="Day_Of_Week" column="Day_Of_Week" type="Numeric" uniqueMembers="false"/>      <Level name="Day_Of_Year" column="Day_Of_Year" type="Numeric" uniqueMembers="false"/>    </Hierarchy>  </Dimension>  <Measure name="Total Bytes" column="Total_Bytes" aggregator="sum" formatString="#,###"/>  <Measure name="Total Airtime" column="Total_Airtime" aggregator="sum" formatString="#,###"/>  <Measure name="Total Connection Setups" column="Total_Connection_Setups" aggregator="sum" formatString="#,###"/></Cube></Schema>=============================================================Select {[Measures].[Total Bytes], [Measures].[Total Airtime], [Measures].[Total Connection Setups] } ON COLUMNS, NON EMPTY {([Category].[All Categories], [Period].[All Period])} ON ROWS from [All_Resources]==============================================================

[shivareddyk]

ANY ONE FIND OUT SOLUTION FOR THIS PROBLEM?

 

pls let me know ur solutionshiva.reddy@hotmail.com

 

Regards

[kevinchristian]

 Me too facing the same problem..

[manask]

i am facing same problem !

Please anybody knows the solution ?

[jfields]

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

 

From my expirence, when I recieve the "result" error, this meant there was a SQL Exception.

Meaning the query to pull the data that was requested blew up.

 

To debug, first turn on Analysis query logging. (In the Analysis Options)

When you get the query that blows up, pull it out of the log and run it in a Query Analyzer.

Should give you the actual sql error. 

 

Hope that helps.