java.util.concurrent.ExecutionException: mondrian.olap.MondrianException: Mondrian Error:Internal error: Error while executing query [with set [AllGeographies] as '{IIf(([HRLocation].[West].[California].Children.Count = 0), {[HRLocation].[West].[California]}, [HRLocation].[West].[California].Children)}' set [Org] as '{IIf(([HROrgStructure].[0].[43].Children.Count = 0), {[HROrgStructure].[0].[43]}, [HROrgStructure].[0].[43].Children)}' set [OrgLocations] as 'Crossjoin([AllGeographies], [Org])' set [ChangeDateInRangeOffsetMinusOne_M] as '{[ChangeDate].[2010].[6].[30]}' set [EmployeeAllTerminationInRange_M] as 'NonEmptyCrossJoin([ChangeDateInRangeOffsetMinusOne_M], [EmployeeTerminationAll_M])' set [EmployeeTerminationAll_M] as '{Except([HRTerminated].Levels(1).Members, {[HRTerminated].[_No_]})}' member [Measures].[EmployeeAllTerminationInRangeCount] as 'Aggregate([EmployeeAllTerminationInRange_M], [Measures].[EmployeeIDcount])' select {[Measures].[EmployeeAllTerminationInRangeCount]} ON COLUMNS, {([HRLocation].[West].[California], [HROrgStructure].[0].[43]), [OrgLocations]} ON ROWS from [HREmployee_HROrgStructure_2010_6_30] ]]

