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

Pentaho BI Platform Tracking | Julian Hyde | 8 years ago
  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

    "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]
  6. 0

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

    knowcoding.com | 11 months ago
    java.sql.SQLException: [Microsoft][ODBC Microsoft Access Driver] Syntax error in FROM claus e.

    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