mondrian.resource.ChainableRuntimeException: Internal error: Error while executing query [select {[Measures]. [Org Salary]} ON columns, Order(Hierarchize(Union({[Employees].CurrentMember}, [Employees].[All Employees].Children)), [Measures].[Org Salary], ASC) ON rows from [HR] ] at mondrian.olap.MondrianResource.newInternal (MondrianResource.java:45)

Pentaho BI Platform Tracking | a_lei | 1 decade ago
  1. 0

    When mondrian executing query " select {[Measures].[Org Salary]} ON columns, Order(Hierarchize(Union({[Employees].CurrentMember}, [Employees].[All Employees].Children)), [Measures].[Org Salary], ASC) ON rows from [HR] ", it will throw exception. Below is the exception information: Caused by: mondrian.resource.ChainableRuntimeException: Internal error: Error while executing query [select {[Measures]. [Org Salary]} ON columns, Order(Hierarchize(Union({[Employees].CurrentMember}, [Employees].[All Employees].Children)), [Measures].[Org Salary], ASC) ON rows from [HR] ] at mondrian.olap.MondrianResource.newInternal (MondrianResource.java:45) at mondrian.olap.Util.newError(Util.java:445) at mondrian.rolap.RolapConnection.execute (RolapConnection.java:257) at com.tonbeller.jpivot.mondrian.MondrianModel.getResult (MondrianModel.java:149) at com.tonbeller.jpivot.mondrian.MondrianModel.getUserMdx (MondrianModel.java:454) ... 62 more Caused by: mondrian.olap.fun.MondrianEvaluationException: infinite loop: context is ([Measures].[Org Salary], [Time]. [1997], [Store].[All Stores], [Pay Type].[All Pay Types], [Store Type].[All Store Types], [Position].[All Positions], [Department].[All Departments], [Employees].[All Employees]) at mondrian.olap.fun.FunUtil.newEvalException (FunUtil.java:35) at mondrian.rolap.RolapEvaluator.checkRecursion (RolapEvaluator.java:197) at mondrian.rolap.RolapEvaluator.<init> (RolapEvaluator.java:76)

    Pentaho BI Platform Tracking | 1 decade ago | a_lei
    mondrian.resource.ChainableRuntimeException: Internal error: Error while executing query [select {[Measures]. [Org Salary]} ON columns, Order(Hierarchize(Union({[Employees].CurrentMember}, [Employees].[All Employees].Children)), [Measures].[Org Salary], ASC) ON rows from [HR] ] at mondrian.olap.MondrianResource.newInternal (MondrianResource.java:45)
  2. 0

    When mondrian executing query " select {[Measures].[Org Salary]} ON columns, Order(Hierarchize(Union({[Employees].CurrentMember}, [Employees].[All Employees].Children)), [Measures].[Org Salary], ASC) ON rows from [HR] ", it will throw exception. Below is the exception information: Caused by: mondrian.resource.ChainableRuntimeException: Internal error: Error while executing query [select {[Measures]. [Org Salary]} ON columns, Order(Hierarchize(Union({[Employees].CurrentMember}, [Employees].[All Employees].Children)), [Measures].[Org Salary], ASC) ON rows from [HR] ] at mondrian.olap.MondrianResource.newInternal (MondrianResource.java:45) at mondrian.olap.Util.newError(Util.java:445) at mondrian.rolap.RolapConnection.execute (RolapConnection.java:257) at com.tonbeller.jpivot.mondrian.MondrianModel.getResult (MondrianModel.java:149) at com.tonbeller.jpivot.mondrian.MondrianModel.getUserMdx (MondrianModel.java:454) ... 62 more Caused by: mondrian.olap.fun.MondrianEvaluationException: infinite loop: context is ([Measures].[Org Salary], [Time]. [1997], [Store].[All Stores], [Pay Type].[All Pay Types], [Store Type].[All Store Types], [Position].[All Positions], [Department].[All Departments], [Employees].[All Employees]) at mondrian.olap.fun.FunUtil.newEvalException (FunUtil.java:35) at mondrian.rolap.RolapEvaluator.checkRecursion (RolapEvaluator.java:197) at mondrian.rolap.RolapEvaluator.<init> (RolapEvaluator.java:76)

    Pentaho BI Platform Tracking | 1 decade ago | a_lei
    mondrian.resource.ChainableRuntimeException: Internal error: Error while executing query [select {[Measures]. [Org Salary]} ON columns, Order(Hierarchize(Union({[Employees].CurrentMember}, [Employees].[All Employees].Children)), [Measures].[Org Salary], ASC) ON rows from [HR] ] at mondrian.olap.MondrianResource.newInternal (MondrianResource.java:45)
  3. 0

    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)

    Pentaho BI Platform Tracking | 1 decade ago | Julian Hyde
    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]) ]
  4. Speed up your debug routine!

    Automated exception search integrated into your IDE

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

    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. mondrian.resource.ChainableRuntimeException

      Internal error: Error while executing query [select {[Measures]. [Org Salary]} ON columns, Order(Hierarchize(Union({[Employees].CurrentMember}, [Employees].[All Employees].Children)), [Measures].[Org Salary], ASC) ON rows from [HR] ] at mondrian.olap.MondrianResource.newInternal (MondrianResource.java:45)

      at mondrian.olap.Util.newError()
    2. mondrian.olap
      Util.newError
      1. mondrian.olap.Util.newError(Util.java:445)
      1 frame