Searched on Google with the first line of a JAVA stack trace?

We can recommend more relevant solutions and speed up debugging when you paste your entire stack trace with the exception message. Try a sample exception.

Recommended solutions based on your search

Solutions on the web

via Pentaho BI Platform Tracking by Julian Hyde, 2 years ago
Mondrian Error:XMLA MDX execute failed
via Pentaho BI Platform Tracking by Julian Hyde, 1 year ago
Mondrian Error:XMLA MDX execute failed
via Pentaho BI Platform Tracking by Dhwani Katagade, 2 years ago
via Pentaho BI Platform Tracking by Dhwani Katagade, 1 year ago
via Pentaho BI Platform Tracking by Old Triage User, 1 year ago
Mondrian Error:XMLA MDX execute failed
via Pentaho BI Platform Tracking by Sebastian Penhouet, 1 year ago
XMLA MDX execute failed
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.0select {[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 ROWSfrom [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 moreCaused 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 moreCaused 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