[Mondrian] Conflicts between MDX Queries

Matt Campbell mcampbell at pentaho.com
Fri Jun 7 15:11:48 EDT 2013


It certainly sounds like a bug.

I'd probably take a divide-and-conquer approach to try to better understand the error.  I.e. try to narrow down exactly which query or queries are causing the problematic one to fail.

When you say it will run successfully on a dashboard where it's the only query-- do you need to clear the Mondrian cache before it succeeds?  Or will you see it fail if you run the 17 query dashboard first and then the 1 query dashboard immediately after?



-----Original Message-----
From: mondrian-bounces at pentaho.org [mailto:mondrian-bounces at pentaho.org] On Behalf Of Kleyson Rios
Sent: Friday, June 07, 2013 2:36 PM
To: Mondrian developer mailing list
Subject: [Mondrian] Conflicts between MDX Queries

I have a panel with 17 MDX queries.

When I run the panel, a specific MDX query fails.

But if I take that specifies MDX query and put it alone in a new dashboard I can run the dashboard with no problem.

I was talking to Peter Vale from webdetails, and he said probably another MDX query cache is being used, but for some reason, is incompatible.

I enabled the mondrian logs, but i didn't found any clue about the problem.

We tried set that specific query to be the first one in the run list, so, I can run my dashboard with no error if that query it is executed first.

What can I do to figure out the problem?

Thanks in advance.

Kleyson Rios.

14:54:09,005 ERROR [CdaContentGenerator] doQuery: Failed to create datasource:Mondrian Error:Internal error: Error while executing query [with set [Periodo Semanas] as '{([Semana.Semanas].[1] : 
[Semana.Semanas].[19])}'
member [Measures].[Casos Parciais] as 'Sum({[Periodo Semanas]}, [Measures].[Casos])'
select NON EMPTY {[Measures].[Casos], [Measures].[Casos Parciais]} ON COLUMNS, NON EMPTY {[Ano.Anos].Children} ON ROWS from [Casos] ]
pt.webdetails.cda.dataaccess.QueryException: Failed to create datasource:Mondrian Error:Internal error: Error while executing query [with set [Periodo Semanas] as '{([Semana.Semanas].[1] : 
[Semana.Semanas].[19])}'
member [Measures].[Casos Parciais] as 'Sum({[Periodo Semanas]}, [Measures].[Casos])'
select NON EMPTY {[Measures].[Casos], [Measures].[Casos Parciais]} ON COLUMNS, NON EMPTY {[Ano.Anos].Children} ON ROWS from [Casos] ] at
pt.webdetails.cda.dataaccess.PREDataAccess.performRawQuery(PREDataAccess.java:180)
at
pt.webdetails.cda.dataaccess.MdxDataAccess.performRawQuery(MdxDataAccess.java:406)
at
pt.webdetails.cda.dataaccess.SimpleDataAccess.queryDataSource(SimpleDataAccess.java:123)
at
pt.webdetails.cda.dataaccess.AbstractDataAccess.doQuery(AbstractDataAccess.java:268)
at pt.webdetails.cda.CdaEngine.doQuery(CdaEngine.java:74)
at
pt.webdetails.cda.CdaContentGenerator.doQuery(CdaContentGenerator.java:163)
at sun.reflect.GeneratedMethodAccessor180.invoke(Unknown Source) at
sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:25)
at java.lang.reflect.Method.invoke(Method.java:597)
at
pt.webdetails.cpf.SimpleContentGenerator.invokeMethod(SimpleContentGenerator.java:324)
at
pt.webdetails.cpf.SimpleContentGenerator.createContent(SimpleContentGenerator.java:157)
at
org.pentaho.platform.web.servlet.GenericServlet.doGet(GenericServlet.java:261)
at
org.pentaho.platform.web.servlet.GenericServlet.doPost(GenericServlet.java:80)
at javax.servlet.http.HttpServlet.service(HttpServlet.java:637)
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.pentaho.platform.web.http.filters.PentahoWebContextFilter.doFilter(PentahoWebContextFilter.java:142)
at
org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:235)
at
org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:206)
at
org.pentaho.platform.web.http.filters.PentahoRequestContextFilter.doFilter(PentahoRequestContextFilter.java:84)
at
org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:235)
at
org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:206)
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:103)
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:235)
at
org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:206)
at
org.pentaho.platform.web.http.filters.SystemStatusFilter.doFilter(SystemStatusFilter.java:60)
at
org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:235)
at
org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:206)
at
org.pentaho.platform.web.http.filters.SetCharacterEncodingFilter.doFilter(SetCharacterEncodingFilter.java:113)
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.authenticator.AuthenticatorBase.invoke(AuthenticatorBase.java:470)
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.Http11AprProcessor.process(Http11AprProcessor.java:861)
at
org.apache.coyote.http11.Http11AprProtocol$Http11ConnectionHandler.process(Http11AprProtocol.java:579)
at org.apache.tomcat.util.net.AprEndpoint$Worker.run(AprEndpoint.java:1584)
at java.lang.Thread.run(Thread.java:662)
Caused by: 
org.pentaho.reporting.engine.classic.core.ReportDataFactoryException:
Failed to create datasource:Mondrian Error:Internal error: Error while executing query [with set [Periodo Semanas] as '{([Semana.Semanas].[1] : 
[Semana.Semanas].[19])}'
member [Measures].[Casos Parciais] as 'Sum({[Periodo Semanas]}, [Measures].[Casos])'
select NON EMPTY {[Measures].[Casos], [Measures].[Casos Parciais]} ON COLUMNS, NON EMPTY {[Ano.Anos].Children} ON ROWS from [Casos] ] at
org.pentaho.reporting.engine.classic.extensions.datasources.mondrian.AbstractMDXDataFactory.performQuery(AbstractMDXDataFactory.java:587)
at
org.pentaho.reporting.engine.classic.extensions.datasources.mondrian.AbstractNamedMDXDataFactory.performQuery(AbstractNamedMDXDataFactory.java:145)
at
pt.webdetails.cda.utils.mondrian.CompactBandedMDXDataFactory.queryData(CompactBandedMDXDataFactory.java:56)
at
org.pentaho.reporting.engine.classic.core.CompoundDataFactory.queryFreeForm(CompoundDataFactory.java:114)
at
org.pentaho.reporting.engine.classic.core.CompoundDataFactory.queryData(CompoundDataFactory.java:90)
at
org.pentaho.reporting.engine.classic.core.cache.CachingDataFactory.queryInternal(CachingDataFactory.java:434)
at
org.pentaho.reporting.engine.classic.core.cache.CachingDataFactory.queryData(CachingDataFactory.java:326)
at
pt.webdetails.cda.dataaccess.PREDataAccess.performRawQuery(PREDataAccess.java:154)
... 74 more

--
Kleyson Rios
Gestor de TI
Coordenador de BI / Banco de Dados
Gerência de Tecnologia da Informação
Secretaria de Estado da Saúde de Goiás
(62) 3201-3707

Se não pode vencer pelo talento, vença pelo esforço. (Dave Weinbaum)

_______________________________________________
Mondrian mailing list
Mondrian at pentaho.org
http://lists.pentaho.org/mailman/listinfo/mondrian


More information about the Mondrian mailing list