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 | 9 years ago
  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 | 9 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 | 9 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] ]
  3. 0

    JAXB Unmarshal List of Interfaces

    Stack Overflow | 11 months ago | billdoor
    java.lang.UnsupportedOperationException
  4. Speed up your debug routine!

    Automated exception search integrated into your IDE

  5. 0

    JNDI DataSource on Tomcat 4.1.27

    Oracle Community | 1 decade ago | 843854
    java.lang.UnsupportedOperationException

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