BUG IN JASPERSERVER PROFESSIONAL VERSION

[shivareddyk]

Hi,

i created one cube with one dimension and measure.i deployed that cube  successfully in jasper server PROFESSIONAL version.i got this error(when ever i try to EXPAND DIMENSION  or example  i click "+ ")

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

 

please let me what is the cause......

Note:-(the same cube and mdx query working well in community version),the problem only in PRO version?

 

Regards

 

Code:

cube code:" <Schema name="New Schema1">	<Cube name="frp_dep_tsting" cache="true" enabled="true">		<Table name="f_deposit" schema="" alias="">		</Table>		<Dimension type="StandardDimension" foreignKey="PRODUCT_ID" name="DEPOSIT TYPE" caption="">			<Hierarchy name="DEPOSIT TYPE" hasAll="true" allMemberName="All DEPOSIT TYPE" allMemberCaption="" primaryKey="PRODUCT_ID" primaryKeyTable="d_product" caption="">				<Table name="d_product" schema="" alias="">				</Table>				<Level name="Level 1" table="d_product" column="CRLINE_DESCR" nameColumn="" type="String" uniqueMembers="false" levelType="Regular" hideMemberIf="Never">					<KeyExpression>						<SQL dialect="mysql">							(case when `d_product`.`CRLINE_DESCR` ='DEMAND DEPOSIT' then '1.DEMAND DEPOSIT'  when `d_product`.`CRLINE_DESCR`= 'SAVINGS DEPOSIT' then '2.SAVINGS DEPOSIT'  when `d_product`.`CRLINE_DESCR`='TIME CERTIFICATES OF DEPOSIT' then '3.TIME CERTIFICATES OF DEPOSIT' else 0 end)						</SQL>					</KeyExpression>				</Level>			</Hierarchy>		</Dimension>		<Measure name="Balance" column="AMOUNT" datatype="Numeric" formatString="#,##0.00" aggregator="sum" visible="true">		</Measure>	</Cube></Schema>"MDX Query:-"select NON EMPTY {[Measures].[balance]} ON COLUMNS,  NON EMPTY {[DEPOSIT TYPE.DEPOSIT TYPE].[All DEPOSIT TYPE]} ON ROWSfrom [frp_dep_tsting]"ERROR IS:-"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: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)	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:127)	at com.opensymphony.module.sitemesh.filter.PageFilter.doFilter(PageFilter.java:56)	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.doPost(FrameworkServlet.java:360)	at javax.servlet.http.HttpServlet.service(HttpServlet.java:709)	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:142)	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 com.jaspersoft.jasperserver.multipleTenancy.MTBasicProcessingFilter.doFilter(MTBasicProcessingFilter.java:182)	at org.acegisecurity.util.FilterChainProxy$VirtualFilterChain.doFilter(FilterChainProxy.java:274)	at com.jaspersoft.jasperserver.war.UserPreferencesFilter.doFilter(UserPreferencesFilter.java:178)	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:178)	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)"

[swood]

It looks like it should work.

 

I would remove primaryKeyTable="d_product" in the Hierarchy definition.

 

I don't know about whether the KeyExpression will work the way you are expecting.

 

If the analysis view comes up, but then there is a problem drilling down (the +), that usually indicates that there is something wrong with the underlying data or the schema. Are you using the same database that worked with the community edition? Did the drill down work there?

 

You could turn on debug logging in WEB-INF/log4j.properties to see more details.

 

log4j.logger.com.tonbeller.jpivot=debug

log4j.logger.mondrian=debug

 

This logging will produce a lot of output.

 

 

Sherman

Jaspersoft

 

Sherman

Jaspersoft