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] ]

Pentaho BI Platform Tracking | gunter rombauts | 7 years ago
  1. 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] ]
  2. 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] ]
  3. 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
  4. Speed up your debug routine!

    Automated exception search integrated into your IDE

  5. 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
  6. 0

    JDBC connection error while using mondrian

    Stack Overflow | 3 years ago | Dhanish Jose
    mondrian.olap.MondrianException: Mondrian Error:Internal error: Connect string '@mondrian.webapp.connectString@=; Catalog='null'' must contain either 'Jdbc' or 'DataSource'

    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 '[param1]' not found

      at mondrian.resource.MondrianResource$_Def0.ex()
    2. mondrian.resource
      MondrianResource$_Def0.ex
      1. mondrian.resource.MondrianResource$_Def0.ex(MondrianResource.java:813)
      1 frame
    3. mondrian.olap
      Util.lookupCompound
      1. mondrian.olap.Util.lookupCompound(Util.java:639)
      1 frame
    4. mondrian.rolap
      RolapSchemaReader.lookupCompound
      1. mondrian.rolap.RolapSchemaReader.lookupCompound(RolapSchemaReader.java:386)
      1 frame
    5. mondrian.olap
      Query$QuerySchemaReader.lookupCompound
      1. mondrian.olap.DelegatingSchemaReader.lookupCompound(DelegatingSchemaReader.java:108)
      2. mondrian.olap.Query$QuerySchemaReader.lookupCompound(Query.java:1508)
      3. mondrian.olap.Query$QuerySchemaReader.lookupCompound(Query.java:1469)
      3 frames
    6. mondrian.olap.fun
      SetFunDef$MemberSetListCalc.evaluateMemberList
      1. mondrian.olap.fun.BuiltinFunTable$22.strToMember(BuiltinFunTable.java:725)
      2. mondrian.olap.fun.BuiltinFunTable$22$1.evaluateMember(BuiltinFunTable.java:715)
      3. mondrian.olap.fun.SetFunDef$MemberSetListCalc$2.evaluateVoid(SetFunDef.java:173)
      4. mondrian.olap.fun.SetFunDef$MemberSetListCalc.evaluateMemberList(SetFunDef.java:190)
      4 frames
    7. mondrian.calc.impl
      AbstractMemberListCalc.evaluateList
      1. mondrian.calc.impl.AbstractMemberListCalc.evaluateList(AbstractMemberListCalc.java:87)
      1 frame
    8. mondrian.rolap
      RolapSchemaReader.getNativeSetEvaluator
      1. mondrian.rolap.RolapNativeSet.expandNonNative(RolapNativeSet.java:826)
      2. mondrian.rolap.RolapNativeSet.checkCrossJoin(RolapNativeSet.java:804)
      3. mondrian.rolap.RolapNativeCrossJoin.createEvaluator(RolapNativeCrossJoin.java:86)
      4. mondrian.rolap.RolapNativeRegistry.createEvaluator(RolapNativeRegistry.java:55)
      5. mondrian.rolap.RolapSchemaReader.getNativeSetEvaluator(RolapSchemaReader.java:566)
      5 frames
    9. mondrian.olap
      DelegatingSchemaReader.getNativeSetEvaluator
      1. mondrian.olap.DelegatingSchemaReader.getNativeSetEvaluator(DelegatingSchemaReader.java:220)
      1 frame
    10. mondrian.olap.fun
      CrossJoinFunDef$BaseTupleIterCalc.evaluateTupleIterable
      1. mondrian.olap.fun.CrossJoinFunDef$BaseTupleIterCalc.evaluateTupleIterable(CrossJoinFunDef.java:253)
      1 frame
    11. mondrian.calc.impl
      AbstractTupleIterCalc.evaluate
      1. mondrian.calc.impl.AbstractTupleIterCalc.evaluate(AbstractTupleIterCalc.java:52)
      1 frame
    12. mondrian.rolap
      RolapConnection.execute
      1. mondrian.rolap.RolapResult.executeAxis(RolapResult.java:727)
      2. mondrian.rolap.RolapResult.evalLoad(RolapResult.java:570)
      3. mondrian.rolap.RolapResult.loadMembers(RolapResult.java:536)
      4. mondrian.rolap.RolapResult.<init>(RolapResult.java:269)
      5. mondrian.rolap.RolapConnection.execute(RolapConnection.java:563)
      5 frames
    13. org.pentaho.reporting
      Worker.run
      1. org.pentaho.reporting.engine.classic.extensions.datasources.mondrian.AbstractMDXDataFactory.performQuery(AbstractMDXDataFactory.java:345)
      2. org.pentaho.reporting.engine.classic.extensions.datasources.mondrian.AbstractNamedMDXDataFactory.performQuery(AbstractNamedMDXDataFactory.java:81)
      3. org.pentaho.reporting.engine.classic.extensions.datasources.mondrian.DenormalizedMDXDataFactory.queryData(DenormalizedMDXDataFactory.java:51)
      4. org.pentaho.reporting.engine.classic.core.CompoundDataFactory.queryData(CompoundDataFactory.java:88)
      5. org.pentaho.reporting.engine.classic.core.states.CachingDataFactory.queryInternal(CachingDataFactory.java:168)
      6. org.pentaho.reporting.engine.classic.core.states.CachingDataFactory.queryData(CachingDataFactory.java:143)
      7. org.pentaho.reporting.engine.classic.core.states.CascadingDataFactory.queryData(CascadingDataFactory.java:81)
      8. org.pentaho.reporting.engine.classic.core.states.datarow.ReportDataRow.createDataRow(ReportDataRow.java:97)
      9. org.pentaho.reporting.engine.classic.core.states.datarow.DefaultFlowController.performQuery(DefaultFlowController.java:185)
      10. org.pentaho.reporting.engine.classic.core.states.process.ProcessState.<init>(ProcessState.java:265)
      11. org.pentaho.reporting.engine.classic.core.layout.output.AbstractReportProcessor.prepareReportProcessing(AbstractReportProcessor.java:389)
      12. org.pentaho.reporting.engine.classic.core.modules.output.pageable.graphics.PrintReportProcessor.getNumberOfPages(PrintReportProcessor.java:77)
      13. org.pentaho.reporting.engine.classic.core.modules.gui.base.PreviewPane$RepaginationRunnable.run(PreviewPane.java:266)
      14. org.pentaho.reporting.engine.classic.core.util.Worker.run(Worker.java:174)
      14 frames