mondrian.xmla.XmlaException: Mondrian Error:XMLA MDX execute failed

Pentaho BI Platform Tracking | Julian Hyde | 8 years ago
tip
Your exception is missing from the Samebug knowledge base.
Here are the best solutions we found on the Internet.
Click on the to mark the helpful solution and get rewards for you help.
  1. 0

    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

    Pentaho BI Platform Tracking | 8 years ago | Julian Hyde
    mondrian.xmla.XmlaException: Mondrian Error:XMLA MDX execute failed
  2. 0

    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

    Pentaho BI Platform Tracking | 8 years ago | Julian Hyde
    mondrian.xmla.XmlaException: Mondrian Error:XMLA MDX execute failed
  3. 0

    "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

    Pentaho BI Platform Tracking | 9 years ago | ajit_joglekar
    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]
  4. Speed up your debug routine!

    Automated exception search integrated into your IDE

  5. 0

    Java sql sqlexception microsoft odbc access driver count field incorrect - Java Programming - KnowCoding.com

    knowcoding.com | 1 year ago
    java.sql.SQLException: [Microsoft][ODBC Microsoft Access Driver] Syntax error in FROM claus e.
  6. 0

    java jdbc ms access "Syntax error in UPDATE statement"

    Stack Overflow | 3 years ago
    java.sql.SQLException: [Microsoft][ODBC Microsoft Access Driver] Syntax error in UPDATE statement.

    Not finding the right solution?
    Take a tour to get the most out of Samebug.

    Tired of useless tips?

    Automated exception search integrated into your IDE

    Root Cause Analysis

    1. 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()
    2. sun.jdbc.odbc
      JdbcOdbcStatement.executeQuery
      1. sun.jdbc.odbc.JdbcOdbc.createSQLException(JdbcOdbc.java:6957)
      2. sun.jdbc.odbc.JdbcOdbc.standardError(JdbcOdbc.java:7114)
      3. sun.jdbc.odbc.JdbcOdbc.SQLExecDirect(JdbcOdbc.java:3110)
      4. sun.jdbc.odbc.JdbcOdbcStatement.execute(JdbcOdbcStatement.java:338)
      5. sun.jdbc.odbc.JdbcOdbcStatement.executeQuery(JdbcOdbcStatement.java:253)
      5 frames
    3. Commons DBCP
      DelegatingStatement.executeQuery
      1. org.apache.commons.dbcp.DelegatingStatement.executeQuery(DelegatingStatement.java:174)
      1 frame
    4. mondrian.rolap
      SqlStatement.execute
      1. mondrian.rolap.SqlStatement.execute(SqlStatement.java:128)
      1 frame
    5. mondrian.resource
      MondrianResource$_Def0.ex
      1. mondrian.resource.MondrianResource$_Def0.ex(MondrianResource.java:811)
      1 frame
    6. mondrian.olap
      Util.newError
      1. mondrian.olap.Util.newInternal(Util.java:1472)
      2. mondrian.olap.Util.newError(Util.java:1488)
      2 frames
    7. mondrian.rolap
      RolapNativeSet$SetEvaluator.execute
      1. mondrian.rolap.SqlStatement.handle(SqlStatement.java:211)
      2. mondrian.rolap.SqlStatement.execute(SqlStatement.java:142)
      3. mondrian.rolap.RolapUtil.executeQuery(RolapUtil.java:242)
      4. mondrian.rolap.HighCardSqlTupleReader.prepareTuples(HighCardSqlTupleReader.java:102)
      5. mondrian.rolap.HighCardSqlTupleReader.readMembers(HighCardSqlTupleReader.java:153)
      6. mondrian.rolap.RolapNativeSet$SetEvaluator.executeList(RolapNativeSet.java:202)
      7. mondrian.rolap.RolapNativeSet$SetEvaluator.execute(RolapNativeSet.java:154)
      7 frames
    8. mondrian.olap.fun
      FilterFunDef$BaseMemberIterCalc.evaluateMemberIterable
      1. mondrian.olap.fun.FilterFunDef$BaseMemberIterCalc.evaluateMemberIterable(FilterFunDef.java:124)
      1 frame
    9. mondrian.calc.impl
      AbstractMemberIterCalc.evaluate
      1. mondrian.calc.impl.AbstractMemberIterCalc.evaluate(AbstractMemberIterCalc.java:55)
      1 frame
    10. mondrian.olap
      ExpCacheDescriptor.evaluate
      1. mondrian.olap.ExpCacheDescriptor.evaluate(ExpCacheDescriptor.java:86)
      1 frame
    11. mondrian.rolap
      RolapEvaluator.getCachedResult
      1. mondrian.rolap.RolapEvaluator.getCachedResult(RolapEvaluator.java:701)
      1 frame
    12. mondrian.olap.fun
      CacheFunDef$1.evaluate
      1. mondrian.olap.fun.CacheFunDef$1.evaluate(CacheFunDef.java:64)
      1 frame
    13. mondrian.calc.impl
      GenericIterCalc.evaluateIterable
      1. mondrian.calc.impl.GenericIterCalc.evaluateIterable(GenericIterCalc.java:65)
      1 frame
    14. mondrian.olap.fun
      CountFunDef$1.evaluateInteger
      1. mondrian.olap.fun.AbstractAggregateFunDef.evaluateCurrentIterable(AbstractAggregateFunDef.java:84)
      2. mondrian.olap.fun.CountFunDef$1.evaluateInteger(CountFunDef.java:71)
      2 frames
    15. mondrian.calc.impl
      BetterExpCompiler$1.evaluateDouble
      1. mondrian.calc.impl.BetterExpCompiler$1.evaluateDouble(BetterExpCompiler.java:48)
      1 frame
    16. mondrian.olap.fun
      IifFunDef$4$1.evaluate
      1. mondrian.olap.fun.BuiltinFunTable$69$1.evaluateBoolean(BuiltinFunTable.java:1849)
      2. mondrian.olap.fun.IifFunDef$4$1.evaluate(IifFunDef.java:141)
      2 frames
    17. mondrian.calc.impl
      AbstractExpCompiler$1.evaluateInteger
      1. mondrian.calc.impl.GenericCalc.evaluateDouble(GenericCalc.java:55)
      2. mondrian.calc.impl.AbstractExpCompiler$1.evaluateInteger(AbstractExpCompiler.java:242)
      2 frames
    18. mondrian.olap.fun
      CrossJoinFunDef$BaseListCalc.evaluateList
      1. mondrian.olap.fun.HeadTailFunDef$1.evaluateList(HeadTailFunDef.java:64)
      2. mondrian.olap.fun.CrossJoinFunDef$BaseListCalc.evaluateList(CrossJoinFunDef.java:1125)
      2 frames
    19. mondrian.calc.impl
      AbstractListCalc.evaluateTupleList
      1. mondrian.calc.impl.AbstractListCalc.evaluateTupleList(AbstractListCalc.java:97)
      1 frame
    20. mondrian.olap.fun
      GenerateFunDef$GenerateListCalcImpl.evaluateList
      1. mondrian.olap.fun.GenerateFunDef$GenerateListCalcImpl.evaluateList(GenerateFunDef.java:179)
      1 frame
    21. mondrian.calc.impl
      AbstractTupleIterCalc.evaluate
      1. mondrian.calc.impl.AbstractListCalc.evaluateTupleList(AbstractListCalc.java:97)
      2. mondrian.calc.impl.AbstractExpCompiler$TupleListIterCalc.evaluateTupleIterable(AbstractExpCompiler.java:562)
      3. mondrian.calc.impl.AbstractTupleIterCalc.evaluate(AbstractTupleIterCalc.java:55)
      3 frames
    22. mondrian.rolap
      RolapConnection.execute
      1. mondrian.rolap.RolapResult.executeAxis(RolapResult.java:727)
      2. mondrian.rolap.RolapResult.evalLoad(RolapResult.java:578)
      3. mondrian.rolap.RolapResult.loadMembers(RolapResult.java:553)
      4. mondrian.rolap.RolapResult.<init>(RolapResult.java:269)
      5. mondrian.rolap.RolapConnection.execute(RolapConnection.java:560)
      5 frames
    23. mondrian.resource
      MondrianResource$_Def0.ex
      1. mondrian.resource.MondrianResource$_Def0.ex(MondrianResource.java:811)
      1 frame
    24. mondrian.olap
      Util.newError
      1. mondrian.olap.Util.newInternal(Util.java:1472)
      2. mondrian.olap.Util.newError(Util.java:1488)
      2 frames
    25. mondrian.rolap
      RolapConnection.execute
      1. mondrian.rolap.RolapConnection.execute(RolapConnection.java:589)
      1 frame
    26. mondrian.xmla
      XmlaHandler.process
      1. mondrian.xmla.XmlaHandler.executeQuery(XmlaHandler.java:1678)
      2. mondrian.xmla.XmlaHandler.executeQuery(XmlaHandler.java:1682)
      3. mondrian.xmla.XmlaHandler.execute(XmlaHandler.java:636)
      4. mondrian.xmla.XmlaHandler.process(XmlaHandler.java:549)
      4 frames
    27. mondrian.tui
      XmlaSupport.processXmla
      1. mondrian.tui.XmlaSupport.processXmla(XmlaSupport.java:862)
      2. mondrian.tui.XmlaSupport.processXmla(XmlaSupport.java:822)
      2 frames
    28. mondrian.xmla
      XmlaCognosTest.testWithFilter
      1. mondrian.xmla.XmlaBaseTestCase.doTests(XmlaBaseTestCase.java:353)
      2. mondrian.xmla.XmlaBaseTestCase.doTestInline(XmlaBaseTestCase.java:290)
      3. mondrian.xmla.XmlaBaseTestCase.doTest(XmlaBaseTestCase.java:247)
      4. mondrian.xmla.XmlaBaseTestCase.doTest(XmlaBaseTestCase.java:236)
      5. mondrian.xmla.XmlaCognosTest.executeMDX(XmlaCognosTest.java:210)
      6. mondrian.xmla.XmlaCognosTest.testWithFilter(XmlaCognosTest.java:201)
      6 frames
    29. Java RT
      DelegatingMethodAccessorImpl.invoke
      1. sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method)
      2. sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:39)
      3. sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:25)
      3 frames
    30. IDEA
      JUnitStarter.main
      1. com.intellij.rt.execution.junit.JUnitStarter.main(JUnitStarter.java:40)
      1 frame
    31. Java RT
      DelegatingMethodAccessorImpl.invoke
      1. sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method)
      2. sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:39)
      3. sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:25)
      3 frames
    32. IDEA
      AppMain.main
      1. com.intellij.rt.execution.application.AppMain.main(AppMain.java:90)
      1 frame