[Mondrian] ArrayIndexOutOfBoundsException:
Joshua Diamond
diamond.joshh at gmail.com
Fri May 22 17:01:04 EDT 2015
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
c: (561)676-3275
-------------- next part --------------
An HTML attachment was scrubbed...
URL: http://lists.pentaho.org/pipermail/mondrian/attachments/20150522/e9a57fae/attachment-0001.html
More information about the Mondrian
mailing list