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]

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

    Automated exception search integrated into your IDE

  5. 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
  6. 0

    SQL server 2000 -> JDBC Date Time Format Problem

    Google Groups | 1 decade ago | mukesh bhakta
    java.sql.SQLException: [Microsoft][ODBC SQL Server Driver][SQL S erver]The conversion of a char data type to a datetime data type resulted in an out-of-range datetime value.

    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] 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.

      at sun.jdbc.odbc.JdbcOdbc.createSQLException()
    2. sun.jdbc.odbc
      JdbcOdbcStatement.executeQuery
      1. sun.jdbc.odbc.JdbcOdbc.createSQLException(JdbcOdbc.java:6958)
      2. sun.jdbc.odbc.JdbcOdbc.standardError(JdbcOdbc.java:7115)
      3. sun.jdbc.odbc.JdbcOdbc.SQLExecDirect(JdbcOdbc.java:3111)
      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:188)
      1 frame
    4. mondrian.rolap
      SqlStatement.execute
      1. mondrian.rolap.SqlStatement.execute(SqlStatement.java:124)
      1 frame
    5. mondrian.resource
      MondrianResource$_Def0.ex
      1. mondrian.resource.MondrianResource$_Def0.ex(MondrianResource.java:760)
      1 frame
    6. mondrian.olap
      Util.newError
      1. mondrian.olap.Util.newInternal(Util.java:1187)
      2. mondrian.olap.Util.newError(Util.java:1203)
      2 frames
    7. mondrian.rolap
      RolapConnection.<init>
      1. mondrian.rolap.SqlStatement.handle(SqlStatement.java:208)
      2. mondrian.rolap.SqlStatement.execute(SqlStatement.java:138)
      3. mondrian.rolap.RolapUtil.executeQuery(RolapUtil.java:285)
      4. mondrian.rolap.SqlTupleReader.prepareTuples(SqlTupleReader.java:330)
      5. mondrian.rolap.SqlTupleReader.readTuples(SqlTupleReader.java:443)
      6. mondrian.rolap.SqlMemberSource.getMembersInLevel(SqlMemberSource.java:431)
      7. mondrian.rolap.SqlMemberSource.getMembersInLevel(SqlMemberSource.java:422)
      8. mondrian.rolap.SqlMemberSource.getMembersInLevel(SqlMemberSource.java:411)
      9. mondrian.rolap.SqlMemberSource.getRootMembers(SqlMemberSource.java:448)
      10. mondrian.rolap.SmartMemberReader.getRootMembers(SmartMemberReader.java:161)
      11. mondrian.rolap.RolapUtil.lookupMemberInternal(RolapUtil.java:129)
      12. mondrian.rolap.RolapUtil.lookupMember(RolapUtil.java:98)
      13. mondrian.rolap.SmartMemberReader.lookupMember(SmartMemberReader.java:253)
      14. mondrian.rolap.RolapHierarchy.init(RolapHierarchy.java:298)
      15. mondrian.rolap.RolapDimension.init(RolapDimension.java:194)
      16. mondrian.rolap.RolapCube.init(RolapCube.java:1072)
      17. mondrian.rolap.RolapCube.<init>(RolapCube.java:262)
      18. mondrian.rolap.RolapSchema.load(RolapSchema.java:436)
      19. mondrian.rolap.RolapSchema.load(RolapSchema.java:335)
      20. mondrian.rolap.RolapSchema.<init>(RolapSchema.java:216)
      21. mondrian.rolap.RolapSchema.<init>(RolapSchema.java:79)
      22. mondrian.rolap.RolapSchema$Pool.get(RolapSchema.java:904)
      23. mondrian.rolap.RolapSchema$Pool.get(RolapSchema.java:715)
      24. mondrian.rolap.RolapConnection.<init>(RolapConnection.java:149)
      25. mondrian.rolap.RolapConnection.<init>(RolapConnection.java:80)
      25 frames
    8. mondrian.olap
      DriverManager.getConnection
      1. mondrian.olap.DriverManager.getConnection(DriverManager.java:190)
      2. mondrian.olap.DriverManager.getConnection(DriverManager.java:131)
      2 frames
    9. mondrian.test
      TestContext.assertQueryReturns
      1. mondrian.test.TestContext.getFoodMartConnection(TestContext.java:211)
      2. mondrian.test.TestContext.getConnection(TestContext.java:192)
      3. mondrian.test.TestContext.executeQuery(TestContext.java:424)
      4. mondrian.test.TestContext.assertQueryReturns(TestContext.java:662)
      4 frames
    10. mondrian.rolap
      RolapResultTest.testAll
      1. mondrian.rolap.RolapResultTest.testAll(RolapResultTest.java:100)
      1 frame
    11. 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
    12. mondrian.test
      MondrianTestRunner$2.run
      1. mondrian.test.MondrianTestRunner$2.run(MondrianTestRunner.java:130)
      1 frame
    13. Java RT
      Thread.run
      1. java.lang.Thread.run(Thread.java:595)
      1 frame