Problem with my MDX query

[dprobst]

Hi,

One topic has been wrote about this message error, while executing the query:

select {([Annee].[All Annee].Children * [Measures].AllMembers )} ON COLUMNS,
  Hierarchize([uH].[All UH].Children) ON ROWS
from [CubeTest]
 

In my opinion, and after reading the same error message I deduced that there is a bug with the AllMembers function.

The solution is to avoid this way of querying by writing the measures I want, but I don't know how to make this

query.

In my schema, I have 2 measures that are "TailleFS" and "OccupationFS"  and i'd like to cross them with

the Time dimension = [Annee].[All Annee].Children.

[2008, 2009]*[OccupationFS, TAilleFS] in column -->  2008 TailleFS  , 2008 OccupationFS, 2009 TailleFS, 2009 OccupationFS   

 

I join my logical schema which can help you to understand. "KP10"

Thank you.

 

 

Code:

Error Trace:   java.lang.NoSuchMethodError: mondrian.olap.fun.FunUtil.addAll(Ljava/util/List;[Ljava/lang/Object;)Vjava.lang.NoSuchMethodError: mondrian.olap.fun.FunUtil.addAll(Ljava/util/List;[Ljava/lang/Object;)V	at mondrian.olap.fun.FunUtil.addMembers(FunUtil.java:269)	at mondrian.olap.fun.FunUtil.addMembers(FunUtil.java:259)	at mondrian.olap.fun.FunUtil.hierarchyMembers(FunUtil.java:1851)	at mondrian.olap.fun.FunUtil.dimensionMembers(FunUtil.java:1868)	at mondrian.olap.fun.BuiltinFunTable$36$1.evaluateList(BuiltinFunTable.java:1010)	at mondrian.olap.fun.CrossJoinFunDef$BaseListCalc.evaluateList(CrossJoinFunDef.java:1106)	at mondrian.olap.fun.SetFunDef$ListSetCalc$2.evaluateVoid(SetFunDef.java:149)	at mondrian.olap.fun.SetFunDef$ListSetCalc.evaluateList(SetFunDef.java:204)	at mondrian.calc.impl.AbstractListCalc.evaluate(AbstractListCalc.java:67)	at mondrian.rolap.RolapResult.executeAxis(RolapResult.java:694)	at mondrian.rolap.RolapResult.evalLoad(RolapResult.java:557)	at mondrian.rolap.RolapResult.loadMembers(RolapResult.java:532)	at mondrian.rolap.RolapResult.<init>(RolapResult.java:254)	at mondrian.rolap.RolapConnection.execute(RolapConnection.java:597)	at com.tonbeller.jpivot.mondrian.MondrianModel.getResult(MondrianModel.java:295)	at com.tonbeller.jpivot.olap.model.OlapModelDecorator.getResult(OlapModelDecorator.java:54)	at com.tonbeller.jpivot.olap.model.CachingOlapModel.getResult(CachingOlapModel.java:49)	at com.tonbeller.jpivot.olap.model.OlapModelDecorator.getResult(OlapModelDecorator.java:54)	at sun.reflect.GeneratedMethodAccessor310.invoke(Unknown Source)	at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:25)	at java.lang.reflect.Method.invoke(Method.java:585)	at javax.el.BeanELResolver.getValue(BeanELResolver.java:62)	at javax.el.CompositeELResolver.getValue(CompositeELResolver.java:54)	at org.apache.el.parser.AstValue.getValue(AstValue.java:118)	at org.apache.el.ValueExpressionImpl.getValue(ValueExpressionImpl.java:186)	at org.apache.jasper.runtime.PageContextImpl.proprietaryEvaluate(PageContextImpl.java:935)	at org.apache.jsp.WEB_002dINF.jsp.olap.viewOlap_jsp._jspx_meth_c_005fif_005f5(viewOlap_jsp.java:2765)	at org.apache.jsp.WEB_002dINF.jsp.olap.viewOlap_jsp._jspService(viewOlap_jsp.java:413)	at org.apache.jasper.runtime.HttpJspBase.service(HttpJspBase.java:70)	at javax.servlet.http.HttpServlet.service(HttpServlet.java:717)	at org.apache.jasper.servlet.JspServletWrapper.service(JspServletWrapper.java:374)	at org.apache.jasper.servlet.JspServlet.serviceJspFile(JspServlet.java:342)	at org.apache.jasper.servlet.JspServlet.service(JspServlet.java:267)	at javax.servlet.http.HttpServlet.service(HttpServlet.java:717)	at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:290)	at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:206)	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:235)	at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:206)	at org.apache.catalina.core.ApplicationDispatcher.invoke(ApplicationDispatcher.java:646)	at org.apache.catalina.core.ApplicationDispatcher.processRequest(ApplicationDispatcher.java:436)	at org.apache.catalina.core.ApplicationDispatcher.doForward(ApplicationDispatcher.java:374)	at org.apache.catalina.core.ApplicationDispatcher.forward(ApplicationDispatcher.java:302)	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:637)	at javax.servlet.http.HttpServlet.service(HttpServlet.java:717)	at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:290)	at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:206)	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:235)	at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:206)	at com.jaspersoft.jasperserver.war.common.UploadMultipartFilter.doFilter(UploadMultipartFilter.java:86)	at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:235)	at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:206)	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 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 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: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:235)	at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:206)	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:235)	at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:206)	at org.apache.catalina.core.StandardWrapperValve.invoke(StandardWrapperValve.java:233)	at org.apache.catalina.core.StandardContextValve.invoke(StandardContextValve.java:191)	at org.apache.catalina.core.StandardHostValve.invoke(StandardHostValve.java:128)	at org.apache.catalina.valves.ErrorReportValve.invoke(ErrorReportValve.java:102)	at org.apache.catalina.core.StandardEngineValve.invoke(StandardEngineValve.java:109)	at org.apache.catalina.connector.CoyoteAdapter.service(CoyoteAdapter.java:293)	at org.apache.coyote.http11.Http11AprProcessor.process(Http11AprProcessor.java:859)	at org.apache.coyote.http11.Http11AprProtocol$Http11ConnectionHandler.process(Http11AprProtocol.java:574)	at org.apache.tomcat.util.net.AprEndpoint$Worker.run(AprEndpoint.java:1527)	at java.lang.Thread.run(Thread.java:595) 

[dprobst]

Hello,

 

I just want to precise that this query works well on JasperAnnalysis schema workbench, the problem that I've

described is on JasperServer .  (It is exactly the same error that one member has posted on the forum)

[swood]

The workbench is on a slightly later version of Mondrian than the one in JS 3.5.

 

This looks like a bug. I'll see if I can track down the reason and a work around.

 

 

Sherman

Jaspersoft

[szymic1]

This problem with AllMembers was described in http://jasperforge.org/plugins/espforum/view.php?group_id=112&forumid=102&topicid=61358

Post Edited by szymic1 at 08/26/2009 12:47

[deaves]

I was getting this same error and could not find any solution mentioned in the forums. After some digging I have managed to identify the cause and find a workaround. The problem was an incompatibility between the versions of Mondrian and eigenbase-xom that are distributed with JasperServer 3.5.0.

 

JasperServer 3.5.0 comes with mondrian-3.0.4.11371-Jaspersoft.jar and eigenbase-xom-1.3.0.11999.jar. Mondrian 3.0.4 wants version 1.1 of eigenbase-xom however. Downgrading to eigenbase-xom version 1.1 resolved the problem here.

 

Regards,

Dave

 

Post Edited by deaves at 10/02/2009 04:28