mondrian.olap.MondrianException: Mondrian Error:Failed to parse query 'select NON EMPTY {[Measures].[Sales]} ON COLUMNS,NON EMPTY TopCount([Customers].[All Customers].Children, 10.0, [Measures].[Sales ]) ON ROWS from [SteelWheelsSales] where ([Markets].[All Markets].[{territory}])'

Searched on Google with the first line of a JAVA stack trace?

We can recommend more relevant solutions and speed up debugging when you paste your entire stack trace with the exception message. Try a sample exception.

Recommended solutions based on your search

Samebug tips

Do you know how to solve this issue? Write a tip to help other users and build your expert profile.

Solutions on the web

via Pentaho BI Platform Tracking by Jared Pshedesky, 1 year ago
Mondrian Error:Failed to parse query 'select NON EMPTY {[Measures].[Sales]} ON COLUMNS,NON EMPTY TopCount([Customers].[All Customers].Children, 10.0, [Measures].[Sales ]) ON ROWS from [SteelWheelsSales] where ([Markets].[All Markets].[{territory}])'
via Pentaho BI Platform Tracking by Jared Pshedesky, 1 year ago
Mondrian Error:Failed to parse query 'select NON EMPTY {[Measures].[Sales]} ON COLUMNS,NON EMPTY TopCount([Customers].[All Customers].Children, 10.0, [Measures].[Sales ]) ON ROWS from [SteelWheelsSales] where ([Markets].[All Markets].[{territory}])'
via blogspot.com by Unknown author, 1 year ago
Mondrian Error:Internal error: while building member cache; sql=[select "time_by_day"."the_year" from "time_by_day" as "time_by_day" group by "time_by_day"."the_year" order by "time_by_day"."the_year" ASC]
via Pentaho BI Platform Tracking by Roman Bondar, 1 year ago
Mondrian Error:Internal error: Error while executing query [select NON EMPTY {Hierarchize({[fee].[fee].Members})} ON COLUMNS, NON EMPTY Crossjoin([id].[id].Members, {[Measures].[amt]}) ON ROWS from [hive_acq_data_sample_duplicate] ]
via Pentaho BI Platform Tracking by Roman Bondar, 1 year ago
Mondrian Error:Internal error: Error while executing query [select NON EMPTY {Hierarchize({[fee].[fee].Members})} ON COLUMNS, NON EMPTY Crossjoin([id].[id].Members, {[Measures].[amt]}) ON ROWS from [hive_acq_data_sample_duplicate] ]
via pentaho.com by Unknown author, 2 years ago
Mondrian Error:Internal error: Error while executing query [select {[Measures].[CoutEoc], [Measures].[CoutRes]} ON COLUMNS, {[Activite].[All Activites]} ON ROWS from [element] ]
mondrian.olap.MondrianException: Mondrian Error:Failed to parse query 'select NON EMPTY {[Measures].[Sales]} ON COLUMNS,NON EMPTY TopCount([Customers].[All Customers].Children, 10.0, [Measures].[Sales ]) ON ROWS from [SteelWheelsSales] where ([Markets].[All Markets].[{territory}])'
at mondrian.resource.MondrianResource$_Def1.ex(MondrianResource.java:802)
at mondrian.olap.Util.lookup(Util.java:775)
at mondrian.olap.Id.accept(Id.java:105)
at mondrian.olap.Query$StackValidator.validate(Query.java:1260)
at mondrian.olap.fun.FunUtil.resolveFunArgs(FunUtil.java:1681)
at mondrian.mdx.UnresolvedFunCall.accept(UnresolvedFunCall.java:99)
at mondrian.olap.Query$StackValidator.validate(Query.java:1260)
at mondrian.olap.QueryAxis.validate(QueryAxis.java:269)
at mondrian.olap.Query.resolve(Query.java:582)
at mondrian.olap.Query.resolve(Query.java:429)
at mondrian.olap.Query.(Query.java:226)
at mondrian.olap.Query.(Query.java:183)
at mondrian.olap.Parser.makeQuery(Parser.java:863)
at mondrian.olap.CUP$Parser$actions.CUP$Parser$do_action(Parser.java:1696)
at mondrian.olap.Parser.do_action(Parser.java:694)
at java_cup.runtime.lr_parser.parse(lr_parser.java:569)
at mondrian.olap.Parser.parseInternal(Parser.java:767)
at mondrian.olap.ConnectionBase.parseQuery(ConnectionBase.java:129)
at mondrian.olap.ConnectionBase.parseQuery(ConnectionBase.java:59)
at org.pentaho.platform.plugin.services.connections.mondrian.MDXConnection.executeQuery(MDXConnection.java:241)
at org.pentaho.platform.plugin.action.mdx.MDXBaseComponent.runQuery(MDXBaseComponent.java:315)
at org.pentaho.platform.plugin.action.mdx.MDXBaseComponent.executeAction(MDXBaseComponent.java:181)
at org.pentaho.platform.engine.services.solution.ComponentBase.execute(ComponentBase.java:440)
at org.pentaho.platform.engine.services.runtime.RuntimeContext.executeComponent(RuntimeContext.java:1298)
at org.pentaho.platform.engine.services.runtime.RuntimeContext.executeAction(RuntimeContext.java:1265)
at org.pentaho.platform.engine.services.runtime.RuntimeContext.performActions(RuntimeContext.java:1174)
at org.pentaho.platform.engine.services.runtime.RuntimeContext.executeLoop(RuntimeContext.java:1127)
at org.pentaho.platform.engine.services.runtime.RuntimeContext.executeSequence(RuntimeContext.java:1012)
at org.pentaho.platform.engine.services.runtime.RuntimeContext.performActions(RuntimeContext.java:1165)
at org.pentaho.platform.engine.services.runtime.RuntimeContext.executeLoop(RuntimeContext.java:1127)
at org.pentaho.platform.engine.services.runtime.RuntimeContext.executeSequence(RuntimeContext.java:1012)
at org.pentaho.platform.engine.services.runtime.RuntimeContext.executeSequence(RuntimeContext.java:908)
at org.pentaho.platform.engine.services.solution.SolutionEngine.executeInternal(SolutionEngine.java:409)
at org.pentaho.platform.engine.services.solution.SolutionEngine.execute(SolutionEngine.java:313)
at org.pentaho.platform.engine.services.solution.SolutionEngine.execute(SolutionEngine.java:192)
at com.pentaho.core.solution.ProSolutionEngine.execute(ProSolutionEngine.java:95)
at org.pentaho.platform.uifoundation.chart.AbstractChartComponent.getActionData(AbstractChartComponent.java:192)
at org.pentaho.platform.uifoundation.chart.CategoryDatasetChartComponent.createChart(CategoryDatasetChartComponent.java:86)
at org.pentaho.platform.uifoundation.chart.CategoryDatasetChartComponent.getXmlContent(CategoryDatasetChartComponent.java:164)
at org.pentaho.platform.uifoundation.component.xml.XmlComponent.getContent(XmlComponent.java:55)
at org.pentaho.platform.uifoundation.chart.ChartHelper.doChart(ChartHelper.java:279)
at org.apache.jsp.jsp.OldHome_jsp._jspService(OldHome_jsp.java:169)
at javax.servlet.http.HttpServlet.service(HttpServlet.java:803)
at org.apache.jasper.servlet.JspServletWrapper.service(JspServletWrapper.java:331)
at org.apache.jasper.servlet.JspServlet.serviceJspFile(JspServlet.java:329)
at javax.servlet.http.HttpServlet.service(HttpServlet.java:803)
at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:269)
at org.acegisecurity.util.FilterChainProxy$VirtualFilterChain.doFilter(FilterChainProxy.java:265)
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:275)
at org.acegisecurity.ui.ExceptionTranslationFilter.doFilter(ExceptionTranslationFilter.java:124)
at org.acegisecurity.util.FilterChainProxy$VirtualFilterChain.doFilter(FilterChainProxy.java:275)
at org.acegisecurity.ui.switchuser.SwitchUserProcessingFilter.doFilter(SwitchUserProcessingFilter.java:341)
at org.pentaho.platform.web.http.security.SecurityStartupFilter.doFilter(SecurityStartupFilter.java:81)
at org.acegisecurity.util.FilterChainProxy$VirtualFilterChain.doFilter(FilterChainProxy.java:275)
at org.acegisecurity.providers.anonymous.AnonymousProcessingFilter.doFilter(AnonymousProcessingFilter.java:125)
at org.acegisecurity.util.FilterChainProxy$VirtualFilterChain.doFilter(FilterChainProxy.java:275)
at org.acegisecurity.ui.rememberme.RememberMeProcessingFilter.doFilter(RememberMeProcessingFilter.java:142)
at org.pentaho.platform.web.http.security.RequestParameterAuthenticationFilter.doFilter(RequestParameterAuthenticationFilter.java:164)
at org.acegisecurity.util.FilterChainProxy$VirtualFilterChain.doFilter(FilterChainProxy.java:275)
at org.acegisecurity.ui.basicauth.BasicProcessingFilter.doFilter(BasicProcessingFilter.java:174)
at org.acegisecurity.util.FilterChainProxy$VirtualFilterChain.doFilter(FilterChainProxy.java:275)
at org.acegisecurity.ui.AbstractProcessingFilter.doFilter(AbstractProcessingFilter.java:271)
at org.acegisecurity.util.FilterChainProxy$VirtualFilterChain.doFilter(FilterChainProxy.java:275)
at org.acegisecurity.ui.logout.LogoutFilter.doFilter(LogoutFilter.java:110)
at org.pentaho.platform.web.http.security.HttpSessionReuseDetectionFilter.doFilter(HttpSessionReuseDetectionFilter.java:129)
at org.acegisecurity.util.FilterChainProxy$VirtualFilterChain.doFilter(FilterChainProxy.java:275)
at org.acegisecurity.context.HttpSessionContextIntegrationFilter.doFilter(HttpSessionContextIntegrationFilter.java:249)
at org.acegisecurity.util.FilterChainProxy$VirtualFilterChain.doFilter(FilterChainProxy.java:275)
at org.acegisecurity.wrapper.SecurityContextHolderAwareRequestFilter.doFilter(SecurityContextHolderAwareRequestFilter.java:81)
at org.acegisecurity.util.FilterChainProxy$VirtualFilterChain.doFilter(FilterChainProxy.java:275)
at org.acegisecurity.util.FilterChainProxy.doFilter(FilterChainProxy.java:149)
at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:215)
at com.pentaho.ui.servlet.SystemStatusFilter.doFilter(SystemStatusFilter.java:43)
at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:215)
at org.pentaho.platform.web.http.filters.SetCharacterEncodingFilter.doFilter(SetCharacterEncodingFilter.java:113)
at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:215)
at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:188)
at org.apache.catalina.core.StandardWrapperValve.invoke(StandardWrapperValve.java:213)
at org.apache.catalina.core.StandardContextValve.invoke(StandardContextValve.java:174)
at org.apache.catalina.authenticator.AuthenticatorBase.invoke(AuthenticatorBase.java:433)
at org.apache.catalina.core.StandardHostValve.invoke(StandardHostValve.java:127)
at org.apache.catalina.valves.ErrorReportValve.invoke(ErrorReportValve.java:117)
at org.apache.catalina.core.StandardEngineValve.invoke(StandardEngineValve.java:108)
at org.apache.coyote.http11.Http11Processor.process(Http11Processor.java:874)
at org.apache.coyote.http11.Http11BaseProtocol$Http11ConnectionHandler.processConnection(Http11BaseProtocol.java:665)
at org.apache.tomcat.util.net.PoolTcpEndpoint.processSocket(PoolTcpEndpoint.java:528)
at org.apache.tomcat.util.net.LeaderFollowerWorkerThread.runIt(LeaderFollowerWorkerThread.java:81)
at java.lang.Thread.run(Unknown Source)

Users with the same issue

You are the first who have seen this exception. Write a tip to help other users and build your expert profile.

Write tip

Know the solutions? Share your knowledge to help other developers to debug faster.