mondrian.rolap.agg.CellRequestQuantumExceededException

Pentaho BI Platform Tracking | Paul Stoellberger | 4 years ago
  1. 0

    We are using TRUNK SNAPSHOT and a default mondrian properties. We see some warnings about the CellRequestQuantumExceededException, but only ocassionally... on my (mac) instance a query works fine while on windows we get the below exception for the following query: SELECT NON EMPTY {Hierarchize({{[Time].[Year].Members}, {[Time].[Quarter].Members}})} ON COLUMNS, NON EMPTY CrossJoin([Product].[Product Category].Members, {[Measures].[Profit]}) ON ROWS FROM [Sales 2] It says WARN but not sure what to do with that information: 08:22:07,492 WARN [ResultBase] Mondrian: exception in executeStripe. mondrian.rolap.agg.CellRequestQuantumExceededException at mondrian.rolap.agg.CellRequestQuantumExceededException.<clinit>(CellRequestQuantumExceededException.java:37) at mondrian.rolap.FastBatchingCellReader.recordCellRequest(FastBatchingCellReader.java:169) at mondrian.rolap.FastBatchingCellReader.get(FastBatchingCellReader.java:141) at mondrian.rolap.RolapEvaluator.evaluateCurrent(RolapEvaluator.java:660) at mondrian.calc.impl.MemberValueCalc.evaluate(MemberValueCalc.java:100) at mondrian.calc.impl.GenericCalc.evaluateDouble(GenericCalc.java:110) at mondrian.olap.fun.BuiltinFunTable$46$1.evaluateDouble(BuiltinFunTable.java:1439) at mondrian.olap.fun.BuiltinFunTable$59$1.evaluateBoolean(BuiltinFunTable.java:1816) at mondrian.olap.fun.IifFunDef$3$1.evaluateString(IifFunDef.java:118) at mondrian.calc.impl.AbstractStringCalc.evaluate(AbstractStringCalc.java:42) at mondrian.rolap.RolapEvaluator.getFormatString(RolapEvaluator.java:873) at mondrian.rolap.RolapResult.executeStripe(RolapResult.java:1008) at mondrian.rolap.RolapResult.executeStripe(RolapResult.java:1119) at mondrian.rolap.RolapResult.executeStripe(RolapResult.java:1119) at mondrian.rolap.RolapResult.executeBody(RolapResult.java:848) at mondrian.rolap.RolapResult.<init>(RolapResult.java:452) at mondrian.rolap.RolapConnection.executeInternal(RolapConnection.java:680) at mondrian.rolap.RolapConnection.access$000(RolapConnection.java:51) at mondrian.rolap.RolapConnection$1.call(RolapConnection.java:631) at mondrian.rolap.RolapConnection$1.call(RolapConnection.java:630) at java.util.concurrent.FutureTask$Sync.innerRun(FutureTask.java:303) at java.util.concurrent.FutureTask.run(FutureTask.java:138) at java.util.concurrent.ThreadPoolExecutor$Worker.runTask(ThreadPoolExecutor.java:886) at java.util.concurrent.ThreadPoolExecutor$Worker.run(ThreadPoolExecutor.java:908) at java.lang.Thread.run(Thread.java:662)

    Pentaho BI Platform Tracking | 4 years ago | Paul Stoellberger
    mondrian.rolap.agg.CellRequestQuantumExceededException
  2. 0

    We are using TRUNK SNAPSHOT and a default mondrian properties. We see some warnings about the CellRequestQuantumExceededException, but only ocassionally... on my (mac) instance a query works fine while on windows we get the below exception for the following query: SELECT NON EMPTY {Hierarchize({{[Time].[Year].Members}, {[Time].[Quarter].Members}})} ON COLUMNS, NON EMPTY CrossJoin([Product].[Product Category].Members, {[Measures].[Profit]}) ON ROWS FROM [Sales 2] It says WARN but not sure what to do with that information: 08:22:07,492 WARN [ResultBase] Mondrian: exception in executeStripe. mondrian.rolap.agg.CellRequestQuantumExceededException at mondrian.rolap.agg.CellRequestQuantumExceededException.<clinit>(CellRequestQuantumExceededException.java:37) at mondrian.rolap.FastBatchingCellReader.recordCellRequest(FastBatchingCellReader.java:169) at mondrian.rolap.FastBatchingCellReader.get(FastBatchingCellReader.java:141) at mondrian.rolap.RolapEvaluator.evaluateCurrent(RolapEvaluator.java:660) at mondrian.calc.impl.MemberValueCalc.evaluate(MemberValueCalc.java:100) at mondrian.calc.impl.GenericCalc.evaluateDouble(GenericCalc.java:110) at mondrian.olap.fun.BuiltinFunTable$46$1.evaluateDouble(BuiltinFunTable.java:1439) at mondrian.olap.fun.BuiltinFunTable$59$1.evaluateBoolean(BuiltinFunTable.java:1816) at mondrian.olap.fun.IifFunDef$3$1.evaluateString(IifFunDef.java:118) at mondrian.calc.impl.AbstractStringCalc.evaluate(AbstractStringCalc.java:42) at mondrian.rolap.RolapEvaluator.getFormatString(RolapEvaluator.java:873) at mondrian.rolap.RolapResult.executeStripe(RolapResult.java:1008) at mondrian.rolap.RolapResult.executeStripe(RolapResult.java:1119) at mondrian.rolap.RolapResult.executeStripe(RolapResult.java:1119) at mondrian.rolap.RolapResult.executeBody(RolapResult.java:848) at mondrian.rolap.RolapResult.<init>(RolapResult.java:452) at mondrian.rolap.RolapConnection.executeInternal(RolapConnection.java:680) at mondrian.rolap.RolapConnection.access$000(RolapConnection.java:51) at mondrian.rolap.RolapConnection$1.call(RolapConnection.java:631) at mondrian.rolap.RolapConnection$1.call(RolapConnection.java:630) at java.util.concurrent.FutureTask$Sync.innerRun(FutureTask.java:303) at java.util.concurrent.FutureTask.run(FutureTask.java:138) at java.util.concurrent.ThreadPoolExecutor$Worker.runTask(ThreadPoolExecutor.java:886) at java.util.concurrent.ThreadPoolExecutor$Worker.run(ThreadPoolExecutor.java:908) at java.lang.Thread.run(Thread.java:662)

    Pentaho BI Platform Tracking | 4 years ago | Paul Stoellberger
    mondrian.rolap.agg.CellRequestQuantumExceededException

    Root Cause Analysis

    1. mondrian.rolap.agg.CellRequestQuantumExceededException

      No message provided

      at mondrian.rolap.agg.CellRequestQuantumExceededException.<clinit>()
    2. mondrian.rolap.agg
      CellRequestQuantumExceededException.<clinit>
      1. mondrian.rolap.agg.CellRequestQuantumExceededException.<clinit>(CellRequestQuantumExceededException.java:37)
      1 frame
    3. mondrian.rolap
      RolapEvaluator.evaluateCurrent
      1. mondrian.rolap.FastBatchingCellReader.recordCellRequest(FastBatchingCellReader.java:169)
      2. mondrian.rolap.FastBatchingCellReader.get(FastBatchingCellReader.java:141)
      3. mondrian.rolap.RolapEvaluator.evaluateCurrent(RolapEvaluator.java:660)
      3 frames
    4. mondrian.calc.impl
      GenericCalc.evaluateDouble
      1. mondrian.calc.impl.MemberValueCalc.evaluate(MemberValueCalc.java:100)
      2. mondrian.calc.impl.GenericCalc.evaluateDouble(GenericCalc.java:110)
      2 frames
    5. mondrian.olap.fun
      IifFunDef$3$1.evaluateString
      1. mondrian.olap.fun.BuiltinFunTable$46$1.evaluateDouble(BuiltinFunTable.java:1439)
      2. mondrian.olap.fun.BuiltinFunTable$59$1.evaluateBoolean(BuiltinFunTable.java:1816)
      3. mondrian.olap.fun.IifFunDef$3$1.evaluateString(IifFunDef.java:118)
      3 frames
    6. mondrian.calc.impl
      AbstractStringCalc.evaluate
      1. mondrian.calc.impl.AbstractStringCalc.evaluate(AbstractStringCalc.java:42)
      1 frame
    7. mondrian.rolap
      RolapConnection$1.call
      1. mondrian.rolap.RolapEvaluator.getFormatString(RolapEvaluator.java:873)
      2. mondrian.rolap.RolapResult.executeStripe(RolapResult.java:1008)
      3. mondrian.rolap.RolapResult.executeStripe(RolapResult.java:1119)
      4. mondrian.rolap.RolapResult.executeStripe(RolapResult.java:1119)
      5. mondrian.rolap.RolapResult.executeBody(RolapResult.java:848)
      6. mondrian.rolap.RolapResult.<init>(RolapResult.java:452)
      7. mondrian.rolap.RolapConnection.executeInternal(RolapConnection.java:680)
      8. mondrian.rolap.RolapConnection.access$000(RolapConnection.java:51)
      9. mondrian.rolap.RolapConnection$1.call(RolapConnection.java:631)
      10. mondrian.rolap.RolapConnection$1.call(RolapConnection.java:630)
      10 frames
    8. Java RT
      Thread.run
      1. java.util.concurrent.FutureTask$Sync.innerRun(FutureTask.java:303)
      2. java.util.concurrent.FutureTask.run(FutureTask.java:138)
      3. java.util.concurrent.ThreadPoolExecutor$Worker.runTask(ThreadPoolExecutor.java:886)
      4. java.util.concurrent.ThreadPoolExecutor$Worker.run(ThreadPoolExecutor.java:908)
      5. java.lang.Thread.run(Thread.java:662)
      5 frames