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}])'

Pentaho BI Platform Tracking | Jared Pshedesky | 8 years ago
  1. 0

    Running the Top 10 Customers sample dashboard fails. Errors look like: Could not generate chart image. Could not load chart data from samples/steel-wheels/homeDashboard/topnmdxquery.xaction Exceptions look like: 17:00:01,529 ERROR [MDXLookupRule] Error Start: Pentaho Pentaho Platform Engine Core 2.0.0-SNAPSHOT.32627 17:00:01,529 ERROR [MDXLookupRule] c103921e-8a7b-11dd-bed1-197b80496e7f:COMPONENT:context-29771427-1222290001483:topnmdxquery.xactionMDXBaseComponent.ERROR_0006 - Could not execute topnmdxquery.xactio n 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$_Def0.ex(MondrianResource.java:785) at mondrian.olap.ConnectionBase.parseQuery(ConnectionBase.java:134) 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 org.apache.jasper.runtime.HttpJspBase.service(HttpJspBase.java:98) 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 org.apache.jasper.servlet.JspServlet.service(JspServlet.java:265) at javax.servlet.http.HttpServlet.service(HttpServlet.java:803) at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:269) at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:188) 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.acegisecurity.util.FilterChainProxy$VirtualFilterChain.doFilter(FilterChainProxy.java:275) 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.acegisecurity.util.FilterChainProxy$VirtualFilterChain.doFilter(FilterChainProxy.java:275) 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.acegisecurity.util.FilterChainProxy$VirtualFilterChain.doFilter(FilterChainProxy.java:275) 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.acegisecurity.util.FilterToBeanProxy.doFilter(FilterToBeanProxy.java:98) at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:215) at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:188) at com.pentaho.ui.servlet.SystemStatusFilter.doFilter(SystemStatusFilter.java:43) at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:215) at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:188) 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.catalina.connector.CoyoteAdapter.service(CoyoteAdapter.java:174) 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 org.apache.tomcat.util.threads.ThreadPool$ControlRunnable.run(ThreadPool.java:689) at java.lang.Thread.run(Unknown Source) Caused by: mondrian.olap.MondrianException: Mondrian Error:Error while parsing MDX statement '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$_Def0.ex(MondrianResource.java:785) at mondrian.olap.Parser.parseInternal(Parser.java:772) at mondrian.olap.ConnectionBase.parseQuery(ConnectionBase.java:129) ... 83 more Caused by: mondrian.olap.MondrianException: Mondrian Error:MDX object '[Markets].[All Markets].[{territory}]' not found in cube 'SteelWheelsSales' 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.<init>(Query.java:226) at mondrian.olap.Query.<init>(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) ... 84 more 17:00:01,561 ERROR [MDXLookupRule] Error end: 17:00:01,561 ERROR [RuntimeContext] c103921e-8a7b-11dd-bed1-197b80496e7f:RUNTIME:context-29771427-1222290001483:topnmdxquery.xaction RuntimeContext.ERROR_0012 - ActionDefinition for MDXLookupRule did not execute successfully 17:00:01,561 ERROR [ProSolutionEngine] c103921e-8a7b-11dd-bed1-197b80496e7f:SOLUTION-ENGINE:topnmdxquery.xaction: SolutionEngine.ERROR_0007 - Action sequence execution failed 17:00:01,561 ERROR [Logger] misc-org.pentaho.platform.engine.services.SolutionURIResolver: SOLREPO.ERROR_0006 - Resource not found: samples/steel-wheels/homeDashboard/Chart_en_US.xsl 17:00:01,561 ERROR [Logger] misc-org.pentaho.platform.engine.services.SolutionURIResolver: SOLREPO.ERROR_0006 - Resource not found: samples/steel-wheels/homeDashboard/Chart_en.xsl 17:00:01,561 ERROR [Logger] misc-org.pentaho.platform.engine.services.SolutionURIResolver: SOLREPO.ERROR_0006 - Resource not found: samples/steel-wheels/homeDashboard/Chart.xsl 17:00:01,561 ERROR [Logger] misc-org.pentaho.platform.engine.services.SolutionURIResolver: SOLREPO.ERROR_0006 - Resource not found: system/custom/xsl/Chart_en_US.xsl 17:00:01,561 ERROR [Logger] misc-org.pentaho.platform.engine.services.SolutionURIResolver: SOLREPO.ERROR_0006 - Resource not found: system/custom/xsl/Chart_en.xsl

    Pentaho BI Platform Tracking | 8 years ago | Jared Pshedesky
    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}])'
  2. 0

    Running the Top 10 Customers sample dashboard fails. Errors look like: Could not generate chart image. Could not load chart data from samples/steel-wheels/homeDashboard/topnmdxquery.xaction Exceptions look like: 17:00:01,529 ERROR [MDXLookupRule] Error Start: Pentaho Pentaho Platform Engine Core 2.0.0-SNAPSHOT.32627 17:00:01,529 ERROR [MDXLookupRule] c103921e-8a7b-11dd-bed1-197b80496e7f:COMPONENT:context-29771427-1222290001483:topnmdxquery.xactionMDXBaseComponent.ERROR_0006 - Could not execute topnmdxquery.xactio n 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$_Def0.ex(MondrianResource.java:785) at mondrian.olap.ConnectionBase.parseQuery(ConnectionBase.java:134) 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 org.apache.jasper.runtime.HttpJspBase.service(HttpJspBase.java:98) 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 org.apache.jasper.servlet.JspServlet.service(JspServlet.java:265) at javax.servlet.http.HttpServlet.service(HttpServlet.java:803) at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:269) at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:188) 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.acegisecurity.util.FilterChainProxy$VirtualFilterChain.doFilter(FilterChainProxy.java:275) 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.acegisecurity.util.FilterChainProxy$VirtualFilterChain.doFilter(FilterChainProxy.java:275) 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.acegisecurity.util.FilterChainProxy$VirtualFilterChain.doFilter(FilterChainProxy.java:275) 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.acegisecurity.util.FilterToBeanProxy.doFilter(FilterToBeanProxy.java:98) at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:215) at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:188) at com.pentaho.ui.servlet.SystemStatusFilter.doFilter(SystemStatusFilter.java:43) at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:215) at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:188) 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.catalina.connector.CoyoteAdapter.service(CoyoteAdapter.java:174) 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 org.apache.tomcat.util.threads.ThreadPool$ControlRunnable.run(ThreadPool.java:689) at java.lang.Thread.run(Unknown Source) Caused by: mondrian.olap.MondrianException: Mondrian Error:Error while parsing MDX statement '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$_Def0.ex(MondrianResource.java:785) at mondrian.olap.Parser.parseInternal(Parser.java:772) at mondrian.olap.ConnectionBase.parseQuery(ConnectionBase.java:129) ... 83 more Caused by: mondrian.olap.MondrianException: Mondrian Error:MDX object '[Markets].[All Markets].[{territory}]' not found in cube 'SteelWheelsSales' 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.<init>(Query.java:226) at mondrian.olap.Query.<init>(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) ... 84 more 17:00:01,561 ERROR [MDXLookupRule] Error end: 17:00:01,561 ERROR [RuntimeContext] c103921e-8a7b-11dd-bed1-197b80496e7f:RUNTIME:context-29771427-1222290001483:topnmdxquery.xaction RuntimeContext.ERROR_0012 - ActionDefinition for MDXLookupRule did not execute successfully 17:00:01,561 ERROR [ProSolutionEngine] c103921e-8a7b-11dd-bed1-197b80496e7f:SOLUTION-ENGINE:topnmdxquery.xaction: SolutionEngine.ERROR_0007 - Action sequence execution failed 17:00:01,561 ERROR [Logger] misc-org.pentaho.platform.engine.services.SolutionURIResolver: SOLREPO.ERROR_0006 - Resource not found: samples/steel-wheels/homeDashboard/Chart_en_US.xsl 17:00:01,561 ERROR [Logger] misc-org.pentaho.platform.engine.services.SolutionURIResolver: SOLREPO.ERROR_0006 - Resource not found: samples/steel-wheels/homeDashboard/Chart_en.xsl 17:00:01,561 ERROR [Logger] misc-org.pentaho.platform.engine.services.SolutionURIResolver: SOLREPO.ERROR_0006 - Resource not found: samples/steel-wheels/homeDashboard/Chart.xsl 17:00:01,561 ERROR [Logger] misc-org.pentaho.platform.engine.services.SolutionURIResolver: SOLREPO.ERROR_0006 - Resource not found: system/custom/xsl/Chart_en_US.xsl 17:00:01,561 ERROR [Logger] misc-org.pentaho.platform.engine.services.SolutionURIResolver: SOLREPO.ERROR_0006 - Resource not found: system/custom/xsl/Chart_en.xsl

    Pentaho BI Platform Tracking | 8 years ago | Jared Pshedesky
    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}])'
  3. 0

    FoodMart.xml fails to load/convert

    GitHub | 1 year ago | ericvergnaud
    mondrian.olap.MondrianException: Mondrian Error:Calculated member or named set in cube 'Warehouse and Sales' has bad formula
  4. Speed up your debug routine!

    Automated exception search integrated into your IDE

  5. 0

    Set the content of the CellSet in OLAP4j

    olap4j | 6 years ago | didourebai
    mondrian.olap.MondrianException: Mondrian Error:Failed to parse query 'SELECT AddCalculatedMembers(.Members) ON COLUMNS, Crossjoin(.Members, .Members) ON ROWS FROM WHERE {.:., ..:..,.}'
  6. 0

    DB Tables data source (Star schema) don't show as available data sources in analyzer. Repro: 1. create a new DB Tables Data Source, select star schema 2. complete the data source, Keep model that get's generated. 3. create a new analyzer report 4. notice that the new data source is not available to select *notice that there is an exception in the console: 11:10:26,969 ERROR [Logger] misc-java.lang.String: MDXConnection.ERROR_0002 - Invalid connection properties: PoolNeeded=false; Locale=en_US; Catalog=solution:admin/resources/metadata/dbTables.mondrian.xml; Provider=mondrian mondrian.olap.MondrianException: Mondrian Error:Unknown aggregator 'none'; valid aggregators are: 'sum', 'count', 'min', 'max', 'avg', 'dist inct-count' at mondrian.resource.MondrianResource$_Def1.ex(MondrianResource.java:858) at mondrian.rolap.RolapBaseCubeMeasure.<init>(RolapBaseCubeMeasure.java:116) at mondrian.rolap.RolapCube.createMeasure(RolapCube.java:340) at mondrian.rolap.RolapCube.<init>(RolapCube.java:251) at mondrian.rolap.RolapSchema.load(RolapSchema.java:442) at mondrian.rolap.RolapSchema.load(RolapSchema.java:318) at mondrian.rolap.RolapSchema.<init>(RolapSchema.java:229) at mondrian.rolap.RolapSchema.<init>(RolapSchema.java:54) at mondrian.rolap.RolapSchema$Pool.get(RolapSchema.java:986) at mondrian.rolap.RolapSchema$Pool.get(RolapSchema.java:797) at mondrian.rolap.RolapConnection.<init>(RolapConnection.java:173) at mondrian.rolap.RolapConnection.<init>(RolapConnection.java:95) at mondrian.olap.DriverManager.getConnection(DriverManager.java:110) at org.pentaho.platform.plugin.services.connections.mondrian.MDXConnection.init(MDXConnection.java:227) at org.pentaho.platform.plugin.services.connections.mondrian.MDXConnection.init(MDXConnection.java:146) at org.pentaho.platform.plugin.services.connections.mondrian.MDXConnection.setProperties(MDXConnection.java:106) at org.pentaho.platform.engine.services.connection.PentahoConnectionFactory.getConnection(PentahoConnectionFactory.java:129) at com.pentaho.analyzer.service.impl.OlapConnectionManagerImpl.createConnection(SourceFile:98) at com.pentaho.analyzer.service.impl.d.getConnection(SourceFile:26) at com.pentaho.analyzer.service.impl.OlapMetaDataManager.getConnection(SourceFile:42) at com.pentaho.analyzer.service.impl.AnalysisAreaManager.createOlapConnection(SourceFile:108) at com.pentaho.analyzer.content.a.j.a(SourceFile:68) at com.pentaho.analyzer.content.a.j.dj(SourceFile:95) at com.pentaho.analyzer.content.AnalyzerContentGenerator.createContent(SourceFile:136) at sun.reflect.GeneratedMethodAccessor101.invoke(Unknown Source) at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:25) at java.lang.reflect.Method.invoke(Method.java:597) at com.pentaho.platform.web.http.context.a.invoke(SourceFile:220) at $Proxy24.createContent(Unknown Source) at org.pentaho.platform.web.servlet.GenericServlet.doGet(GenericServlet.java:261) at javax.servlet.http.HttpServlet.service(HttpServlet.java:617) 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 org.pentaho.platform.web.http.filters.PentahoWebContextFilter.doFilter(PentahoWebContextFilter.java:96) at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:235) at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:206) at org.pentaho.platform.web.http.filters.PentahoRequestContextFilter.doFilter(PentahoRequestContextFilter.java:84) at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:235) at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:206) at org.springframework.security.util.FilterChainProxy$VirtualFilterChain.doFilter(FilterChainProxy.java:378) at org.springframework.security.intercept.web.FilterSecurityInterceptor.invoke(FilterSecurityInterceptor.java:109) at org.springframework.security.intercept.web.FilterSecurityInterceptor.doFilter(FilterSecurityInterceptor.java:83) at org.springframework.security.util.FilterChainProxy$VirtualFilterChain.doFilter(FilterChainProxy.java:390) at org.springframework.security.ui.ExceptionTranslationFilter.doFilterHttp(ExceptionTranslationFilter.java:101) at org.springframework.security.ui.SpringSecurityFilter.doFilter(SpringSecurityFilter.java:53) at org.springframework.security.util.FilterChainProxy$VirtualFilterChain.doFilter(FilterChainProxy.java:390) at org.pentaho.platform.web.http.security.SecurityStartupFilter.doFilter(SecurityStartupFilter.java:103) at org.springframework.security.util.FilterChainProxy$VirtualFilterChain.doFilter(FilterChainProxy.java:390) at org.springframework.security.providers.anonymous.AnonymousProcessingFilter.doFilterHttp(AnonymousProcessingFilter.java:105) at org.springframework.security.ui.SpringSecurityFilter.doFilter(SpringSecurityFilter.java:53) at org.springframework.security.util.FilterChainProxy$VirtualFilterChain.doFilter(FilterChainProxy.java:390) at org.pentaho.platform.web.http.security.RequestParameterAuthenticationFilter.doFilter(RequestParameterAuthenticationFilter.java:16 9) at org.springframework.security.util.FilterChainProxy$VirtualFilterChain.doFilter(FilterChainProxy.java:390) at org.springframework.security.ui.basicauth.BasicProcessingFilter.doFilterHttp(BasicProcessingFilter.java:174) at org.springframework.security.ui.SpringSecurityFilter.doFilter(SpringSecurityFilter.java:53) at org.springframework.security.util.FilterChainProxy$VirtualFilterChain.doFilter(FilterChainProxy.java:390) at org.springframework.security.ui.AbstractProcessingFilter.doFilterHttp(AbstractProcessingFilter.java:278) at org.springframework.security.ui.SpringSecurityFilter.doFilter(SpringSecurityFilter.java:53) at org.springframework.security.util.FilterChainProxy$VirtualFilterChain.doFilter(FilterChainProxy.java:390) at org.springframework.security.ui.logout.LogoutFilter.doFilterHttp(LogoutFilter.java:89) at org.springframework.security.ui.SpringSecurityFilter.doFilter(SpringSecurityFilter.java:53) at org.springframework.security.util.FilterChainProxy$VirtualFilterChain.doFilter(FilterChainProxy.java:390) at org.pentaho.platform.web.http.security.HttpSessionReuseDetectionFilter.doFilter(HttpSessionReuseDetectionFilter.java:134) at org.springframework.security.util.FilterChainProxy$VirtualFilterChain.doFilter(FilterChainProxy.java:390) at org.springframework.security.context.HttpSessionContextIntegrationFilter.doFilterHttp(HttpSessionContextIntegrationFilter.java:23 5) at org.springframework.security.ui.SpringSecurityFilter.doFilter(SpringSecurityFilter.java:53) at org.springframework.security.util.FilterChainProxy$VirtualFilterChain.doFilter(FilterChainProxy.java:390) at org.springframework.security.wrapper.SecurityContextHolderAwareRequestFilter.doFilterHttp(SecurityContextHolderAwareRequestFilter .java:91) at org.springframework.security.ui.SpringSecurityFilter.doFilter(SpringSecurityFilter.java:53) at org.springframework.security.util.FilterChainProxy$VirtualFilterChain.doFilter(FilterChainProxy.java:390) at org.springframework.security.util.FilterChainProxy.doFilter(FilterChainProxy.java:175) at org.springframework.security.util.FilterToBeanProxy.doFilter(FilterToBeanProxy.java:99) at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:235) at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:206) at com.pentaho.ui.servlet.SystemStatusFilter.doFilter(SourceFile:43) at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:235) at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:206) at org.pentaho.platform.web.http.filters.SetCharacterEncodingFilter.doFilter(SetCharacterEncodingFilter.java:113) 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.authenticator.AuthenticatorBase.invoke(AuthenticatorBase.java:470) at org.apache.catalina.core.StandardHostValve.invoke(StandardHostValve.java:127) 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:298) at org.apache.coyote.http11.Http11AprProcessor.process(Http11AprProcessor.java:861) at org.apache.coyote.http11.Http11AprProtocol$Http11ConnectionHandler.process(Http11AprProtocol.java:579) at org.apache.tomcat.util.net.AprEndpoint$Worker.run(AprEndpoint.java:1584) at java.lang.Thread.run(Thread.java:619) 11:10:26,998 ERROR [j] mondrian.olap.MondrianException: Mondrian Error:Unknown aggregator 'none'; valid aggregators are: 'sum', 'count', 'mi n', 'max', 'avg', 'distinct-count' java.lang.RuntimeException: mondrian.olap.MondrianException: Mondrian Error:Unknown aggregator 'none'; valid aggregators are: 'sum', 'count' , 'min', 'max', 'avg', 'distinct-count' at com.pentaho.analyzer.service.impl.OlapConnectionManagerImpl.createConnection(SourceFile:108) at com.pentaho.analyzer.service.impl.d.getConnection(SourceFile:26) at com.pentaho.analyzer.service.impl.OlapMetaDataManager.getConnection(SourceFile:42) at com.pentaho.analyzer.service.impl.AnalysisAreaManager.createOlapConnection(SourceFile:108) at com.pentaho.analyzer.content.a.j.a(SourceFile:68) at com.pentaho.analyzer.content.a.j.dj(SourceFile:95) at com.pentaho.analyzer.content.AnalyzerContentGenerator.createContent(SourceFile:136) at sun.reflect.GeneratedMethodAccessor101.invoke(Unknown Source) at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:25) at java.lang.reflect.Method.invoke(Method.java:597) at com.pentaho.platform.web.http.context.a.invoke(SourceFile:220) at $Proxy24.createContent(Unknown Source) at org.pentaho.platform.web.servlet.GenericServlet.doGet(GenericServlet.java:261) at javax.servlet.http.HttpServlet.service(HttpServlet.java:617) 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 org.pentaho.platform.web.http.filters.PentahoWebContextFilter.doFilter(PentahoWebContextFilter.java:96) at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:235) at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:206) at org.pentaho.platform.web.http.filters.PentahoRequestContextFilter.doFilter(PentahoRequestContextFilter.java:84) at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:235) at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:206) at org.springframework.security.util.FilterChainProxy$VirtualFilterChain.doFilter(FilterChainProxy.java:378) at org.springframework.security.intercept.web.FilterSecurityInterceptor.invoke(FilterSecurityInterceptor.java:109) at org.springframework.security.intercept.web.FilterSecurityInterceptor.doFilter(FilterSecurityInterceptor.java:83) at org.springframework.security.util.FilterChainProxy$VirtualFilterChain.doFilter(FilterChainProxy.java:390) at org.springframework.security.ui.ExceptionTranslationFilter.doFilterHttp(ExceptionTranslationFilter.java:101) at org.springframework.security.ui.SpringSecurityFilter.doFilter(SpringSecurityFilter.java:53) at org.springframework.security.util.FilterChainProxy$VirtualFilterChain.doFilter(FilterChainProxy.java:390) at org.pentaho.platform.web.http.security.SecurityStartupFilter.doFilter(SecurityStartupFilter.java:103) at org.springframework.security.util.FilterChainProxy$VirtualFilterChain.doFilter(FilterChainProxy.java:390) at org.springframework.security.providers.anonymous.AnonymousProcessingFilter.doFilterHttp(AnonymousProcessingFilter.java:105) at org.springframework.security.ui.SpringSecurityFilter.doFilter(SpringSecurityFilter.java:53) at org.springframework.security.util.FilterChainProxy$VirtualFilterChain.doFilter(FilterChainProxy.java:390) at org.pentaho.platform.web.http.security.RequestParameterAuthenticationFilter.doFilter(RequestParameterAuthenticationFilter.java:16 9) at org.springframework.security.util.FilterChainProxy$VirtualFilterChain.doFilter(FilterChainProxy.java:390) at org.springframework.security.ui.basicauth.BasicProcessingFilter.doFilterHttp(BasicProcessingFilter.java:174) at org.springframework.security.ui.SpringSecurityFilter.doFilter(SpringSecurityFilter.java:53) at org.springframework.security.util.FilterChainProxy$VirtualFilterChain.doFilter(FilterChainProxy.java:390) at org.springframework.security.ui.AbstractProcessingFilter.doFilterHttp(AbstractProcessingFilter.java:278) at org.springframework.security.ui.SpringSecurityFilter.doFilter(SpringSecurityFilter.java:53) at org.springframework.security.util.FilterChainProxy$VirtualFilterChain.doFilter(FilterChainProxy.java:390) at org.springframework.security.ui.logout.LogoutFilter.doFilterHttp(LogoutFilter.java:89) at org.springframework.security.ui.SpringSecurityFilter.doFilter(SpringSecurityFilter.java:53) at org.springframework.security.util.FilterChainProxy$VirtualFilterChain.doFilter(FilterChainProxy.java:390) at org.pentaho.platform.web.http.security.HttpSessionReuseDetectionFilter.doFilter(HttpSessionReuseDetectionFilter.java:134) at org.springframework.security.util.FilterChainProxy$VirtualFilterChain.doFilter(FilterChainProxy.java:390) at org.springframework.security.context.HttpSessionContextIntegrationFilter.doFilterHttp(HttpSessionContextIntegrationFilter.java:23 5) at org.springframework.security.ui.SpringSecurityFilter.doFilter(SpringSecurityFilter.java:53) at org.springframework.security.util.FilterChainProxy$VirtualFilterChain.doFilter(FilterChainProxy.java:390) at org.springframework.security.wrapper.SecurityContextHolderAwareRequestFilter.doFilterHttp(SecurityContextHolderAwareRequestFilter .java:91) at org.springframework.security.ui.SpringSecurityFilter.doFilter(SpringSecurityFilter.java:53) at org.springframework.security.util.FilterChainProxy$VirtualFilterChain.doFilter(FilterChainProxy.java:390) at org.springframework.security.util.FilterChainProxy.doFilter(FilterChainProxy.java:175) at org.springframework.security.util.FilterToBeanProxy.doFilter(FilterToBeanProxy.java:99) at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:235) at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:206) at com.pentaho.ui.servlet.SystemStatusFilter.doFilter(SourceFile:43) at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:235) at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:206) at org.pentaho.platform.web.http.filters.SetCharacterEncodingFilter.doFilter(SetCharacterEncodingFilter.java:113) 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.authenticator.AuthenticatorBase.invoke(AuthenticatorBase.java:470) at org.apache.catalina.core.StandardHostValve.invoke(StandardHostValve.java:127) 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:298) at org.apache.coyote.http11.Http11AprProcessor.process(Http11AprProcessor.java:861) at org.apache.coyote.http11.Http11AprProtocol$Http11ConnectionHandler.process(Http11AprProtocol.java:579) at org.apache.tomcat.util.net.AprEndpoint$Worker.run(AprEndpoint.java:1584) at java.lang.Thread.run(Thread.java:619) Caused by: mondrian.olap.MondrianException: Mondrian Error:Unknown aggregator 'none'; valid aggregators are: 'sum', 'count', 'min', 'max', ' avg', 'distinct-count' at mondrian.resource.MondrianResource$_Def1.ex(MondrianResource.java:858) at mondrian.rolap.RolapBaseCubeMeasure.<init>(RolapBaseCubeMeasure.java:116) at mondrian.rolap.RolapCube.createMeasure(RolapCube.java:340) at mondrian.rolap.RolapCube.<init>(RolapCube.java:251) at mondrian.rolap.RolapSchema.load(RolapSchema.java:442) at mondrian.rolap.RolapSchema.load(RolapSchema.java:318) at mondrian.rolap.RolapSchema.<init>(RolapSchema.java:229) at mondrian.rolap.RolapSchema.<init>(RolapSchema.java:54) at mondrian.rolap.RolapSchema$Pool.get(RolapSchema.java:986) at mondrian.rolap.RolapSchema$Pool.get(RolapSchema.java:797) at mondrian.rolap.RolapConnection.<init>(RolapConnection.java:173) at mondrian.rolap.RolapConnection.<init>(RolapConnection.java:95) at mondrian.olap.DriverManager.getConnection(DriverManager.java:110) at org.pentaho.platform.plugin.services.connections.mondrian.MDXConnection.init(MDXConnection.java:227) at org.pentaho.platform.plugin.services.connections.mondrian.MDXConnection.init(MDXConnection.java:146) at org.pentaho.platform.plugin.services.connections.mondrian.MDXConnection.setProperties(MDXConnection.java:106) at org.pentaho.platform.engine.services.connection.PentahoConnectionFactory.getConnection(PentahoConnectionFactory.java:129) at com.pentaho.analyzer.service.impl.OlapConnectionManagerImpl.createConnection(SourceFile:98) ... 74 more 11:10:28,136 ERROR [DefaultThemeManager] Unable to retrieve module theme for (analyzer) as the module theme definition was not found

    Pentaho BI Platform Tracking | 5 years ago | Rob Fellows
    mondrian.olap.MondrianException: Mondrian Error:Unknown aggregator 'none'; valid aggregators are: 'sum', 'count', 'min', 'max', 'avg', 'dist inct-count'

    Not finding the right solution?
    Take a tour to get the most out of Samebug.

    Tired of useless tips?

    Automated exception search integrated into your IDE

    Root Cause Analysis

    1. mondrian.olap.MondrianException

      Mondrian Error:MDX object '[Markets].[All Markets].[{territory}]' not found in cube 'SteelWheelsSales'

      at mondrian.resource.MondrianResource$_Def1.ex()
    2. mondrian.resource
      MondrianResource$_Def1.ex
      1. mondrian.resource.MondrianResource$_Def1.ex(MondrianResource.java:802)
      1 frame
    3. mondrian.olap
      Query$StackValidator.validate
      1. mondrian.olap.Util.lookup(Util.java:775)
      2. mondrian.olap.Id.accept(Id.java:105)
      3. mondrian.olap.Query$StackValidator.validate(Query.java:1260)
      3 frames
    4. mondrian.olap.fun
      FunUtil.resolveFunArgs
      1. mondrian.olap.fun.FunUtil.resolveFunArgs(FunUtil.java:1681)
      1 frame
    5. mondrian.mdx
      UnresolvedFunCall.accept
      1. mondrian.mdx.UnresolvedFunCall.accept(UnresolvedFunCall.java:99)
      1 frame
    6. mondrian.olap
      Parser.do_action
      1. mondrian.olap.Query$StackValidator.validate(Query.java:1260)
      2. mondrian.olap.QueryAxis.validate(QueryAxis.java:269)
      3. mondrian.olap.Query.resolve(Query.java:582)
      4. mondrian.olap.Query.resolve(Query.java:429)
      5. mondrian.olap.Query.<init>(Query.java:226)
      6. mondrian.olap.Query.<init>(Query.java:183)
      7. mondrian.olap.Parser.makeQuery(Parser.java:863)
      8. mondrian.olap.CUP$Parser$actions.CUP$Parser$do_action(Parser.java:1696)
      9. mondrian.olap.Parser.do_action(Parser.java:694)
      9 frames
    7. Xalan Java
      lr_parser.parse
      1. java_cup.runtime.lr_parser.parse(lr_parser.java:569)
      1 frame
    8. mondrian.olap
      ConnectionBase.parseQuery
      1. mondrian.olap.Parser.parseInternal(Parser.java:767)
      2. mondrian.olap.ConnectionBase.parseQuery(ConnectionBase.java:129)
      3. mondrian.olap.ConnectionBase.parseQuery(ConnectionBase.java:59)
      3 frames
    9. org.pentaho.platform
      SolutionEngine.execute
      1. org.pentaho.platform.plugin.services.connections.mondrian.MDXConnection.executeQuery(MDXConnection.java:241)
      2. org.pentaho.platform.plugin.action.mdx.MDXBaseComponent.runQuery(MDXBaseComponent.java:315)
      3. org.pentaho.platform.plugin.action.mdx.MDXBaseComponent.executeAction(MDXBaseComponent.java:181)
      4. org.pentaho.platform.engine.services.solution.ComponentBase.execute(ComponentBase.java:440)
      5. org.pentaho.platform.engine.services.runtime.RuntimeContext.executeComponent(RuntimeContext.java:1298)
      6. org.pentaho.platform.engine.services.runtime.RuntimeContext.executeAction(RuntimeContext.java:1265)
      7. org.pentaho.platform.engine.services.runtime.RuntimeContext.performActions(RuntimeContext.java:1174)
      8. org.pentaho.platform.engine.services.runtime.RuntimeContext.executeLoop(RuntimeContext.java:1127)
      9. org.pentaho.platform.engine.services.runtime.RuntimeContext.executeSequence(RuntimeContext.java:1012)
      10. org.pentaho.platform.engine.services.runtime.RuntimeContext.performActions(RuntimeContext.java:1165)
      11. org.pentaho.platform.engine.services.runtime.RuntimeContext.executeLoop(RuntimeContext.java:1127)
      12. org.pentaho.platform.engine.services.runtime.RuntimeContext.executeSequence(RuntimeContext.java:1012)
      13. org.pentaho.platform.engine.services.runtime.RuntimeContext.executeSequence(RuntimeContext.java:908)
      14. org.pentaho.platform.engine.services.solution.SolutionEngine.executeInternal(SolutionEngine.java:409)
      15. org.pentaho.platform.engine.services.solution.SolutionEngine.execute(SolutionEngine.java:313)
      16. org.pentaho.platform.engine.services.solution.SolutionEngine.execute(SolutionEngine.java:192)
      16 frames
    10. com.pentaho.core
      ProSolutionEngine.execute
      1. com.pentaho.core.solution.ProSolutionEngine.execute(ProSolutionEngine.java:95)
      1 frame
    11. org.pentaho.platform
      ChartHelper.doChart
      1. org.pentaho.platform.uifoundation.chart.AbstractChartComponent.getActionData(AbstractChartComponent.java:192)
      2. org.pentaho.platform.uifoundation.chart.CategoryDatasetChartComponent.createChart(CategoryDatasetChartComponent.java:86)
      3. org.pentaho.platform.uifoundation.chart.CategoryDatasetChartComponent.getXmlContent(CategoryDatasetChartComponent.java:164)
      4. org.pentaho.platform.uifoundation.component.xml.XmlComponent.getContent(XmlComponent.java:55)
      5. org.pentaho.platform.uifoundation.chart.ChartHelper.doChart(ChartHelper.java:279)
      5 frames
    12. org.apache.jsp
      OldHome_jsp._jspService
      1. org.apache.jsp.jsp.OldHome_jsp._jspService(OldHome_jsp.java:169)
      1 frame
    13. GWT dev
      HttpJspBase.service
      1. org.apache.jasper.runtime.HttpJspBase.service(HttpJspBase.java:98)
      1 frame
    14. JavaServlet
      HttpServlet.service
      1. javax.servlet.http.HttpServlet.service(HttpServlet.java:803)
      1 frame
    15. GWT dev
      JspServlet.service
      1. org.apache.jasper.servlet.JspServletWrapper.service(JspServletWrapper.java:331)
      2. org.apache.jasper.servlet.JspServlet.serviceJspFile(JspServlet.java:329)
      3. org.apache.jasper.servlet.JspServlet.service(JspServlet.java:265)
      3 frames
    16. JavaServlet
      HttpServlet.service
      1. javax.servlet.http.HttpServlet.service(HttpServlet.java:803)
      1 frame
    17. Glassfish Core
      ApplicationFilterChain.doFilter
      1. org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:269)
      2. org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:188)
      2 frames
    18. Acegi Security Core
      FilterChainProxy$VirtualFilterChain.doFilter
      1. org.acegisecurity.util.FilterChainProxy$VirtualFilterChain.doFilter(FilterChainProxy.java:265)
      2. org.acegisecurity.intercept.web.FilterSecurityInterceptor.invoke(FilterSecurityInterceptor.java:107)
      3. org.acegisecurity.intercept.web.FilterSecurityInterceptor.doFilter(FilterSecurityInterceptor.java:72)
      4. org.acegisecurity.util.FilterChainProxy$VirtualFilterChain.doFilter(FilterChainProxy.java:275)
      5. org.acegisecurity.ui.ExceptionTranslationFilter.doFilter(ExceptionTranslationFilter.java:124)
      6. org.acegisecurity.util.FilterChainProxy$VirtualFilterChain.doFilter(FilterChainProxy.java:275)
      7. org.acegisecurity.ui.switchuser.SwitchUserProcessingFilter.doFilter(SwitchUserProcessingFilter.java:341)
      8. org.acegisecurity.util.FilterChainProxy$VirtualFilterChain.doFilter(FilterChainProxy.java:275)
      8 frames
    19. org.pentaho.platform
      SecurityStartupFilter.doFilter
      1. org.pentaho.platform.web.http.security.SecurityStartupFilter.doFilter(SecurityStartupFilter.java:81)
      1 frame
    20. Acegi Security Core
      FilterChainProxy$VirtualFilterChain.doFilter
      1. org.acegisecurity.util.FilterChainProxy$VirtualFilterChain.doFilter(FilterChainProxy.java:275)
      2. org.acegisecurity.providers.anonymous.AnonymousProcessingFilter.doFilter(AnonymousProcessingFilter.java:125)
      3. org.acegisecurity.util.FilterChainProxy$VirtualFilterChain.doFilter(FilterChainProxy.java:275)
      4. org.acegisecurity.ui.rememberme.RememberMeProcessingFilter.doFilter(RememberMeProcessingFilter.java:142)
      5. org.acegisecurity.util.FilterChainProxy$VirtualFilterChain.doFilter(FilterChainProxy.java:275)
      5 frames
    21. org.pentaho.platform
      RequestParameterAuthenticationFilter.doFilter
      1. org.pentaho.platform.web.http.security.RequestParameterAuthenticationFilter.doFilter(RequestParameterAuthenticationFilter.java:164)
      1 frame
    22. Acegi Security Core
      FilterChainProxy$VirtualFilterChain.doFilter
      1. org.acegisecurity.util.FilterChainProxy$VirtualFilterChain.doFilter(FilterChainProxy.java:275)
      2. org.acegisecurity.ui.basicauth.BasicProcessingFilter.doFilter(BasicProcessingFilter.java:174)
      3. org.acegisecurity.util.FilterChainProxy$VirtualFilterChain.doFilter(FilterChainProxy.java:275)
      4. org.acegisecurity.ui.AbstractProcessingFilter.doFilter(AbstractProcessingFilter.java:271)
      5. org.acegisecurity.util.FilterChainProxy$VirtualFilterChain.doFilter(FilterChainProxy.java:275)
      6. org.acegisecurity.ui.logout.LogoutFilter.doFilter(LogoutFilter.java:110)
      7. org.acegisecurity.util.FilterChainProxy$VirtualFilterChain.doFilter(FilterChainProxy.java:275)
      7 frames
    23. org.pentaho.platform
      HttpSessionReuseDetectionFilter.doFilter
      1. org.pentaho.platform.web.http.security.HttpSessionReuseDetectionFilter.doFilter(HttpSessionReuseDetectionFilter.java:129)
      1 frame
    24. Acegi Security Core
      FilterToBeanProxy.doFilter
      1. org.acegisecurity.util.FilterChainProxy$VirtualFilterChain.doFilter(FilterChainProxy.java:275)
      2. org.acegisecurity.context.HttpSessionContextIntegrationFilter.doFilter(HttpSessionContextIntegrationFilter.java:249)
      3. org.acegisecurity.util.FilterChainProxy$VirtualFilterChain.doFilter(FilterChainProxy.java:275)
      4. org.acegisecurity.wrapper.SecurityContextHolderAwareRequestFilter.doFilter(SecurityContextHolderAwareRequestFilter.java:81)
      5. org.acegisecurity.util.FilterChainProxy$VirtualFilterChain.doFilter(FilterChainProxy.java:275)
      6. org.acegisecurity.util.FilterChainProxy.doFilter(FilterChainProxy.java:149)
      7. org.acegisecurity.util.FilterToBeanProxy.doFilter(FilterToBeanProxy.java:98)
      7 frames
    25. Glassfish Core
      ApplicationFilterChain.doFilter
      1. org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:215)
      2. org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:188)
      2 frames
    26. com.pentaho.ui
      SystemStatusFilter.doFilter
      1. com.pentaho.ui.servlet.SystemStatusFilter.doFilter(SystemStatusFilter.java:43)
      1 frame
    27. Glassfish Core
      ApplicationFilterChain.doFilter
      1. org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:215)
      2. org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:188)
      2 frames
    28. org.pentaho.platform
      SetCharacterEncodingFilter.doFilter
      1. org.pentaho.platform.web.http.filters.SetCharacterEncodingFilter.doFilter(SetCharacterEncodingFilter.java:113)
      1 frame
    29. Glassfish Core
      CoyoteAdapter.service
      1. org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:215)
      2. org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:188)
      3. org.apache.catalina.core.StandardWrapperValve.invoke(StandardWrapperValve.java:213)
      4. org.apache.catalina.core.StandardContextValve.invoke(StandardContextValve.java:174)
      5. org.apache.catalina.authenticator.AuthenticatorBase.invoke(AuthenticatorBase.java:433)
      6. org.apache.catalina.core.StandardHostValve.invoke(StandardHostValve.java:127)
      7. org.apache.catalina.valves.ErrorReportValve.invoke(ErrorReportValve.java:117)
      8. org.apache.catalina.core.StandardEngineValve.invoke(StandardEngineValve.java:108)
      9. org.apache.catalina.connector.CoyoteAdapter.service(CoyoteAdapter.java:174)
      9 frames
    30. Grizzly HTTP
      LeaderFollowerWorkerThread.runIt
      1. org.apache.coyote.http11.Http11Processor.process(Http11Processor.java:874)
      2. org.apache.coyote.http11.Http11BaseProtocol$Http11ConnectionHandler.processConnection(Http11BaseProtocol.java:665)
      3. org.apache.tomcat.util.net.PoolTcpEndpoint.processSocket(PoolTcpEndpoint.java:528)
      4. org.apache.tomcat.util.net.LeaderFollowerWorkerThread.runIt(LeaderFollowerWorkerThread.java:81)
      4 frames
    31. Tomcat Util
      ThreadPool$ControlRunnable.run
      1. org.apache.tomcat.util.threads.ThreadPool$ControlRunnable.run(ThreadPool.java:689)
      1 frame
    32. Java RT
      Thread.run
      1. java.lang.Thread.run(Unknown Source)
      1 frame