mondrian.olap.MondrianException

Mondrian Error:Internal error: Error while executing query [with member [Store].[CA plus USA] as 'Aggregate({[Store].[All Stores].[USA].[CA], [Store].[All Stores].[USA]})', solve_order = 1.0 member [Time].[Q1 plus July] as 'Aggregate({[Time].[1997].[Q1], [Time].[1997].[Q3].[7]})', solve_order = 1.0 select {[Measures].[Customer Count], [Measures].[Unit Sales]} ON COLUMNS, ({[Store].[CA plus USA]} * {[Time].[Q1 plus July]}) ON ROWS from [Sales] ]

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 p_thiyagu, 1 year ago
    Mondrian Error:Internal error: Error while executing query [with member [Store].[CA plus USA] as 'Aggregate({[Store].[All Stores].[USA].[CA], [Store].[All Stores].[USA]})', solve_order = 1.0 member [Time].[Q1 plus July] as 'Aggregate({[Time].[1997
  • via Pentaho BI Platform Tracking by p_thiyagu, 1 year ago
    Mondrian Error:Internal error: Error while executing query [with member [Store].[CA plus USA] as 'Aggregate({[Store].[All Stores].[USA].[CA], [Store].[All Stores].[USA]})', solve_order = 1.0 member [Time].[Q1 plus July] as 'Aggregate({[Time].[1997
  • via Pentaho BI Platform Tracking by weavelink, 9 months ago
    ].[All Stores ].[Canada].[BC].[Vancouver].[Store 19], [Store].[All Stores].[Canada].[BC].[Victoria], [Store].[All Stores]. [Mexico], [Store].[All Stores].[USA]} ON ROWS from [Sales] where [Time].[1997] '
  • Stack trace

    • mondrian.olap.MondrianException: Mondrian Error:Internal error: Error while executing query [with member [Store].[CA plus USA] as 'Aggregate({[Store].[All Stores].[USA].[CA], [Store].[All Stores].[USA]})', solve_order = 1.0 member [Time].[Q1 plus July] as 'Aggregate({[Time].[1997].[Q1], [Time].[1997].[Q3].[7]})', solve_order = 1.0 select {[Measures].[Customer Count], [Measures].[Unit Sales]} ON COLUMNS, ({[Store].[CA plus USA]} * {[Time].[Q1 plus July]}) ON ROWS from [Sales] ] at mondrian.resource.MondrianResource$_Def0.ex(MondrianResource.java:755) at mondrian.olap.Util.newInternal(Util.java:1104) at mondrian.olap.Util.newError(Util.java:1120) at mondrian.rolap.RolapConnection.execute(RolapConnection.java:442) at mondrian.test.TestContext.executeQuery(TestContext.java:390) at mondrian.test.TestContext.assertQueryReturns(TestContext.java:615) at mondrian.test.FoodMartTestCase.assertQueryReturns(FoodMartTestCase.java:124) at mondrian.rolap.FastBatchingCellReaderTest.testAggregateDistinctCount4(FastBatchingCellReaderTest.java:1051) at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method) at sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:39) at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:25) at com.intellij.rt.execution.junit.JUnitStarter.main(JUnitStarter.java:40) at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method) at sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:39) at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:25) at com.intellij.rt.execution.application.AppMain.main(AppMain.java:90) Caused by: java.lang.UnsupportedOperationException at mondrian.rolap.agg.CompoundQuerySpec.addMeasure(CompoundQuerySpec.java:85) at mondrian.rolap.agg.CompoundQuerySpec.nonDistinctGenerateSql(CompoundQuerySpec.java:122) at mondrian.rolap.agg.AbstractQuerySpec.generateSqlQuery(AbstractQuerySpec.java:159) at mondrian.rolap.agg.CompoundQuerySpec.compoundGenerateSql(CompoundQuerySpec.java:158) at mondrian.rolap.RolapAggregationManager.generateMultiSql(RolapAggregationManager.java:447) at mondrian.rolap.FastBatchingCellReader.getCompound(FastBatchingCellReader.java:129) at mondrian.rolap.RolapEvaluator.evaluateCurrent(RolapEvaluator.java:480) at mondrian.olap.fun.AggregateFunDef$1.evaluateDouble(AggregateFunDef.java:80) at mondrian.calc.impl.AbstractDoubleCalc.evaluate(AbstractDoubleCalc.java:42) at mondrian.rolap.RolapEvaluator.evaluateCurrent(RolapEvaluator.java:494) at mondrian.olap.fun.AggregateFunDef$1.evaluateDouble(AggregateFunDef.java:80) at mondrian.calc.impl.AbstractDoubleCalc.evaluate(AbstractDoubleCalc.java:42) at mondrian.rolap.RolapEvaluator.evaluateCurrent(RolapEvaluator.java:494) at mondrian.rolap.RolapResult.executeStripe(RolapResult.java:817) at mondrian.rolap.RolapResult.executeStripe(RolapResult.java:898) at mondrian.rolap.RolapResult.executeStripe(RolapResult.java:898) at mondrian.rolap.RolapResult.executeBody(RolapResult.java:728) at mondrian.rolap.RolapResult.<init>(RolapResult.java:390) at mondrian.rolap.RolapConnection.execute(RolapConnection.java:414) ... 16 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

    You’re the first here who have seen this exception.