mondrian.olap.MondrianException: Mondrian Error:Failed to parse query ' select NON EMPTY {[Measures].[COUNT of NL_ALL_SUBSCRIPTIONS.I_TOPIC_ID]} ON columns, NON EMPTY {([ZEIT.ZEIT].[ALL ZEIT], [THEMA.THEMA].[ALL THEMA])} ON rows from [NL_ALL] '

Searched on Google with the first line of a JAVA stack trace?

We can recommend more relevant solutions and speed up debugging when you paste your entire stack trace with the exception message. Try a sample exception.

Recommended solutions based on your search

Samebug tips

Do you know how to solve this issue? Write a tip to help other users and build your expert profile.

Solutions on the web

via Pentaho BI Platform Tracking by Klaus Mende, 1 year ago
Mondrian Error:Failed to parse query ' select NON EMPTY {[Measures].[COUNT of NL_ALL_SUBSCRIPTIONS.I_TOPIC_ID]} ON columns, NON EMPTY {([ZEIT.ZEIT].[ALL ZEIT], [THEMA.THEMA].[ALL THEMA])} ON rows from [NL_ALL] '
via Pentaho BI Platform Tracking by Klaus Mende, 1 year ago
Mondrian Error:Failed to parse query ' select NON EMPTY {[Measures].[COUNT of NL_ALL_SUBSCRIPTIONS.I_TOPIC_ID]} ON columns, NON EMPTY {([ZEIT.ZEIT].[ALL ZEIT], [THEMA.THEMA].[ALL THEMA])} ON rows from [NL_ALL] '
via Pentaho BI Platform Tracking by Bill Seyler, 1 year ago
COLUMNS, NON EMPTY Crossjoin({ [Region].[All Regions] }, Crossjoin({ [Department].[All Departments] }, { [Positions].[All Positions] } ) ) ON ROWS from [Quadrant Analysis] '
via Pentaho BI Platform Tracking by Bill Seyler, 1 year ago
COLUMNS, NON EMPTY Crossjoin({ [Region].[All Regions] }, Crossjoin({ [Department].[All Departments] }, { [Positions].[All Positions] } ) ) ON ROWS from [Quadrant Analysis] '
via Pentaho BI Platform Tracking by Dr. Arndt Schoenberg, 1 year ago
Mondrian Error:Failed to parse query ' select NON EMPTY {[Measures].[TPost], [Measures].[km], [Measures].[amountTours], [Measures].[RUELPercIst]} ON COLUMNS, NON EMPTY Crossjoin({[Zeit_Dim.Kalender].[Alle].[2008]}, Crossjoin({[Orga
via Pentaho BI Platform Tracking by Dr. Arndt Schoenberg, 11 months ago
Mondrian Error:Failed to parse query ' select NON EMPTY {[Measures].[TPost], [Measures].[km], [Measures].[amountTours], [Measures].[RUELPercIst]} ON COLUMNS, NON EMPTY Crossjoin({[Zeit_Dim.Kalender].[Alle].[2008]}, Crossjoin({[Orga
mondrian.olap.MondrianException: Mondrian Error:Failed to parse query ' select NON EMPTY {[Measures].[COUNT of NL_ALL_SUBSCRIPTIONS.I_TOPIC_ID]} ON columns, NON EMPTY {([ZEIT.ZEIT].[ALL ZEIT], [THEMA.THEMA].[ALL THEMA])} ON rows from [NL_ALL] '
at com.ibm.db2.jcc.b.hh.c(hh.java:1662)
at com.ibm.db2.jcc.b.hh.d(hh.java:1650)
at com.ibm.db2.jcc.b.hh.a(hh.java:1219)
at com.ibm.db2.jcc.c.db.g(db.java:139)
at com.ibm.db2.jcc.c.db.a(db.java:39)
at com.ibm.db2.jcc.c.t.a(t.java:34)
at com.ibm.db2.jcc.c.sb.f(sb.java:142)
at com.ibm.db2.jcc.b.hh.n(hh.java:1190)
at com.ibm.db2.jcc.b.hh.a(hh.java:1902)
at com.ibm.db2.jcc.b.hh.a(hh.java:491)
at com.ibm.db2.jcc.b.hh.executeQuery(hh.java:475)
at mondrian.rolap.SqlStatement.execute(SqlStatement.java:124)
at mondrian.rolap.RolapUtil.executeQuery(RolapUtil.java:285)
at mondrian.rolap.RolapUtil.executeQuery(RolapUtil.java:246)
at mondrian.rolap.SqlMemberSource.getMemberChildren2(SqlMemberSource.java:711)
at mondrian.rolap.SqlMemberSource.getMemberChildren(SqlMemberSource.java:641)
at mondrian.rolap.SqlMemberSource.getMemberChildren(SqlMemberSource.java:616)
at mondrian.rolap.SmartMemberReader.readMemberChildren(SmartMemberReader.java:280)
at mondrian.rolap.SmartMemberReader.getMemberChildren(SmartMemberReader.java:245)
at mondrian.rolap.SmartMemberReader.getMemberChildren(SmartMemberReader.java:212)
at mondrian.rolap.RolapSchemaReader.internalGetMemberChildren(RolapSchemaReader.java:151)
at mondrian.rolap.RolapSchemaReader.lookupMemberChildByName(RolapSchemaReader.java:322)
at mondrian.olap.Util.lookupHierarchyRootMember(Util.java:916)
at mondrian.olap.HierarchyBase.lookupChild(HierarchyBase.java:121)
at mondrian.olap.DimensionBase.lookupChild(DimensionBase.java:102)
at mondrian.olap.CubeBase.lookupChild(CubeBase.java:115)
at mondrian.rolap.RolapCube.lookupChild(RolapCube.java:2221)
at mondrian.rolap.RolapSchemaReader.getElementChild(RolapSchemaReader.java:254)
at mondrian.olap.Util.lookupCompound(Util.java:576)
at mondrian.rolap.RolapSchemaReader.lookupCompound(RolapSchemaReader.java:303)
at mondrian.olap.DelegatingSchemaReader.lookupCompound(DelegatingSchemaReader.java:105)
at mondrian.olap.Query$QuerySchemaReader.lookupCompound(Query.java:1542)
at mondrian.olap.Query$QuerySchemaReader.lookupCompound(Query.java:1509)
at mondrian.olap.Util.lookup(Util.java:733)
at mondrian.olap.Id.accept(Id.java:111)
at mondrian.olap.Query$StackValidator.validate(Query.java:1208)
at mondrian.olap.fun.FunUtil.resolveFunArgs(FunUtil.java:1751)
at mondrian.mdx.UnresolvedFunCall.accept(UnresolvedFunCall.java:91)
at mondrian.olap.Query$StackValidator.validate(Query.java:1208)
at mondrian.olap.fun.FunUtil.resolveFunArgs(FunUtil.java:1751)
at mondrian.mdx.UnresolvedFunCall.accept(UnresolvedFunCall.java:91)
at mondrian.olap.Query$StackValidator.validate(Query.java:1208)
at mondrian.olap.QueryAxis.resolve(QueryAxis.java:201)
at mondrian.olap.Query$StackValidator.validate(Query.java:1268)
at mondrian.olap.Query.resolve(Query.java:570)
at mondrian.olap.Query.resolve(Query.java:425)
at mondrian.olap.Query.(Query.java:220)
at mondrian.olap.Query.(Query.java:180)
at mondrian.olap.Parser.makeQuery(Parser.java:846)
at mondrian.olap.CUP$Parser$actions.CUP$Parser$do_action(Parser.java:1679)
at mondrian.olap.Parser.do_action(Parser.java:680)
at java_cup.runtime.lr_parser.parse(lr_parser.java:569)
at mondrian.olap.Parser.parseInternal(Parser.java:750)
at mondrian.olap.ConnectionBase.parseQuery(ConnectionBase.java:74)
at mondrian.olap.ConnectionBase.parseQuery(ConnectionBase.java:59)
at com.tonbeller.jpivot.mondrian.MondrianModel.parseMDX(MondrianModel.java:528)
at com.tonbeller.jpivot.mondrian.MondrianModel.initialize(MondrianModel.java:495)
at com.tonbeller.jpivot.olap.model.OlapModelDecorator.initialize(OlapModelDecorator.java:132)
at com.tonbeller.jpivot.tags.OlapModelProxy$MyState.initialize(OlapModelProxy.java:77)
at com.tonbeller.jpivot.tags.StackStateManager.initializeAndShow(StackStateManager.java:76)
at com.tonbeller.jpivot.tags.OlapModelProxy.initializeAndShow(OlapModelProxy.java:160)
at com.tonbeller.jpivot.tags.OlapModelTag.doEndTag(OlapModelTag.java:81)
at org.apache.jsp.jsp.Pivot_jsp._jspService(Pivot_jsp.java:789)
at javax.servlet.http.HttpServlet.service(HttpServlet.java:803)
at org.apache.jasper.servlet.JspServletWrapper.service(JspServletWrapper.java:387)
at org.apache.jasper.servlet.JspServlet.serviceJspFile(JspServlet.java:320)
at javax.servlet.http.HttpServlet.service(HttpServlet.java:803)
at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:290)
at org.acegisecurity.util.FilterChainProxy$VirtualFilterChain.doFilter(FilterChainProxy.java:264)
at org.acegisecurity.intercept.web.FilterSecurityInterceptor.invoke(FilterSecurityInterceptor.java:107)
at org.acegisecurity.intercept.web.FilterSecurityInterceptor.doFilter(FilterSecurityInterceptor.java:72)
at org.acegisecurity.util.FilterChainProxy$VirtualFilterChain.doFilter(FilterChainProxy.java:274)
at org.acegisecurity.ui.ExceptionTranslationFilter.doFilter(ExceptionTranslationFilter.java:110)
at org.acegisecurity.util.FilterChainProxy$VirtualFilterChain.doFilter(FilterChainProxy.java:274)
at org.acegisecurity.ui.switchuser.SwitchUserProcessingFilter.doFilter(SwitchUserProcessingFilter.java:335)
at com.pentaho.security.SecurityStartupFilter.doFilter(SecurityStartupFilter.java:76)
at org.acegisecurity.util.FilterChainProxy$VirtualFilterChain.doFilter(FilterChainProxy.java:274)
at org.acegisecurity.providers.anonymous.AnonymousProcessingFilter.doFilter(AnonymousProcessingFilter.java:125)
at org.acegisecurity.util.FilterChainProxy$VirtualFilterChain.doFilter(FilterChainProxy.java:274)
at org.acegisecurity.ui.rememberme.RememberMeProcessingFilter.doFilter(RememberMeProcessingFilter.java:142)
at com.pentaho.security.RequestParameterAuthenticationFilter.doFilter(RequestParameterAuthenticationFilter.java:164)
at org.acegisecurity.util.FilterChainProxy$VirtualFilterChain.doFilter(FilterChainProxy.java:274)
at org.acegisecurity.ui.basicauth.BasicProcessingFilter.doFilter(BasicProcessingFilter.java:178)
at org.acegisecurity.util.FilterChainProxy$VirtualFilterChain.doFilter(FilterChainProxy.java:274)
at org.acegisecurity.ui.AbstractProcessingFilter.doFilter(AbstractProcessingFilter.java:217)
at org.acegisecurity.util.FilterChainProxy$VirtualFilterChain.doFilter(FilterChainProxy.java:274)
at org.acegisecurity.ui.logout.LogoutFilter.doFilter(LogoutFilter.java:108)
at com.pentaho.security.HttpSessionReuseDetectionFilter.doFilter(HttpSessionReuseDetectionFilter.java:130)
at org.acegisecurity.util.FilterChainProxy$VirtualFilterChain.doFilter(FilterChainProxy.java:274)
at org.acegisecurity.context.HttpSessionContextIntegrationFilter.doFilter(HttpSessionContextIntegrationFilter.java:193)
at org.acegisecurity.util.FilterChainProxy$VirtualFilterChain.doFilter(FilterChainProxy.java:274)
at org.acegisecurity.wrapper.SecurityContextHolderAwareRequestFilter.doFilter(SecurityContextHolderAwareRequestFilter.java:81)
at org.acegisecurity.util.FilterChainProxy$VirtualFilterChain.doFilter(FilterChainProxy.java:274)
at org.acegisecurity.util.FilterChainProxy.doFilter(FilterChainProxy.java:148)
at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:235)
at com.tonbeller.wcf.controller.RequestFilter$MyHandler.normalRequest(RequestFilter.java:139)
at com.tonbeller.wcf.controller.RequestSynchronizer.handleRequest(RequestSynchronizer.java:127)
at com.tonbeller.wcf.controller.RequestFilter.doFilter(RequestFilter.java:263)
at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:235)
at org.pentaho.core.system.SystemStatusFilter.doFilter(SystemStatusFilter.java:53)
at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:235)
at org.pentaho.ui.servlet.SetCharacterEncodingFilter.doFilter(SetCharacterEncodingFilter.java:112)
at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:235)
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:230)
at org.apache.catalina.core.StandardContextValve.invoke(StandardContextValve.java:175)
at org.apache.catalina.core.StandardHostValve.invoke(StandardHostValve.java:128)
at org.apache.catalina.core.StandardEngineValve.invoke(StandardEngineValve.java:109)
at org.apache.coyote.http11.Http11Processor.process(Http11Processor.java:844)
at org.apache.coyote.http11.Http11Protocol$Http11ConnectionHandler.process(Http11Protocol.java:580)
at java.lang.Thread.run(Unknown Source)

Users with the same issue

Samebug visitor profile picture
Unknown user
Once, 1 year ago

Write tip

Know the solutions? Share your knowledge to help other developers to debug faster.