mondrian.resource.ChainableRuntimeException: Internal error: not found

Pentaho BI Platform Tracking | hhaas | 1 decade ago
tip
Your exception is missing from the Samebug knowledge base.
Here are the best solutions we found on the Internet.
Click on the to mark the helpful solution and get rewards for you help.
  1. 0

    The following MDX select {[Measures].[Unit Sales], [Measures].[Store Cost], [Measures].[Store Sales]} ON columns, Order(TopCount({[Product].[Product Category].Members}, 10.0, [Measures].[Unit Sales]), [Measures].[Store Sales], ASC) ON rows from [Sales] where [Time].[1997] leads to an exception. Ordering a Topccount (by "another" measure) is perfectly valid from my point of view. Works fine with MSOLAP. Stack Trace: mondrian.resource.ChainableRuntimeException: Internal error: not found at mondrian.olap.MondrianResource.newInternal (MondrianResource.java:42) at mondrian.rolap.agg.AggregationManager.getCellFromCach e(AggregationManager.java:159) at mondrian.rolap.RolapAggregationManager.getCellFromCac he(RolapAggregationManager.java:139) at mondrian.rolap.RolapResult$AggregatingCellReader.get (RolapResult.java:303) at mondrian.rolap.RolapEvaluator.evaluateCurrent (RolapEvaluator.java:180) at mondrian.olap.fun.FunUtil.evaluateMembers (FunUtil.java:393) at mondrian.olap.fun.FunUtil.evaluateMembers (FunUtil.java:359) at mondrian.olap.fun.FunUtil.sort (FunUtil.java:420) at mondrian.olap.fun.BuiltinFunTable$73.evaluate (BuiltinFunTable.java:2527) at mondrian.rolap.RolapEvaluator.xx (RolapEvaluator.java:129) at mondrian.olap.FunCall.evaluate (FunCall.java:247) at mondrian.rolap.RolapResult.executeAxis (RolapResult.java:150) at mondrian.rolap.RolapResult. (RolapResult.java:74) at mondrian.rolap.RolapConnection.execute (RolapConnection.java:198) at com.tonbeller.jpivot.mondrian.MondrianModel.getResult (MondrianModel.java:94)

    Pentaho BI Platform Tracking | 1 decade ago | hhaas
    mondrian.resource.ChainableRuntimeException: Internal error: not found
  2. 0

    The following MDX raises an Error: with member [Measures].[USales] as '[Measures].[Unit Sales]', format_string = iif([Measures].[Sales Count] > 100, "#.00 good","#.00 bad") select {[Measures].[USales] , [Measures].[Store Cost], [Measures].[Store Sales]} ON columns, Crossjoin({[Promotion Media].[All Media].[Radio], [Promotion Media].[All Media].[TV], [Promotion Media]. [All Media].[Sunday Paper], [Promotion Media].[All Media].[Street Handout]}, [Product].[All Products]. [Drink].Children) ON rows from [Sales] where ([Time].[1997]) Java: "with member [Measures].[USales] as '[Measures].[Unit Sales]'," +"format_string =" +"iif([Measures].[Sales Count] > 100, \"#.00 good\", \"#.00 bad\") " +"select {[Measures].[USales] , [Measures].[Store Cost], [Measures].[Store Sales]} ON columns," +" Crossjoin({[Promotion Media].[All Media].[Radio], [Promotion Media].[All Media].[TV], [Promotion Media]. [All Media].[Sunday Paper], [Promotion Media].[All Media].[Street Handout]}, [Product].[All Products]. [Drink].Children) ON rows" +" from [Sales]" +" where ([Time].[1997])" the problem is triggered by the fact, that ([Measures]. [Sales Count] is used only within the "iif". If it is added to the axis, the query works fine. the call stack is: mondrian.resource.ChainableRuntimeException: Internal error: not found at mondrian.olap.MondrianResource.newInternal (MondrianResource.java:42) at mondrian.rolap.agg.AggregationManager.getCellFromCac he(AggregationManager.java:157) at mondrian.rolap.RolapAggregationManager.getCellFromC ache(RolapAggregationManager.java:130) at mondrian.rolap.RolapResult$AggregatingCellReader.get (RolapResult.java:295) at mondrian.rolap.RolapEvaluator.evaluateCurrent (RolapEvaluator.java:166) at mondrian.rolap.RolapMember.evaluateScalar (RolapMember.java:105) at mondrian.olap.fun.BuiltinFunTable$42.evaluate (BuiltinFunTable.java:1492) at mondrian.rolap.RolapEvaluator.xx (RolapEvaluator.java:116) at mondrian.olap.FunCall.evaluate (FunCall.java:244) at mondrian.olap.ExpBase.evaluateScalar (ExpBase.java:158) at mondrian.olap.fun.FunUtil.getDoubleArg (FunUtil.java:126) at mondrian.olap.fun.BuiltinFunTable$108.evaluate (BuiltinFunTable.java:3461) at mondrian.rolap.RolapEvaluator.xx (RolapEvaluator.java:116) at mondrian.olap.FunCall.evaluate (FunCall.java:244) at mondrian.olap.fun.FunUtil.getArg (FunUtil.java:53) at mondrian.olap.fun.FunUtil.getArg (FunUtil.java:44) at mondrian.olap.fun.FunUtil.getBooleanArg (FunUtil.java:94) at mondrian.olap.fun.BuiltinFunTable$75.evaluate (BuiltinFunTable.java:2766) at mondrian.rolap.RolapEvaluator.xx (RolapEvaluator.java:116) at mondrian.olap.FunCall.evaluate (FunCall.java:244) at mondrian.rolap.RolapEvaluator.getFormatString (RolapEvaluator.java:227) at mondrian.rolap.RolapEvaluator.getFormat (RolapEvaluator.java:232) at mondrian.rolap.RolapEvaluator.format (RolapEvaluator.java:251) at mondrian.rolap.RolapCell.computeFormattedValue (RolapResult.java:393) at mondrian.rolap.RolapCell.<init> (RolapResult.java:389) at mondrian.rolap.RolapResult.getCell (RolapResult.java:139) at com.tonbeller.jpivot.mondrian.MondrianResult.initData (MondrianResult.java:106) at com.tonbeller.jpivot.mondrian.MondrianResult.executeQu ery(MondrianResult.java:49) at com.tonbeller.jpivot.mondrian.MondrianModel.getResult (MondrianModel.java:122) at com.tonbeller.jpivot.mondrian.HHTest.main (HHTest.java:167)

    Pentaho BI Platform Tracking | 1 decade ago | hhaas
    mondrian.resource.ChainableRuntimeException: Internal error: not found
  3. 0

    I have the following level in a hierarchy: <Level name="Name" table="store" column="kdnr" uniqueMembers="false"> <Property name="Bank" table="store" column="bank"/> <Property name="Strasse" table="store" column="strasse"/> </Level> while doing a query, the following exception occurs: Caused by: Spaltenindex au�erhalb des g�ltigen Bereichs (sth like "column index out of range") at org.postgresql.jdbc2.ResultSet.getObject(ResultSet.java:728) at mondrian.rolap.SqlMemberSource.getMembersInLevel(SqlMemberSource.java:395) ... 22 more caused by mondrian.resource.ChainableRuntimeException: Internal error: %1 at mondrian.olap.MondrianResource.newInternal(MondrianResource.java:45) at mondrian.rolap.SqlMemberSource.getMembersInLevel(SqlMemberSource.java:439) at mondrian.rolap.SmartMemberReader.getMembersInLevel(SmartMemberReader.java:112) at mondrian.rolap.RolapLevel.getMembers(RolapLevel.java:176) at mondrian.olap.fun.BuiltinFunTable$60.evaluate(BuiltinFunTable.java:1847) i included System.out.println( "trying to populate property " + property.getName() + " from column " + ( column + 3 + j ) ); in line 394 of SQLMemberSource which shows me: trying to populate property Bank from column 3 trying to populate property Strasse from column 4 trying to populate property Bank from column 4 trying to populate property Strasse from column 5 trying to populate property Bank from column 5 trying to populate property Strasse from column 6 the hierarchy is three levels deep, so this occurs in the iteration for (int i = 0; i <= levelDepth; i++). column is incremented each time, and the properties are tried to set three times. i think, the column-calculation should be done more like ( levelDepth + j + 1 ) instead of ( column + 3 + j ) so it grabs the elements directly after the hierarchy-elements from the select-statement. but the routine tries to set the elements three times instead of once, and this fix should not work if there are properties defined on more than one level. jan

    Pentaho BI Platform Tracking | 1 decade ago | janheise
    mondrian.resource.ChainableRuntimeException: Internal error: %1
  4. Speed up your debug routine!

    Automated exception search integrated into your IDE

    Root Cause Analysis

    1. mondrian.resource.ChainableRuntimeException

      Internal error: not found

      at mondrian.olap.MondrianResource.newInternal()
    2. mondrian.olap
      MondrianResource.newInternal
      1. mondrian.olap.MondrianResource.newInternal(MondrianResource.java:42)
      1 frame
    3. mondrian.rolap.agg
      AggregationManager.getCellFromCache
      1. mondrian.rolap.agg.AggregationManager.getCellFromCache(AggregationManager.java:159)
      1 frame
    4. mondrian.rolap
      RolapEvaluator.evaluateCurrent
      1. mondrian.rolap.RolapAggregationManager.getCellFromCache(RolapAggregationManager.java:139)
      2. mondrian.rolap.RolapResult$AggregatingCellReader.get(RolapResult.java:303)
      3. mondrian.rolap.RolapEvaluator.evaluateCurrent(RolapEvaluator.java:180)
      3 frames
    5. mondrian.olap.fun
      BuiltinFunTable$73.evaluate
      1. mondrian.olap.fun.FunUtil.evaluateMembers(FunUtil.java:393)
      2. mondrian.olap.fun.FunUtil.evaluateMembers(FunUtil.java:359)
      3. mondrian.olap.fun.FunUtil.sort(FunUtil.java:420)
      4. mondrian.olap.fun.BuiltinFunTable$73.evaluate(BuiltinFunTable.java:2527)
      4 frames
    6. mondrian.rolap
      RolapEvaluator.xx
      1. mondrian.rolap.RolapEvaluator.xx(RolapEvaluator.java:129)
      1 frame
    7. mondrian.olap
      FunCall.evaluate
      1. mondrian.olap.FunCall.evaluate(FunCall.java:247)
      1 frame
    8. mondrian.rolap
      RolapConnection.execute
      1. mondrian.rolap.RolapResult.executeAxis(RolapResult.java:150)
      2. mondrian.rolap.RolapResult.<init>(RolapResult.java:74)
      3. mondrian.rolap.RolapConnection.execute(RolapConnection.java:198)
      3 frames
    9. com.tonbeller.jpivot
      MondrianModel.getResult
      1. com.tonbeller.jpivot.mondrian.MondrianModel.getResult(MondrianModel.java:94)
      1 frame