mondrian.resource.ChainableRuntimeException: Internal error: %1

Pentaho BI Platform Tracking | janheise | 1 decade ago
tip
Do you know that we can give you better hits? Get more relevant results from Samebug’s stack trace search.
  1. 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
  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

    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
  4. Speed up your debug routine!

    Automated exception search integrated into your IDE

    Root Cause Analysis

    1. mondrian.resource.ChainableRuntimeException

      Internal error: %1

      at mondrian.olap.MondrianResource.newInternal()
    2. mondrian.olap
      MondrianResource.newInternal
      1. mondrian.olap.MondrianResource.newInternal(MondrianResource.java:45)
      1 frame
    3. mondrian.rolap
      RolapLevel.getMembers
      1. mondrian.rolap.SqlMemberSource.getMembersInLevel(SqlMemberSource.java:439)
      2. mondrian.rolap.SmartMemberReader.getMembersInLevel(SmartMemberReader.java:112)
      3. mondrian.rolap.RolapLevel.getMembers(RolapLevel.java:176)
      3 frames
    4. mondrian.olap.fun
      BuiltinFunTable$60.evaluate
      1. mondrian.olap.fun.BuiltinFunTable$60.evaluate(BuiltinFunTable.java:1847)
      1 frame