mondrian.olap.MondrianException

There are no available Samebug tips for this exception. Do you have an idea how to solve this issue? A short tip would help users who saw this issue last week.

  • Using Mondrian 3.10-SNAPSHOT, the following query works: WITH SET [Markets] as '{[Markets].[All Markets]}' MEMBER [Measures].[Invalid] as '(0/0)' select {[Measures].[Invalid]} ON COLUMNS, {[Markets]} ON ROWS from [SteelWheelsSales] Using Mondrian 3.11-SNAPSHOT, it does not. It throws the following: mondrian.olap.MondrianException: Mondrian Error:Failed to parse query 'WITH SET [Markets] as '{[Markets].[All Markets]}' MEMBER [Measures].[Invalid] as '(0/0)' select {[Measures].[Invalid]} ON COLUMNS, {[Markets]} ON ROWS from [SteelWheelsSales]' at mondrian.resource.MondrianResource$_Def0.ex(MondrianResource.java:977) at mondrian.olap.ConnectionBase.parseStatement(ConnectionBase.java:101) at mondrian.rolap.RolapConnection.parseStatement(RolapConnection.java:760) at mondrian.olap.ConnectionBase.parseQuery(ConnectionBase.java:56) at org.pentaho.reporting.engine.classic.extensions.datasources.mondrian.AbstractMDXDataFactory.performQuery(AbstractMDXDataFactory.java:444) at org.pentaho.reporting.engine.classic.extensions.datasources.mondrian.AbstractNamedMDXDataFactory.performQuery(AbstractNamedMDXDataFactory.java:145) at org.pentaho.reporting.engine.classic.extensions.datasources.mondrian.BandedMDXDataFactory.queryData(BandedMDXDataFactory.java:54) at org.pentaho.reporting.engine.classic.core.CompoundDataFactory.queryStatic(CompoundDataFactory.java:135) at org.pentaho.reporting.engine.classic.core.CompoundDataFactory.queryData(CompoundDataFactory.java:85) 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:127) Caused by: java.lang.UnsupportedOperationException at mondrian.mdx.UnresolvedFunCall.getType(UnresolvedFunCall.java:82) at mondrian.olap.SetBase.getType(SetBase.java:140) at mondrian.mdx.NamedSetExpr.getType(NamedSetExpr.java:123) at mondrian.olap.ValidatorImpl.canConvert(ValidatorImpl.java:253) at mondrian.olap.fun.SetFunDef$ResolverImpl.resolve(SetFunDef.java:428) at mondrian.olap.ValidatorImpl.getDef(ValidatorImpl.java:190) at mondrian.olap.fun.FunUtil.resolveFunArgs(FunUtil.java:2027) at mondrian.mdx.UnresolvedFunCall.accept(UnresolvedFunCall.java:102) at mondrian.olap.ValidatorImpl.validate(ValidatorImpl.java:83)
    via by Pedro Vale,
  • Using Mondrian 3.10-SNAPSHOT, the following query works: {noformat} WITH SET [Markets] as '{[Markets].[All Markets]}' MEMBER [Measures].[Invalid] as '(0/0)' select {[Measures].[Invalid]} ON COLUMNS, {[Markets]} ON ROWS from [SteelWheelsSales] {noformat} Using Mondrian 3.11-SNAPSHOT, it does not. It throws the following: {noformat} mondrian.olap.MondrianException: Mondrian Error:Failed to parse query 'WITH SET [Markets] as '{[Markets].[All Markets]}' MEMBER [Measures].[Invalid] as '(0/0)' select {[Measures].[Invalid]} ON COLUMNS, {[Markets]} ON ROWS from [SteelWheelsSales]' at mondrian.resource.MondrianResource$_Def0.ex(MondrianResource.java:977) at mondrian.olap.ConnectionBase.parseStatement(ConnectionBase.java:101) at mondrian.rolap.RolapConnection.parseStatement(RolapConnection.java:760) at mondrian.olap.ConnectionBase.parseQuery(ConnectionBase.java:56) at org.pentaho.reporting.engine.classic.extensions.datasources.mondrian.AbstractMDXDataFactory.performQuery(AbstractMDXDataFactory.java:444) at org.pentaho.reporting.engine.classic.extensions.datasources.mondrian.AbstractNamedMDXDataFactory.performQuery(AbstractNamedMDXDataFactory.java:145) at org.pentaho.reporting.engine.classic.extensions.datasources.mondrian.BandedMDXDataFactory.queryData(BandedMDXDataFactory.java:54) at org.pentaho.reporting.engine.classic.core.CompoundDataFactory.queryStatic(CompoundDataFactory.java:135) at org.pentaho.reporting.engine.classic.core.CompoundDataFactory.queryData(CompoundDataFactory.java:85) 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:127) Caused by: java.lang.UnsupportedOperationException at mondrian.mdx.UnresolvedFunCall.getType(UnresolvedFunCall.java:82) at mondrian.olap.SetBase.getType(SetBase.java:140) at mondrian.mdx.NamedSetExpr.getType(NamedSetExpr.java:123) at mondrian.olap.ValidatorImpl.canConvert(ValidatorImpl.java:253) at mondrian.olap.fun.SetFunDef$ResolverImpl.resolve(SetFunDef.java:428) at mondrian.olap.ValidatorImpl.getDef(ValidatorImpl.java:190) at mondrian.olap.fun.FunUtil.resolveFunArgs(FunUtil.java:2027) at mondrian.mdx.UnresolvedFunCall.accept(UnresolvedFunCall.java:102) at mondrian.olap.ValidatorImpl.validate(ValidatorImpl.java:83) {noformat}
    via by Pedro Vale,
    • mondrian.olap.MondrianException: Mondrian Error:Failed to parse query 'WITH SET [Markets] as '{[Markets].[All Markets]}' MEMBER [Measures].[Invalid] as '(0/0)' select {[Measures].[Invalid]} ON COLUMNS, {[Markets]} ON ROWS from [SteelWheelsSales]' at mondrian.resource.MondrianResource$_Def0.ex(MondrianResource.java:977) at mondrian.olap.ConnectionBase.parseStatement(ConnectionBase.java:101) at mondrian.rolap.RolapConnection.parseStatement(RolapConnection.java:760) at mondrian.olap.ConnectionBase.parseQuery(ConnectionBase.java:56) at org.pentaho.reporting.engine.classic.extensions.datasources.mondrian.AbstractMDXDataFactory.performQuery(AbstractMDXDataFactory.java:444) at org.pentaho.reporting.engine.classic.extensions.datasources.mondrian.AbstractNamedMDXDataFactory.performQuery(AbstractNamedMDXDataFactory.java:145) at org.pentaho.reporting.engine.classic.extensions.datasources.mondrian.BandedMDXDataFactory.queryData(BandedMDXDataFactory.java:54) at org.pentaho.reporting.engine.classic.core.CompoundDataFactory.queryStatic(CompoundDataFactory.java:135) at org.pentaho.reporting.engine.classic.core.CompoundDataFactory.queryData(CompoundDataFactory.java:85) 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:127) Caused by: java.lang.UnsupportedOperationException at mondrian.mdx.UnresolvedFunCall.getType(UnresolvedFunCall.java:82) at mondrian.olap.SetBase.getType(SetBase.java:140) at mondrian.mdx.NamedSetExpr.getType(NamedSetExpr.java:123) at mondrian.olap.ValidatorImpl.canConvert(ValidatorImpl.java:253) at mondrian.olap.fun.SetFunDef$ResolverImpl.resolve(SetFunDef.java:428) at mondrian.olap.ValidatorImpl.getDef(ValidatorImpl.java:190) at mondrian.olap.fun.FunUtil.resolveFunArgs(FunUtil.java:2027) at mondrian.mdx.UnresolvedFunCall.accept(UnresolvedFunCall.java:102) at mondrian.olap.ValidatorImpl.validate(ValidatorImpl.java:83)
    No Bugmate found.