mondrian.resource.ChainableRuntimeException

There are no available Samebug tips for this exception. Do you have an idea how to solve this issue? A short tip would help users who saw this issue last week.

  • 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)
    via by hhaas,
  • 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)
    via by hhaas,
  • 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
    via by janheise,
  • Results: Error: mondrian.resource.ChainableRuntimeException: Internal error: Error while executing query [select {[Measures]. [Unit Sales]} ON columns, Order(Except([Promotion Media].[Media Type].Members, {[Promotion Media].[All Media].[No Media]}), [Measures].[Unit Sales], DESC) ON rows from [Sales] where ([Time].[1997], [Customers]) ] at mondrian.olap.MondrianResource.newInternal (MondrianResource.java:45) at mondrian.olap.Util.newError(Util.java:445) at mondrian.rolap.RolapConnection.execute (RolapConnection.java:213) at mondrian.web.servlet.MDXQueryServlet.processRequest (MDXQueryServlet.java:78) at mondrian.web.servlet.MDXQueryServlet.doGet (MDXQueryServlet.java:200) at javax.servlet.http.HttpServlet.service (HttpServlet.java:740) at javax.servlet.http.HttpServlet.service (HttpServlet.java:853) at org.apache.catalina.core.ApplicationFilterChain.internalDo Filter(ApplicationFilterChain.java:247) at org.apache.catalina.core.ApplicationFilterChain.doFilter (ApplicationFilterChain.java:193) at org.apache.catalina.core.StandardWrapperValve.invoke (StandardWrapperValve.java:256) at org.apache.catalina.core.StandardPipeline$StandardPipeli neValveContext.invokeNext(StandardPipeline.java:643) at org.apache.catalina.core.StandardPipeline.invoke (StandardPipeline.java:480) at org.apache.catalina.core.ContainerBase.invoke (ContainerBase.java:995) at org.apache.catalina.core.StandardContextValve.invoke (StandardContextValve.java:191) at org.apache.catalina.core.StandardPipeline$StandardPipeli neValveContext.invokeNext(StandardPipeline.java:643) at org.apache.catalina.core.StandardPipeline.invoke (StandardPipeline.java:480) at org.apache.catalina.core.ContainerBase.invoke (ContainerBase.java:995) at org.apache.catalina.core.StandardContext.invoke (StandardContext.java:2415) at org.apache.catalina.core.StandardHostValve.invoke (StandardHostValve.java:180) at org.apache.catalina.core.StandardPipeline$StandardPipeli neValveContext.invokeNext(StandardPipeline.java:643) at org.apache.catalina.valves.ErrorDispatcherValve.invoke (ErrorDispatcherValve.java:171) at org.apache.catalina.core.StandardPipeline$StandardPipeli neValveContext.invokeNext(StandardPipeline.java:641) at org.apache.catalina.valves.ErrorReportValve.invoke (ErrorReportValve.java:172) at org.apache.catalina.core.StandardPipeline$StandardPipeli neValveContext.invokeNext(StandardPipeline.java:641) at org.apache.catalina.core.StandardPipeline.invoke (StandardPipeline.java:480) at org.apache.catalina.core.ContainerBase.invoke (ContainerBase.java:995) at org.apache.catalina.core.StandardEngineValve.invoke (StandardEngineValve.java:174) at org.apache.catalina.core.StandardPipeline$StandardPipeli neValveContext.invokeNext(StandardPipeline.java:643) at org.apache.catalina.core.StandardPipeline.invoke (StandardPipeline.java:480) at org.apache.catalina.core.ContainerBase.invoke (ContainerBase.java:995) at org.apache.coyote.tomcat4.CoyoteAdapter.service (CoyoteAdapter.java:223) at org.apache.coyote.http11.Http11Processor.process (Http11Processor.java:594) at org.apache.coyote.http11.Http11Protocol$Http11Connec tionHandler.processConnection(Http11Protocol.java:392) at org.apache.tomcat.util.net.TcpWorkerThread.runIt (PoolTcpEndpoint.java:565) at org.apache.tomcat.util.threads.ThreadPool$ControlRunna ble.run(ThreadPool.java:619) at java.lang.Thread.run(Thread.java:536) Caused by: java.lang.ClassCastException at mondrian.olap.fun.FunUtil.getMemberArg (FunUtil.java:163) at mondrian.olap.fun.TupleFunDef.evaluate (TupleFunDef.java:61) at mondrian.rolap.RolapEvaluator.xx (RolapEvaluator.java:129) at mondrian.olap.FunCall.evaluate(FunCall.java:247) at mondrian.olap.fun.SetFunDef.evaluate (SetFunDef.java:56) 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.<init>(RolapResult.java:70) at mondrian.rolap.RolapConnection.execute (RolapConnection.java:198) ... 33 more caused by java.lang.ClassCastException at mondrian.olap.fun.FunUtil.getMemberArg (FunUtil.java:163) at mondrian.olap.fun.TupleFunDef.evaluate (TupleFunDef.java:61) at mondrian.rolap.RolapEvaluator.xx (RolapEvaluator.java:129) at mondrian.olap.FunCall.evaluate(FunCall.java:247) at mondrian.olap.fun.SetFunDef.evaluate (SetFunDef.java:56) 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.<init>(RolapResult.java:70) at mondrian.rolap.RolapConnection.execute (RolapConnection.java:198) at mondrian.web.servlet.MDXQueryServlet.processRequest (MDXQueryServlet.java:78) at mondrian.web.servlet.MDXQueryServlet.doGet (MDXQueryServlet.java:200) at javax.servlet.http.HttpServlet.service (HttpServlet.java:740) at javax.servlet.http.HttpServlet.service (HttpServlet.java:853) at org.apache.catalina.core.ApplicationFilterChain.internalDo Filter(ApplicationFilterChain.java:247) at org.apache.catalina.core.ApplicationFilterChain.doFilter (ApplicationFilterChain.java:193) at org.apache.catalina.core.StandardWrapperValve.invoke (StandardWrapperValve.java:256) at org.apache.catalina.core.StandardPipeline$StandardPipeli neValveContext.invokeNext(StandardPipeline.java:643) at org.apache.catalina.core.StandardPipeline.invoke (StandardPipeline.java:480) at org.apache.catalina.core.ContainerBase.invoke (ContainerBase.java:995) at org.apache.catalina.core.StandardContextValve.invoke (StandardContextValve.java:191) at org.apache.catalina.core.StandardPipeline$StandardPipeli neValveContext.invokeNext(StandardPipeline.java:643) at org.apache.catalina.core.StandardPipeline.invoke (StandardPipeline.java:480) at org.apache.catalina.core.ContainerBase.invoke (ContainerBase.java:995) at org.apache.catalina.core.StandardContext.invoke (StandardContext.java:2415) at org.apache.catalina.core.StandardHostValve.invoke (StandardHostValve.java:180) at org.apache.catalina.core.StandardPipeline$StandardPipeli neValveContext.invokeNext(StandardPipeline.java:643) at org.apache.catalina.valves.ErrorDispatcherValve.invoke (ErrorDispatcherValve.java:171) at org.apache.catalina.core.StandardPipeline$StandardPipeli neValveContext.invokeNext(StandardPipeline.java:641) at org.apache.catalina.valves.ErrorReportValve.invoke (ErrorReportValve.java:172) at org.apache.catalina.core.StandardPipeline$StandardPipeli neValveContext.invokeNext(StandardPipeline.java:641) at org.apache.catalina.core.StandardPipeline.invoke (StandardPipeline.java:480) at org.apache.catalina.core.ContainerBase.invoke (ContainerBase.java:995) at org.apache.catalina.core.StandardEngineValve.invoke (StandardEngineValve.java:174) at org.apache.catalina.core.StandardPipeline$StandardPipeli neValveContext.invokeNext(StandardPipeline.java:643) at org.apache.catalina.core.StandardPipeline.invoke (StandardPipeline.java:480) at org.apache.catalina.core.ContainerBase.invoke (ContainerBase.java:995) at org.apache.coyote.tomcat4.CoyoteAdapter.service (CoyoteAdapter.java:223) at org.apache.coyote.http11.Http11Processor.process (Http11Processor.java:594) at org.apache.coyote.http11.Http11Protocol$Http11Connec tionHandler.processConnection(Http11Protocol.java:392) at org.apache.tomcat.util.net.TcpWorkerThread.runIt (PoolTcpEndpoint.java:565) at org.apache.tomcat.util.threads.ThreadPool$ControlRunna ble.run(ThreadPool.java:619) at java.lang.Thread.run(Thread.java:536) java.lang.ClassCastException at mondrian.olap.fun.FunUtil.getMemberArg (FunUtil.java:163) at mondrian.olap.fun.TupleFunDef.evaluate (TupleFunDef.java:61) at mondrian.rolap.RolapEvaluator.xx (RolapEvaluator.java:129) at mondrian.olap.FunCall.evaluate(FunCall.java:247) at mondrian.olap.fun.SetFunDef.evaluate (SetFunDef.java:56) 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.<init>(RolapResult.java:70) at mondrian.rolap.RolapConnection.execute (RolapConnection.java:198) at mondrian.web.servlet.MDXQueryServlet.processRequest (MDXQueryServlet.java:78) at mondrian.web.servlet.MDXQueryServlet.doGet (MDXQueryServlet.java:200) at javax.servlet.http.HttpServlet.service (HttpServlet.java:740) at javax.servlet.http.HttpServlet.service (HttpServlet.java:853) at org.apache.catalina.core.ApplicationFilterChain.internalDo Filter(ApplicationFilterChain.java:247) at org.apache.catalina.core.ApplicationFilterChain.doFilter (ApplicationFilterChain.java:193) at org.apache.catalina.core.StandardWrapperValve.invoke (StandardWrapperValve.java:256) at org.apache.catalina.core.StandardPipeline$StandardPipeli neValveContext.invokeNext(StandardPipeline.java:643) at org.apache.catalina.core.StandardPipeline.invoke (StandardPipeline.java:480) at org.apache.catalina.core.ContainerBase.invoke (ContainerBase.java:995) at org.apache.catalina.core.StandardContextValve.invoke (StandardContextValve.java:191) at org.apache.catalina.core.StandardPipeline$StandardPipeli neValveContext.invokeNext(StandardPipeline.java:643) at org.apache.catalina.core.StandardPipeline.invoke (StandardPipeline.java:480) at org.apache.catalina.core.ContainerBase.invoke (ContainerBase.java:995) at org.apache.catalina.core.StandardContext.invoke (StandardContext.java:2415) at org.apache.catalina.core.StandardHostValve.invoke (StandardHostValve.java:180) at org.apache.catalina.core.StandardPipeline$StandardPipeli neValveContext.invokeNext(StandardPipeline.java:643) at org.apache.catalina.valves.ErrorDispatcherValve.invoke (ErrorDispatcherValve.java:171) at org.apache.catalina.core.StandardPipeline$StandardPipeli neValveContext.invokeNext(StandardPipeline.java:641) at org.apache.catalina.valves.ErrorReportValve.invoke (ErrorReportValve.java:172) at org.apache.catalina.core.StandardPipeline$StandardPipeli neValveContext.invokeNext(StandardPipeline.java:641) at org.apache.catalina.core.StandardPipeline.invoke (StandardPipeline.java:480) at org.apache.catalina.core.ContainerBase.invoke (ContainerBase.java:995) at org.apache.catalina.core.StandardEngineValve.invoke (StandardEngineValve.java:174) at org.apache.catalina.core.StandardPipeline$StandardPipeli neValveContext.invokeNext(StandardPipeline.java:643) at org.apache.catalina.core.StandardPipeline.invoke (StandardPipeline.java:480) at org.apache.catalina.core.ContainerBase.invoke (ContainerBase.java:995) at org.apache.coyote.tomcat4.CoyoteAdapter.service (CoyoteAdapter.java:223) at org.apache.coyote.http11.Http11Processor.process (Http11Processor.java:594) at org.apache.coyote.http11.Http11Protocol$Http11Connec tionHandler.processConnection(Http11Protocol.java:392) at org.apache.tomcat.util.net.TcpWorkerThread.runIt (PoolTcpEndpoint.java:565) at org.apache.tomcat.util.threads.ThreadPool$ControlRunna ble.run(ThreadPool.java:619) at java.lang.Thread.run(Thread.java:536) The problem seems to be with the implicit conversion of a dimension [Customers] to a member [Customers].DefaultMember. The workaround is to write ... where ([Time].[1997],[Customers].DefaultMember)
    via by Julian Hyde,
    • mondrian.resource.ChainableRuntimeException: Internal error: not found at mondrian.olap.MondrianResource.newInternal(MondrianResource.java:42) at mondrian.rolap.agg.AggregationManager.getCellFromCache(AggregationManager.java:157) at mondrian.rolap.RolapAggregationManager.getCellFromCache(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.executeQuery(MondrianResult.java:49) at com.tonbeller.jpivot.mondrian.MondrianModel.getResult(MondrianModel.java:122) at com.tonbeller.jpivot.mondrian.HHTest.main(HHTest.java:167)
    No Bugmate found.