mondrian.olap.MondrianException

Mondrian Error:Internal error: Error while executing query [select Hierarchize(Union(Union(Union(Crossjoin({[Markets].[All Markets].[APAC]}, {[Time].[All Years].[2003], [Time].[All Years].[2004], [Time].[All Years].[2005]}), Crossjoin({[Markets].[All Markets].[EMEA]}, {[Time].[All Years].[2003], [Time].[All Years].[2004], [Time].[All Years].[2005]})), Crossjoin({[Markets].[All Markets].[Japan]}, {[Time].[All Years].[2003], [Time].[All Years].[2004], [Time].[All Years].[2005]})), Crossjoin({[Markets].[All Markets].[NA]}, {[Time].[All Years].[2003], [Time].[All Years].[2004], [Time].[All Years].[2005]}))) ON COLUMNS, {Parameter("sLine", [Product], "[Product].[All Products].[Motorcycles]")} ON ROWS from [SteelWheelsSales] where Parameter("sMeasures", [Measures], [Measures].[Sales]) ]

Samebug tips0

We couldn't find tips for this exception.

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

Solutions on the web3

  • via Unknown by Kurtis Cruzada,
  • via Unknown by Kurtis Cruzada,
  • via Unknown by scudderfish,
  • Stack trace

    • mondrian.olap.MondrianException: Mondrian Error:Internal error: Error while executing query [select Hierarchize(Union(Union(Union(Crossjoin({[Markets].[All Markets].[APAC]}, {[Time].[All Years].[2003], [Time].[All Years].[2004], [Time].[All Years].[2005]}), Crossjoin({[Markets].[All Markets].[EMEA]}, {[Time].[All Years].[2003], [Time].[All Years].[2004], [Time].[All Years].[2005]})), Crossjoin({[Markets].[All Markets].[Japan]}, {[Time].[All Years].[2003], [Time].[All Years].[2004], [Time].[All Years].[2005]})), Crossjoin({[Markets].[All Markets].[NA]}, {[Time].[All Years].[2003], [Time].[All Years].[2004], [Time].[All Years].[2005]}))) ON COLUMNS, {Parameter("sLine", [Product], "[Product].[All Products].[Motorcycles]")} ON ROWS from [SteelWheelsSales] where Parameter("sMeasures", [Measures], [Measures].[Sales]) ] at mondrian.resource.MondrianResource$_Def0.ex(MondrianResource.java:811) at mondrian.olap.Util.newInternal(Util.java:1472) at mondrian.olap.Util.newError(Util.java:1488) at mondrian.rolap.RolapConnection.execute(RolapConnection.java:589) at org.pentaho.reporting.engine.classic.extensions.datasources.mondrian.AbstractMDXDataFactory.performQuery(AbstractMDXDataFactory.java:238) at org.pentaho.reporting.engine.classic.extensions.datasources.mondrian.BandedMDXDataFactory.queryData(BandedMDXDataFactory.java:41) at org.pentaho.reporting.engine.classic.core.CompoundDataFactory.queryData(CompoundDataFactory.java:101) at org.pentaho.reporting.engine.classic.core.states.CachingDataFactory.queryInternal(CachingDataFactory.java:185) at org.pentaho.reporting.engine.classic.core.states.CachingDataFactory.queryData(CachingDataFactory.java:160) at org.pentaho.reporting.engine.classic.core.states.CascadingDataFactory.queryData(CascadingDataFactory.java:94) at org.pentaho.reporting.engine.classic.core.states.datarow.ReportDataRow.createDataRow(ReportDataRow.java:110) at org.pentaho.reporting.engine.classic.core.states.datarow.DefaultFlowController.performQuery(DefaultFlowController.java:193) at org.pentaho.reporting.engine.classic.core.states.process.ProcessState.<init>(ProcessState.java:237) at org.pentaho.reporting.engine.classic.core.layout.output.AbstractReportProcessor.prepareReportProcessing(AbstractReportProcessor.java:387) at org.pentaho.reporting.engine.classic.core.modules.output.pageable.graphics.PrintReportProcessor.getNumberOfPages(PrintReportProcessor.java:90) at org.pentaho.reporting.engine.classic.core.modules.gui.base.PreviewPane$RepaginationRunnable.run(PreviewPane.java:274) at org.pentaho.reporting.engine.classic.core.util.Worker.run(Worker.java:187) Caused by: java.lang.ClassCastException: java.lang.String at mondrian.calc.impl.GenericCalc.evaluateMember(GenericCalc.java:80) at mondrian.olap.fun.SetFunDef$MemberSetListCalc$2.evaluateVoid(SetFunDef.java:172) at mondrian.olap.fun.SetFunDef$MemberSetListCalc.evaluateMemberList(SetFunDef.java:189) at mondrian.calc.impl.AbstractExpCompiler$MemberListIterCalc.evaluateMemberIterable(AbstractExpCompiler.java:544) at mondrian.calc.impl.AbstractMemberIterCalc.evaluate(AbstractMemberIterCalc.java:55) at mondrian.rolap.RolapResult.executeAxis(RolapResult.java:731) at mondrian.rolap.RolapResult.evalLoad(RolapResult.java:577) at mondrian.rolap.RolapResult.loadMembers(RolapResult.java:552) at mondrian.rolap.RolapResult.<init>(RolapResult.java:269) at mondrian.rolap.RolapConnection.execute(RolapConnection.java:560) ... 13 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

    We couldn't find other users who have seen this exception.