mondrian.olap.MondrianException: Mondrian Error:Member '[Store].[USA].[CA]' not found

Pentaho BI Platform Tracking | Luc Boudreau | 7 years ago
tip
Your exception is missing from the Samebug knowledge base.
Here are the best solutions we found on the Internet.
Click on the to mark the helpful solution and get rewards for you help.
  1. 0

    When I run the test suite against a MySQL database on a Windows machine, i get exceptions. The database is configured to use UTF-8 collation. Looking at the sql logs, I can confirm that the actual row was retrieved. mondrian.olap.MondrianException: Mondrian Error:Member '[Store].[USA].[CA]' not found at mondrian.resource.MondrianResource$_Def0.ex(MondrianResource.java:838) at mondrian.olap.Util.lookupCompound(Util.java:589) at mondrian.rolap.RolapSchemaReader.lookupCompound(RolapSchemaReader.java:406) at mondrian.rolap.RolapCube$RolapCubeSchemaReader.getMemberByUniqueName(RolapCube.java:2816) at mondrian.rolap.RolapSchemaReader.getMemberByUniqueName(RolapSchemaReader.java:375) at mondrian.rolap.RolapSchema.createRole(RolapSchema.java:631) at mondrian.rolap.RolapSchema.load(RolapSchema.java:446) at mondrian.rolap.RolapSchema.load(RolapSchema.java:309) at mondrian.rolap.RolapSchema.<init>(RolapSchema.java:210) at mondrian.rolap.RolapSchema.<init>(RolapSchema.java:201) at mondrian.rolap.RolapSchema$Pool.get(RolapSchema.java:868) at mondrian.rolap.RolapSchema$Pool.get(RolapSchema.java:766) at mondrian.rolap.RolapConnection.<init>(RolapConnection.java:166) at mondrian.rolap.RolapConnection.<init>(RolapConnection.java:95) at mondrian.olap.DriverManager.getConnection(DriverManager.java:110) at mondrian.test.TestContext.getFoodMartConnection(TestContext.java:255) at mondrian.test.TestContext.getRawFoodMartSchema(TestContext.java:407) at mondrian.test.TestContext.getFoodMartSchema(TestContext.java:335) at mondrian.test.TestContext$6.getFoodMartConnectionProperties(TestContext.java:1712) at mondrian.test.TestContext$9.getFoodMartConnectionProperties(TestContext.java:1819) at mondrian.test.TestContext.getFoodMartConnection(TestContext.java:233) at mondrian.test.TestContext.getConnection(TestContext.java:207) at mondrian.test.TestContext.executeQuery(TestContext.java:513) at mondrian.test.TestContext.assertQueryReturns(TestContext.java:1082) at mondrian.test.Aaaaa.testBug721(Aaaaa.java:53) at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method) at sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:39) at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:25) at java.lang.reflect.Method.invoke(Method.java:592) at junit.framework.TestCase.runTest(TestCase.java:164) at junit.framework.TestCase.runBare(TestCase.java:130) at junit.framework.TestResult$1.protect(TestResult.java:110) at junit.framework.TestResult.runProtected(TestResult.java:128) at junit.framework.TestResult.run(TestResult.java:113) at junit.framework.TestCase.run(TestCase.java:120) at junit.framework.TestSuite.runTest(TestSuite.java:228) at junit.framework.TestSuite.run(TestSuite.java:223) at org.junit.internal.runners.OldTestClassRunner.run(OldTestClassRunner.java:35) at org.eclipse.jdt.internal.junit4.runner.JUnit4TestReference.run(JUnit4TestReference.java:46) at org.eclipse.jdt.internal.junit.runner.TestExecution.run(TestExecution.java:38) at org.eclipse.jdt.internal.junit.runner.RemoteTestRunner.runTests(RemoteTestRunner.java:467) at org.eclipse.jdt.internal.junit.runner.RemoteTestRunner.runTests(RemoteTestRunner.java:683) at org.eclipse.jdt.internal.junit.runner.RemoteTestRunner.run(RemoteTestRunner.java:390) at org.eclipse.jdt.internal.junit.runner.RemoteTestRunner.main(RemoteTestRunner.java:197) 2010-08-10 11:50:27,648 DEBUG [mondrian.sql] 7: SqlMemberSource.getMemberChildren: executing sql [select `store`.`store_country` as `c0` from `store` as `store` where UPPER(`store`.`store_country`) = UPPER('USA') group by `store`.`store_country` order by ISNULL(`store`.`store_country`), `store`.`store_country` ASC] 2010-08-10 11:50:27,663 DEBUG [mondrian.sql] 7: , exec 15 ms 2010-08-10 11:50:27,663 DEBUG [mondrian.sql] 7: , exec+fetch 15 ms, 1 rows

    Pentaho BI Platform Tracking | 7 years ago | Luc Boudreau
    mondrian.olap.MondrianException: Mondrian Error:Member '[Store].[USA].[CA]' not found
  2. 0

    When I run the test suite against a MySQL database on a Windows machine, i get exceptions. The database is configured to use UTF-8 collation. Looking at the sql logs, I can confirm that the actual row was retrieved. mondrian.olap.MondrianException: Mondrian Error:Member '[Store].[USA].[CA]' not found at mondrian.resource.MondrianResource$_Def0.ex(MondrianResource.java:838) at mondrian.olap.Util.lookupCompound(Util.java:589) at mondrian.rolap.RolapSchemaReader.lookupCompound(RolapSchemaReader.java:406) at mondrian.rolap.RolapCube$RolapCubeSchemaReader.getMemberByUniqueName(RolapCube.java:2816) at mondrian.rolap.RolapSchemaReader.getMemberByUniqueName(RolapSchemaReader.java:375) at mondrian.rolap.RolapSchema.createRole(RolapSchema.java:631) at mondrian.rolap.RolapSchema.load(RolapSchema.java:446) at mondrian.rolap.RolapSchema.load(RolapSchema.java:309) at mondrian.rolap.RolapSchema.<init>(RolapSchema.java:210) at mondrian.rolap.RolapSchema.<init>(RolapSchema.java:201) at mondrian.rolap.RolapSchema$Pool.get(RolapSchema.java:868) at mondrian.rolap.RolapSchema$Pool.get(RolapSchema.java:766) at mondrian.rolap.RolapConnection.<init>(RolapConnection.java:166) at mondrian.rolap.RolapConnection.<init>(RolapConnection.java:95) at mondrian.olap.DriverManager.getConnection(DriverManager.java:110) at mondrian.test.TestContext.getFoodMartConnection(TestContext.java:255) at mondrian.test.TestContext.getRawFoodMartSchema(TestContext.java:407) at mondrian.test.TestContext.getFoodMartSchema(TestContext.java:335) at mondrian.test.TestContext$6.getFoodMartConnectionProperties(TestContext.java:1712) at mondrian.test.TestContext$9.getFoodMartConnectionProperties(TestContext.java:1819) at mondrian.test.TestContext.getFoodMartConnection(TestContext.java:233) at mondrian.test.TestContext.getConnection(TestContext.java:207) at mondrian.test.TestContext.executeQuery(TestContext.java:513) at mondrian.test.TestContext.assertQueryReturns(TestContext.java:1082) at mondrian.test.Aaaaa.testBug721(Aaaaa.java:53) at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method) at sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:39) at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:25) at java.lang.reflect.Method.invoke(Method.java:592) at junit.framework.TestCase.runTest(TestCase.java:164) at junit.framework.TestCase.runBare(TestCase.java:130) at junit.framework.TestResult$1.protect(TestResult.java:110) at junit.framework.TestResult.runProtected(TestResult.java:128) at junit.framework.TestResult.run(TestResult.java:113) at junit.framework.TestCase.run(TestCase.java:120) at junit.framework.TestSuite.runTest(TestSuite.java:228) at junit.framework.TestSuite.run(TestSuite.java:223) at org.junit.internal.runners.OldTestClassRunner.run(OldTestClassRunner.java:35) at org.eclipse.jdt.internal.junit4.runner.JUnit4TestReference.run(JUnit4TestReference.java:46) at org.eclipse.jdt.internal.junit.runner.TestExecution.run(TestExecution.java:38) at org.eclipse.jdt.internal.junit.runner.RemoteTestRunner.runTests(RemoteTestRunner.java:467) at org.eclipse.jdt.internal.junit.runner.RemoteTestRunner.runTests(RemoteTestRunner.java:683) at org.eclipse.jdt.internal.junit.runner.RemoteTestRunner.run(RemoteTestRunner.java:390) at org.eclipse.jdt.internal.junit.runner.RemoteTestRunner.main(RemoteTestRunner.java:197) 2010-08-10 11:50:27,648 DEBUG [mondrian.sql] 7: SqlMemberSource.getMemberChildren: executing sql [select `store`.`store_country` as `c0` from `store` as `store` where UPPER(`store`.`store_country`) = UPPER('USA') group by `store`.`store_country` order by ISNULL(`store`.`store_country`), `store`.`store_country` ASC] 2010-08-10 11:50:27,663 DEBUG [mondrian.sql] 7: , exec 15 ms 2010-08-10 11:50:27,663 DEBUG [mondrian.sql] 7: , exec+fetch 15 ms, 1 rows

    Pentaho BI Platform Tracking | 7 years ago | Luc Boudreau
    mondrian.olap.MondrianException: Mondrian Error:Member '[Store].[USA].[CA]' not found
  3. 0

    run the attached report. The error message = unable to initialize the report. No stack trace with an explanation. Change the de default value of param1 to "param1" without quotes. Look at the parameter part in the MDX : Parameter("param1", STRING, "param1") It replaces the wrong part!!!!!!!!!!!! The stack trace now is as follows: org.pentaho.reporting.engine.classic.core.ReportProcessingException: Unable to initialize the report at org.pentaho.reporting.engine.classic.core.layout.output.AbstractReportProcessor.prepareReportProcessing(AbstractReportProcessor.java:482) at org.pentaho.reporting.engine.classic.core.modules.output.pageable.graphics.PrintReportProcessor.getNumberOfPages(PrintReportProcessor.java:77) at org.pentaho.reporting.engine.classic.core.modules.gui.base.PreviewPane$RepaginationRunnable.run(PreviewPane.java:266) at org.pentaho.reporting.engine.classic.core.util.Worker.run(Worker.java:174) ParentException: org.pentaho.reporting.engine.classic.core.ReportDataFactoryException: Failed to create datasource:Mondrian Error:Internal error: Error while executing query [select Crossjoin({StrToMember(Parameter("param1", STRING, "param1"))}, {[Measures].[Quantity], [Measures].[Sales]}) ON COLUMNS, {[Product].[All Products].[Classic Cars], [Product].[All Products].[Motorcycles], [Product].[All Products].[Planes], [Product].[All Products].[Ships], [Product].[All Products].[Trains], [Product].[All Products].[Trucks and Buses], [Product].[All Products].[Vintage Cars]} ON ROWS from [SteelWheelsSales] ] at org.pentaho.reporting.engine.classic.extensions.datasources.mondrian.AbstractMDXDataFactory.performQuery(AbstractMDXDataFactory.java:354) at org.pentaho.reporting.engine.classic.extensions.datasources.mondrian.AbstractNamedMDXDataFactory.performQuery(AbstractNamedMDXDataFactory.java:81) at org.pentaho.reporting.engine.classic.extensions.datasources.mondrian.DenormalizedMDXDataFactory.queryData(DenormalizedMDXDataFactory.java:51) at org.pentaho.reporting.engine.classic.core.CompoundDataFactory.queryData(CompoundDataFactory.java:88) at org.pentaho.reporting.engine.classic.core.states.CachingDataFactory.queryInternal(CachingDataFactory.java:168) at org.pentaho.reporting.engine.classic.core.states.CachingDataFactory.queryData(CachingDataFactory.java:143) at org.pentaho.reporting.engine.classic.core.states.CascadingDataFactory.queryData(CascadingDataFactory.java:81) at org.pentaho.reporting.engine.classic.core.states.datarow.ReportDataRow.createDataRow(ReportDataRow.java:97) at org.pentaho.reporting.engine.classic.core.states.datarow.DefaultFlowController.performQuery(DefaultFlowController.java:185) at org.pentaho.reporting.engine.classic.core.states.process.ProcessState.<init>(ProcessState.java:265) at org.pentaho.reporting.engine.classic.core.layout.output.AbstractReportProcessor.prepareReportProcessing(AbstractReportProcessor.java:389) at org.pentaho.reporting.engine.classic.core.modules.output.pageable.graphics.PrintReportProcessor.getNumberOfPages(PrintReportProcessor.java:77) at org.pentaho.reporting.engine.classic.core.modules.gui.base.PreviewPane$RepaginationRunnable.run(PreviewPane.java:266) at org.pentaho.reporting.engine.classic.core.util.Worker.run(Worker.java:174) ParentException: mondrian.olap.MondrianException: Mondrian Error:Internal error: Error while executing query [select Crossjoin({StrToMember(Parameter("param1", STRING, "param1"))}, {[Measures].[Quantity], [Measures].[Sales]}) ON COLUMNS, {[Product].[All Products].[Classic Cars], [Product].[All Products].[Motorcycles], [Product].[All Products].[Planes], [Product].[All Products].[Ships], [Product].[All Products].[Trains], [Product].[All Products].[Trucks and Buses], [Product].[All Products].[Vintage Cars]} ON ROWS from [SteelWheelsSales] ] at mondrian.resource.MondrianResource$_Def0.ex(MondrianResource.java:816) at mondrian.olap.Util.newInternal(Util.java:1466) at mondrian.olap.Util.newError(Util.java:1482) at mondrian.rolap.RolapConnection.execute(RolapConnection.java:592) at org.pentaho.reporting.engine.classic.extensions.datasources.mondrian.AbstractMDXDataFactory.performQuery(AbstractMDXDataFactory.java:345) at org.pentaho.reporting.engine.classic.extensions.datasources.mondrian.AbstractNamedMDXDataFactory.performQuery(AbstractNamedMDXDataFactory.java:81) at org.pentaho.reporting.engine.classic.extensions.datasources.mondrian.DenormalizedMDXDataFactory.queryData(DenormalizedMDXDataFactory.java:51) at org.pentaho.reporting.engine.classic.core.CompoundDataFactory.queryData(CompoundDataFactory.java:88) at org.pentaho.reporting.engine.classic.core.states.CachingDataFactory.queryInternal(CachingDataFactory.java:168) at org.pentaho.reporting.engine.classic.core.states.CachingDataFactory.queryData(CachingDataFactory.java:143) at org.pentaho.reporting.engine.classic.core.states.CascadingDataFactory.queryData(CascadingDataFactory.java:81) at org.pentaho.reporting.engine.classic.core.states.datarow.ReportDataRow.createDataRow(ReportDataRow.java:97) at org.pentaho.reporting.engine.classic.core.states.datarow.DefaultFlowController.performQuery(DefaultFlowController.java:185) at org.pentaho.reporting.engine.classic.core.states.process.ProcessState.<init>(ProcessState.java:265) at org.pentaho.reporting.engine.classic.core.layout.output.AbstractReportProcessor.prepareReportProcessing(AbstractReportProcessor.java:389) at org.pentaho.reporting.engine.classic.core.modules.output.pageable.graphics.PrintReportProcessor.getNumberOfPages(PrintReportProcessor.java:77) at org.pentaho.reporting.engine.classic.core.modules.gui.base.PreviewPane$RepaginationRunnable.run(PreviewPane.java:266) at org.pentaho.reporting.engine.classic.core.util.Worker.run(Worker.java:174) Caused by: mondrian.olap.MondrianException: Mondrian Error:Member '[param1]' not found at mondrian.resource.MondrianResource$_Def0.ex(MondrianResource.java:813) at mondrian.olap.Util.lookupCompound(Util.java:639) at mondrian.rolap.RolapSchemaReader.lookupCompound(RolapSchemaReader.java:386) at mondrian.olap.DelegatingSchemaReader.lookupCompound(DelegatingSchemaReader.java:108) at mondrian.olap.Query$QuerySchemaReader.lookupCompound(Query.java:1508) at mondrian.olap.Query$QuerySchemaReader.lookupCompound(Query.java:1469) at mondrian.olap.fun.BuiltinFunTable$22.strToMember(BuiltinFunTable.java:725) at mondrian.olap.fun.BuiltinFunTable$22$1.evaluateMember(BuiltinFunTable.java:715) at mondrian.olap.fun.SetFunDef$MemberSetListCalc$2.evaluateVoid(SetFunDef.java:173) at mondrian.olap.fun.SetFunDef$MemberSetListCalc.evaluateMemberList(SetFunDef.java:190) at mondrian.calc.impl.AbstractMemberListCalc.evaluateList(AbstractMemberListCalc.java:87) at mondrian.rolap.RolapNativeSet.expandNonNative(RolapNativeSet.java:826) at mondrian.rolap.RolapNativeSet.checkCrossJoin(RolapNativeSet.java:804) at mondrian.rolap.RolapNativeCrossJoin.createEvaluator(RolapNativeCrossJoin.java:86) at mondrian.rolap.RolapNativeRegistry.createEvaluator(RolapNativeRegistry.java:55) at mondrian.rolap.RolapSchemaReader.getNativeSetEvaluator(RolapSchemaReader.java:566) at mondrian.olap.DelegatingSchemaReader.getNativeSetEvaluator(DelegatingSchemaReader.java:220) at mondrian.olap.fun.CrossJoinFunDef$BaseTupleIterCalc.evaluateTupleIterable(CrossJoinFunDef.java:253) at mondrian.calc.impl.AbstractTupleIterCalc.evaluate(AbstractTupleIterCalc.java:52) at mondrian.rolap.RolapResult.executeAxis(RolapResult.java:727) at mondrian.rolap.RolapResult.evalLoad(RolapResult.java:570) at mondrian.rolap.RolapResult.loadMembers(RolapResult.java:536) at mondrian.rolap.RolapResult.<init>(RolapResult.java:269) at mondrian.rolap.RolapConnection.execute(RolapConnection.java:563) ... 14 more

    Pentaho BI Platform Tracking | 7 years ago | gunter rombauts
    mondrian.olap.MondrianException: Mondrian Error:Internal error: Error while executing query [select Crossjoin({StrToMember(Parameter("param1", STRING, "param1"))}, {[Measures].[Quantity], [Measures].[Sales]}) ON COLUMNS, {[Product].[All Products].[Classic Cars], [Product].[All Products].[Motorcycles], [Product].[All Products].[Planes], [Product].[All Products].[Ships], [Product].[All Products].[Trains], [Product].[All Products].[Trucks and Buses], [Product].[All Products].[Vintage Cars]} ON ROWS from [SteelWheelsSales] ]
  4. Speed up your debug routine!

    Automated exception search integrated into your IDE

  5. 0

    run the attached report. The error message = unable to initialize the report. No stack trace with an explanation. Change the de default value of param1 to "param1" without quotes. Look at the parameter part in the MDX : Parameter("param1", STRING, "param1") It replaces the wrong part!!!!!!!!!!!! The stack trace now is as follows: org.pentaho.reporting.engine.classic.core.ReportProcessingException: Unable to initialize the report at org.pentaho.reporting.engine.classic.core.layout.output.AbstractReportProcessor.prepareReportProcessing(AbstractReportProcessor.java:482) at org.pentaho.reporting.engine.classic.core.modules.output.pageable.graphics.PrintReportProcessor.getNumberOfPages(PrintReportProcessor.java:77) at org.pentaho.reporting.engine.classic.core.modules.gui.base.PreviewPane$RepaginationRunnable.run(PreviewPane.java:266) at org.pentaho.reporting.engine.classic.core.util.Worker.run(Worker.java:174) ParentException: org.pentaho.reporting.engine.classic.core.ReportDataFactoryException: Failed to create datasource:Mondrian Error:Internal error: Error while executing query [select Crossjoin({StrToMember(Parameter("param1", STRING, "param1"))}, {[Measures].[Quantity], [Measures].[Sales]}) ON COLUMNS, {[Product].[All Products].[Classic Cars], [Product].[All Products].[Motorcycles], [Product].[All Products].[Planes], [Product].[All Products].[Ships], [Product].[All Products].[Trains], [Product].[All Products].[Trucks and Buses], [Product].[All Products].[Vintage Cars]} ON ROWS from [SteelWheelsSales] ] at org.pentaho.reporting.engine.classic.extensions.datasources.mondrian.AbstractMDXDataFactory.performQuery(AbstractMDXDataFactory.java:354) at org.pentaho.reporting.engine.classic.extensions.datasources.mondrian.AbstractNamedMDXDataFactory.performQuery(AbstractNamedMDXDataFactory.java:81) at org.pentaho.reporting.engine.classic.extensions.datasources.mondrian.DenormalizedMDXDataFactory.queryData(DenormalizedMDXDataFactory.java:51) at org.pentaho.reporting.engine.classic.core.CompoundDataFactory.queryData(CompoundDataFactory.java:88) at org.pentaho.reporting.engine.classic.core.states.CachingDataFactory.queryInternal(CachingDataFactory.java:168) at org.pentaho.reporting.engine.classic.core.states.CachingDataFactory.queryData(CachingDataFactory.java:143) at org.pentaho.reporting.engine.classic.core.states.CascadingDataFactory.queryData(CascadingDataFactory.java:81) at org.pentaho.reporting.engine.classic.core.states.datarow.ReportDataRow.createDataRow(ReportDataRow.java:97) at org.pentaho.reporting.engine.classic.core.states.datarow.DefaultFlowController.performQuery(DefaultFlowController.java:185) at org.pentaho.reporting.engine.classic.core.states.process.ProcessState.<init>(ProcessState.java:265) at org.pentaho.reporting.engine.classic.core.layout.output.AbstractReportProcessor.prepareReportProcessing(AbstractReportProcessor.java:389) at org.pentaho.reporting.engine.classic.core.modules.output.pageable.graphics.PrintReportProcessor.getNumberOfPages(PrintReportProcessor.java:77) at org.pentaho.reporting.engine.classic.core.modules.gui.base.PreviewPane$RepaginationRunnable.run(PreviewPane.java:266) at org.pentaho.reporting.engine.classic.core.util.Worker.run(Worker.java:174) ParentException: mondrian.olap.MondrianException: Mondrian Error:Internal error: Error while executing query [select Crossjoin({StrToMember(Parameter("param1", STRING, "param1"))}, {[Measures].[Quantity], [Measures].[Sales]}) ON COLUMNS, {[Product].[All Products].[Classic Cars], [Product].[All Products].[Motorcycles], [Product].[All Products].[Planes], [Product].[All Products].[Ships], [Product].[All Products].[Trains], [Product].[All Products].[Trucks and Buses], [Product].[All Products].[Vintage Cars]} ON ROWS from [SteelWheelsSales] ] at mondrian.resource.MondrianResource$_Def0.ex(MondrianResource.java:816) at mondrian.olap.Util.newInternal(Util.java:1466) at mondrian.olap.Util.newError(Util.java:1482) at mondrian.rolap.RolapConnection.execute(RolapConnection.java:592) at org.pentaho.reporting.engine.classic.extensions.datasources.mondrian.AbstractMDXDataFactory.performQuery(AbstractMDXDataFactory.java:345) at org.pentaho.reporting.engine.classic.extensions.datasources.mondrian.AbstractNamedMDXDataFactory.performQuery(AbstractNamedMDXDataFactory.java:81) at org.pentaho.reporting.engine.classic.extensions.datasources.mondrian.DenormalizedMDXDataFactory.queryData(DenormalizedMDXDataFactory.java:51) at org.pentaho.reporting.engine.classic.core.CompoundDataFactory.queryData(CompoundDataFactory.java:88) at org.pentaho.reporting.engine.classic.core.states.CachingDataFactory.queryInternal(CachingDataFactory.java:168) at org.pentaho.reporting.engine.classic.core.states.CachingDataFactory.queryData(CachingDataFactory.java:143) at org.pentaho.reporting.engine.classic.core.states.CascadingDataFactory.queryData(CascadingDataFactory.java:81) at org.pentaho.reporting.engine.classic.core.states.datarow.ReportDataRow.createDataRow(ReportDataRow.java:97) at org.pentaho.reporting.engine.classic.core.states.datarow.DefaultFlowController.performQuery(DefaultFlowController.java:185) at org.pentaho.reporting.engine.classic.core.states.process.ProcessState.<init>(ProcessState.java:265) at org.pentaho.reporting.engine.classic.core.layout.output.AbstractReportProcessor.prepareReportProcessing(AbstractReportProcessor.java:389) at org.pentaho.reporting.engine.classic.core.modules.output.pageable.graphics.PrintReportProcessor.getNumberOfPages(PrintReportProcessor.java:77) at org.pentaho.reporting.engine.classic.core.modules.gui.base.PreviewPane$RepaginationRunnable.run(PreviewPane.java:266) at org.pentaho.reporting.engine.classic.core.util.Worker.run(Worker.java:174) Caused by: mondrian.olap.MondrianException: Mondrian Error:Member '[param1]' not found at mondrian.resource.MondrianResource$_Def0.ex(MondrianResource.java:813) at mondrian.olap.Util.lookupCompound(Util.java:639) at mondrian.rolap.RolapSchemaReader.lookupCompound(RolapSchemaReader.java:386) at mondrian.olap.DelegatingSchemaReader.lookupCompound(DelegatingSchemaReader.java:108) at mondrian.olap.Query$QuerySchemaReader.lookupCompound(Query.java:1508) at mondrian.olap.Query$QuerySchemaReader.lookupCompound(Query.java:1469) at mondrian.olap.fun.BuiltinFunTable$22.strToMember(BuiltinFunTable.java:725) at mondrian.olap.fun.BuiltinFunTable$22$1.evaluateMember(BuiltinFunTable.java:715) at mondrian.olap.fun.SetFunDef$MemberSetListCalc$2.evaluateVoid(SetFunDef.java:173) at mondrian.olap.fun.SetFunDef$MemberSetListCalc.evaluateMemberList(SetFunDef.java:190) at mondrian.calc.impl.AbstractMemberListCalc.evaluateList(AbstractMemberListCalc.java:87) at mondrian.rolap.RolapNativeSet.expandNonNative(RolapNativeSet.java:826) at mondrian.rolap.RolapNativeSet.checkCrossJoin(RolapNativeSet.java:804) at mondrian.rolap.RolapNativeCrossJoin.createEvaluator(RolapNativeCrossJoin.java:86) at mondrian.rolap.RolapNativeRegistry.createEvaluator(RolapNativeRegistry.java:55) at mondrian.rolap.RolapSchemaReader.getNativeSetEvaluator(RolapSchemaReader.java:566) at mondrian.olap.DelegatingSchemaReader.getNativeSetEvaluator(DelegatingSchemaReader.java:220) at mondrian.olap.fun.CrossJoinFunDef$BaseTupleIterCalc.evaluateTupleIterable(CrossJoinFunDef.java:253) at mondrian.calc.impl.AbstractTupleIterCalc.evaluate(AbstractTupleIterCalc.java:52) at mondrian.rolap.RolapResult.executeAxis(RolapResult.java:727) at mondrian.rolap.RolapResult.evalLoad(RolapResult.java:570) at mondrian.rolap.RolapResult.loadMembers(RolapResult.java:536) at mondrian.rolap.RolapResult.<init>(RolapResult.java:269) at mondrian.rolap.RolapConnection.execute(RolapConnection.java:563) ... 14 more

    Pentaho BI Platform Tracking | 7 years ago | gunter rombauts
    mondrian.olap.MondrianException: Mondrian Error:Internal error: Error while executing query [select Crossjoin({StrToMember(Parameter("param1", STRING, "param1"))}, {[Measures].[Quantity], [Measures].[Sales]}) ON COLUMNS, {[Product].[All Products].[Classic Cars], [Product].[All Products].[Motorcycles], [Product].[All Products].[Planes], [Product].[All Products].[Ships], [Product].[All Products].[Trains], [Product].[All Products].[Trucks and Buses], [Product].[All Products].[Vintage Cars]} ON ROWS from [SteelWheelsSales] ]
  6. 0

    The StrToMember function results in an application exception when used with a member key. Example: StrToMember("[Time].[Year].&[1997]").Name mondrian.olap.MondrianException: Mondrian Error:Internal error: Error while executing query [with member [Measures].[Foo] as 'StrToMember("[Time].[Year].&[1997]").Name' select {[Measures].[Foo]} ON COLUMNS from [Sales] ] at mondrian.resource.MondrianResource$_Def0.ex(MondrianResource.java:972) at mondrian.olap.Util.newInternal(Util.java:2404) at mondrian.olap.Util.newError(Util.java:2420) at mondrian.rolap.RolapConnection.executeInternal(RolapConnection.java:707) at mondrian.rolap.RolapConnection.access$3(RolapConnection.java:628) at mondrian.rolap.RolapConnection$1.call(RolapConnection.java:623) at mondrian.rolap.RolapConnection$1.call(RolapConnection.java:1) at java.util.concurrent.FutureTask$Sync.innerRun(FutureTask.java:334) at java.util.concurrent.FutureTask.run(FutureTask.java:166) at java.util.concurrent.ThreadPoolExecutor.runWorker(ThreadPoolExecutor.java:1110) at java.util.concurrent.ThreadPoolExecutor$Worker.run(ThreadPoolExecutor.java:603) at java.lang.Thread.run(Thread.java:722) Caused by: mondrian.olap.MondrianException: Mondrian Error:Cannot find MDX member '[Time].[Year]'. Make sure it is indeed a member and not a level or a hierarchy. at mondrian.resource.MondrianResource$_Def0.ex(MondrianResource.java:969) at mondrian.olap.Util.lookupCompound(Util.java:874) at mondrian.olap.Util.lookupCompound(Util.java:678) at mondrian.util.IdentifierParser$BuilderImpl.resolveMember(IdentifierParser.java:62) at mondrian.olap.fun.FunUtil$7.memberComplete(FunUtil.java:2618) at org.olap4j.impl.IdentifierParser.parseMember(IdentifierParser.java:323) at mondrian.olap.fun.FunUtil.parseMember(FunUtil.java:2622) at mondrian.olap.fun.FunUtil.parseMember(FunUtil.java:2629) at mondrian.olap.fun.StrToMemberFunDef$1.evaluateMember(StrToMemberFunDef.java:46) at mondrian.calc.impl.AbstractMemberCalc.evaluate(AbstractMemberCalc.java:44) at mondrian.rolap.RolapProfilingEvaluator$ProfilingScalarCalc.evaluate(RolapProfilingEvaluator.java:225) at mondrian.calc.impl.GenericCalc.evaluateMember(GenericCalc.java:149) at mondrian.olap.fun.BuiltinFunTable$34$1.evaluateString(BuiltinFunTable.java:1258) at mondrian.calc.impl.AbstractStringCalc.evaluate(AbstractStringCalc.java:42) at mondrian.rolap.RolapProfilingEvaluator$ProfilingScalarCalc.evaluate(RolapProfilingEvaluator.java:225) at mondrian.rolap.RolapEvaluator.evaluateCurrent(RolapEvaluator.java:688) at mondrian.rolap.RolapResult.executeStripe(RolapResult.java:1051) at mondrian.rolap.RolapResult.executeStripe(RolapResult.java:1201) at mondrian.rolap.RolapResult.executeBody(RolapResult.java:913) at mondrian.rolap.RolapResult.<init>(RolapResult.java:470) at mondrian.rolap.RolapConnection.executeInternal(RolapConnection.java:672) ... 8 more

    Pentaho BI Platform Tracking | 3 years ago | Steve Szabo
    mondrian.olap.MondrianException: Mondrian Error:Internal error: Error while executing query [with member [Measures].[Foo] as 'StrToMember("[Time].[Year].&[1997]").Name' select {[Measures].[Foo]} ON COLUMNS from [Sales] ]

    1 unregistered visitors
    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:Member '[Store].[USA].[CA]' not found

      at mondrian.resource.MondrianResource$_Def0.ex()
    2. mondrian.resource
      MondrianResource$_Def0.ex
      1. mondrian.resource.MondrianResource$_Def0.ex(MondrianResource.java:838)
      1 frame
    3. mondrian.olap
      Util.lookupCompound
      1. mondrian.olap.Util.lookupCompound(Util.java:589)
      1 frame
    4. mondrian.rolap
      RolapConnection.<init>
      1. mondrian.rolap.RolapSchemaReader.lookupCompound(RolapSchemaReader.java:406)
      2. mondrian.rolap.RolapCube$RolapCubeSchemaReader.getMemberByUniqueName(RolapCube.java:2816)
      3. mondrian.rolap.RolapSchemaReader.getMemberByUniqueName(RolapSchemaReader.java:375)
      4. mondrian.rolap.RolapSchema.createRole(RolapSchema.java:631)
      5. mondrian.rolap.RolapSchema.load(RolapSchema.java:446)
      6. mondrian.rolap.RolapSchema.load(RolapSchema.java:309)
      7. mondrian.rolap.RolapSchema.<init>(RolapSchema.java:210)
      8. mondrian.rolap.RolapSchema.<init>(RolapSchema.java:201)
      9. mondrian.rolap.RolapSchema$Pool.get(RolapSchema.java:868)
      10. mondrian.rolap.RolapSchema$Pool.get(RolapSchema.java:766)
      11. mondrian.rolap.RolapConnection.<init>(RolapConnection.java:166)
      12. mondrian.rolap.RolapConnection.<init>(RolapConnection.java:95)
      12 frames
    5. mondrian.olap
      DriverManager.getConnection
      1. mondrian.olap.DriverManager.getConnection(DriverManager.java:110)
      1 frame
    6. mondrian.test
      Aaaaa.testBug721
      1. mondrian.test.TestContext.getFoodMartConnection(TestContext.java:255)
      2. mondrian.test.TestContext.getRawFoodMartSchema(TestContext.java:407)
      3. mondrian.test.TestContext.getFoodMartSchema(TestContext.java:335)
      4. mondrian.test.TestContext$6.getFoodMartConnectionProperties(TestContext.java:1712)
      5. mondrian.test.TestContext$9.getFoodMartConnectionProperties(TestContext.java:1819)
      6. mondrian.test.TestContext.getFoodMartConnection(TestContext.java:233)
      7. mondrian.test.TestContext.getConnection(TestContext.java:207)
      8. mondrian.test.TestContext.executeQuery(TestContext.java:513)
      9. mondrian.test.TestContext.assertQueryReturns(TestContext.java:1082)
      10. mondrian.test.Aaaaa.testBug721(Aaaaa.java:53)
      10 frames
    7. Java RT
      Method.invoke
      1. sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method)
      2. sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:39)
      3. sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:25)
      4. java.lang.reflect.Method.invoke(Method.java:592)
      4 frames
    8. JUnit
      OldTestClassRunner.run
      1. junit.framework.TestCase.runTest(TestCase.java:164)
      2. junit.framework.TestCase.runBare(TestCase.java:130)
      3. junit.framework.TestResult$1.protect(TestResult.java:110)
      4. junit.framework.TestResult.runProtected(TestResult.java:128)
      5. junit.framework.TestResult.run(TestResult.java:113)
      6. junit.framework.TestCase.run(TestCase.java:120)
      7. junit.framework.TestSuite.runTest(TestSuite.java:228)
      8. junit.framework.TestSuite.run(TestSuite.java:223)
      9. org.junit.internal.runners.OldTestClassRunner.run(OldTestClassRunner.java:35)
      9 frames
    9. JUnit4 Runner
      JUnit4TestReference.run
      1. org.eclipse.jdt.internal.junit4.runner.JUnit4TestReference.run(JUnit4TestReference.java:46)
      1 frame
    10. JUnit3 Runner
      RemoteTestRunner.main
      1. org.eclipse.jdt.internal.junit.runner.TestExecution.run(TestExecution.java:38)
      2. org.eclipse.jdt.internal.junit.runner.RemoteTestRunner.runTests(RemoteTestRunner.java:467)
      3. org.eclipse.jdt.internal.junit.runner.RemoteTestRunner.runTests(RemoteTestRunner.java:683)
      4. org.eclipse.jdt.internal.junit.runner.RemoteTestRunner.run(RemoteTestRunner.java:390)
      5. org.eclipse.jdt.internal.junit.runner.RemoteTestRunner.main(RemoteTestRunner.java:197)
      5 frames