[Mondrian] ArrayIndexOutOfBoundsException:

Julian Hyde julianhyde at gmail.com
Fri May 22 17:28:51 EDT 2015


Check for trailing spaces on the ends of member names. Or a level that you have declared as a numeric that is really some different type. Look for a level that has fewer than 6 members.

> On May 22, 2015, at 2:01 PM, Joshua Diamond <diamond.joshh at gmail.com> wrote:
> 
> 
> Hi, 
> 
> I'm getting an ArrayIndexOutOfBoundsException: 5 errors with one of my schemas. I've tried out a few different versions of mondrian but that doesn't appear to do anything. Does anyone have any idea what might be causing this?
>  
> I'm using saiku 2.6 standalone with mondrian 3.6.9, I tried mondrian 3.9.0.X and mondrian 3.8.0.X. Can this possibly be a schema def problem? I'll post my schema if necessary.
> 
> From the saiku users email list It was suggested that it was a bug with the aggregate reader but I do not have any aggregate tables for this schema. 
> 
> I'm really at a loss for debugging this problem. Any help is much appreciated.
> 
> Thanks!
> 
> Josh
> 
> mdx: 
> WITH
> SET [~FILTER] AS
>     {[CycleDim.CycleHier].[General].[2010 General]}
> SET [~COLUMNS_OfficeDim.OfficeHier] AS
>     {[OfficeDim.OfficeHier].[U.S. President], [OfficeDim.OfficeHier].[U.S. Senate]}
> SET [~COLUMNS_PartyDim.PartyHier] AS
>     {[PartyDim.PartyHier].[Party].Members}
> SET [~COLUMNS_Measures] AS
>     {[Measures].[VotesDisplay], [Measures].[Percentage]}
> SET [~ROWS] AS
>     {[GeoDim.GeoHier].[Illinois]}
> SELECT
> NON EMPTY ([~COLUMNS_OfficeDim.OfficeHier]  *  [~COLUMNS_PartyDim.PartyHier]  *  [~COLUMNS_Measures]) ON COLUMNS,
> NON EMPTY [~ROWS] ON ROWS
> FROM [ElectionResults]
> WHERE [~FILTER]
> 
> saiku.log: 
> 
> 2015-05-22 15:06:43,667 ERROR [org.saiku.web.rest.resources.QueryResource] Cannot execute query (C0D1901C-6690-0F46-B8CA-54757C07B15C)
> org.saiku.service.util.exception.SaikuServiceException: runId:9	Can't execute query: C0D1901C-6690-0F46-B8CA-54757C07B15C
> 	at org.saiku.service.olap.OlapQueryService.execute(OlapQueryService.java:307)
> 	at org.saiku.service.olap.OlapQueryService.execute(OlapQueryService.java:225)
> 	at org.saiku.web.rest.resources.QueryResource.execute(QueryResource.java:780)
> 	at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method)
> 	at sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:57)
> 	at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:43)
> 	at java.lang.reflect.Method.invoke(Method.java:606)
> 	at com.sun.jersey.spi.container.JavaMethodInvokerFactory$1.invoke(JavaMethodInvokerFactory.java:60)
> 	at com.sun.jersey.server.impl.model.method.dispatch.AbstractResourceMethodDispatchProvider$TypeOutInvoker._dispatch(AbstractResourceMethodDispatchProvider.java:185)
> 	at com.sun.jersey.server.impl.model.method.dispatch.ResourceJavaMethodDispatcher.dispatch(ResourceJavaMethodDispatcher.java:75)
> 	at com.sun.jersey.server.impl.uri.rules.HttpMethodRule.accept(HttpMethodRule.java:288)
> 	at com.sun.jersey.server.impl.uri.rules.RightHandPathRule.accept(RightHandPathRule.java:147)
> 	at com.sun.jersey.server.impl.uri.rules.ResourceClassRule.accept(ResourceClassRule.java:108)
> 	at com.sun.jersey.server.impl.uri.rules.RightHandPathRule.accept(RightHandPathRule.java:147)
> 	at com.sun.jersey.server.impl.uri.rules.RootResourceClassesRule.accept(RootResourceClassesRule.java:84)
> 	at com.sun.jersey.server.impl.application.WebApplicationImpl._handleRequest(WebApplicationImpl.java:1469)
> 	at com.sun.jersey.server.impl.application.WebApplicationImpl._handleRequest(WebApplicationImpl.java:1400)
> 	at com.sun.jersey.server.impl.application.WebApplicationImpl.handleRequest(WebApplicationImpl.java:1349)
> 	at com.sun.jersey.server.impl.application.WebApplicationImpl.handleRequest(WebApplicationImpl.java:1339)
> 	at com.sun.jersey.spi.container.servlet.WebComponent.service(WebComponent.java:416)
> 	at com.sun.jersey.spi.container.servlet.ServletContainer.service(ServletContainer.java:537)
> 	at org.codehaus.enunciate.modules.jersey.EnunciateJerseyServletContainer.service(EnunciateJerseyServletContainer.java:250)
> 	at javax.servlet.http.HttpServlet.service(HttpServlet.java:717)
> 	at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:290)
> 	at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:206)
> 	at org.codehaus.enunciate.webapp.HTTPRequestContextFilter.doFilter(HTTPRequestContextFilter.java:36)
> 	at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:235)
> 	at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:206)
> 	at org.springframework.security.web.FilterChainProxy$VirtualFilterChain.doFilter(FilterChainProxy.java:343)
> 	at org.springframework.security.web.access.intercept.FilterSecurityInterceptor.invoke(FilterSecurityInterceptor.java:109)
> 	at org.springframework.security.web.access.intercept.FilterSecurityInterceptor.doFilter(FilterSecurityInterceptor.java:83)
> 	at org.springframework.security.web.FilterChainProxy$VirtualFilterChain.doFilter(FilterChainProxy.java:355)
> 	at org.springframework.security.web.access.ExceptionTranslationFilter.doFilter(ExceptionTranslationFilter.java:97)
> 	at org.springframework.security.web.FilterChainProxy$VirtualFilterChain.doFilter(FilterChainProxy.java:355)
> 	at org.springframework.security.web.session.SessionManagementFilter.doFilter(SessionManagementFilter.java:100)
> 	at org.springframework.security.web.FilterChainProxy$VirtualFilterChain.doFilter(FilterChainProxy.java:355)
> 	at org.springframework.security.web.authentication.AnonymousAuthenticationFilter.doFilter(AnonymousAuthenticationFilter.java:78)
> 	at org.springframework.security.web.FilterChainProxy$VirtualFilterChain.doFilter(FilterChainProxy.java:355)
> 	at org.springframework.security.web.servletapi.SecurityContextHolderAwareRequestFilter.doFilter(SecurityContextHolderAwareRequestFilter.java:54)
> 	at org.springframework.security.web.FilterChainProxy$VirtualFilterChain.doFilter(FilterChainProxy.java:355)
> 	at org.springframework.security.web.savedrequest.RequestCacheAwareFilter.doFilter(RequestCacheAwareFilter.java:35)
> 	at org.springframework.security.web.FilterChainProxy$VirtualFilterChain.doFilter(FilterChainProxy.java:355)
> 	at org.springframework.security.web.authentication.www.BasicAuthenticationFilter.doFilter(BasicAuthenticationFilter.java:177)
> 	at org.springframework.security.web.FilterChainProxy$VirtualFilterChain.doFilter(FilterChainProxy.java:355)
> 	at org.springframework.security.web.authentication.ui.DefaultLoginPageGeneratingFilter.doFilter(DefaultLoginPageGeneratingFilter.java:91)
> 	at org.springframework.security.web.FilterChainProxy$VirtualFilterChain.doFilter(FilterChainProxy.java:355)
> 	at org.springframework.security.web.authentication.AbstractAuthenticationProcessingFilter.doFilter(AbstractAuthenticationProcessingFilter.java:187)
> 	at org.springframework.security.web.FilterChainProxy$VirtualFilterChain.doFilter(FilterChainProxy.java:355)
> 	at org.springframework.security.web.authentication.logout.LogoutFilter.doFilter(LogoutFilter.java:105)
> 	at org.springframework.security.web.FilterChainProxy$VirtualFilterChain.doFilter(FilterChainProxy.java:355)
> 	at org.springframework.security.web.context.SecurityContextPersistenceFilter.doFilter(SecurityContextPersistenceFilter.java:79)
> 	at org.springframework.security.web.FilterChainProxy$VirtualFilterChain.doFilter(FilterChainProxy.java:355)
> 	at org.springframework.security.web.FilterChainProxy.doFilter(FilterChainProxy.java:149)
> 	at org.springframework.web.filter.DelegatingFilterProxy.invokeDelegate(DelegatingFilterProxy.java:237)
> 	at org.springframework.web.filter.DelegatingFilterProxy.doFilter(DelegatingFilterProxy.java:167)
> 	at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:235)
> 	at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:206)
> 	at org.apache.catalina.core.StandardWrapperValve.invoke(StandardWrapperValve.java:233)
> 	at org.apache.catalina.core.StandardContextValve.invoke(StandardContextValve.java:191)
> 	at org.apache.catalina.core.StandardHostValve.invoke(StandardHostValve.java:127)
> 	at org.apache.catalina.valves.ErrorReportValve.invoke(ErrorReportValve.java:102)
> 	at org.apache.catalina.core.StandardEngineValve.invoke(StandardEngineValve.java:109)
> 	at org.apache.catalina.connector.CoyoteAdapter.service(CoyoteAdapter.java:298)
> 	at org.apache.coyote.http11.Http11Processor.process(Http11Processor.java:852)
> 	at org.apache.coyote.http11.Http11Protocol$Http11ConnectionHandler.process(Http11Protocol.java:588)
> 	at org.apache.tomcat.util.net.JIoEndpoint$Worker.run(JIoEndpoint.java:489)
> 	at java.lang.Thread.run(Thread.java:745)
> Caused by: org.olap4j.OlapException: mondrian gave exception while executing query
> 	at mondrian.olap4j.MondrianOlap4jConnection$Helper.createException(MondrianOlap4jConnection.java:843)
> 	at mondrian.olap4j.MondrianOlap4jStatement.executeOlapQueryInternal(MondrianOlap4jStatement.java:423)
> 	at mondrian.olap4j.MondrianOlap4jStatement.executeOlapQuery(MondrianOlap4jStatement.java:347)
> 	at org.saiku.olap.query.OlapQuery.execute(OlapQuery.java:293)
> 	at org.saiku.service.olap.OlapQueryService.execute(OlapQueryService.java:251)
> 	... 66 more
> Caused by: mondrian.olap.MondrianException: Mondrian Error:Internal error: Error while executing query [with set [~FILTER] as '{[CycleDim.CycleHier].[General].[2010 General]}'
>   set [~COLUMNS_OfficeDim.OfficeHier] as '{[OfficeDim.OfficeHier].[U.S. President], [OfficeDim.OfficeHier].[U.S. Senate]}'
>   set [~COLUMNS_PartyDim.PartyHier] as '{[PartyDim.PartyHier].[Party].Members}'
>   set [~COLUMNS_Measures] as '{[Measures].[VotesDisplay], [Measures].[Percentage]}'
>   set [~ROWS] as '{[GeoDim.GeoHier].[Illinois]}'
> select NON EMPTY (([~COLUMNS_OfficeDim.OfficeHier] * [~COLUMNS_PartyDim.PartyHier]) * [~COLUMNS_Measures]) ON COLUMNS,
>   NON EMPTY [~ROWS] ON ROWS
> from [ElectionResults]
> where [~FILTER]
> ]
> 	at mondrian.resource.MondrianResource$_Def0.ex(MondrianResource.java:977)
> 	at mondrian.olap.Util.newInternal(Util.java:2404)
> 	at mondrian.olap.Util.newError(Util.java:2420)
> 	at mondrian.rolap.RolapConnection.executeInternal(RolapConnection.java:706)
> 	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:621)
> 	at java.util.concurrent.FutureTask.run(FutureTask.java:262)
> 	at java.util.concurrent.ThreadPoolExecutor.runWorker(ThreadPoolExecutor.java:1145)
> 	at java.util.concurrent.ThreadPoolExecutor$Worker.run(ThreadPoolExecutor.java:615)
> 	... 1 more
> Caused by: java.lang.ArrayIndexOutOfBoundsException: 5
> 	at mondrian.rolap.agg.SegmentBuilder.rollup(SegmentBuilder.java:206)
> 	at mondrian.rolap.FastBatchingCellReader.loadAggregations(FastBatchingCellReader.java:306)
> 	at mondrian.rolap.RolapResult.phase(RolapResult.java:563)
> 	at mondrian.rolap.RolapResult.executeBody(RolapResult.java:923)
> 	at mondrian.rolap.RolapResult.<init>(RolapResult.java:469)
> 	at mondrian.rolap.RolapConnection.executeInternal(RolapConnection.java:671)
> 	... 7 more
> -- 
> Joshua Diamond
> e: Diamond.JoshH at gmail.com <mailto:Diamond.JoshH at gmail.com>
> c: (561)676-3275
> 
> _______________________________________________
> Mondrian mailing list
> Mondrian at pentaho.org
> http://lists.pentaho.org/mailman/listinfo/mondrian

-------------- next part --------------
An HTML attachment was scrubbed...
URL: http://lists.pentaho.org/pipermail/mondrian/attachments/20150522/597e46dd/attachment-0001.html 


More information about the Mondrian mailing list