mondrian.olap.MondrianException: Mondrian Error:Failed to parse query 'select {[Measures].[Org Salary], [Measures].[Count]} ON COLUMNS, Crossjoin({[Position].[All Position]}, [Employees].[Sheri Nowmer].Children) ON ROWS from [HR] where [Time].[1997] '

Pentaho BI Platform Tracking | damien hostin | 4 years ago
  1. 0

    here is the case with foodmart.xml I run those updates in pg_admin, in order to rename the employe id from 1 to 99999 : update employee set employee_id='99999' where employee_id='1' update employee set supervisor_id='99999' where supervisor_id='1' update employee_closure set employee_id='99999' where employee_id='1' update employee_closure set supervisor_id='99999' where supervisor_id='1' With hasAll=true on the employee hierarchy, it seems to have no problems. But as our hierarchies already have an "all" member, we decided to set hasAll=false. (This also allow us to have a correct total, but I don't know if it is a side effect or a feature) If you set the hierarchy in FoodMart.xml that way : <Dimension name="Employees" foreignKey="employee_id"> <Hierarchy hasAll="false" defaultMember="Sheri Nowmer" primaryKey="employee_id"> <Table name="employee"/> <Level name="Employee Id" type="Numeric" uniqueMembers="true" column="employee_id" parentColumn="supervisor_id" nameColumn="full_name" nullParentValue="0"> <Closure parentColumn="supervisor_id" childColumn="employee_id"> <Table name="employee_closure"/> </Closure> <Property name="Marital Status" column="marital_status"/> <Property name="Position Title" column="position_title"/> <Property name="Gender" column="gender"/> <Property name="Salary" column="salary"/> <Property name="Education Level" column="education_level"/> <Property name="Management Role" column="management_role"/> </Level> </Hierarchy> </Dimension> and run in a short class that directly query mondrian the following MDX : select {[Measures].[Org Salary], [Measures].[Count]} ON COLUMNS, Hierarchize(Union(Crossjoin({[Position].[All Position]}, {[Employees].[Sheri Nowmer]}), Crossjoin({[Position].[All Position]}, [Employees].[Sheri Nowmer].Children))) ON ROWS from [HR] where [Time].[1997] you get in console : ... DEBUG [main] - Util.lookupCompound: parent.name=Employees, category=member, names=[Sheri Nowmer] DEBUG [main] - 2: SqlTupleReader.readTuples [[Employees].[Employee Id]]: executing sql [select "employee"."supervisor_id" as "c0", "employee"."employee_id" as "c1", "employee"."full_name" as "c2", "employee"."marital_status" as "c3", "employee"."position_title" as "c4", "employee"."gender" as "c5", "employee"."salary" as "c6", "employee"."education_level" as "c7", "employee"."management_role" as "c8" from "employee" as "employee" group by "employee"."supervisor_id", "employee"."employee_id", "employee"."full_name", "employee"."marital_status", "employee"."position_title", "employee"."gender", "employee"."salary", "employee"."education_level", "employee"."management_role" order by "employee"."supervisor_id" ASC NULLS FIRST, "employee"."employee_id" ASC NULLS LAST] ... DEBUG [main] - 2: , exec 23 ms DEBUG [main] - SqlTupleReader.readTuples [[Employees].[Employee Id]]: executing sql [select "employee"."supervisor_id" as "c0", "employee"."employee_id" as "c1", "employee"."full_name" as "c2", "employee"."marital_status" as "c3", "employee"."position_title" as "c4", "employee"."gender" as "c5", "employee"."salary" as "c6", "employee"."education_level" as "c7", "employee"."management_role" as "c8" from "employee" as "employee" group by "employee"."supervisor_id", "employee"."employee_id", "employee"."full_name", "employee"."marital_status", "employee"."position_title", "employee"."gender", "employee"."salary", "employee"."education_level", "employee"."management_role" order by "employee"."supervisor_id" ASC NULLS FIRST, "employee"."employee_id" ASC NULLS LAST], exec 23 ms WARN [main] - The level [Employees].[Employee Id] makes use of the 'parentColumn' attribute, but a parent member for key 2 is missing. This can be due to the usage of the NativizeSet MDX function with a list of members form a parent-child hierarchy that doesn't include all parent members in its definition. Using NativizeSet with a parent-child hierarchy requires the parent members to be included in the set, or the hierarchy cannot be properly built natively. WARN [main] - The level [Employees].[Employee Id] makes use of the 'parentColumn' attribute, but a parent member for key 2 is missing. This can be due to the usage of the NativizeSet MDX function with a list of members form a parent-child hierarchy that doesn't include all parent members in its definition. Using NativizeSet with a parent-child hierarchy requires the parent members to be included in the set, or the hierarchy cannot be properly built natively. ... etc, lot of warn messages ... DEBUG [main] - 2: , exec+fetch 135 ms, 1155 rows DEBUG [main] - SqlTupleReader.readTuples [[Employees].[Employee Id]]: done executing sql [select "employee"."supervisor_id" as "c0", "employee"."employee_id" as "c1", "employee"."full_name" as "c2", "employee"."marital_status" as "c3", "employee"."position_title" as "c4", "employee"."gender" as "c5", "employee"."salary" as "c6", "employee"."education_level" as "c7", "employee"."management_role" as "c8" from "employee" as "employee" group by "employee"."supervisor_id", "employee"."employee_id", "employee"."full_name", "employee"."marital_status", "employee"."position_title", "employee"."gender", "employee"."salary", "employee"."education_level", "employee"."management_role" order by "employee"."supervisor_id" ASC NULLS FIRST, "employee"."employee_id" ASC NULLS LAST], exec+fetch 135 ms, 1155 rows DEBUG [Mondrian Monitor] - SqlStatementEndEvent(2) DEBUG [main] - HierarchyBase.lookupChild: name=Employees, childname=[Sheri Nowmer] returning elementname=Sheri Nowmer DEBUG [main] - Util.lookupCompound: found child.name=Sheri Nowmer, child.class=mondrian.rolap.SqlMemberSource$RolapParentChildMember DEBUG [main] - Normal cardinality for [Employees] DEBUG [main] - HierarchyUsage: kind=PRIVATE, hierarchyName=Employees$Closure, fullName=Employees, foreignKey=employee_id, source=null, level=null, name=Employees, cubeDim=mondrian.olap.MondrianDef$Dimension DEBUG [main] - HierarchyUsage: kind=PRIVATE, hierarchyName=Employees$Closure, fullName=Employees, foreignKey=employee_id, source=null, level=null, name=Employees, cubeDim=mondrian.olap.MondrianDef$Dimension DEBUG [main] - RolapCube.createUsage: cube=HR, hierarchy=Employees$Closure, usage=HierarchyUsage: kind=PRIVATE, hierarchyName=Employees$Closure, fullName=Employees, foreignKey=employee_id, source=null, level=null, name=Employees DEBUG [main] - RolapCube.createUsage: register HierarchyUsage: kind=PRIVATE, hierarchyName=Employees$Closure, fullName=Employees, foreignKey=employee_id, source=null, level=null, name=Employees DEBUG [main] - Normal cardinality for [Employees$Closure] DEBUG [main] - Normal cardinality for [Employees$Closure] DEBUG [main] - RolapCube.getUsages: name=Employees$Closure ... etc ... Axis #0: {[Time].[1997]} Axis #1: {[Measures].[Org Salary]} {[Measures].[Count]} Axis #2: {[Position].[All Position], [Employees].[Sheri Nowmer].[Derrick Whelply]} {[Position].[All Position], [Employees].[Sheri Nowmer].[Michael Spence]} {[Position].[All Position], [Employees].[Sheri Nowmer].[Maya Gutierrez]} {[Position].[All Position], [Employees].[Sheri Nowmer].[Roberta Damstra]} {[Position].[All Position], [Employees].[Sheri Nowmer].[Rebecca Kanagaki]} {[Position].[All Position], [Employees].[Sheri Nowmer].[Darren Stanz]} {[Position].[All Position], [Employees].[Sheri Nowmer].[Donna Arnold]} Row #0: 36 494,07 € Row #0: 7 236 Row #1: Row #1: Row #2: Row #2: Row #3: 428,76 € Row #3: 36 Row #4: 234,36 € Row #4: 24 Row #5: 832,68 € Row #5: 60 Row #6: 577,80 € Row #6: 24 So you get the WARN message that tells the hierarchy is not in the correct order, but the result seems ok. In JPivot, when you try to use the navigator component, you get all the record directly (like a sql resultset) instead of a well built hierarchy. (I haven't get how it queries mondrian yet) If we do not use Closure Table there's a lot of query on the employee table but that's ok because only closure table allow to load hierarchy in a few query. But it ends with that error : Exception in thread "main" mondrian.olap.MondrianException: Mondrian Error:Failed to parse query 'select {[Measures].[Org Salary], [Measures].[Count]} ON COLUMNS, Crossjoin({[Position].[All Position]}, [Employees].[Sheri Nowmer].Children) ON ROWS from [HR] where [Time].[1997] ' at mondrian.resource.MondrianResource$_Def0.ex(MondrianResource.java:942) at mondrian.olap.ConnectionBase.parseStatement(ConnectionBase.java:100) at mondrian.rolap.RolapConnection.parseStatement(RolapConnection.java:765) at mondrian.olap.ConnectionBase.parseQuery(ConnectionBase.java:55) at com.axege.test.analysis.TestMondrian.main(TestMondrian.java:33) Caused by: mondrian.olap.MondrianException: Mondrian Error:MDX object '[Employees].[Sheri Nowmer]' not found in cube 'HR' at mondrian.resource.MondrianResource$_Def1.ex(MondrianResource.java:959) at mondrian.olap.Util.lookup(Util.java:1079) at mondrian.olap.Id.accept(Id.java:103) at mondrian.olap.ValidatorImpl.validate(ValidatorImpl.java:79) at mondrian.olap.fun.FunUtil.resolveFunArgs(FunUtil.java:1981) at mondrian.mdx.UnresolvedFunCall.accept(UnresolvedFunCall.java:102) at mondrian.olap.ValidatorImpl.validate(ValidatorImpl.java:79) at mondrian.olap.fun.FunUtil.resolveFunArgs(FunUtil.java:1981) at mondrian.mdx.UnresolvedFunCall.accept(UnresolvedFunCall.java:102) at mondrian.olap.ValidatorImpl.validate(ValidatorImpl.java:79) at mondrian.olap.QueryAxis.resolve(QueryAxis.java:213) at mondrian.olap.ValidatorImpl.validate(ValidatorImpl.java:140) at mondrian.olap.Query.resolve(Query.java:561) at mondrian.olap.Query.resolve(Query.java:446) at mondrian.olap.Query.<init>(Query.java:200) at mondrian.olap.Query.<init>(Query.java:161) at mondrian.olap.Parser$FactoryImpl.makeQuery(Parser.java:927) at mondrian.parser.MdxParserImpl.selectStatement(MdxParserImpl.java:1184) at mondrian.parser.MdxParserImpl.statement(MdxParserImpl.java:1016) at mondrian.parser.MdxParserImpl.statementEof(MdxParserImpl.java:185) at mondrian.parser.JavaccParserValidatorImpl.parseInternal(JavaccParserValidatorImpl.java:57) at mondrian.olap.ConnectionBase.parseStatement(ConnectionBase.java:96) ... 3 more Damien

    Pentaho BI Platform Tracking | 4 years ago | damien hostin
    mondrian.olap.MondrianException: Mondrian Error:Failed to parse query 'select {[Measures].[Org Salary], [Measures].[Count]} ON COLUMNS, Crossjoin({[Position].[All Position]}, [Employees].[Sheri Nowmer].Children) ON ROWS from [HR] where [Time].[1997] '
  2. 0

    here is the case with foodmart.xml I run those updates in pg_admin, in order to rename the employe id from 1 to 99999 : update employee set employee_id='99999' where employee_id='1' update employee set supervisor_id='99999' where supervisor_id='1' update employee_closure set employee_id='99999' where employee_id='1' update employee_closure set supervisor_id='99999' where supervisor_id='1' With hasAll=true on the employee hierarchy, it seems to have no problems. But as our hierarchies already have an "all" member, we decided to set hasAll=false. (This also allow us to have a correct total, but I don't know if it is a side effect or a feature) If you set the hierarchy in FoodMart.xml that way : <Dimension name="Employees" foreignKey="employee_id"> <Hierarchy hasAll="false" defaultMember="Sheri Nowmer" primaryKey="employee_id"> <Table name="employee"/> <Level name="Employee Id" type="Numeric" uniqueMembers="true" column="employee_id" parentColumn="supervisor_id" nameColumn="full_name" nullParentValue="0"> <Closure parentColumn="supervisor_id" childColumn="employee_id"> <Table name="employee_closure"/> </Closure> <Property name="Marital Status" column="marital_status"/> <Property name="Position Title" column="position_title"/> <Property name="Gender" column="gender"/> <Property name="Salary" column="salary"/> <Property name="Education Level" column="education_level"/> <Property name="Management Role" column="management_role"/> </Level> </Hierarchy> </Dimension> and run in a short class that directly query mondrian the following MDX : select {[Measures].[Org Salary], [Measures].[Count]} ON COLUMNS, Hierarchize(Union(Crossjoin({[Position].[All Position]}, {[Employees].[Sheri Nowmer]}), Crossjoin({[Position].[All Position]}, [Employees].[Sheri Nowmer].Children))) ON ROWS from [HR] where [Time].[1997] you get in console : ... DEBUG [main] - Util.lookupCompound: parent.name=Employees, category=member, names=[Sheri Nowmer] DEBUG [main] - 2: SqlTupleReader.readTuples [[Employees].[Employee Id]]: executing sql [select "employee"."supervisor_id" as "c0", "employee"."employee_id" as "c1", "employee"."full_name" as "c2", "employee"."marital_status" as "c3", "employee"."position_title" as "c4", "employee"."gender" as "c5", "employee"."salary" as "c6", "employee"."education_level" as "c7", "employee"."management_role" as "c8" from "employee" as "employee" group by "employee"."supervisor_id", "employee"."employee_id", "employee"."full_name", "employee"."marital_status", "employee"."position_title", "employee"."gender", "employee"."salary", "employee"."education_level", "employee"."management_role" order by "employee"."supervisor_id" ASC NULLS FIRST, "employee"."employee_id" ASC NULLS LAST] ... DEBUG [main] - 2: , exec 23 ms DEBUG [main] - SqlTupleReader.readTuples [[Employees].[Employee Id]]: executing sql [select "employee"."supervisor_id" as "c0", "employee"."employee_id" as "c1", "employee"."full_name" as "c2", "employee"."marital_status" as "c3", "employee"."position_title" as "c4", "employee"."gender" as "c5", "employee"."salary" as "c6", "employee"."education_level" as "c7", "employee"."management_role" as "c8" from "employee" as "employee" group by "employee"."supervisor_id", "employee"."employee_id", "employee"."full_name", "employee"."marital_status", "employee"."position_title", "employee"."gender", "employee"."salary", "employee"."education_level", "employee"."management_role" order by "employee"."supervisor_id" ASC NULLS FIRST, "employee"."employee_id" ASC NULLS LAST], exec 23 ms WARN [main] - The level [Employees].[Employee Id] makes use of the 'parentColumn' attribute, but a parent member for key 2 is missing. This can be due to the usage of the NativizeSet MDX function with a list of members form a parent-child hierarchy that doesn't include all parent members in its definition. Using NativizeSet with a parent-child hierarchy requires the parent members to be included in the set, or the hierarchy cannot be properly built natively. WARN [main] - The level [Employees].[Employee Id] makes use of the 'parentColumn' attribute, but a parent member for key 2 is missing. This can be due to the usage of the NativizeSet MDX function with a list of members form a parent-child hierarchy that doesn't include all parent members in its definition. Using NativizeSet with a parent-child hierarchy requires the parent members to be included in the set, or the hierarchy cannot be properly built natively. ... etc, lot of warn messages ... DEBUG [main] - 2: , exec+fetch 135 ms, 1155 rows DEBUG [main] - SqlTupleReader.readTuples [[Employees].[Employee Id]]: done executing sql [select "employee"."supervisor_id" as "c0", "employee"."employee_id" as "c1", "employee"."full_name" as "c2", "employee"."marital_status" as "c3", "employee"."position_title" as "c4", "employee"."gender" as "c5", "employee"."salary" as "c6", "employee"."education_level" as "c7", "employee"."management_role" as "c8" from "employee" as "employee" group by "employee"."supervisor_id", "employee"."employee_id", "employee"."full_name", "employee"."marital_status", "employee"."position_title", "employee"."gender", "employee"."salary", "employee"."education_level", "employee"."management_role" order by "employee"."supervisor_id" ASC NULLS FIRST, "employee"."employee_id" ASC NULLS LAST], exec+fetch 135 ms, 1155 rows DEBUG [Mondrian Monitor] - SqlStatementEndEvent(2) DEBUG [main] - HierarchyBase.lookupChild: name=Employees, childname=[Sheri Nowmer] returning elementname=Sheri Nowmer DEBUG [main] - Util.lookupCompound: found child.name=Sheri Nowmer, child.class=mondrian.rolap.SqlMemberSource$RolapParentChildMember DEBUG [main] - Normal cardinality for [Employees] DEBUG [main] - HierarchyUsage: kind=PRIVATE, hierarchyName=Employees$Closure, fullName=Employees, foreignKey=employee_id, source=null, level=null, name=Employees, cubeDim=mondrian.olap.MondrianDef$Dimension DEBUG [main] - HierarchyUsage: kind=PRIVATE, hierarchyName=Employees$Closure, fullName=Employees, foreignKey=employee_id, source=null, level=null, name=Employees, cubeDim=mondrian.olap.MondrianDef$Dimension DEBUG [main] - RolapCube.createUsage: cube=HR, hierarchy=Employees$Closure, usage=HierarchyUsage: kind=PRIVATE, hierarchyName=Employees$Closure, fullName=Employees, foreignKey=employee_id, source=null, level=null, name=Employees DEBUG [main] - RolapCube.createUsage: register HierarchyUsage: kind=PRIVATE, hierarchyName=Employees$Closure, fullName=Employees, foreignKey=employee_id, source=null, level=null, name=Employees DEBUG [main] - Normal cardinality for [Employees$Closure] DEBUG [main] - Normal cardinality for [Employees$Closure] DEBUG [main] - RolapCube.getUsages: name=Employees$Closure ... etc ... Axis #0: {[Time].[1997]} Axis #1: {[Measures].[Org Salary]} {[Measures].[Count]} Axis #2: {[Position].[All Position], [Employees].[Sheri Nowmer].[Derrick Whelply]} {[Position].[All Position], [Employees].[Sheri Nowmer].[Michael Spence]} {[Position].[All Position], [Employees].[Sheri Nowmer].[Maya Gutierrez]} {[Position].[All Position], [Employees].[Sheri Nowmer].[Roberta Damstra]} {[Position].[All Position], [Employees].[Sheri Nowmer].[Rebecca Kanagaki]} {[Position].[All Position], [Employees].[Sheri Nowmer].[Darren Stanz]} {[Position].[All Position], [Employees].[Sheri Nowmer].[Donna Arnold]} Row #0: 36 494,07 € Row #0: 7 236 Row #1: Row #1: Row #2: Row #2: Row #3: 428,76 € Row #3: 36 Row #4: 234,36 € Row #4: 24 Row #5: 832,68 € Row #5: 60 Row #6: 577,80 € Row #6: 24 So you get the WARN message that tells the hierarchy is not in the correct order, but the result seems ok. In JPivot, when you try to use the navigator component, you get all the record directly (like a sql resultset) instead of a well built hierarchy. (I haven't get how it queries mondrian yet) If we do not use Closure Table there's a lot of query on the employee table but that's ok because only closure table allow to load hierarchy in a few query. But it ends with that error : Exception in thread "main" mondrian.olap.MondrianException: Mondrian Error:Failed to parse query 'select {[Measures].[Org Salary], [Measures].[Count]} ON COLUMNS, Crossjoin({[Position].[All Position]}, [Employees].[Sheri Nowmer].Children) ON ROWS from [HR] where [Time].[1997] ' at mondrian.resource.MondrianResource$_Def0.ex(MondrianResource.java:942) at mondrian.olap.ConnectionBase.parseStatement(ConnectionBase.java:100) at mondrian.rolap.RolapConnection.parseStatement(RolapConnection.java:765) at mondrian.olap.ConnectionBase.parseQuery(ConnectionBase.java:55) at com.axege.test.analysis.TestMondrian.main(TestMondrian.java:33) Caused by: mondrian.olap.MondrianException: Mondrian Error:MDX object '[Employees].[Sheri Nowmer]' not found in cube 'HR' at mondrian.resource.MondrianResource$_Def1.ex(MondrianResource.java:959) at mondrian.olap.Util.lookup(Util.java:1079) at mondrian.olap.Id.accept(Id.java:103) at mondrian.olap.ValidatorImpl.validate(ValidatorImpl.java:79) at mondrian.olap.fun.FunUtil.resolveFunArgs(FunUtil.java:1981) at mondrian.mdx.UnresolvedFunCall.accept(UnresolvedFunCall.java:102) at mondrian.olap.ValidatorImpl.validate(ValidatorImpl.java:79) at mondrian.olap.fun.FunUtil.resolveFunArgs(FunUtil.java:1981) at mondrian.mdx.UnresolvedFunCall.accept(UnresolvedFunCall.java:102) at mondrian.olap.ValidatorImpl.validate(ValidatorImpl.java:79) at mondrian.olap.QueryAxis.resolve(QueryAxis.java:213) at mondrian.olap.ValidatorImpl.validate(ValidatorImpl.java:140) at mondrian.olap.Query.resolve(Query.java:561) at mondrian.olap.Query.resolve(Query.java:446) at mondrian.olap.Query.<init>(Query.java:200) at mondrian.olap.Query.<init>(Query.java:161) at mondrian.olap.Parser$FactoryImpl.makeQuery(Parser.java:927) at mondrian.parser.MdxParserImpl.selectStatement(MdxParserImpl.java:1184) at mondrian.parser.MdxParserImpl.statement(MdxParserImpl.java:1016) at mondrian.parser.MdxParserImpl.statementEof(MdxParserImpl.java:185) at mondrian.parser.JavaccParserValidatorImpl.parseInternal(JavaccParserValidatorImpl.java:57) at mondrian.olap.ConnectionBase.parseStatement(ConnectionBase.java:96) ... 3 more Damien

    Pentaho BI Platform Tracking | 4 years ago | damien hostin
    mondrian.olap.MondrianException: Mondrian Error:Failed to parse query 'select {[Measures].[Org Salary], [Measures].[Count]} ON COLUMNS, Crossjoin({[Position].[All Position]}, [Employees].[Sheri Nowmer].Children) ON ROWS from [HR] where [Time].[1997] '
  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

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

    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 '[Employees].[Sheri Nowmer]' not found in cube 'HR'

      at mondrian.resource.MondrianResource$_Def1.ex()
    2. mondrian.resource
      MondrianResource$_Def1.ex
      1. mondrian.resource.MondrianResource$_Def1.ex(MondrianResource.java:959)
      1 frame
    3. mondrian.olap
      ValidatorImpl.validate
      1. mondrian.olap.Util.lookup(Util.java:1079)
      2. mondrian.olap.Id.accept(Id.java:103)
      3. mondrian.olap.ValidatorImpl.validate(ValidatorImpl.java:79)
      3 frames
    4. mondrian.olap.fun
      FunUtil.resolveFunArgs
      1. mondrian.olap.fun.FunUtil.resolveFunArgs(FunUtil.java:1981)
      1 frame
    5. mondrian.mdx
      UnresolvedFunCall.accept
      1. mondrian.mdx.UnresolvedFunCall.accept(UnresolvedFunCall.java:102)
      1 frame
    6. mondrian.olap
      ValidatorImpl.validate
      1. mondrian.olap.ValidatorImpl.validate(ValidatorImpl.java:79)
      1 frame
    7. mondrian.olap.fun
      FunUtil.resolveFunArgs
      1. mondrian.olap.fun.FunUtil.resolveFunArgs(FunUtil.java:1981)
      1 frame
    8. mondrian.mdx
      UnresolvedFunCall.accept
      1. mondrian.mdx.UnresolvedFunCall.accept(UnresolvedFunCall.java:102)
      1 frame
    9. mondrian.olap
      Parser$FactoryImpl.makeQuery
      1. mondrian.olap.ValidatorImpl.validate(ValidatorImpl.java:79)
      2. mondrian.olap.QueryAxis.resolve(QueryAxis.java:213)
      3. mondrian.olap.ValidatorImpl.validate(ValidatorImpl.java:140)
      4. mondrian.olap.Query.resolve(Query.java:561)
      5. mondrian.olap.Query.resolve(Query.java:446)
      6. mondrian.olap.Query.<init>(Query.java:200)
      7. mondrian.olap.Query.<init>(Query.java:161)
      8. mondrian.olap.Parser$FactoryImpl.makeQuery(Parser.java:927)
      8 frames
    10. mondrian.parser
      JavaccParserValidatorImpl.parseInternal
      1. mondrian.parser.MdxParserImpl.selectStatement(MdxParserImpl.java:1184)
      2. mondrian.parser.MdxParserImpl.statement(MdxParserImpl.java:1016)
      3. mondrian.parser.MdxParserImpl.statementEof(MdxParserImpl.java:185)
      4. mondrian.parser.JavaccParserValidatorImpl.parseInternal(JavaccParserValidatorImpl.java:57)
      4 frames
    11. mondrian.olap
      ConnectionBase.parseStatement
      1. mondrian.olap.ConnectionBase.parseStatement(ConnectionBase.java:96)
      1 frame
    12. mondrian.rolap
      RolapConnection.parseStatement
      1. mondrian.rolap.RolapConnection.parseStatement(RolapConnection.java:765)
      1 frame
    13. mondrian.olap
      ConnectionBase.parseQuery
      1. mondrian.olap.ConnectionBase.parseQuery(ConnectionBase.java:55)
      1 frame
    14. com.axege.test
      TestMondrian.main
      1. com.axege.test.analysis.TestMondrian.main(TestMondrian.java:33)
      1 frame