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

Pentaho BI Platform Tracking | Luc Boudreau | 6 years ago
  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 | 6 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 | 6 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