mondrian.xmla.XmlaException

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.

  • XmlaCognosTest.testWithFilter generates a query with count(distinct ...), which access does not support. The SQL generation code should check Dialect.allowsCountDistinct(). Stack: mondrian.xmla.XmlaException: Mondrian Error:XMLA MDX execute failed at mondrian.xmla.XmlaHandler.executeQuery(XmlaHandler.java:1682) at mondrian.xmla.XmlaHandler.execute(XmlaHandler.java:636) at mondrian.xmla.XmlaHandler.process(XmlaHandler.java:549) at mondrian.tui.XmlaSupport.processXmla(XmlaSupport.java:862) at mondrian.tui.XmlaSupport.processXmla(XmlaSupport.java:822) at mondrian.xmla.XmlaBaseTestCase.doTests(XmlaBaseTestCase.java:353) at mondrian.xmla.XmlaBaseTestCase.doTestInline(XmlaBaseTestCase.java:290) at mondrian.xmla.XmlaBaseTestCase.doTest(XmlaBaseTestCase.java:247) at mondrian.xmla.XmlaBaseTestCase.doTest(XmlaBaseTestCase.java:236) at mondrian.xmla.XmlaCognosTest.executeMDX(XmlaCognosTest.java:210) at mondrian.xmla.XmlaCognosTest.testWithFilter(XmlaCognosTest.java:201) at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method) at sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:39) at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:25) at com.intellij.rt.execution.junit.JUnitStarter.main(JUnitStarter.java:40) at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method) at sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:39) at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:25) at com.intellij.rt.execution.application.AppMain.main(AppMain.java:90) Caused by: mondrian.olap.MondrianException: Mondrian Error:Internal error: Error while executing query [with member [Measures].[COG_OQP_USR_Customer Count] as '[Measures].[COG_OQP_INT_m1]', SOLVE_ORDER = 2.0 member [Measures].[COG_OQP_INT_m1] as 'IIf(([Measures].[Customer Count] > 1380.0), [Measures].[Customer Count], NULL)', SOLVE_ORDER = 2.0 select {[Measures].[COG_OQP_USR_Customer Count]} DIMENSION PROPERTIES PARENT_LEVEL, PARENT_UNIQUE_NAME ON COLUMNS, Generate({[Gender].[Gender].Members}, Crossjoin(Head({[Gender].CurrentMember}, IIf((Count(Filter({[Marital Status].[Marital Status].Members}, ([Measures].[Customer Count] > 1380.0)), INCLUDEEMPTY) > 0.0), 1.0, 0.0)), Filter({[Marital Status].[Marital Status].Members}, ([Measures].[Customer Count] > 1380.0))), ALL) DIMENSION PROPERTIES PARENT_LEVEL, PARENT_UNIQUE_NAME ON ROWS from [Sales] ] at mondrian.resource.MondrianResource$_Def0.ex(MondrianResource.java:811) at mondrian.olap.Util.newInternal(Util.java:1472) at mondrian.olap.Util.newError(Util.java:1488) at mondrian.rolap.RolapConnection.execute(RolapConnection.java:589) at mondrian.xmla.XmlaHandler.executeQuery(XmlaHandler.java:1678) ... 31 more Caused by: mondrian.olap.MondrianException: Mondrian Error:Internal error: Populating member cache with members for [[Marital Status].[Marital Status]]; sql=[select `customer`.`marital_status` as `c0` from `customer` as `customer`, `sales_fact_1997` as `sales_fact_1997`, `time_by_day` as `time_by_day` where `sales_fact_1997`.`customer_id` = `customer`.`customer_id` and `sales_fact_1997`.`time_id` = `time_by_day`.`time_id` and `time_by_day`.`the_year` = 1997 and `customer`.`gender` = 'F' group by `customer`.`marital_status` having (count(distinct `sales_fact_1997`.`customer_id`) > 1380.0) order by `customer`.`marital_status` ASC] at mondrian.resource.MondrianResource$_Def0.ex(MondrianResource.java:811) at mondrian.olap.Util.newInternal(Util.java:1472) at mondrian.olap.Util.newError(Util.java:1488) at mondrian.rolap.SqlStatement.handle(SqlStatement.java:211) at mondrian.rolap.SqlStatement.execute(SqlStatement.java:142) at mondrian.rolap.RolapUtil.executeQuery(RolapUtil.java:242) at mondrian.rolap.HighCardSqlTupleReader.prepareTuples(HighCardSqlTupleReader.java:102) at mondrian.rolap.HighCardSqlTupleReader.readMembers(HighCardSqlTupleReader.java:153) at mondrian.rolap.RolapNativeSet$SetEvaluator.executeList(RolapNativeSet.java:202) at mondrian.rolap.RolapNativeSet$SetEvaluator.execute(RolapNativeSet.java:154) at mondrian.olap.fun.FilterFunDef$BaseMemberIterCalc.evaluateMemberIterable(FilterFunDef.java:124) at mondrian.calc.impl.AbstractMemberIterCalc.evaluate(AbstractMemberIterCalc.java:55) at mondrian.olap.ExpCacheDescriptor.evaluate(ExpCacheDescriptor.java:86) at mondrian.rolap.RolapEvaluator.getCachedResult(RolapEvaluator.java:701) at mondrian.olap.fun.CacheFunDef$1.evaluate(CacheFunDef.java:64) at mondrian.calc.impl.GenericIterCalc.evaluateIterable(GenericIterCalc.java:65) at mondrian.olap.fun.AbstractAggregateFunDef.evaluateCurrentIterable(AbstractAggregateFunDef.java:84) at mondrian.olap.fun.CountFunDef$1.evaluateInteger(CountFunDef.java:71) at mondrian.calc.impl.BetterExpCompiler$1.evaluateDouble(BetterExpCompiler.java:48) at mondrian.olap.fun.BuiltinFunTable$69$1.evaluateBoolean(BuiltinFunTable.java:1849) at mondrian.olap.fun.IifFunDef$4$1.evaluate(IifFunDef.java:141) at mondrian.calc.impl.GenericCalc.evaluateDouble(GenericCalc.java:55) at mondrian.calc.impl.AbstractExpCompiler$1.evaluateInteger(AbstractExpCompiler.java:242) at mondrian.olap.fun.HeadTailFunDef$1.evaluateList(HeadTailFunDef.java:64) at mondrian.olap.fun.CrossJoinFunDef$BaseListCalc.evaluateList(CrossJoinFunDef.java:1125) at mondrian.calc.impl.AbstractListCalc.evaluateTupleList(AbstractListCalc.java:97) at mondrian.olap.fun.GenerateFunDef$GenerateListCalcImpl.evaluateList(GenerateFunDef.java:179) at mondrian.calc.impl.AbstractListCalc.evaluateTupleList(AbstractListCalc.java:97) at mondrian.calc.impl.AbstractExpCompiler$TupleListIterCalc.evaluateTupleIterable(AbstractExpCompiler.java:562) at mondrian.calc.impl.AbstractTupleIterCalc.evaluate(AbstractTupleIterCalc.java:55) at mondrian.rolap.RolapResult.executeAxis(RolapResult.java:727) at mondrian.rolap.RolapResult.evalLoad(RolapResult.java:578) at mondrian.rolap.RolapResult.loadMembers(RolapResult.java:553) at mondrian.rolap.RolapResult.<init>(RolapResult.java:269) at mondrian.rolap.RolapConnection.execute(RolapConnection.java:560) ... 32 more Caused by: java.sql.SQLException: [Microsoft][ODBC Microsoft Access Driver] Syntax error (missing operator) in query expression '(count(distinct `sales_fact_1997`.`customer_id`) > 1380.0)'. at sun.jdbc.odbc.JdbcOdbc.createSQLException(JdbcOdbc.java:6957) at sun.jdbc.odbc.JdbcOdbc.standardError(JdbcOdbc.java:7114) at sun.jdbc.odbc.JdbcOdbc.SQLExecDirect(JdbcOdbc.java:3110) at sun.jdbc.odbc.JdbcOdbcStatement.execute(JdbcOdbcStatement.java:338) at sun.jdbc.odbc.JdbcOdbcStatement.executeQuery(JdbcOdbcStatement.java:253) at org.apache.commons.dbcp.DelegatingStatement.executeQuery(DelegatingStatement.java:174) at mondrian.rolap.SqlStatement.execute(SqlStatement.java:128) ... 62 more
    via by Julian Hyde,
  • XmlaCognosTest.testWithFilter generates a query with count(distinct ...), which access does not support. The SQL generation code should check Dialect.allowsCountDistinct(). Stack: mondrian.xmla.XmlaException: Mondrian Error:XMLA MDX execute failed at mondrian.xmla.XmlaHandler.executeQuery(XmlaHandler.java:1682) at mondrian.xmla.XmlaHandler.execute(XmlaHandler.java:636) at mondrian.xmla.XmlaHandler.process(XmlaHandler.java:549) at mondrian.tui.XmlaSupport.processXmla(XmlaSupport.java:862) at mondrian.tui.XmlaSupport.processXmla(XmlaSupport.java:822) at mondrian.xmla.XmlaBaseTestCase.doTests(XmlaBaseTestCase.java:353) at mondrian.xmla.XmlaBaseTestCase.doTestInline(XmlaBaseTestCase.java:290) at mondrian.xmla.XmlaBaseTestCase.doTest(XmlaBaseTestCase.java:247) at mondrian.xmla.XmlaBaseTestCase.doTest(XmlaBaseTestCase.java:236) at mondrian.xmla.XmlaCognosTest.executeMDX(XmlaCognosTest.java:210) at mondrian.xmla.XmlaCognosTest.testWithFilter(XmlaCognosTest.java:201) at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method) at sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:39) at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:25) at com.intellij.rt.execution.junit.JUnitStarter.main(JUnitStarter.java:40) at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method) at sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:39) at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:25) at com.intellij.rt.execution.application.AppMain.main(AppMain.java:90) Caused by: mondrian.olap.MondrianException: Mondrian Error:Internal error: Error while executing query [with member [Measures].[COG_OQP_USR_Customer Count] as '[Measures].[COG_OQP_INT_m1]', SOLVE_ORDER = 2.0 member [Measures].[COG_OQP_INT_m1] as 'IIf(([Measures].[Customer Count] > 1380.0), [Measures].[Customer Count], NULL)', SOLVE_ORDER = 2.0 select {[Measures].[COG_OQP_USR_Customer Count]} DIMENSION PROPERTIES PARENT_LEVEL, PARENT_UNIQUE_NAME ON COLUMNS, Generate({[Gender].[Gender].Members}, Crossjoin(Head({[Gender].CurrentMember}, IIf((Count(Filter({[Marital Status].[Marital Status].Members}, ([Measures].[Customer Count] > 1380.0)), INCLUDEEMPTY) > 0.0), 1.0, 0.0)), Filter({[Marital Status].[Marital Status].Members}, ([Measures].[Customer Count] > 1380.0))), ALL) DIMENSION PROPERTIES PARENT_LEVEL, PARENT_UNIQUE_NAME ON ROWS from [Sales] ] at mondrian.resource.MondrianResource$_Def0.ex(MondrianResource.java:811) at mondrian.olap.Util.newInternal(Util.java:1472) at mondrian.olap.Util.newError(Util.java:1488) at mondrian.rolap.RolapConnection.execute(RolapConnection.java:589) at mondrian.xmla.XmlaHandler.executeQuery(XmlaHandler.java:1678) ... 31 more Caused by: mondrian.olap.MondrianException: Mondrian Error:Internal error: Populating member cache with members for [[Marital Status].[Marital Status]]; sql=[select `customer`.`marital_status` as `c0` from `customer` as `customer`, `sales_fact_1997` as `sales_fact_1997`, `time_by_day` as `time_by_day` where `sales_fact_1997`.`customer_id` = `customer`.`customer_id` and `sales_fact_1997`.`time_id` = `time_by_day`.`time_id` and `time_by_day`.`the_year` = 1997 and `customer`.`gender` = 'F' group by `customer`.`marital_status` having (count(distinct `sales_fact_1997`.`customer_id`) > 1380.0) order by `customer`.`marital_status` ASC] at mondrian.resource.MondrianResource$_Def0.ex(MondrianResource.java:811) at mondrian.olap.Util.newInternal(Util.java:1472) at mondrian.olap.Util.newError(Util.java:1488) at mondrian.rolap.SqlStatement.handle(SqlStatement.java:211) at mondrian.rolap.SqlStatement.execute(SqlStatement.java:142) at mondrian.rolap.RolapUtil.executeQuery(RolapUtil.java:242) at mondrian.rolap.HighCardSqlTupleReader.prepareTuples(HighCardSqlTupleReader.java:102) at mondrian.rolap.HighCardSqlTupleReader.readMembers(HighCardSqlTupleReader.java:153) at mondrian.rolap.RolapNativeSet$SetEvaluator.executeList(RolapNativeSet.java:202) at mondrian.rolap.RolapNativeSet$SetEvaluator.execute(RolapNativeSet.java:154) at mondrian.olap.fun.FilterFunDef$BaseMemberIterCalc.evaluateMemberIterable(FilterFunDef.java:124) at mondrian.calc.impl.AbstractMemberIterCalc.evaluate(AbstractMemberIterCalc.java:55) at mondrian.olap.ExpCacheDescriptor.evaluate(ExpCacheDescriptor.java:86) at mondrian.rolap.RolapEvaluator.getCachedResult(RolapEvaluator.java:701) at mondrian.olap.fun.CacheFunDef$1.evaluate(CacheFunDef.java:64) at mondrian.calc.impl.GenericIterCalc.evaluateIterable(GenericIterCalc.java:65) at mondrian.olap.fun.AbstractAggregateFunDef.evaluateCurrentIterable(AbstractAggregateFunDef.java:84) at mondrian.olap.fun.CountFunDef$1.evaluateInteger(CountFunDef.java:71) at mondrian.calc.impl.BetterExpCompiler$1.evaluateDouble(BetterExpCompiler.java:48) at mondrian.olap.fun.BuiltinFunTable$69$1.evaluateBoolean(BuiltinFunTable.java:1849) at mondrian.olap.fun.IifFunDef$4$1.evaluate(IifFunDef.java:141) at mondrian.calc.impl.GenericCalc.evaluateDouble(GenericCalc.java:55) at mondrian.calc.impl.AbstractExpCompiler$1.evaluateInteger(AbstractExpCompiler.java:242) at mondrian.olap.fun.HeadTailFunDef$1.evaluateList(HeadTailFunDef.java:64) at mondrian.olap.fun.CrossJoinFunDef$BaseListCalc.evaluateList(CrossJoinFunDef.java:1125) at mondrian.calc.impl.AbstractListCalc.evaluateTupleList(AbstractListCalc.java:97) at mondrian.olap.fun.GenerateFunDef$GenerateListCalcImpl.evaluateList(GenerateFunDef.java:179) at mondrian.calc.impl.AbstractListCalc.evaluateTupleList(AbstractListCalc.java:97) at mondrian.calc.impl.AbstractExpCompiler$TupleListIterCalc.evaluateTupleIterable(AbstractExpCompiler.java:562) at mondrian.calc.impl.AbstractTupleIterCalc.evaluate(AbstractTupleIterCalc.java:55) at mondrian.rolap.RolapResult.executeAxis(RolapResult.java:727) at mondrian.rolap.RolapResult.evalLoad(RolapResult.java:578) at mondrian.rolap.RolapResult.loadMembers(RolapResult.java:553) at mondrian.rolap.RolapResult.<init>(RolapResult.java:269) at mondrian.rolap.RolapConnection.execute(RolapConnection.java:560) ... 32 more Caused by: java.sql.SQLException: [Microsoft][ODBC Microsoft Access Driver] Syntax error (missing operator) in query expression '(count(distinct `sales_fact_1997`.`customer_id`) > 1380.0)'. at sun.jdbc.odbc.JdbcOdbc.createSQLException(JdbcOdbc.java:6957) at sun.jdbc.odbc.JdbcOdbc.standardError(JdbcOdbc.java:7114) at sun.jdbc.odbc.JdbcOdbc.SQLExecDirect(JdbcOdbc.java:3110) at sun.jdbc.odbc.JdbcOdbcStatement.execute(JdbcOdbcStatement.java:338) at sun.jdbc.odbc.JdbcOdbcStatement.executeQuery(JdbcOdbcStatement.java:253) at org.apache.commons.dbcp.DelegatingStatement.executeQuery(DelegatingStatement.java:174) at mondrian.rolap.SqlStatement.execute(SqlStatement.java:128) ... 62 more
    via by Julian Hyde,
  • "build test" fails on msaccess at RolapResultTest.testAll(). The stack trace is at the bottom Some observations: - If we replace the existing access mdb file with the one from zip archive the tests work for a run immediately after replacement - If we mark the db readonly from the datasource configuration dialog the tests are bypassed hence there is no failure Richard, please let me know if any further information is required Thanks, -Ajit Stack trace: [java] [1440] ........................................ [java] [1480] ........................... [java] There was 1 error: [java] 1) testAll(mondrian.rolap.RolapResultTest)mondrian.olap.MondrianException: Mondrian Error:Internal error: Po pulating member cache with members for [[D1].[Name]]; sql=[select `D1`.`name` as `c0` from `D1` as `D1` group by `D1`.`n ame` order by `D1`.`name` ASC] [java] at mondrian.resource.MondrianResource$_Def0.ex(MondrianResource.java:760) [java] at mondrian.olap.Util.newInternal(Util.java:1187) [java] at mondrian.olap.Util.newError(Util.java:1203) [java] at mondrian.rolap.SqlStatement.handle(SqlStatement.java:208) [java] at mondrian.rolap.SqlStatement.execute(SqlStatement.java:138) [java] at mondrian.rolap.RolapUtil.executeQuery(RolapUtil.java:285) [java] at mondrian.rolap.SqlTupleReader.prepareTuples(SqlTupleReader.java:330) [java] at mondrian.rolap.SqlTupleReader.readTuples(SqlTupleReader.java:443) [java] at mondrian.rolap.SqlMemberSource.getMembersInLevel(SqlMemberSource.java:431) [java] at mondrian.rolap.SqlMemberSource.getMembersInLevel(SqlMemberSource.java:422) [java] at mondrian.rolap.SqlMemberSource.getMembersInLevel(SqlMemberSource.java:411) [java] at mondrian.rolap.SqlMemberSource.getRootMembers(SqlMemberSource.java:448) [java] at mondrian.rolap.SmartMemberReader.getRootMembers(SmartMemberReader.java:161) [java] at mondrian.rolap.RolapUtil.lookupMemberInternal(RolapUtil.java:129) [java] at mondrian.rolap.RolapUtil.lookupMember(RolapUtil.java:98) [java] at mondrian.rolap.SmartMemberReader.lookupMember(SmartMemberReader.java:253) [java] at mondrian.rolap.RolapHierarchy.init(RolapHierarchy.java:298) [java] at mondrian.rolap.RolapDimension.init(RolapDimension.java:194) [java] at mondrian.rolap.RolapCube.init(RolapCube.java:1072) [java] at mondrian.rolap.RolapCube.<init>(RolapCube.java:262) [java] at mondrian.rolap.RolapSchema.load(RolapSchema.java:436) [java] at mondrian.rolap.RolapSchema.load(RolapSchema.java:335) [java] at mondrian.rolap.RolapSchema.<init>(RolapSchema.java:216) [java] at mondrian.rolap.RolapSchema.<init>(RolapSchema.java:79) [java] at mondrian.rolap.RolapSchema$Pool.get(RolapSchema.java:904) [java] at mondrian.rolap.RolapSchema$Pool.get(RolapSchema.java:715) [java] at mondrian.rolap.RolapConnection.<init>(RolapConnection.java:149) [java] at mondrian.rolap.RolapConnection.<init>(RolapConnection.java:80) [java] at mondrian.olap.DriverManager.getConnection(DriverManager.java:190) [java] at mondrian.olap.DriverManager.getConnection(DriverManager.java:131) [java] at mondrian.test.TestContext.getFoodMartConnection(TestContext.java:211) [java] at mondrian.test.TestContext.getConnection(TestContext.java:192) [java] at mondrian.test.TestContext.executeQuery(TestContext.java:424) [java] at mondrian.test.TestContext.assertQueryReturns(TestContext.java:662) [java] at mondrian.rolap.RolapResultTest.testAll(RolapResultTest.java:100) [java] at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method) [java] at sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:39) [java] at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:25) [java] at mondrian.test.MondrianTestRunner$2.run(MondrianTestRunner.java:130) [java] at java.lang.Thread.run(Thread.java:595) [java] Caused by: java.sql.SQLException: [Microsoft][ODBC Microsoft Access Driver] The Microsoft Jet database engin e cannot find the input table or query 'D1'. Make sure it exists and that its name is spelled correctly. [java] at sun.jdbc.odbc.JdbcOdbc.createSQLException(JdbcOdbc.java:6958) [java] at sun.jdbc.odbc.JdbcOdbc.standardError(JdbcOdbc.java:7115) [java] at sun.jdbc.odbc.JdbcOdbc.SQLExecDirect(JdbcOdbc.java:3111) [java] at sun.jdbc.odbc.JdbcOdbcStatement.execute(JdbcOdbcStatement.java:338) [java] at sun.jdbc.odbc.JdbcOdbcStatement.executeQuery(JdbcOdbcStatement.java:253) [java] at org.apache.commons.dbcp.DelegatingStatement.executeQuery(DelegatingStatement.java:188) [java] at mondrian.rolap.SqlStatement.execute(SqlStatement.java:124) [java] ... 46 more [java] FAILURES!!! [java] Tests run: 1507, Failures: 0, Errors: 1
    via by ajit_joglekar,
    • mondrian.xmla.XmlaException: Mondrian Error:XMLA MDX execute failed at mondrian.xmla.XmlaHandler.executeQuery(XmlaHandler.java:1682) at mondrian.xmla.XmlaHandler.execute(XmlaHandler.java:636) at mondrian.xmla.XmlaHandler.process(XmlaHandler.java:549) at mondrian.tui.XmlaSupport.processXmla(XmlaSupport.java:862) at mondrian.tui.XmlaSupport.processXmla(XmlaSupport.java:822) at mondrian.xmla.XmlaBaseTestCase.doTests(XmlaBaseTestCase.java:353) at mondrian.xmla.XmlaBaseTestCase.doTestInline(XmlaBaseTestCase.java:290) at mondrian.xmla.XmlaBaseTestCase.doTest(XmlaBaseTestCase.java:247) at mondrian.xmla.XmlaBaseTestCase.doTest(XmlaBaseTestCase.java:236) at mondrian.xmla.XmlaCognosTest.executeMDX(XmlaCognosTest.java:210) at mondrian.xmla.XmlaCognosTest.testWithFilter(XmlaCognosTest.java:201) at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method) at sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:39) at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:25) at com.intellij.rt.execution.junit.JUnitStarter.main(JUnitStarter.java:40) at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method) at sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:39) at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:25) at com.intellij.rt.execution.application.AppMain.main(AppMain.java:90) Caused by: mondrian.olap.MondrianException: Mondrian Error:Internal error: Error while executing query [with member [Measures].[COG_OQP_USR_Customer Count] as '[Measures].[COG_OQP_INT_m1]', SOLVE_ORDER = 2.0 member [Measures].[COG_OQP_INT_m1] as 'IIf(([Measures].[Customer Count] > 1380.0), [Measures].[Customer Count], NULL)', SOLVE_ORDER = 2.0 select {[Measures].[COG_OQP_USR_Customer Count]} DIMENSION PROPERTIES PARENT_LEVEL, PARENT_UNIQUE_NAME ON COLUMNS, Generate({[Gender].[Gender].Members}, Crossjoin(Head({[Gender].CurrentMember}, IIf((Count(Filter({[Marital Status].[Marital Status].Members}, ([Measures].[Customer Count] > 1380.0)), INCLUDEEMPTY) > 0.0), 1.0, 0.0)), Filter({[Marital Status].[Marital Status].Members}, ([Measures].[Customer Count] > 1380.0))), ALL) DIMENSION PROPERTIES PARENT_LEVEL, PARENT_UNIQUE_NAME ON ROWS from [Sales] ] at mondrian.resource.MondrianResource$_Def0.ex(MondrianResource.java:811) at mondrian.olap.Util.newInternal(Util.java:1472) at mondrian.olap.Util.newError(Util.java:1488) at mondrian.rolap.RolapConnection.execute(RolapConnection.java:589) at mondrian.xmla.XmlaHandler.executeQuery(XmlaHandler.java:1678) ... 19 more Caused by: mondrian.olap.MondrianException: Mondrian Error:Internal error: Populating member cache with members for [[Marital Status].[Marital Status]]; sql=[select `customer`.`marital_status` as `c0` from `customer` as `customer`, `sales_fact_1997` as `sales_fact_1997`, `time_by_day` as `time_by_day` where `sales_fact_1997`.`customer_id` = `customer`.`customer_id` and `sales_fact_1997`.`time_id` = `time_by_day`.`time_id` and `time_by_day`.`the_year` = 1997 and `customer`.`gender` = 'F' group by `customer`.`marital_status` having (count(distinct `sales_fact_1997`.`customer_id`) > 1380.0) order by `customer`.`marital_status` ASC] at mondrian.resource.MondrianResource$_Def0.ex(MondrianResource.java:811) at mondrian.olap.Util.newInternal(Util.java:1472) at mondrian.olap.Util.newError(Util.java:1488) at mondrian.rolap.SqlStatement.handle(SqlStatement.java:211) at mondrian.rolap.SqlStatement.execute(SqlStatement.java:142) at mondrian.rolap.RolapUtil.executeQuery(RolapUtil.java:242) at mondrian.rolap.HighCardSqlTupleReader.prepareTuples(HighCardSqlTupleReader.java:102) at mondrian.rolap.HighCardSqlTupleReader.readMembers(HighCardSqlTupleReader.java:153) at mondrian.rolap.RolapNativeSet$SetEvaluator.executeList(RolapNativeSet.java:202) at mondrian.rolap.RolapNativeSet$SetEvaluator.execute(RolapNativeSet.java:154) at mondrian.olap.fun.FilterFunDef$BaseMemberIterCalc.evaluateMemberIterable(FilterFunDef.java:124) at mondrian.calc.impl.AbstractMemberIterCalc.evaluate(AbstractMemberIterCalc.java:55) at mondrian.olap.ExpCacheDescriptor.evaluate(ExpCacheDescriptor.java:86) at mondrian.rolap.RolapEvaluator.getCachedResult(RolapEvaluator.java:701) at mondrian.olap.fun.CacheFunDef$1.evaluate(CacheFunDef.java:64) at mondrian.calc.impl.GenericIterCalc.evaluateIterable(GenericIterCalc.java:65) at mondrian.olap.fun.AbstractAggregateFunDef.evaluateCurrentIterable(AbstractAggregateFunDef.java:84) at mondrian.olap.fun.CountFunDef$1.evaluateInteger(CountFunDef.java:71) at mondrian.calc.impl.BetterExpCompiler$1.evaluateDouble(BetterExpCompiler.java:48) at mondrian.olap.fun.BuiltinFunTable$69$1.evaluateBoolean(BuiltinFunTable.java:1849) at mondrian.olap.fun.IifFunDef$4$1.evaluate(IifFunDef.java:141) at mondrian.calc.impl.GenericCalc.evaluateDouble(GenericCalc.java:55) at mondrian.calc.impl.AbstractExpCompiler$1.evaluateInteger(AbstractExpCompiler.java:242) at mondrian.olap.fun.HeadTailFunDef$1.evaluateList(HeadTailFunDef.java:64) at mondrian.olap.fun.CrossJoinFunDef$BaseListCalc.evaluateList(CrossJoinFunDef.java:1125) at mondrian.calc.impl.AbstractListCalc.evaluateTupleList(AbstractListCalc.java:97) at mondrian.olap.fun.GenerateFunDef$GenerateListCalcImpl.evaluateList(GenerateFunDef.java:179) at mondrian.calc.impl.AbstractListCalc.evaluateTupleList(AbstractListCalc.java:97) at mondrian.calc.impl.AbstractExpCompiler$TupleListIterCalc.evaluateTupleIterable(AbstractExpCompiler.java:562) at mondrian.calc.impl.AbstractTupleIterCalc.evaluate(AbstractTupleIterCalc.java:55) at mondrian.rolap.RolapResult.executeAxis(RolapResult.java:727) at mondrian.rolap.RolapResult.evalLoad(RolapResult.java:578) at mondrian.rolap.RolapResult.loadMembers(RolapResult.java:553) at mondrian.rolap.RolapResult.<init>(RolapResult.java:269) at mondrian.rolap.RolapConnection.execute(RolapConnection.java:560) ... 24 more Caused by: java.sql.SQLException: [Microsoft][ODBC Microsoft Access Driver] Syntax error (missing operator) in query expression '(count(distinct `sales_fact_1997`.`customer_id`) > 1380.0)'. at sun.jdbc.odbc.JdbcOdbc.createSQLException(JdbcOdbc.java:6957) at sun.jdbc.odbc.JdbcOdbc.standardError(JdbcOdbc.java:7114) at sun.jdbc.odbc.JdbcOdbc.SQLExecDirect(JdbcOdbc.java:3110) at sun.jdbc.odbc.JdbcOdbcStatement.execute(JdbcOdbcStatement.java:338) at sun.jdbc.odbc.JdbcOdbcStatement.executeQuery(JdbcOdbcStatement.java:253) at org.apache.commons.dbcp.DelegatingStatement.executeQuery(DelegatingStatement.java:174) at mondrian.rolap.SqlStatement.execute(SqlStatement.java:128) ... 59 more

    Users with the same issue

    Unknown visitor1 times, last one,
    Unknown visitor2 times, last one,
    Unknown visitor1 times, last one,
    Unknown visitor1 times, last one,
    Unknown visitor1 times, last one,
    12 more bugmates