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

Pentaho BI Platform Tracking | p_thiyagu | 10 years ago
tip
Click on the to mark the solution that helps you, Samebug will learn from it.
As a community member, you’ll be rewarded for you help.
  1. 0

    I'm getting below error with default mondrian properties setup and connecting to Oracle 10.2. 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) ... 29 more

    Pentaho BI Platform Tracking | 10 years ago | p_thiyagu
    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] ]
  2. 0

    I'm getting below error with default mondrian properties setup and connecting to Oracle 10.2. 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) ... 29 more

    Pentaho BI Platform Tracking | 10 years ago | p_thiyagu
    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] ]

    Root Cause Analysis

    1. java.lang.UnsupportedOperationException

      No message provided

      at mondrian.rolap.agg.CompoundQuerySpec.addMeasure()
    2. mondrian.rolap.agg
      CompoundQuerySpec.compoundGenerateSql
      1. mondrian.rolap.agg.CompoundQuerySpec.addMeasure(CompoundQuerySpec.java:85)
      2. mondrian.rolap.agg.CompoundQuerySpec.nonDistinctGenerateSql(CompoundQuerySpec.java:122)
      3. mondrian.rolap.agg.AbstractQuerySpec.generateSqlQuery(AbstractQuerySpec.java:159)
      4. mondrian.rolap.agg.CompoundQuerySpec.compoundGenerateSql(CompoundQuerySpec.java:158)
      4 frames
    3. mondrian.rolap
      RolapEvaluator.evaluateCurrent
      1. mondrian.rolap.RolapAggregationManager.generateMultiSql(RolapAggregationManager.java:447)
      2. mondrian.rolap.FastBatchingCellReader.getCompound(FastBatchingCellReader.java:129)
      3. mondrian.rolap.RolapEvaluator.evaluateCurrent(RolapEvaluator.java:480)
      3 frames
    4. mondrian.olap.fun
      AggregateFunDef$1.evaluateDouble
      1. mondrian.olap.fun.AggregateFunDef$1.evaluateDouble(AggregateFunDef.java:80)
      1 frame
    5. mondrian.calc.impl
      AbstractDoubleCalc.evaluate
      1. mondrian.calc.impl.AbstractDoubleCalc.evaluate(AbstractDoubleCalc.java:42)
      1 frame
    6. mondrian.rolap
      RolapEvaluator.evaluateCurrent
      1. mondrian.rolap.RolapEvaluator.evaluateCurrent(RolapEvaluator.java:494)
      1 frame
    7. mondrian.olap.fun
      AggregateFunDef$1.evaluateDouble
      1. mondrian.olap.fun.AggregateFunDef$1.evaluateDouble(AggregateFunDef.java:80)
      1 frame
    8. mondrian.calc.impl
      AbstractDoubleCalc.evaluate
      1. mondrian.calc.impl.AbstractDoubleCalc.evaluate(AbstractDoubleCalc.java:42)
      1 frame
    9. mondrian.rolap
      RolapConnection.execute
      1. mondrian.rolap.RolapEvaluator.evaluateCurrent(RolapEvaluator.java:494)
      2. mondrian.rolap.RolapResult.executeStripe(RolapResult.java:817)
      3. mondrian.rolap.RolapResult.executeStripe(RolapResult.java:898)
      4. mondrian.rolap.RolapResult.executeStripe(RolapResult.java:898)
      5. mondrian.rolap.RolapResult.executeBody(RolapResult.java:728)
      6. mondrian.rolap.RolapResult.<init>(RolapResult.java:390)
      7. mondrian.rolap.RolapConnection.execute(RolapConnection.java:414)
      7 frames
    10. mondrian.resource
      MondrianResource$_Def0.ex
      1. mondrian.resource.MondrianResource$_Def0.ex(MondrianResource.java:755)
      1 frame
    11. mondrian.olap
      Util.newError
      1. mondrian.olap.Util.newInternal(Util.java:1104)
      2. mondrian.olap.Util.newError(Util.java:1120)
      2 frames
    12. mondrian.rolap
      RolapConnection.execute
      1. mondrian.rolap.RolapConnection.execute(RolapConnection.java:442)
      1 frame
    13. mondrian.test
      FoodMartTestCase.assertQueryReturns
      1. mondrian.test.TestContext.executeQuery(TestContext.java:390)
      2. mondrian.test.TestContext.assertQueryReturns(TestContext.java:615)
      3. mondrian.test.FoodMartTestCase.assertQueryReturns(FoodMartTestCase.java:124)
      3 frames
    14. mondrian.rolap
      FastBatchingCellReaderTest.testAggregateDistinctCount4
      1. mondrian.rolap.FastBatchingCellReaderTest.testAggregateDistinctCount4(FastBatchingCellReaderTest.java:1051)
      1 frame
    15. Java RT
      DelegatingMethodAccessorImpl.invoke
      1. sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method)
      2. sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:39)
      3. sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:25)
      3 frames
    16. IDEA
      JUnitStarter.main
      1. com.intellij.rt.execution.junit.JUnitStarter.main(JUnitStarter.java:40)
      1 frame
    17. Java RT
      DelegatingMethodAccessorImpl.invoke
      1. sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method)
      2. sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:39)
      3. sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:25)
      3 frames
    18. IDEA
      AppMain.main
      1. com.intellij.rt.execution.application.AppMain.main(AppMain.java:90)
      1 frame