mondrian.olap.fun.MondrianEvaluationException: Could not find an aggregator in the current evaluation context

Pentaho BI Platform Tracking | Matt Campbell | 4 years ago
  1. 0

    Mondrian gives an error if a measure is present in a compound slicer with caculated members from a a dimension. For example, the following query produces the error: #ERR: mondrian.olap.fun.MondrianEvaluationException: Could not find an aggregator in the current evaluation context WITH MEMBER [Store].[aggCA] AS 'Aggregate({[Store].[USA].[CA].[Los Angeles], [Store].[USA].[CA].[San Francisco]})' MEMBER [Store].[aggOR] AS 'Aggregate({[Store].[USA].[OR].[Portland]})' SELECT FROM SALES WHERE [Measures].[Unit Sales] * { [Store].[aggCA], [Store].[aggOR] } mondrian.olap.fun.MondrianEvaluationException: Could not find an aggregator in the current evaluation context at mondrian.olap.fun.FunUtil.newEvalException(FunUtil.java:84) at mondrian.olap.fun.AggregateFunDef$AggregateCalc.aggregate(AggregateFunDef.java:99) at mondrian.olap.fun.AggregateFunDef$AggregateCalc.evaluate(AggregateFunDef.java:74) at mondrian.rolap.RolapEvaluator.evaluateCurrent(RolapEvaluator.java:687) at mondrian.rolap.RolapResult.executeStripe(RolapResult.java:1023) at mondrian.rolap.RolapResult.executeBody(RolapResult.java:885) at mondrian.rolap.RolapResult.<init>(RolapResult.java:465) at mondrian.rolap.RolapConnection.executeInternal(RolapConnection.java:671) at mondrian.rolap.RolapConnection.access$000(RolapConnection.java:51) at mondrian.rolap.RolapConnection$1.call(RolapConnection.java:622) at mondrian.rolap.RolapConnection$1.call(RolapConnection.java:620) 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) The same query will succeed with non-calculated dimension members, or in non-compound slicer.

    Pentaho BI Platform Tracking | 4 years ago | Matt Campbell
    mondrian.olap.fun.MondrianEvaluationException: Could not find an aggregator in the current evaluation context
  2. 0

    Mondrian gives an error if a measure is present in a compound slicer with caculated members from a a dimension. For example, the following query produces the error: #ERR: mondrian.olap.fun.MondrianEvaluationException: Could not find an aggregator in the current evaluation context WITH MEMBER [Store].[aggCA] AS 'Aggregate({[Store].[USA].[CA].[Los Angeles], [Store].[USA].[CA].[San Francisco]})' MEMBER [Store].[aggOR] AS 'Aggregate({[Store].[USA].[OR].[Portland]})' SELECT FROM SALES WHERE [Measures].[Unit Sales] * { [Store].[aggCA], [Store].[aggOR] } mondrian.olap.fun.MondrianEvaluationException: Could not find an aggregator in the current evaluation context at mondrian.olap.fun.FunUtil.newEvalException(FunUtil.java:84) at mondrian.olap.fun.AggregateFunDef$AggregateCalc.aggregate(AggregateFunDef.java:99) at mondrian.olap.fun.AggregateFunDef$AggregateCalc.evaluate(AggregateFunDef.java:74) at mondrian.rolap.RolapEvaluator.evaluateCurrent(RolapEvaluator.java:687) at mondrian.rolap.RolapResult.executeStripe(RolapResult.java:1023) at mondrian.rolap.RolapResult.executeBody(RolapResult.java:885) at mondrian.rolap.RolapResult.<init>(RolapResult.java:465) at mondrian.rolap.RolapConnection.executeInternal(RolapConnection.java:671) at mondrian.rolap.RolapConnection.access$000(RolapConnection.java:51) at mondrian.rolap.RolapConnection$1.call(RolapConnection.java:622) at mondrian.rolap.RolapConnection$1.call(RolapConnection.java:620) 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) The same query will succeed with non-calculated dimension members, or in non-compound slicer.

    Pentaho BI Platform Tracking | 4 years ago | Matt Campbell
    mondrian.olap.fun.MondrianEvaluationException: Could not find an aggregator in the current evaluation context
  3. 0

    For Micahel's schema file, when he has the location and product on the same axis and grand totals turned on, he gets the below stack trace. A similar report on foodmart or steel wheels does not reproduce the exception. The MDX statement pattern is the same between salesdata and steelwheels/foodmart so we will need to debug Mondrian code to figure out what's going on. java.util.concurrent.ExecutionException: java.lang.RuntimeException: mondrian.olap.fun.MondrianEvaluationException: Infinite loop while evaluating calculated member '[Product.All Products].[*TOTAL_MEMBER_SEL~SUM]'; context stack is {([Location.All Regions].[*TOTAL_MEMBER_SEL~SUM]), ([Location.All Regions].[*TOTAL_MEMBER_SEL~SUM])}java.lang.RuntimeException: java.util.concurrent.ExecutionException: java.lang.RuntimeException: mondrian.olap.fun.MondrianEvaluationException: Infinite loop while evaluating calculated member '[Product.All Products].[*TOTAL_MEMBER_SEL~SUM]'; context stack is {([Location.All Regions].[*TOTAL_MEMBER_SEL~SUM]), ([Location.All Regions].[*TOTAL_MEMBER_SEL~SUM])} at com.pentaho.analyzer.report.ReportRequestService.get(ReportRequestService.java:187) at com.pentaho.analyzer.content.controller.ReportRunner.getResult(ReportRunner.java:256) at com.pentaho.analyzer.content.controller.AjaxBean.getReportHTML(AjaxBean.java:197) at com.pentaho.analyzer.content.AnalyzerContentGenerator.createContent(AnalyzerContentGenerator.java:120) at sun.reflect.GeneratedMethodAccessor142.invoke(Unknown Source) at sun.reflect.DelegatingMethodAccessorImpl.invoke(Unknown Source) at java.lang.reflect.Method.invoke(Unknown Source) at com.pentaho.platform.web.http.context.WebSpringPentahoObjectFactory$ProxyInvokeHandler.invoke(WebSpringPentahoObjectFactory.java:220) at $Proxy9.createContent(Unknown Source) at org.pentaho.platform.web.servlet.GenericServlet.doGet(GenericServlet.java:251) at org.pentaho.platform.web.servlet.GenericServlet.doPost(GenericServlet.java:82) at javax.servlet.http.HttpServlet.service(HttpServlet.java:710) at javax.servlet.http.HttpServlet.service(HttpServlet.java:803) at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:269) at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:188) at org.springframework.security.util.FilterChainProxy$VirtualFilterChain.doFilter(FilterChainProxy.java:378) at org.springframework.security.intercept.web.FilterSecurityInterceptor.invoke(FilterSecurityInterceptor.java:109) at org.springframework.security.intercept.web.FilterSecurityInterceptor.doFilter(FilterSecurityInterceptor.java:83) at org.springframework.security.util.FilterChainProxy$VirtualFilterChain.doFilter(FilterChainProxy.java:390) at org.springframework.security.ui.ExceptionTranslationFilter.doFilterHttp(ExceptionTranslationFilter.java:101) at org.springframework.security.ui.SpringSecurityFilter.doFilter(SpringSecurityFilter.java:53) at org.springframework.security.util.FilterChainProxy$VirtualFilterChain.doFilter(FilterChainProxy.java:390) at org.pentaho.platform.web.http.security.SecurityStartupFilter.doFilter(SecurityStartupFilter.java:85) at org.springframework.security.util.FilterChainProxy$VirtualFilterChain.doFilter(FilterChainProxy.java:390) at org.springframework.security.providers.anonymous.AnonymousProcessingFilter.doFilterHttp(AnonymousProcessingFilter.java:105) at org.springframework.security.ui.SpringSecurityFilter.doFilter(SpringSecurityFilter.java:53) at org.springframework.security.util.FilterChainProxy$VirtualFilterChain.doFilter(FilterChainProxy.java:390) at org.pentaho.platform.web.http.security.RequestParameterAuthenticationFilter.doFilter(RequestParameterAuthenticationFilter.java:169) at org.springframework.security.util.FilterChainProxy$VirtualFilterChain.doFilter(FilterChainProxy.java:390) at org.springframework.security.ui.basicauth.BasicProcessingFilter.doFilterHttp(BasicProcessingFilter.java:174) at org.springframework.security.ui.SpringSecurityFilter.doFilter(SpringSecurityFilter.java:53) at org.springframework.security.util.FilterChainProxy$VirtualFilterChain.doFilter(FilterChainProxy.java:390) at org.springframework.security.ui.AbstractProcessingFilter.doFilterHttp(AbstractProcessingFilter.java:278) at org.springframework.security.ui.SpringSecurityFilter.doFilter(SpringSecurityFilter.java:53) at org.springframework.security.util.FilterChainProxy$VirtualFilterChain.doFilter(FilterChainProxy.java:390) at org.springframework.security.ui.logout.LogoutFilter.doFilterHttp(LogoutFilter.java:89) at org.springframework.security.ui.SpringSecurityFilter.doFilter(SpringSecurityFilter.java:53) at org.springframework.security.util.FilterChainProxy$VirtualFilterChain.doFilter(FilterChainProxy.java:390) at org.pentaho.platform.web.http.security.HttpSessionReuseDetectionFilter.doFilter(HttpSessionReuseDetectionFilter.java:134) at org.springframework.security.util.FilterChainProxy$VirtualFilterChain.doFilter(FilterChainProxy.java:390) at org.springframework.security.context.HttpSessionContextIntegrationFilter.doFilterHttp(HttpSessionContextIntegrationFilter.java:235) at org.springframework.security.ui.SpringSecurityFilter.doFilter(SpringSecurityFilter.java:53) at org.springframework.security.util.FilterChainProxy$VirtualFilterChain.doFilter(FilterChainProxy.java:390) at org.springframework.security.wrapper.SecurityContextHolderAwareRequestFilter.doFilterHttp(SecurityContextHolderAwareRequestFilter.java:91) at org.springframework.security.ui.SpringSecurityFilter.doFilter(SpringSecurityFilter.java:53) at org.springframework.security.util.FilterChainProxy$VirtualFilterChain.doFilter(FilterChainProxy.java:390) at org.springframework.security.util.FilterChainProxy.doFilter(FilterChainProxy.java:175) at org.springframework.security.util.FilterToBeanProxy.doFilter(FilterToBeanProxy.java:99) at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:215) at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:188) at com.pentaho.ui.servlet.SystemStatusFilter.doFilter(SystemStatusFilter.java:43) at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:215) at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:188) at org.pentaho.platform.web.http.filters.SetCharacterEncodingFilter.doFilter(SetCharacterEncodingFilter.java:113) at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:215) at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:188) at org.apache.catalina.core.StandardWrapperValve.invoke(StandardWrapperValve.java:213) at org.apache.catalina.core.StandardContextValve.invoke(StandardContextValve.java:174) at org.apache.catalina.authenticator.AuthenticatorBase.invoke(AuthenticatorBase.java:433) at org.apache.catalina.core.StandardHostValve.invoke(StandardHostValve.java:127) at org.apache.catalina.valves.ErrorReportValve.invoke(ErrorReportValve.java:117) at org.apache.catalina.core.StandardEngineValve.invoke(StandardEngineValve.java:108) at org.apache.catalina.connector.CoyoteAdapter.service(CoyoteAdapter.java:174) at org.apache.coyote.http11.Http11Processor.process(Http11Processor.java:874) at org.apache.coyote.http11.Http11BaseProtocol$Http11ConnectionHandler.processConnection(Http11BaseProtocol.java:665) at org.apache.tomcat.util.net.PoolTcpEndpoint.processSocket(PoolTcpEndpoint.java:528) at org.apache.tomcat.util.net.LeaderFollowerWorkerThread.runIt(LeaderFollowerWorkerThread.java:81) at org.apache.tomcat.util.threads.ThreadPool$ControlRunnable.run(ThreadPool.java:689) at java.lang.Thread.run(Unknown Source) Caused by: java.util.concurrent.ExecutionException: java.lang.RuntimeException: mondrian.olap.fun.MondrianEvaluationException: Infinite loop while evaluating calculated member '[Product.All Products].[*TOTAL_MEMBER_SEL~SUM]'; context stack is {([Location.All Regions].[*TOTAL_MEMBER_SEL~SUM]), ([Location.All Regions].[*TOTAL_MEMBER_SEL~SUM])} at java.util.concurrent.FutureTask$Sync.innerGet(Unknown Source) at java.util.concurrent.FutureTask.get(Unknown Source) at com.pentaho.analyzer.report.ReportRequestService.get(ReportRequestService.java:145) ... 68 more Caused by: java.lang.RuntimeException: mondrian.olap.fun.MondrianEvaluationException: Infinite loop while evaluating calculated member '[Product.All Products].[*TOTAL_MEMBER_SEL~SUM]'; context stack is {([Location.All Regions].[*TOTAL_MEMBER_SEL~SUM]), ([Location.All Regions].[*TOTAL_MEMBER_SEL~SUM])} at com.pentaho.analyzer.service.impl.AnalysisAreaManager.executeQuery(AnalysisAreaManager.java:343) at com.pentaho.analyzer.report.ReportManagerImpl.parseAndExecuteMDX(ReportManagerImpl.java:293) at com.pentaho.analyzer.report.ReportManagerImpl.getCVResultSet(ReportManagerImpl.java:352) at com.pentaho.analyzer.report.ReportManagerImpl.runReport(ReportManagerImpl.java:110) at com.pentaho.analyzer.report.ReportManagerImpl.runReport(ReportManagerImpl.java:81) at com.pentaho.analyzer.report.ReportRequestService$1.call(ReportRequestService.java:238) at com.pentaho.analyzer.report.ReportRequestService$1.call(ReportRequestService.java:229) at java.util.concurrent.FutureTask$Sync.innerRun(Unknown Source) at java.util.concurrent.FutureTask.run(Unknown Source) at java.util.concurrent.ThreadPoolExecutor$Worker.runTask(Unknown Source) at java.util.concurrent.ThreadPoolExecutor$Worker.run(Unknown Source) ... 1 more Caused by: mondrian.olap.fun.MondrianEvaluationException: Infinite loop while evaluating calculated member '[Product.All Products].[*TOTAL_MEMBER_SEL~SUM]'; context stack is {([Location.All Regions].[*TOTAL_MEMBER_SEL~SUM]), ([Location.All Regions].[*TOTAL_MEMBER_SEL~SUM])} at mondrian.olap.fun.FunUtil.newEvalException(FunUtil.java:78) at mondrian.rolap.RolapEvaluator.checkRecursion(RolapEvaluator.java:540) at mondrian.rolap.RolapEvaluator.setExpanding(RolapEvaluator.java:473) at mondrian.rolap.RolapMemberCalculation.pushSelf(RolapMemberCalculation.java:60) at mondrian.rolap.RolapEvaluator.evaluateCurrent(RolapEvaluator.java:459) at mondrian.calc.impl.ValueCalc.evaluate(ValueCalc.java:36) at mondrian.olap.fun.FunUtil.evaluateSet(FunUtil.java:1481) at mondrian.olap.fun.FunUtil.sumDouble(FunUtil.java:1385) at mondrian.olap.fun.SumFunDef$2.evaluateDouble(SumFunDef.java:119) at mondrian.calc.impl.AbstractDoubleCalc.evaluate(AbstractDoubleCalc.java:45) at mondrian.rolap.RolapEvaluator.evaluateCurrent(RolapEvaluator.java:461) at mondrian.olap.fun.CrossJoinFunDef.checkData(CrossJoinFunDef.java:2571) at mondrian.olap.fun.CrossJoinFunDef.nonEmptyList(CrossJoinFunDef.java:2516) at mondrian.olap.fun.NonEmptyCrossJoinFunDef$1.evaluateList(NonEmptyCrossJoinFunDef.java:68) at mondrian.olap.fun.UnionFunDef$1.evaluateList(UnionFunDef.java:58) at mondrian.calc.impl.AbstractListCalc.evaluateTupleList(AbstractListCalc.java:89) at mondrian.calc.impl.AbstractExpCompiler$TupleListIterCalc.evaluateTupleIterable(AbstractExpCompiler.java:584) at mondrian.calc.impl.AbstractTupleIterCalc.evaluate(AbstractTupleIterCalc.java:52) at mondrian.rolap.RolapResult.executeAxis(RolapResult.java:727) at mondrian.rolap.RolapResult.evalLoad(RolapResult.java:570) at mondrian.rolap.RolapResult.loadMembers(RolapResult.java:536) at mondrian.rolap.RolapResult.(RolapResult.java:269) at mondrian.rolap.RolapConnection.execute(RolapConnection.java:563) at com.pentaho.analyzer.service.impl.AnalysisAreaManager.executeQuery(AnalysisAreaManager.java:335) ... 11 more Failed java.lang.RuntimeException: java.util.concurrent.ExecutionException: java.lang.RuntimeException: mondrian.olap.fun.MondrianEvaluationException: Infinite loop while evaluating calculated member '[Product.All Products].[*TOTAL_MEMBER_SEL~SUM]'; context stack is {([Location.All Regions].[*TOTAL_MEMBER_SEL~SUM]), ([Location.All Regions].[*TOTAL_MEMBER_SEL~SUM])} Server Version: Pentaho Platform Core TRUNK-SNAPSHOT.development

    Pentaho BI Platform Tracking | 7 years ago | Benny Chow
    java.util.concurrent.ExecutionException: java.lang.RuntimeException: mondrian.olap.fun.MondrianEvaluationException: Infinite loop while evaluating calculated member '[Product.All Products].[*TOTAL_MEMBER_SEL~SUM]'; context stack is {([Location.All Regions].[*TOTAL_MEMBER_SEL~SUM]), ([Location.All Regions].[*TOTAL_MEMBER_SEL~SUM])}
  4. Speed up your debug routine!

    Automated exception search integrated into your IDE

  5. 0

    For Micahel's schema file, when he has the location and product on the same axis and grand totals turned on, he gets the below stack trace. A similar report on foodmart or steel wheels does not reproduce the exception. The MDX statement pattern is the same between salesdata and steelwheels/foodmart so we will need to debug Mondrian code to figure out what's going on. java.util.concurrent.ExecutionException: java.lang.RuntimeException: mondrian.olap.fun.MondrianEvaluationException: Infinite loop while evaluating calculated member '[Product.All Products].[*TOTAL_MEMBER_SEL~SUM]'; context stack is {([Location.All Regions].[*TOTAL_MEMBER_SEL~SUM]), ([Location.All Regions].[*TOTAL_MEMBER_SEL~SUM])}java.lang.RuntimeException: java.util.concurrent.ExecutionException: java.lang.RuntimeException: mondrian.olap.fun.MondrianEvaluationException: Infinite loop while evaluating calculated member '[Product.All Products].[*TOTAL_MEMBER_SEL~SUM]'; context stack is {([Location.All Regions].[*TOTAL_MEMBER_SEL~SUM]), ([Location.All Regions].[*TOTAL_MEMBER_SEL~SUM])} at com.pentaho.analyzer.report.ReportRequestService.get(ReportRequestService.java:187) at com.pentaho.analyzer.content.controller.ReportRunner.getResult(ReportRunner.java:256) at com.pentaho.analyzer.content.controller.AjaxBean.getReportHTML(AjaxBean.java:197) at com.pentaho.analyzer.content.AnalyzerContentGenerator.createContent(AnalyzerContentGenerator.java:120) at sun.reflect.GeneratedMethodAccessor142.invoke(Unknown Source) at sun.reflect.DelegatingMethodAccessorImpl.invoke(Unknown Source) at java.lang.reflect.Method.invoke(Unknown Source) at com.pentaho.platform.web.http.context.WebSpringPentahoObjectFactory$ProxyInvokeHandler.invoke(WebSpringPentahoObjectFactory.java:220) at $Proxy9.createContent(Unknown Source) at org.pentaho.platform.web.servlet.GenericServlet.doGet(GenericServlet.java:251) at org.pentaho.platform.web.servlet.GenericServlet.doPost(GenericServlet.java:82) at javax.servlet.http.HttpServlet.service(HttpServlet.java:710) at javax.servlet.http.HttpServlet.service(HttpServlet.java:803) at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:269) at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:188) at org.springframework.security.util.FilterChainProxy$VirtualFilterChain.doFilter(FilterChainProxy.java:378) at org.springframework.security.intercept.web.FilterSecurityInterceptor.invoke(FilterSecurityInterceptor.java:109) at org.springframework.security.intercept.web.FilterSecurityInterceptor.doFilter(FilterSecurityInterceptor.java:83) at org.springframework.security.util.FilterChainProxy$VirtualFilterChain.doFilter(FilterChainProxy.java:390) at org.springframework.security.ui.ExceptionTranslationFilter.doFilterHttp(ExceptionTranslationFilter.java:101) at org.springframework.security.ui.SpringSecurityFilter.doFilter(SpringSecurityFilter.java:53) at org.springframework.security.util.FilterChainProxy$VirtualFilterChain.doFilter(FilterChainProxy.java:390) at org.pentaho.platform.web.http.security.SecurityStartupFilter.doFilter(SecurityStartupFilter.java:85) at org.springframework.security.util.FilterChainProxy$VirtualFilterChain.doFilter(FilterChainProxy.java:390) at org.springframework.security.providers.anonymous.AnonymousProcessingFilter.doFilterHttp(AnonymousProcessingFilter.java:105) at org.springframework.security.ui.SpringSecurityFilter.doFilter(SpringSecurityFilter.java:53) at org.springframework.security.util.FilterChainProxy$VirtualFilterChain.doFilter(FilterChainProxy.java:390) at org.pentaho.platform.web.http.security.RequestParameterAuthenticationFilter.doFilter(RequestParameterAuthenticationFilter.java:169) at org.springframework.security.util.FilterChainProxy$VirtualFilterChain.doFilter(FilterChainProxy.java:390) at org.springframework.security.ui.basicauth.BasicProcessingFilter.doFilterHttp(BasicProcessingFilter.java:174) at org.springframework.security.ui.SpringSecurityFilter.doFilter(SpringSecurityFilter.java:53) at org.springframework.security.util.FilterChainProxy$VirtualFilterChain.doFilter(FilterChainProxy.java:390) at org.springframework.security.ui.AbstractProcessingFilter.doFilterHttp(AbstractProcessingFilter.java:278) at org.springframework.security.ui.SpringSecurityFilter.doFilter(SpringSecurityFilter.java:53) at org.springframework.security.util.FilterChainProxy$VirtualFilterChain.doFilter(FilterChainProxy.java:390) at org.springframework.security.ui.logout.LogoutFilter.doFilterHttp(LogoutFilter.java:89) at org.springframework.security.ui.SpringSecurityFilter.doFilter(SpringSecurityFilter.java:53) at org.springframework.security.util.FilterChainProxy$VirtualFilterChain.doFilter(FilterChainProxy.java:390) at org.pentaho.platform.web.http.security.HttpSessionReuseDetectionFilter.doFilter(HttpSessionReuseDetectionFilter.java:134) at org.springframework.security.util.FilterChainProxy$VirtualFilterChain.doFilter(FilterChainProxy.java:390) at org.springframework.security.context.HttpSessionContextIntegrationFilter.doFilterHttp(HttpSessionContextIntegrationFilter.java:235) at org.springframework.security.ui.SpringSecurityFilter.doFilter(SpringSecurityFilter.java:53) at org.springframework.security.util.FilterChainProxy$VirtualFilterChain.doFilter(FilterChainProxy.java:390) at org.springframework.security.wrapper.SecurityContextHolderAwareRequestFilter.doFilterHttp(SecurityContextHolderAwareRequestFilter.java:91) at org.springframework.security.ui.SpringSecurityFilter.doFilter(SpringSecurityFilter.java:53) at org.springframework.security.util.FilterChainProxy$VirtualFilterChain.doFilter(FilterChainProxy.java:390) at org.springframework.security.util.FilterChainProxy.doFilter(FilterChainProxy.java:175) at org.springframework.security.util.FilterToBeanProxy.doFilter(FilterToBeanProxy.java:99) at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:215) at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:188) at com.pentaho.ui.servlet.SystemStatusFilter.doFilter(SystemStatusFilter.java:43) at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:215) at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:188) at org.pentaho.platform.web.http.filters.SetCharacterEncodingFilter.doFilter(SetCharacterEncodingFilter.java:113) at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:215) at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:188) at org.apache.catalina.core.StandardWrapperValve.invoke(StandardWrapperValve.java:213) at org.apache.catalina.core.StandardContextValve.invoke(StandardContextValve.java:174) at org.apache.catalina.authenticator.AuthenticatorBase.invoke(AuthenticatorBase.java:433) at org.apache.catalina.core.StandardHostValve.invoke(StandardHostValve.java:127) at org.apache.catalina.valves.ErrorReportValve.invoke(ErrorReportValve.java:117) at org.apache.catalina.core.StandardEngineValve.invoke(StandardEngineValve.java:108) at org.apache.catalina.connector.CoyoteAdapter.service(CoyoteAdapter.java:174) at org.apache.coyote.http11.Http11Processor.process(Http11Processor.java:874) at org.apache.coyote.http11.Http11BaseProtocol$Http11ConnectionHandler.processConnection(Http11BaseProtocol.java:665) at org.apache.tomcat.util.net.PoolTcpEndpoint.processSocket(PoolTcpEndpoint.java:528) at org.apache.tomcat.util.net.LeaderFollowerWorkerThread.runIt(LeaderFollowerWorkerThread.java:81) at org.apache.tomcat.util.threads.ThreadPool$ControlRunnable.run(ThreadPool.java:689) at java.lang.Thread.run(Unknown Source) Caused by: java.util.concurrent.ExecutionException: java.lang.RuntimeException: mondrian.olap.fun.MondrianEvaluationException: Infinite loop while evaluating calculated member '[Product.All Products].[*TOTAL_MEMBER_SEL~SUM]'; context stack is {([Location.All Regions].[*TOTAL_MEMBER_SEL~SUM]), ([Location.All Regions].[*TOTAL_MEMBER_SEL~SUM])} at java.util.concurrent.FutureTask$Sync.innerGet(Unknown Source) at java.util.concurrent.FutureTask.get(Unknown Source) at com.pentaho.analyzer.report.ReportRequestService.get(ReportRequestService.java:145) ... 68 more Caused by: java.lang.RuntimeException: mondrian.olap.fun.MondrianEvaluationException: Infinite loop while evaluating calculated member '[Product.All Products].[*TOTAL_MEMBER_SEL~SUM]'; context stack is {([Location.All Regions].[*TOTAL_MEMBER_SEL~SUM]), ([Location.All Regions].[*TOTAL_MEMBER_SEL~SUM])} at com.pentaho.analyzer.service.impl.AnalysisAreaManager.executeQuery(AnalysisAreaManager.java:343) at com.pentaho.analyzer.report.ReportManagerImpl.parseAndExecuteMDX(ReportManagerImpl.java:293) at com.pentaho.analyzer.report.ReportManagerImpl.getCVResultSet(ReportManagerImpl.java:352) at com.pentaho.analyzer.report.ReportManagerImpl.runReport(ReportManagerImpl.java:110) at com.pentaho.analyzer.report.ReportManagerImpl.runReport(ReportManagerImpl.java:81) at com.pentaho.analyzer.report.ReportRequestService$1.call(ReportRequestService.java:238) at com.pentaho.analyzer.report.ReportRequestService$1.call(ReportRequestService.java:229) at java.util.concurrent.FutureTask$Sync.innerRun(Unknown Source) at java.util.concurrent.FutureTask.run(Unknown Source) at java.util.concurrent.ThreadPoolExecutor$Worker.runTask(Unknown Source) at java.util.concurrent.ThreadPoolExecutor$Worker.run(Unknown Source) ... 1 more Caused by: mondrian.olap.fun.MondrianEvaluationException: Infinite loop while evaluating calculated member '[Product.All Products].[*TOTAL_MEMBER_SEL~SUM]'; context stack is {([Location.All Regions].[*TOTAL_MEMBER_SEL~SUM]), ([Location.All Regions].[*TOTAL_MEMBER_SEL~SUM])} at mondrian.olap.fun.FunUtil.newEvalException(FunUtil.java:78) at mondrian.rolap.RolapEvaluator.checkRecursion(RolapEvaluator.java:540) at mondrian.rolap.RolapEvaluator.setExpanding(RolapEvaluator.java:473) at mondrian.rolap.RolapMemberCalculation.pushSelf(RolapMemberCalculation.java:60) at mondrian.rolap.RolapEvaluator.evaluateCurrent(RolapEvaluator.java:459) at mondrian.calc.impl.ValueCalc.evaluate(ValueCalc.java:36) at mondrian.olap.fun.FunUtil.evaluateSet(FunUtil.java:1481) at mondrian.olap.fun.FunUtil.sumDouble(FunUtil.java:1385) at mondrian.olap.fun.SumFunDef$2.evaluateDouble(SumFunDef.java:119) at mondrian.calc.impl.AbstractDoubleCalc.evaluate(AbstractDoubleCalc.java:45) at mondrian.rolap.RolapEvaluator.evaluateCurrent(RolapEvaluator.java:461) at mondrian.olap.fun.CrossJoinFunDef.checkData(CrossJoinFunDef.java:2571) at mondrian.olap.fun.CrossJoinFunDef.nonEmptyList(CrossJoinFunDef.java:2516) at mondrian.olap.fun.NonEmptyCrossJoinFunDef$1.evaluateList(NonEmptyCrossJoinFunDef.java:68) at mondrian.olap.fun.UnionFunDef$1.evaluateList(UnionFunDef.java:58) at mondrian.calc.impl.AbstractListCalc.evaluateTupleList(AbstractListCalc.java:89) at mondrian.calc.impl.AbstractExpCompiler$TupleListIterCalc.evaluateTupleIterable(AbstractExpCompiler.java:584) at mondrian.calc.impl.AbstractTupleIterCalc.evaluate(AbstractTupleIterCalc.java:52) at mondrian.rolap.RolapResult.executeAxis(RolapResult.java:727) at mondrian.rolap.RolapResult.evalLoad(RolapResult.java:570) at mondrian.rolap.RolapResult.loadMembers(RolapResult.java:536) at mondrian.rolap.RolapResult.(RolapResult.java:269) at mondrian.rolap.RolapConnection.execute(RolapConnection.java:563) at com.pentaho.analyzer.service.impl.AnalysisAreaManager.executeQuery(AnalysisAreaManager.java:335) ... 11 more Failed java.lang.RuntimeException: java.util.concurrent.ExecutionException: java.lang.RuntimeException: mondrian.olap.fun.MondrianEvaluationException: Infinite loop while evaluating calculated member '[Product.All Products].[*TOTAL_MEMBER_SEL~SUM]'; context stack is {([Location.All Regions].[*TOTAL_MEMBER_SEL~SUM]), ([Location.All Regions].[*TOTAL_MEMBER_SEL~SUM])} Server Version: Pentaho Platform Core TRUNK-SNAPSHOT.development

    Pentaho BI Platform Tracking | 7 years ago | Benny Chow
    java.util.concurrent.ExecutionException: java.lang.RuntimeException: mondrian.olap.fun.MondrianEvaluationException: Infinite loop while evaluating calculated member '[Product.All Products].[*TOTAL_MEMBER_SEL~SUM]'; context stack is {([Location.All Regions].[*TOTAL_MEMBER_SEL~SUM]), ([Location.All Regions].[*TOTAL_MEMBER_SEL~SUM])}

    Root Cause Analysis

    1. mondrian.olap.fun.MondrianEvaluationException

      Could not find an aggregator in the current evaluation context

      at mondrian.olap.fun.FunUtil.newEvalException()
    2. mondrian.olap.fun
      AggregateFunDef$AggregateCalc.evaluate
      1. mondrian.olap.fun.FunUtil.newEvalException(FunUtil.java:84)
      2. mondrian.olap.fun.AggregateFunDef$AggregateCalc.aggregate(AggregateFunDef.java:99)
      3. mondrian.olap.fun.AggregateFunDef$AggregateCalc.evaluate(AggregateFunDef.java:74)
      3 frames
    3. mondrian.rolap
      RolapConnection$1.call
      1. mondrian.rolap.RolapEvaluator.evaluateCurrent(RolapEvaluator.java:687)
      2. mondrian.rolap.RolapResult.executeStripe(RolapResult.java:1023)
      3. mondrian.rolap.RolapResult.executeBody(RolapResult.java:885)
      4. mondrian.rolap.RolapResult.<init>(RolapResult.java:465)
      5. mondrian.rolap.RolapConnection.executeInternal(RolapConnection.java:671)
      6. mondrian.rolap.RolapConnection.access$000(RolapConnection.java:51)
      7. mondrian.rolap.RolapConnection$1.call(RolapConnection.java:622)
      8. mondrian.rolap.RolapConnection$1.call(RolapConnection.java:620)
      8 frames
    4. 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