Pentaho BI Platform Tracking | Geoff Zenger | 5 years ago
  1. 0

    Occasionally, under high load scenarios, we are encountering the following exception being thrown from DenseObjectSegmentDataSet.getObject(CellKey). The problem is clearly a race condition because the same query will return successfully if executed again (and many times it is executed successfully on its first run as well). Unfortunately, I do not currently have any reliable repro steps, but will upload them if/when I find some. This problem was not observed with Mondrian 3.2, and so appears to be new. Stack Trace: Caused by: mondrian.olap.MondrianException: Mondrian Error:Internal error: Error while executing query [with set [AllGeographies] as '{IIf(([HRLocation].[West].[California].Children.Count = 0), {[HRLocation].[West].[California]}, [HRLocation].[West].[California].Children)}' set [Org] as '{IIf(([HROrgStructure].[0].[43].Children.Count = 0), {[HROrgStructure].[0].[43]}, [HROrgStructure].[0].[43].Children)}' set [OrgLocations] as 'Crossjoin([AllGeographies], [Org])' set [ChangeDateInRangeOffsetMinusOne_M] as '{[ChangeDate].[2010].[6].[30]}' set [EmployeeInvoluntaryTermination_M] as '{[HRTerminated].[Involuntary]}' set [EmployeeInvoluntaryTerminationInRange_M] as 'Crossjoin([ChangeDateInRangeOffsetMinusOne_M], [EmployeeInvoluntaryTermination_M])' member [Measures].[EmployeeInvoluntaryTerminationInRangeCount] as 'Aggregate([EmployeeInvoluntaryTerminationInRange_M], [Measures].[EmployeeIDcount])' select {[Measures].[EmployeeInvoluntaryTerminationInRangeCount]} ON COLUMNS, {([HRLocation].[West].[California], [HROrgStructure].[0].[43]), [OrgLocations]} ON ROWS from [HREmployee_HROrgStructure_2010_6_30] ] at mondrian.resource.MondrianResource$_Def0.ex(MondrianResource.java:912) at mondrian.olap.Util.newInternal(Util.java:2062) at mondrian.olap.Util.newError(Util.java:2078) at mondrian.rolap.RolapConnection.executeInternal(RolapConnection.java:702) at mondrian.rolap.RolapConnection.access$3(RolapConnection.java:626) at mondrian.rolap.RolapConnection$1.call(RolapConnection.java:621) at mondrian.rolap.RolapConnection$1.call(RolapConnection.java:1) at java.util.concurrent.FutureTask$Sync.innerRun(Unknown Source) at java.util.concurrent.FutureTask.run(Unknown Source) at java.util.concurrent.ThreadPoolExecutor.runWorker(Unknown Source) at java.util.concurrent.ThreadPoolExecutor$Worker.run(Unknown Source) ... 1 more Caused by: mondrian.olap.MondrianException: Mondrian Error:Internal error: Pending segment failed to load: Segment #2656 { measure=count(HREmployee_EventMeasures.EmployeeID) HRTerminated_HRTerminated.TerminationInfo0=any HRLocation_HRLocation.Country={West} HRLocation_HRLocation.State={California} HRLocation_HRLocation.City={California} HREmployee_validityStart_HREmployee_validityStart.Year={2010} HREmployee_validityStart_HREmployee_validityStart.Month={6} HREmployee_validityStart_HREmployee_validityStart.Day={30} HROrgStructure_HROrgStructure_HROrgStructure_fixed_2010_6_30.Level0={0} HROrgStructure_HROrgStructure_HROrgStructure_fixed_2010_6_30.Level1={43} HROrgStructure_HROrgStructure_HROrgStructure_fixed_2010_6_30.Level2={43, 44, 54, 63, 64, 74, 86, 87}} at mondrian.resource.MondrianResource$_Def0.ex(MondrianResource.java:909) at mondrian.olap.Util.newInternal(Util.java:2055) at mondrian.olap.Util.newError(Util.java:2070) at mondrian.rolap.agg.Segment.waitUntilLoaded(Segment.java:422) at mondrian.rolap.agg.Aggregation.getCellValue(Aggregation.java:719) at mondrian.rolap.agg.AggregationManager.getCellFromCache(AggregationManager.java:133) at mondrian.rolap.FastBatchingCellReader.get(FastBatchingCellReader.java:97) at mondrian.rolap.RolapEvaluator.evaluateCurrent(RolapEvaluator.java:658) at mondrian.calc.impl.MemberValueCalc.evaluate(MemberValueCalc.java:101) at mondrian.olap.fun.FunUtil.evaluateSet(FunUtil.java:1536) at mondrian.olap.fun.FunUtil.sumDouble(FunUtil.java:1449) at mondrian.olap.fun.FunUtil.sum(FunUtil.java:1440) at mondrian.rolap.RolapAggregator$1.aggregate(RolapAggregator.java:36) at mondrian.olap.fun.AggregateFunDef$AggregateCalc.aggregate(AggregateFunDef.java:114) at mondrian.olap.fun.AggregateFunDef$AggregateCalc.evaluate(AggregateFunDef.java:75) at mondrian.rolap.RolapEvaluator.evaluateCurrent(RolapEvaluator.java:685) at mondrian.rolap.RolapResult.executeStripe(RolapResult.java:931) at mondrian.rolap.RolapResult.executeStripe(RolapResult.java:1071) at mondrian.rolap.RolapResult.executeStripe(RolapResult.java:1071) at mondrian.rolap.RolapResult.executeBody(RolapResult.java:820) at mondrian.rolap.RolapResult.<init>(RolapResult.java:445) at mondrian.rolap.RolapConnection.executeInternal(RolapConnection.java:668) ... 8 more SOURCE : remote=127.0.0.1/yvr-test02, host=localhost:8083com.visiercorp.server.base.VServerException: SQL fetch for [] with connection [WITH SET [AllGeographies] AS {IIF ([HRLocation].[West].[California].Children.Count = 0, [HRLocation].[West].[California], [HRLocation].[West].[California].Children)} SET [Org] AS {IIF ([HROrgStructure].[0].[43].Children.Count = 0, [HROrgStructure].[0].[43], [HROrgStructure].[0].[43].Children)} SET [OrgLocations] AS CROSSJOIN([AllGeographies], [Org]) SET [ChangeDateInRangeOffsetMinusOne_M] AS {[ChangeDate].[2010].[6].[30]} SET [EmployeeAllTerminationInRange_M] AS NONEMPTYCROSSJOIN([ChangeDateInRangeOffsetMinusOne_M], [EmployeeTerminationAll_M]) SET [EmployeeTerminationAll_M] AS {EXCEPT([HRTerminated].Levels(1).Members,[HRTerminated].[_No_])} MEMBER [Measures].[EmployeeAllTerminationInRangeCount] AS Aggregate([EmployeeAllTerminationInRange_M], [Measures].[EmployeeIDCount]) SELECT {[Measures].[EmployeeAllTerminationInRangeCount]} ON 0, {([HRLocation].[West].[California],[HROrgStructure].[0].[43]), [OrgLocations]} ON 1 FROM HREmployee_HROrgStructure_2010_6_30] was invalid. Detail: [SQL fetch for [] with connection [WITH SET [AllGeographies] AS {IIF ([HRLocation].[West].[California].Children.Count = 0, [HRLocation].[West].[California], [HRLocation].[West].[California].Children)} SET [Org] AS {IIF ([HROrgStructure].[0].[43].Children.Count = 0, [HROrgStructure].[0].[43], [HROrgStructure].[0].[43].Children)} SET [OrgLocations] AS CROSSJOIN([AllGeographies], [Org]) SET [ChangeDateInRangeOffsetMinusOne_M] AS {[ChangeDate].[2010].[6].[30]} SET [EmployeeAllTerminationInRange_M] AS NONEMPTYCROSSJOIN([ChangeDateInRangeOffsetMinusOne_M], [EmployeeTerminationAll_M]) SET [EmployeeTerminationAll_M] AS {EXCEPT([HRTerminated].Levels(1).Members,[HRTerminated].[_No_])} MEMBER [Measures].[EmployeeAllTerminationInRangeCount] AS Aggregate([EmployeeAllTerminationInRange_M], [Measures].[EmployeeIDCount]) SELECT {[Measures].[EmployeeAllTerminationInRangeCount]} ON 0, {([HRLocation].[West].[California],[HROrgStructure].[0].[43]), [OrgLocations]} ON 1 FROM HREmployee_HROrgStructure_2010_6_30] was invalid. Detail: [Mondrian Error:java.util.concurrent.ExecutionException: mondrian.olap.MondrianException: Mondrian Error:Internal error: Error while executing query [with set [AllGeographies] as '{IIf(([HRLocation].[West].[California].Children.Count = 0), {[HRLocation].[West].[California]}, [HRLocation].[West].[California].Children)}' set [Org] as '{IIf(([HROrgStructure].[0].[43].Children.Count = 0), {[HROrgStructure].[0].[43]}, [HROrgStructure].[0].[43].Children)}' set [OrgLocations] as 'Crossjoin([AllGeographies], [Org])' set [ChangeDateInRangeOffsetMinusOne_M] as '{[ChangeDate].[2010].[6].[30]}' set [EmployeeAllTerminationInRange_M] as 'NonEmptyCrossJoin([ChangeDateInRangeOffsetMinusOne_M], [EmployeeTerminationAll_M])' set [EmployeeTerminationAll_M] as '{Except([HRTerminated].Levels(1).Members, {[HRTerminated].[_No_]})}' member [Measures].[EmployeeAllTerminationInRangeCount] as 'Aggregate([EmployeeAllTerminationInRange_M], [Measures].[EmployeeIDcount])' select {[Measures].[EmployeeAllTerminationInRangeCount]} ON COLUMNS, {([HRLocation].[West].[California], [HROrgStructure].[0].[43]), [OrgLocations]} ON ROWS from [HREmployee_HROrgStructure_2010_6_30] ]]] at com.visiercorp.server.function.fetch.MdxDatabaseFetch.processAnalyticQuery(MdxDatabaseFetch.java:1322) at com.visiercorp.server.function.plugin.provided.AnalyticConceptBuilder.runQueryOnFactTable(AnalyticConceptBuilder.java:775) at com.visiercorp.server.function.plugin.provided.AnalyticConceptBuilder.executeQueryOnShard(AnalyticConceptBuilder.java:1694) at com.visiercorp.server.function.plugin.provided.AnalyticConceptBuilder.processChunk(AnalyticConceptBuilder.java:1806) at com.visiercorp.server.model.FunctionEngine.processChunk(FunctionEngine.java:83) at com.visiercorp.server.processor.AbstractProcessor.processChunk(AbstractProcessor.java:604) at com.visiercorp.server.processor.AbstractProcessor.processChunkAsString(AbstractProcessor.java:626) at com.visiercorp.server.processor.ProcessorManagerImpl$ProcessorProxy.processChunkAsString(ProcessorManagerImpl.java:288) at com.visiercorp.server.rest.ApplicationService.executeFunction(ApplicationService.java:464) at sun.reflect.GeneratedMethodAccessor165.invoke(Unknown Source) at sun.reflect.DelegatingMethodAccessorImpl.invoke(Unknown Source) at java.lang.reflect.Method.invoke(Unknown Source) at org.jboss.resteasy.core.MethodInjectorImpl.invoke(MethodInjectorImpl.java:140) at org.jboss.resteasy.core.ResourceMethod.invokeOnTarget(ResourceMethod.java:255) at org.jboss.resteasy.core.ResourceMethod.invoke(ResourceMethod.java:220) at org.jboss.resteasy.core.ResourceMethod.invoke(ResourceMethod.java:209) at org.jboss.resteasy.core.SynchronousDispatcher.getResponse(SynchronousDispatcher.java:519) at org.jboss.resteasy.core.SynchronousDispatcher.invoke(SynchronousDispatcher.java:496) at org.jboss.resteasy.core.SynchronousDispatcher.invoke(SynchronousDispatcher.java:119) at org.jboss.resteasy.plugins.server.servlet.ServletContainerDispatcher.service(ServletContainerDispatcher.java:208) at org.jboss.resteasy.plugins.server.servlet.HttpServletDispatcher.service(HttpServletDispatcher.java:55) at org.jboss.resteasy.plugins.server.servlet.HttpServletDispatcher.service(HttpServletDispatcher.java:50) at javax.servlet.http.HttpServlet.service(HttpServlet.java:820) at org.eclipse.jetty.servlet.ServletHolder.handle(ServletHolder.java:538) at org.eclipse.jetty.servlet.ServletHandler$CachedChain.doFilter(ServletHandler.java:1352) at org.eclipse.jetty.servlets.UserAgentFilter.doFilter(UserAgentFilter.java:77) at org.eclipse.jetty.servlets.GzipFilter.doFilter(GzipFilter.java:170) at org.eclipse.jetty.servlet.ServletHandler$CachedChain.doFilter(ServletHandler.java:1323) at org.eclipse.jetty.servlet.ServletHandler.doHandle(ServletHandler.java:476) at org.eclipse.jetty.server.handler.ScopedHandler.handle(ScopedHandler.java:119) at org.eclipse.jetty.security.SecurityHandler.handle(SecurityHandler.java:480) at org.eclipse.jetty.server.session.SessionHandler.doHandle(SessionHandler.java:225) at org.eclipse.jetty.server.handler.ContextHandler.doHandle(ContextHandler.java:937) at org.eclipse.jetty.servlet.ServletHandler.doScope(ServletHandler.java:406) at org.eclipse.jetty.server.session.SessionHandler.doScope(SessionHandler.java:183) at org.eclipse.jetty.server.handler.ContextHandler.doScope(ContextHandler.java:871) at org.eclipse.jetty.server.handler.ScopedHandler.handle(ScopedHandler.java:117) at org.eclipse.jetty.server.handler.ContextHandlerCollection.handle(ContextHandlerCollection.java:247) at org.eclipse.jetty.server.handler.HandlerCollection.handle(HandlerCollection.java:149) at org.eclipse.jetty.server.handler.HandlerWrapper.handle(HandlerWrapper.java:110) at org.eclipse.jetty.server.Server.handle(Server.java:346) at org.eclipse.jetty.server.HttpConnection.handleRequest(HttpConnection.java:589) at org.eclipse.jetty.server.HttpConnection$RequestHandler.content(HttpConnection.java:1065) at org.eclipse.jetty.http.HttpParser.parseNext(HttpParser.java:823) at org.eclipse.jetty.http.HttpParser.parseAvailable(HttpParser.java:220) at org.eclipse.jetty.server.HttpConnection.handle(HttpConnection.java:411) at org.eclipse.jetty.io.nio.SelectChannelEndPoint.handle(SelectChannelEndPoint.java:535) at org.eclipse.jetty.io.nio.SelectChannelEndPoint$1.run(SelectChannelEndPoint.java:40) at org.eclipse.jetty.util.thread.QueuedThreadPool$3.run(QueuedThreadPool.java:529) at java.lang.Thread.run(Unknown Source) Caused by: com.visiercorp.server.base.VServerException: SQL fetch for [] with connection [WITH SET [AllGeographies] AS {IIF ([HRLocation].[West].[California].Children.Count = 0, [HRLocation].[West].[California], [HRLocation].[West].[California].Children)} SET [Org] AS {IIF ([HROrgStructure].[0].[43].Children.Count = 0, [HROrgStructure].[0].[43], [HROrgStructure].[0].[43].Children)} SET [OrgLocations] AS CROSSJOIN([AllGeographies], [Org]) SET [ChangeDateInRangeOffsetMinusOne_M] AS {[ChangeDate].[2010].[6].[30]} SET [EmployeeAllTerminationInRange_M] AS NONEMPTYCROSSJOIN([ChangeDateInRangeOffsetMinusOne_M], [EmployeeTerminationAll_M]) SET [EmployeeTerminationAll_M] AS {EXCEPT([HRTerminated].Levels(1).Members,[HRTerminated].[_No_])} MEMBER [Measures].[EmployeeAllTerminationInRangeCount] AS Aggregate([EmployeeAllTerminationInRange_M], [Measures].[EmployeeIDCount]) SELECT {[Measures].[EmployeeAllTerminationInRangeCount]} ON 0, {([HRLocation].[West].[California],[HROrgStructure].[0].[43]), [OrgLocations]} ON 1 FROM HREmployee_HROrgStructure_2010_6_30] was invalid. Detail: [Mondrian Error:java.util.concurrent.ExecutionException: mondrian.olap.MondrianException: Mondrian Error:Internal error: Error while executing query [with set [AllGeographies] as '{IIf(([HRLocation].[West].[California].Children.Count = 0), {[HRLocation].[West].[California]}, [HRLocation].[West].[California].Children)}' set [Org] as '{IIf(([HROrgStructure].[0].[43].Children.Count = 0), {[HROrgStructure].[0].[43]}, [HROrgStructure].[0].[43].Children)}' set [OrgLocations] as 'Crossjoin([AllGeographies], [Org])' set [ChangeDateInRangeOffsetMinusOne_M] as '{[ChangeDate].[2010].[6].[30]}' set [EmployeeAllTerminationInRange_M] as 'NonEmptyCrossJoin([ChangeDateInRangeOffsetMinusOne_M], [EmployeeTerminationAll_M])' set [EmployeeTerminationAll_M] as '{Except([HRTerminated].Levels(1).Members, {[HRTerminated].[_No_]})}' member [Measures].[EmployeeAllTerminationInRangeCount] as 'Aggregate([EmployeeAllTerminationInRange_M], [Measures].[EmployeeIDcount])' select {[Measures].[EmployeeAllTerminationInRangeCount]} ON COLUMNS, {([HRLocation].[West].[California], [HROrgStructure].[0].[43]), [OrgLocations]} ON ROWS from [HREmployee_HROrgStructure_2010_6_30] ]] at com.visiercorp.server.function.fetch.MdxDatabaseFetch.executeQuery(MdxDatabaseFetch.java:1352) at com.visiercorp.server.function.fetch.MdxDatabaseFetch.processAnalyticQuery(MdxDatabaseFetch.java:1302) ... 49 more Caused by: mondrian.olap.MondrianException: Mondrian Error:java.util.concurrent.ExecutionException: mondrian.olap.MondrianException: Mondrian Error:Internal error: Error while executing query [with set [AllGeographies] as '{IIf(([HRLocation].[West].[California].Children.Count = 0), {[HRLocation].[West].[California]}, [HRLocation].[West].[California].Children)}' set [Org] as '{IIf(([HROrgStructure].[0].[43].Children.Count = 0), {[HROrgStructure].[0].[43]}, [HROrgStructure].[0].[43].Children)}' set [OrgLocations] as 'Crossjoin([AllGeographies], [Org])' set [ChangeDateInRangeOffsetMinusOne_M] as '{[ChangeDate].[2010].[6].[30]}' set [EmployeeAllTerminationInRange_M] as 'NonEmptyCrossJoin([ChangeDateInRangeOffsetMinusOne_M], [EmployeeTerminationAll_M])' set [EmployeeTerminationAll_M] as '{Except([HRTerminated].Levels(1).Members, {[HRTerminated].[_No_]})}' member [Measures].[EmployeeAllTerminationInRangeCount] as 'Aggregate([EmployeeAllTerminationInRange_M], [Measures].[EmployeeIDcount])' select {[Measures].[EmployeeAllTerminationInRangeCount]} ON COLUMNS, {([HRLocation].[West].[California], [HROrgStructure].[0].[43]), [OrgLocations]} ON ROWS from [HREmployee_HROrgStructure_2010_6_30] ] at mondrian.rolap.RolapResultShepherd.shepherdExecution(RolapResultShepherd.java:158) at mondrian.rolap.RolapConnection.execute(RolapConnection.java:617) at mondrian.olap4j.MondrianOlap4jCellSet.execute(MondrianOlap4jCellSet.java:89) at mondrian.olap4j.MondrianOlap4jStatement.executeOlapQueryInternal(MondrianOlap4jStatement.java:409) at mondrian.olap4j.MondrianOlap4jStatement.executeOlapQuery(MondrianOlap4jStatement.java:341) at com.visiercorp.server.function.fetch.MdxDatabaseFetch.executeMdxQuery(MdxDatabaseFetch.java:912) at com.visiercorp.server.function.fetch.MdxDatabaseFetch.executeQuery(MdxDatabaseFetch.java:1342) ... 50 more Caused by: java.util.concurrent.ExecutionException: mondrian.olap.MondrianException: Mondrian Error:Internal error: Error while executing query [with set [AllGeographies] as '{IIf(([HRLocation].[West].[California].Children.Count = 0), {[HRLocation].[West].[California]}, [HRLocation].[West].[California].Children)}' set [Org] as '{IIf(([HROrgStructure].[0].[43].Children.Count = 0), {[HROrgStructure].[0].[43]}, [HROrgStructure].[0].[43].Children)}' set [OrgLocations] as 'Crossjoin([AllGeographies], [Org])' set [ChangeDateInRangeOffsetMinusOne_M] as '{[ChangeDate].[2010].[6].[30]}' set [EmployeeAllTerminationInRange_M] as 'NonEmptyCrossJoin([ChangeDateInRangeOffsetMinusOne_M], [EmployeeTerminationAll_M])' set [EmployeeTerminationAll_M] as '{Except([HRTerminated].Levels(1).Members, {[HRTerminated].[_No_]})}' member [Measures].[EmployeeAllTerminationInRangeCount] as 'Aggregate([EmployeeAllTerminationInRange_M], [Measures].[EmployeeIDcount])' select {[Measures].[EmployeeAllTerminationInRangeCount]} ON COLUMNS, {([HRLocation].[West].[California], [HROrgStructure].[0].[43]), [OrgLocations]} ON ROWS from [HREmployee_HROrgStructure_2010_6_30] ] at java.util.concurrent.FutureTask$Sync.innerGet(Unknown Source) at java.util.concurrent.FutureTask.get(Unknown Source) at mondrian.rolap.RolapResultShepherd.shepherdExecution(RolapResultShepherd.java:132) ... 56 more Caused by: mondrian.olap.MondrianException: Mondrian Error:Internal error: Error while executing query [with set [AllGeographies] as '{IIf(([HRLocation].[West].[California].Children.Count = 0), {[HRLocation].[West].[California]}, [HRLocation].[West].[California].Children)}' set [Org] as '{IIf(([HROrgStructure].[0].[43].Children.Count = 0), {[HROrgStructure].[0].[43]}, [HROrgStructure].[0].[43].Children)}' set [OrgLocations] as 'Crossjoin([AllGeographies], [Org])' set [ChangeDateInRangeOffsetMinusOne_M] as '{[ChangeDate].[2010].[6].[30]}' set [EmployeeAllTerminationInRange_M] as 'NonEmptyCrossJoin([ChangeDateInRangeOffsetMinusOne_M], [EmployeeTerminationAll_M])' set [EmployeeTerminationAll_M] as '{Except([HRTerminated].Levels(1).Members, {[HRTerminated].[_No_]})}' member [Measures].[EmployeeAllTerminationInRangeCount] as 'Aggregate([EmployeeAllTerminationInRange_M], [Measures].[EmployeeIDcount])' select {[Measures].[EmployeeAllTerminationInRangeCount]} ON COLUMNS, {([HRLocation].[West].[California], [HROrgStructure].[0].[43]), [OrgLocations]} ON ROWS from [HREmployee_HROrgStructure_2010_6_30] ] at mondrian.resource.MondrianResource$_Def0.ex(MondrianResource.java:912) at mondrian.olap.Util.newInternal(Util.java:2062) at mondrian.olap.Util.newError(Util.java:2078) at mondrian.rolap.RolapConnection.executeInternal(RolapConnection.java:702) at mondrian.rolap.RolapConnection.access$3(RolapConnection.java:626) at mondrian.rolap.RolapConnection$1.call(RolapConnection.java:621) at mondrian.rolap.RolapConnection$1.call(RolapConnection.java:1) at java.util.concurrent.FutureTask$Sync.innerRun(Unknown Source) at java.util.concurrent.FutureTask.run(Unknown Source) at java.util.concurrent.ThreadPoolExecutor.runWorker(Unknown Source) at java.util.concurrent.ThreadPoolExecutor$Worker.run(Unknown Source) ... 1 more Caused by: java.lang.ArrayIndexOutOfBoundsException: 3 at mondrian.rolap.agg.DenseObjectSegmentDataset.getObject(DenseObjectSegmentDataset.java:49) at mondrian.rolap.agg.Segment.getCellValue(Segment.java:368) at mondrian.rolap.agg.Aggregation.getCellValue(Aggregation.java:705) at mondrian.rolap.agg.AggregationManager.getCellFromCache(AggregationManager.java:133) at mondrian.rolap.FastBatchingCellReader.get(FastBatchingCellReader.java:97) at mondrian.rolap.RolapEvaluator.evaluateCurrent(RolapEvaluator.java:658) at mondrian.calc.impl.MemberValueCalc.evaluate(MemberValueCalc.java:101) at mondrian.olap.fun.FunUtil.evaluateSet(FunUtil.java:1536) at mondrian.olap.fun.FunUtil.sumDouble(FunUtil.java:1449) at mondrian.olap.fun.FunUtil.sum(FunUtil.java:1440) at mondrian.rolap.RolapAggregator$1.aggregate(RolapAggregator.java:36) at mondrian.olap.fun.AggregateFunDef$AggregateCalc.aggregate(AggregateFunDef.java:114) at mondrian.olap.fun.AggregateFunDef$AggregateCalc.evaluate(AggregateFunDef.java:75) at mondrian.rolap.RolapEvaluator.evaluateCurrent(RolapEvaluator.java:685) at mondrian.rolap.RolapResult.executeStripe(RolapResult.java:931) at mondrian.rolap.RolapResult.executeStripe(RolapResult.java:1071) at mondrian.rolap.RolapResult.executeStripe(RolapResult.java:1071) at mondrian.rolap.RolapResult.executeBody(RolapResult.java:820) at mondrian.rolap.RolapResult.<init>(RolapResult.java:445) at mondrian.rolap.RolapConnection.executeInternal(RolapConnection.java:668) ... 8 more

    Pentaho BI Platform Tracking | 5 years ago | Geoff Zenger
    java.util.concurrent.ExecutionException: mondrian.olap.MondrianException: Mondrian Error:Internal error: Error while executing query [with set [AllGeographies] as '{IIf(([HRLocation].[West].[California].Children.Count = 0), {[HRLocation].[West].[California]}, [HRLocation].[West].[California].Children)}' set [Org] as '{IIf(([HROrgStructure].[0].[43].Children.Count = 0), {[HROrgStructure].[0].[43]}, [HROrgStructure].[0].[43].Children)}' set [OrgLocations] as 'Crossjoin([AllGeographies], [Org])' set [ChangeDateInRangeOffsetMinusOne_M] as '{[ChangeDate].[2010].[6].[30]}' set [EmployeeAllTerminationInRange_M] as 'NonEmptyCrossJoin([ChangeDateInRangeOffsetMinusOne_M], [EmployeeTerminationAll_M])' set [EmployeeTerminationAll_M] as '{Except([HRTerminated].Levels(1).Members, {[HRTerminated].[_No_]})}' member [Measures].[EmployeeAllTerminationInRangeCount] as 'Aggregate([EmployeeAllTerminationInRange_M], [Measures].[EmployeeIDcount])' select {[Measures].[EmployeeAllTerminationInRangeCount]} ON COLUMNS, {([HRLocation].[West].[California], [HROrgStructure].[0].[43]), [OrgLocations]} ON ROWS from [HREmployee_HROrgStructure_2010_6_30] ]]
  2. 0

    Occasionally, under high load scenarios, we are encountering the following exception being thrown from DenseObjectSegmentDataSet.getObject(CellKey). The problem is clearly a race condition because the same query will return successfully if executed again (and many times it is executed successfully on its first run as well). Unfortunately, I do not currently have any reliable repro steps, but will upload them if/when I find some. This problem was not observed with Mondrian 3.2, and so appears to be new. Stack Trace: Caused by: mondrian.olap.MondrianException: Mondrian Error:Internal error: Error while executing query [with set [AllGeographies] as '{IIf(([HRLocation].[West].[California].Children.Count = 0), {[HRLocation].[West].[California]}, [HRLocation].[West].[California].Children)}' set [Org] as '{IIf(([HROrgStructure].[0].[43].Children.Count = 0), {[HROrgStructure].[0].[43]}, [HROrgStructure].[0].[43].Children)}' set [OrgLocations] as 'Crossjoin([AllGeographies], [Org])' set [ChangeDateInRangeOffsetMinusOne_M] as '{[ChangeDate].[2010].[6].[30]}' set [EmployeeInvoluntaryTermination_M] as '{[HRTerminated].[Involuntary]}' set [EmployeeInvoluntaryTerminationInRange_M] as 'Crossjoin([ChangeDateInRangeOffsetMinusOne_M], [EmployeeInvoluntaryTermination_M])' member [Measures].[EmployeeInvoluntaryTerminationInRangeCount] as 'Aggregate([EmployeeInvoluntaryTerminationInRange_M], [Measures].[EmployeeIDcount])' select {[Measures].[EmployeeInvoluntaryTerminationInRangeCount]} ON COLUMNS, {([HRLocation].[West].[California], [HROrgStructure].[0].[43]), [OrgLocations]} ON ROWS from [HREmployee_HROrgStructure_2010_6_30] ] at mondrian.resource.MondrianResource$_Def0.ex(MondrianResource.java:912) at mondrian.olap.Util.newInternal(Util.java:2062) at mondrian.olap.Util.newError(Util.java:2078) at mondrian.rolap.RolapConnection.executeInternal(RolapConnection.java:702) at mondrian.rolap.RolapConnection.access$3(RolapConnection.java:626) at mondrian.rolap.RolapConnection$1.call(RolapConnection.java:621) at mondrian.rolap.RolapConnection$1.call(RolapConnection.java:1) at java.util.concurrent.FutureTask$Sync.innerRun(Unknown Source) at java.util.concurrent.FutureTask.run(Unknown Source) at java.util.concurrent.ThreadPoolExecutor.runWorker(Unknown Source) at java.util.concurrent.ThreadPoolExecutor$Worker.run(Unknown Source) ... 1 more Caused by: mondrian.olap.MondrianException: Mondrian Error:Internal error: Pending segment failed to load: Segment #2656 { measure=count(HREmployee_EventMeasures.EmployeeID) HRTerminated_HRTerminated.TerminationInfo0=any HRLocation_HRLocation.Country={West} HRLocation_HRLocation.State={California} HRLocation_HRLocation.City={California} HREmployee_validityStart_HREmployee_validityStart.Year={2010} HREmployee_validityStart_HREmployee_validityStart.Month={6} HREmployee_validityStart_HREmployee_validityStart.Day={30} HROrgStructure_HROrgStructure_HROrgStructure_fixed_2010_6_30.Level0={0} HROrgStructure_HROrgStructure_HROrgStructure_fixed_2010_6_30.Level1={43} HROrgStructure_HROrgStructure_HROrgStructure_fixed_2010_6_30.Level2={43, 44, 54, 63, 64, 74, 86, 87}} at mondrian.resource.MondrianResource$_Def0.ex(MondrianResource.java:909) at mondrian.olap.Util.newInternal(Util.java:2055) at mondrian.olap.Util.newError(Util.java:2070) at mondrian.rolap.agg.Segment.waitUntilLoaded(Segment.java:422) at mondrian.rolap.agg.Aggregation.getCellValue(Aggregation.java:719) at mondrian.rolap.agg.AggregationManager.getCellFromCache(AggregationManager.java:133) at mondrian.rolap.FastBatchingCellReader.get(FastBatchingCellReader.java:97) at mondrian.rolap.RolapEvaluator.evaluateCurrent(RolapEvaluator.java:658) at mondrian.calc.impl.MemberValueCalc.evaluate(MemberValueCalc.java:101) at mondrian.olap.fun.FunUtil.evaluateSet(FunUtil.java:1536) at mondrian.olap.fun.FunUtil.sumDouble(FunUtil.java:1449) at mondrian.olap.fun.FunUtil.sum(FunUtil.java:1440) at mondrian.rolap.RolapAggregator$1.aggregate(RolapAggregator.java:36) at mondrian.olap.fun.AggregateFunDef$AggregateCalc.aggregate(AggregateFunDef.java:114) at mondrian.olap.fun.AggregateFunDef$AggregateCalc.evaluate(AggregateFunDef.java:75) at mondrian.rolap.RolapEvaluator.evaluateCurrent(RolapEvaluator.java:685) at mondrian.rolap.RolapResult.executeStripe(RolapResult.java:931) at mondrian.rolap.RolapResult.executeStripe(RolapResult.java:1071) at mondrian.rolap.RolapResult.executeStripe(RolapResult.java:1071) at mondrian.rolap.RolapResult.executeBody(RolapResult.java:820) at mondrian.rolap.RolapResult.<init>(RolapResult.java:445) at mondrian.rolap.RolapConnection.executeInternal(RolapConnection.java:668) ... 8 more SOURCE : remote=127.0.0.1/yvr-test02, host=localhost:8083com.visiercorp.server.base.VServerException: SQL fetch for [] with connection [WITH SET [AllGeographies] AS {IIF ([HRLocation].[West].[California].Children.Count = 0, [HRLocation].[West].[California], [HRLocation].[West].[California].Children)} SET [Org] AS {IIF ([HROrgStructure].[0].[43].Children.Count = 0, [HROrgStructure].[0].[43], [HROrgStructure].[0].[43].Children)} SET [OrgLocations] AS CROSSJOIN([AllGeographies], [Org]) SET [ChangeDateInRangeOffsetMinusOne_M] AS {[ChangeDate].[2010].[6].[30]} SET [EmployeeAllTerminationInRange_M] AS NONEMPTYCROSSJOIN([ChangeDateInRangeOffsetMinusOne_M], [EmployeeTerminationAll_M]) SET [EmployeeTerminationAll_M] AS {EXCEPT([HRTerminated].Levels(1).Members,[HRTerminated].[_No_])} MEMBER [Measures].[EmployeeAllTerminationInRangeCount] AS Aggregate([EmployeeAllTerminationInRange_M], [Measures].[EmployeeIDCount]) SELECT {[Measures].[EmployeeAllTerminationInRangeCount]} ON 0, {([HRLocation].[West].[California],[HROrgStructure].[0].[43]), [OrgLocations]} ON 1 FROM HREmployee_HROrgStructure_2010_6_30] was invalid. Detail: [SQL fetch for [] with connection [WITH SET [AllGeographies] AS {IIF ([HRLocation].[West].[California].Children.Count = 0, [HRLocation].[West].[California], [HRLocation].[West].[California].Children)} SET [Org] AS {IIF ([HROrgStructure].[0].[43].Children.Count = 0, [HROrgStructure].[0].[43], [HROrgStructure].[0].[43].Children)} SET [OrgLocations] AS CROSSJOIN([AllGeographies], [Org]) SET [ChangeDateInRangeOffsetMinusOne_M] AS {[ChangeDate].[2010].[6].[30]} SET [EmployeeAllTerminationInRange_M] AS NONEMPTYCROSSJOIN([ChangeDateInRangeOffsetMinusOne_M], [EmployeeTerminationAll_M]) SET [EmployeeTerminationAll_M] AS {EXCEPT([HRTerminated].Levels(1).Members,[HRTerminated].[_No_])} MEMBER [Measures].[EmployeeAllTerminationInRangeCount] AS Aggregate([EmployeeAllTerminationInRange_M], [Measures].[EmployeeIDCount]) SELECT {[Measures].[EmployeeAllTerminationInRangeCount]} ON 0, {([HRLocation].[West].[California],[HROrgStructure].[0].[43]), [OrgLocations]} ON 1 FROM HREmployee_HROrgStructure_2010_6_30] was invalid. Detail: [Mondrian Error:java.util.concurrent.ExecutionException: mondrian.olap.MondrianException: Mondrian Error:Internal error: Error while executing query [with set [AllGeographies] as '{IIf(([HRLocation].[West].[California].Children.Count = 0), {[HRLocation].[West].[California]}, [HRLocation].[West].[California].Children)}' set [Org] as '{IIf(([HROrgStructure].[0].[43].Children.Count = 0), {[HROrgStructure].[0].[43]}, [HROrgStructure].[0].[43].Children)}' set [OrgLocations] as 'Crossjoin([AllGeographies], [Org])' set [ChangeDateInRangeOffsetMinusOne_M] as '{[ChangeDate].[2010].[6].[30]}' set [EmployeeAllTerminationInRange_M] as 'NonEmptyCrossJoin([ChangeDateInRangeOffsetMinusOne_M], [EmployeeTerminationAll_M])' set [EmployeeTerminationAll_M] as '{Except([HRTerminated].Levels(1).Members, {[HRTerminated].[_No_]})}' member [Measures].[EmployeeAllTerminationInRangeCount] as 'Aggregate([EmployeeAllTerminationInRange_M], [Measures].[EmployeeIDcount])' select {[Measures].[EmployeeAllTerminationInRangeCount]} ON COLUMNS, {([HRLocation].[West].[California], [HROrgStructure].[0].[43]), [OrgLocations]} ON ROWS from [HREmployee_HROrgStructure_2010_6_30] ]]] at com.visiercorp.server.function.fetch.MdxDatabaseFetch.processAnalyticQuery(MdxDatabaseFetch.java:1322) at com.visiercorp.server.function.plugin.provided.AnalyticConceptBuilder.runQueryOnFactTable(AnalyticConceptBuilder.java:775) at com.visiercorp.server.function.plugin.provided.AnalyticConceptBuilder.executeQueryOnShard(AnalyticConceptBuilder.java:1694) at com.visiercorp.server.function.plugin.provided.AnalyticConceptBuilder.processChunk(AnalyticConceptBuilder.java:1806) at com.visiercorp.server.model.FunctionEngine.processChunk(FunctionEngine.java:83) at com.visiercorp.server.processor.AbstractProcessor.processChunk(AbstractProcessor.java:604) at com.visiercorp.server.processor.AbstractProcessor.processChunkAsString(AbstractProcessor.java:626) at com.visiercorp.server.processor.ProcessorManagerImpl$ProcessorProxy.processChunkAsString(ProcessorManagerImpl.java:288) at com.visiercorp.server.rest.ApplicationService.executeFunction(ApplicationService.java:464) at sun.reflect.GeneratedMethodAccessor165.invoke(Unknown Source) at sun.reflect.DelegatingMethodAccessorImpl.invoke(Unknown Source) at java.lang.reflect.Method.invoke(Unknown Source) at org.jboss.resteasy.core.MethodInjectorImpl.invoke(MethodInjectorImpl.java:140) at org.jboss.resteasy.core.ResourceMethod.invokeOnTarget(ResourceMethod.java:255) at org.jboss.resteasy.core.ResourceMethod.invoke(ResourceMethod.java:220) at org.jboss.resteasy.core.ResourceMethod.invoke(ResourceMethod.java:209) at org.jboss.resteasy.core.SynchronousDispatcher.getResponse(SynchronousDispatcher.java:519) at org.jboss.resteasy.core.SynchronousDispatcher.invoke(SynchronousDispatcher.java:496) at org.jboss.resteasy.core.SynchronousDispatcher.invoke(SynchronousDispatcher.java:119) at org.jboss.resteasy.plugins.server.servlet.ServletContainerDispatcher.service(ServletContainerDispatcher.java:208) at org.jboss.resteasy.plugins.server.servlet.HttpServletDispatcher.service(HttpServletDispatcher.java:55) at org.jboss.resteasy.plugins.server.servlet.HttpServletDispatcher.service(HttpServletDispatcher.java:50) at javax.servlet.http.HttpServlet.service(HttpServlet.java:820) at org.eclipse.jetty.servlet.ServletHolder.handle(ServletHolder.java:538) at org.eclipse.jetty.servlet.ServletHandler$CachedChain.doFilter(ServletHandler.java:1352) at org.eclipse.jetty.servlets.UserAgentFilter.doFilter(UserAgentFilter.java:77) at org.eclipse.jetty.servlets.GzipFilter.doFilter(GzipFilter.java:170) at org.eclipse.jetty.servlet.ServletHandler$CachedChain.doFilter(ServletHandler.java:1323) at org.eclipse.jetty.servlet.ServletHandler.doHandle(ServletHandler.java:476) at org.eclipse.jetty.server.handler.ScopedHandler.handle(ScopedHandler.java:119) at org.eclipse.jetty.security.SecurityHandler.handle(SecurityHandler.java:480) at org.eclipse.jetty.server.session.SessionHandler.doHandle(SessionHandler.java:225) at org.eclipse.jetty.server.handler.ContextHandler.doHandle(ContextHandler.java:937) at org.eclipse.jetty.servlet.ServletHandler.doScope(ServletHandler.java:406) at org.eclipse.jetty.server.session.SessionHandler.doScope(SessionHandler.java:183) at org.eclipse.jetty.server.handler.ContextHandler.doScope(ContextHandler.java:871) at org.eclipse.jetty.server.handler.ScopedHandler.handle(ScopedHandler.java:117) at org.eclipse.jetty.server.handler.ContextHandlerCollection.handle(ContextHandlerCollection.java:247) at org.eclipse.jetty.server.handler.HandlerCollection.handle(HandlerCollection.java:149) at org.eclipse.jetty.server.handler.HandlerWrapper.handle(HandlerWrapper.java:110) at org.eclipse.jetty.server.Server.handle(Server.java:346) at org.eclipse.jetty.server.HttpConnection.handleRequest(HttpConnection.java:589) at org.eclipse.jetty.server.HttpConnection$RequestHandler.content(HttpConnection.java:1065) at org.eclipse.jetty.http.HttpParser.parseNext(HttpParser.java:823) at org.eclipse.jetty.http.HttpParser.parseAvailable(HttpParser.java:220) at org.eclipse.jetty.server.HttpConnection.handle(HttpConnection.java:411) at org.eclipse.jetty.io.nio.SelectChannelEndPoint.handle(SelectChannelEndPoint.java:535) at org.eclipse.jetty.io.nio.SelectChannelEndPoint$1.run(SelectChannelEndPoint.java:40) at org.eclipse.jetty.util.thread.QueuedThreadPool$3.run(QueuedThreadPool.java:529) at java.lang.Thread.run(Unknown Source) Caused by: com.visiercorp.server.base.VServerException: SQL fetch for [] with connection [WITH SET [AllGeographies] AS {IIF ([HRLocation].[West].[California].Children.Count = 0, [HRLocation].[West].[California], [HRLocation].[West].[California].Children)} SET [Org] AS {IIF ([HROrgStructure].[0].[43].Children.Count = 0, [HROrgStructure].[0].[43], [HROrgStructure].[0].[43].Children)} SET [OrgLocations] AS CROSSJOIN([AllGeographies], [Org]) SET [ChangeDateInRangeOffsetMinusOne_M] AS {[ChangeDate].[2010].[6].[30]} SET [EmployeeAllTerminationInRange_M] AS NONEMPTYCROSSJOIN([ChangeDateInRangeOffsetMinusOne_M], [EmployeeTerminationAll_M]) SET [EmployeeTerminationAll_M] AS {EXCEPT([HRTerminated].Levels(1).Members,[HRTerminated].[_No_])} MEMBER [Measures].[EmployeeAllTerminationInRangeCount] AS Aggregate([EmployeeAllTerminationInRange_M], [Measures].[EmployeeIDCount]) SELECT {[Measures].[EmployeeAllTerminationInRangeCount]} ON 0, {([HRLocation].[West].[California],[HROrgStructure].[0].[43]), [OrgLocations]} ON 1 FROM HREmployee_HROrgStructure_2010_6_30] was invalid. Detail: [Mondrian Error:java.util.concurrent.ExecutionException: mondrian.olap.MondrianException: Mondrian Error:Internal error: Error while executing query [with set [AllGeographies] as '{IIf(([HRLocation].[West].[California].Children.Count = 0), {[HRLocation].[West].[California]}, [HRLocation].[West].[California].Children)}' set [Org] as '{IIf(([HROrgStructure].[0].[43].Children.Count = 0), {[HROrgStructure].[0].[43]}, [HROrgStructure].[0].[43].Children)}' set [OrgLocations] as 'Crossjoin([AllGeographies], [Org])' set [ChangeDateInRangeOffsetMinusOne_M] as '{[ChangeDate].[2010].[6].[30]}' set [EmployeeAllTerminationInRange_M] as 'NonEmptyCrossJoin([ChangeDateInRangeOffsetMinusOne_M], [EmployeeTerminationAll_M])' set [EmployeeTerminationAll_M] as '{Except([HRTerminated].Levels(1).Members, {[HRTerminated].[_No_]})}' member [Measures].[EmployeeAllTerminationInRangeCount] as 'Aggregate([EmployeeAllTerminationInRange_M], [Measures].[EmployeeIDcount])' select {[Measures].[EmployeeAllTerminationInRangeCount]} ON COLUMNS, {([HRLocation].[West].[California], [HROrgStructure].[0].[43]), [OrgLocations]} ON ROWS from [HREmployee_HROrgStructure_2010_6_30] ]] at com.visiercorp.server.function.fetch.MdxDatabaseFetch.executeQuery(MdxDatabaseFetch.java:1352) at com.visiercorp.server.function.fetch.MdxDatabaseFetch.processAnalyticQuery(MdxDatabaseFetch.java:1302) ... 49 more Caused by: mondrian.olap.MondrianException: Mondrian Error:java.util.concurrent.ExecutionException: mondrian.olap.MondrianException: Mondrian Error:Internal error: Error while executing query [with set [AllGeographies] as '{IIf(([HRLocation].[West].[California].Children.Count = 0), {[HRLocation].[West].[California]}, [HRLocation].[West].[California].Children)}' set [Org] as '{IIf(([HROrgStructure].[0].[43].Children.Count = 0), {[HROrgStructure].[0].[43]}, [HROrgStructure].[0].[43].Children)}' set [OrgLocations] as 'Crossjoin([AllGeographies], [Org])' set [ChangeDateInRangeOffsetMinusOne_M] as '{[ChangeDate].[2010].[6].[30]}' set [EmployeeAllTerminationInRange_M] as 'NonEmptyCrossJoin([ChangeDateInRangeOffsetMinusOne_M], [EmployeeTerminationAll_M])' set [EmployeeTerminationAll_M] as '{Except([HRTerminated].Levels(1).Members, {[HRTerminated].[_No_]})}' member [Measures].[EmployeeAllTerminationInRangeCount] as 'Aggregate([EmployeeAllTerminationInRange_M], [Measures].[EmployeeIDcount])' select {[Measures].[EmployeeAllTerminationInRangeCount]} ON COLUMNS, {([HRLocation].[West].[California], [HROrgStructure].[0].[43]), [OrgLocations]} ON ROWS from [HREmployee_HROrgStructure_2010_6_30] ] at mondrian.rolap.RolapResultShepherd.shepherdExecution(RolapResultShepherd.java:158) at mondrian.rolap.RolapConnection.execute(RolapConnection.java:617) at mondrian.olap4j.MondrianOlap4jCellSet.execute(MondrianOlap4jCellSet.java:89) at mondrian.olap4j.MondrianOlap4jStatement.executeOlapQueryInternal(MondrianOlap4jStatement.java:409) at mondrian.olap4j.MondrianOlap4jStatement.executeOlapQuery(MondrianOlap4jStatement.java:341) at com.visiercorp.server.function.fetch.MdxDatabaseFetch.executeMdxQuery(MdxDatabaseFetch.java:912) at com.visiercorp.server.function.fetch.MdxDatabaseFetch.executeQuery(MdxDatabaseFetch.java:1342) ... 50 more Caused by: java.util.concurrent.ExecutionException: mondrian.olap.MondrianException: Mondrian Error:Internal error: Error while executing query [with set [AllGeographies] as '{IIf(([HRLocation].[West].[California].Children.Count = 0), {[HRLocation].[West].[California]}, [HRLocation].[West].[California].Children)}' set [Org] as '{IIf(([HROrgStructure].[0].[43].Children.Count = 0), {[HROrgStructure].[0].[43]}, [HROrgStructure].[0].[43].Children)}' set [OrgLocations] as 'Crossjoin([AllGeographies], [Org])' set [ChangeDateInRangeOffsetMinusOne_M] as '{[ChangeDate].[2010].[6].[30]}' set [EmployeeAllTerminationInRange_M] as 'NonEmptyCrossJoin([ChangeDateInRangeOffsetMinusOne_M], [EmployeeTerminationAll_M])' set [EmployeeTerminationAll_M] as '{Except([HRTerminated].Levels(1).Members, {[HRTerminated].[_No_]})}' member [Measures].[EmployeeAllTerminationInRangeCount] as 'Aggregate([EmployeeAllTerminationInRange_M], [Measures].[EmployeeIDcount])' select {[Measures].[EmployeeAllTerminationInRangeCount]} ON COLUMNS, {([HRLocation].[West].[California], [HROrgStructure].[0].[43]), [OrgLocations]} ON ROWS from [HREmployee_HROrgStructure_2010_6_30] ] at java.util.concurrent.FutureTask$Sync.innerGet(Unknown Source) at java.util.concurrent.FutureTask.get(Unknown Source) at mondrian.rolap.RolapResultShepherd.shepherdExecution(RolapResultShepherd.java:132) ... 56 more Caused by: mondrian.olap.MondrianException: Mondrian Error:Internal error: Error while executing query [with set [AllGeographies] as '{IIf(([HRLocation].[West].[California].Children.Count = 0), {[HRLocation].[West].[California]}, [HRLocation].[West].[California].Children)}' set [Org] as '{IIf(([HROrgStructure].[0].[43].Children.Count = 0), {[HROrgStructure].[0].[43]}, [HROrgStructure].[0].[43].Children)}' set [OrgLocations] as 'Crossjoin([AllGeographies], [Org])' set [ChangeDateInRangeOffsetMinusOne_M] as '{[ChangeDate].[2010].[6].[30]}' set [EmployeeAllTerminationInRange_M] as 'NonEmptyCrossJoin([ChangeDateInRangeOffsetMinusOne_M], [EmployeeTerminationAll_M])' set [EmployeeTerminationAll_M] as '{Except([HRTerminated].Levels(1).Members, {[HRTerminated].[_No_]})}' member [Measures].[EmployeeAllTerminationInRangeCount] as 'Aggregate([EmployeeAllTerminationInRange_M], [Measures].[EmployeeIDcount])' select {[Measures].[EmployeeAllTerminationInRangeCount]} ON COLUMNS, {([HRLocation].[West].[California], [HROrgStructure].[0].[43]), [OrgLocations]} ON ROWS from [HREmployee_HROrgStructure_2010_6_30] ] at mondrian.resource.MondrianResource$_Def0.ex(MondrianResource.java:912) at mondrian.olap.Util.newInternal(Util.java:2062) at mondrian.olap.Util.newError(Util.java:2078) at mondrian.rolap.RolapConnection.executeInternal(RolapConnection.java:702) at mondrian.rolap.RolapConnection.access$3(RolapConnection.java:626) at mondrian.rolap.RolapConnection$1.call(RolapConnection.java:621) at mondrian.rolap.RolapConnection$1.call(RolapConnection.java:1) at java.util.concurrent.FutureTask$Sync.innerRun(Unknown Source) at java.util.concurrent.FutureTask.run(Unknown Source) at java.util.concurrent.ThreadPoolExecutor.runWorker(Unknown Source) at java.util.concurrent.ThreadPoolExecutor$Worker.run(Unknown Source) ... 1 more Caused by: java.lang.ArrayIndexOutOfBoundsException: 3 at mondrian.rolap.agg.DenseObjectSegmentDataset.getObject(DenseObjectSegmentDataset.java:49) at mondrian.rolap.agg.Segment.getCellValue(Segment.java:368) at mondrian.rolap.agg.Aggregation.getCellValue(Aggregation.java:705) at mondrian.rolap.agg.AggregationManager.getCellFromCache(AggregationManager.java:133) at mondrian.rolap.FastBatchingCellReader.get(FastBatchingCellReader.java:97) at mondrian.rolap.RolapEvaluator.evaluateCurrent(RolapEvaluator.java:658) at mondrian.calc.impl.MemberValueCalc.evaluate(MemberValueCalc.java:101) at mondrian.olap.fun.FunUtil.evaluateSet(FunUtil.java:1536) at mondrian.olap.fun.FunUtil.sumDouble(FunUtil.java:1449) at mondrian.olap.fun.FunUtil.sum(FunUtil.java:1440) at mondrian.rolap.RolapAggregator$1.aggregate(RolapAggregator.java:36) at mondrian.olap.fun.AggregateFunDef$AggregateCalc.aggregate(AggregateFunDef.java:114) at mondrian.olap.fun.AggregateFunDef$AggregateCalc.evaluate(AggregateFunDef.java:75) at mondrian.rolap.RolapEvaluator.evaluateCurrent(RolapEvaluator.java:685) at mondrian.rolap.RolapResult.executeStripe(RolapResult.java:931) at mondrian.rolap.RolapResult.executeStripe(RolapResult.java:1071) at mondrian.rolap.RolapResult.executeStripe(RolapResult.java:1071) at mondrian.rolap.RolapResult.executeBody(RolapResult.java:820) at mondrian.rolap.RolapResult.<init>(RolapResult.java:445) at mondrian.rolap.RolapConnection.executeInternal(RolapConnection.java:668) ... 8 more

    Pentaho BI Platform Tracking | 5 years ago | Geoff Zenger
    java.util.concurrent.ExecutionException: mondrian.olap.MondrianException: Mondrian Error:Internal error: Error while executing query [with set [AllGeographies] as '{IIf(([HRLocation].[West].[California].Children.Count = 0), {[HRLocation].[West].[California]}, [HRLocation].[West].[California].Children)}' set [Org] as '{IIf(([HROrgStructure].[0].[43].Children.Count = 0), {[HROrgStructure].[0].[43]}, [HROrgStructure].[0].[43].Children)}' set [OrgLocations] as 'Crossjoin([AllGeographies], [Org])' set [ChangeDateInRangeOffsetMinusOne_M] as '{[ChangeDate].[2010].[6].[30]}' set [EmployeeAllTerminationInRange_M] as 'NonEmptyCrossJoin([ChangeDateInRangeOffsetMinusOne_M], [EmployeeTerminationAll_M])' set [EmployeeTerminationAll_M] as '{Except([HRTerminated].Levels(1).Members, {[HRTerminated].[_No_]})}' member [Measures].[EmployeeAllTerminationInRangeCount] as 'Aggregate([EmployeeAllTerminationInRange_M], [Measures].[EmployeeIDcount])' select {[Measures].[EmployeeAllTerminationInRangeCount]} ON COLUMNS, {([HRLocation].[West].[California], [HROrgStructure].[0].[43]), [OrgLocations]} ON ROWS from [HREmployee_HROrgStructure_2010_6_30] ]]
  3. 0

    powermock

    solutionscore.com | 1 year ago
    java.lang.IllegalStateException: Failed to transform class with name com.myProject.MyClassToBeTested. Reason: 3
  4. Speed up your debug routine!

    Automated exception search integrated into your IDE

  5. 0

    Technomancy crash

    GitHub | 2 years ago | Frontrider
    java.lang.ArrayIndexOutOfBoundsException: 3

    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. java.lang.ArrayIndexOutOfBoundsException

      3

      at mondrian.rolap.agg.DenseObjectSegmentDataset.getObject()
    2. mondrian.rolap.agg
      AggregationManager.getCellFromCache
      1. mondrian.rolap.agg.DenseObjectSegmentDataset.getObject(DenseObjectSegmentDataset.java:49)
      2. mondrian.rolap.agg.Segment.getCellValue(Segment.java:368)
      3. mondrian.rolap.agg.Aggregation.getCellValue(Aggregation.java:705)
      4. mondrian.rolap.agg.AggregationManager.getCellFromCache(AggregationManager.java:133)
      4 frames
    3. mondrian.rolap
      RolapEvaluator.evaluateCurrent
      1. mondrian.rolap.FastBatchingCellReader.get(FastBatchingCellReader.java:97)
      2. mondrian.rolap.RolapEvaluator.evaluateCurrent(RolapEvaluator.java:658)
      2 frames
    4. mondrian.calc.impl
      MemberValueCalc.evaluate
      1. mondrian.calc.impl.MemberValueCalc.evaluate(MemberValueCalc.java:101)
      1 frame
    5. mondrian.olap.fun
      FunUtil.sum
      1. mondrian.olap.fun.FunUtil.evaluateSet(FunUtil.java:1536)
      2. mondrian.olap.fun.FunUtil.sumDouble(FunUtil.java:1449)
      3. mondrian.olap.fun.FunUtil.sum(FunUtil.java:1440)
      3 frames
    6. mondrian.rolap
      RolapAggregator$1.aggregate
      1. mondrian.rolap.RolapAggregator$1.aggregate(RolapAggregator.java:36)
      1 frame
    7. mondrian.olap.fun
      AggregateFunDef$AggregateCalc.evaluate
      1. mondrian.olap.fun.AggregateFunDef$AggregateCalc.aggregate(AggregateFunDef.java:114)
      2. mondrian.olap.fun.AggregateFunDef$AggregateCalc.evaluate(AggregateFunDef.java:75)
      2 frames
    8. mondrian.rolap
      RolapConnection$1.call
      1. mondrian.rolap.RolapEvaluator.evaluateCurrent(RolapEvaluator.java:685)
      2. mondrian.rolap.RolapResult.executeStripe(RolapResult.java:931)
      3. mondrian.rolap.RolapResult.executeStripe(RolapResult.java:1071)
      4. mondrian.rolap.RolapResult.executeStripe(RolapResult.java:1071)
      5. mondrian.rolap.RolapResult.executeBody(RolapResult.java:820)
      6. mondrian.rolap.RolapResult.<init>(RolapResult.java:445)
      7. mondrian.rolap.RolapConnection.executeInternal(RolapConnection.java:668)
      8. mondrian.rolap.RolapConnection.access$3(RolapConnection.java:626)
      9. mondrian.rolap.RolapConnection$1.call(RolapConnection.java:621)
      10. mondrian.rolap.RolapConnection$1.call(RolapConnection.java:1)
      10 frames
    9. Java RT
      ThreadPoolExecutor$Worker.run
      1. java.util.concurrent.FutureTask$Sync.innerRun(Unknown Source)
      2. java.util.concurrent.FutureTask.run(Unknown Source)
      3. java.util.concurrent.ThreadPoolExecutor.runWorker(Unknown Source)
      4. java.util.concurrent.ThreadPoolExecutor$Worker.run(Unknown Source)
      4 frames
    10. com.visiercorp.server
      MdxDatabaseFetch.processAnalyticQuery
      1. com.visiercorp.server.function.fetch.MdxDatabaseFetch.processAnalyticQuery(MdxDatabaseFetch.java:1302)
      1 frame