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

Samebug tips0

There are no available Samebug tips for this exception. If you know how to solve this issue, help other users by writing a short tip.

Don't give up yet. Paste your full stack trace to get a solution.

Solutions on the web338

  • via Pentaho BI Platform Tracking by gunter rombauts, 1 year ago
    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
  • via Pentaho BI Platform Tracking by gunter rombauts, 1 year ago
    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
  • via Pentaho BI Platform Tracking by Sulaiman Karmali, 1 year ago
    , { [TopSelection], [Customers].[All Customers].[Other Customers]} ON ROWS from [SteelWheelsSales] where ( strToMember(Parameter("sLine", STRING, "[Product].[All Products].[Classic Cars]")), strToMember(Parameter("sMarket", STRING, "[Markets].[All Markets].[Japan]")), strToMember(Parameter("sYear", STRING, "[Time].[All Years].[2003]")) )
  • Stack trace

    • 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

    Write tip

    You have a different solution? A short tip here would help you and many other users who saw this issue last week.

    Users with the same issue

    Unknown user
    Once, 1 year ago