mondrian.resource.ChainableRuntimeException

mondrian.resource.ChainableRuntimeException: Internal error: Error while executing query [select {[Measures]. [Unit Sales]} ON columns, Order(Except([Promotion Media].[Media Type].Members, {[Promotion Media].[All Media].[No Media]}), [Measures].[Unit Sales], DESC) ON rows from [Sales] where ([Time].[1997], [Customers]) ] at mondrian.olap.MondrianResource.newInternal(MondrianResource.java:45) at mondrian.olap.Util.newError(Util.java:445) at mondrian.rolap.RolapConnection.execute(RolapConnection.java:213) at mondrian.web.servlet.MDXQueryServlet.processRequest(MDXQueryServlet.java:78) at mondrian.web.servlet.MDXQueryServlet.doGet(MDXQueryServlet.java:200) at javax.servlet.http.HttpServlet.service(HttpServlet.java:740) at javax.servlet.http.HttpServlet.service(HttpServlet.java:853) at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:247) at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:193) at org.apache.catalina.core.StandardWrapperValve.invoke(StandardWrapperValve.java:256) at org.apache.catalina.core.StandardPipeline$StandardPipelineValveContext.invokeNext(StandardPipeline.java:643) at org.apache.catalina.core.StandardPipeline.invoke(StandardPipeline.java:480) at org.apache.catalina.core.ContainerBase.invoke(ContainerBase.java:995) at org.apache.catalina.core.StandardContextValve.invoke(StandardContextValve.java:191) at org.apache.catalina.core.StandardPipeline$StandardPipelineValveContext.invokeNext(StandardPipeline.java:643) at org.apache.catalina.core.StandardPipeline.invoke(StandardPipeline.java:480) at org.apache.catalina.core.ContainerBase.invoke(ContainerBase.java:995) at org.apache.catalina.core.StandardContext.invoke(StandardContext.java:2415) at org.apache.catalina.core.StandardHostValve.invoke(StandardHostValve.java:180) at org.apache.catalina.core.StandardPipeline$StandardPipelineValveContext.invokeNext(StandardPipeline.java:643) at org.apache.catalina.valves.ErrorDispatcherValve.invoke(ErrorDispatcherValve.java:171) at org.apache.catalina.core.StandardPipeline$StandardPipelineValveContext.invokeNext(StandardPipeline.java:641) at org.apache.catalina.valves.ErrorReportValve.invoke(ErrorReportValve.java:172) at org.apache.catalina.core.StandardPipeline$StandardPipelineValveContext.invokeNext(StandardPipeline.java:641) at org.apache.catalina.core.StandardPipeline.invoke(StandardPipeline.java:480) at org.apache.catalina.core.ContainerBase.invoke(ContainerBase.java:995) at org.apache.catalina.core.StandardEngineValve.invoke(StandardEngineValve.java:174) at org.apache.catalina.core.StandardPipeline$StandardPipelineValveContext.invokeNext(StandardPipeline.java:643) at org.apache.catalina.core.StandardPipeline.invoke(StandardPipeline.java:480) at org.apache.catalina.core.ContainerBase.invoke(ContainerBase.java:995) at org.apache.coyote.tomcat4.CoyoteAdapter.service(CoyoteAdapter.java:223) at org.apache.coyote.http11.Http11Processor.process(Http11Processor.java:594) at org.apache.coyote.http11.Http11Protocol$Http11ConnectionHandler.processConnection(Http11Protocol.java:392) at org.apache.tomcat.util.net.TcpWorkerThread.runIt(PoolTcpEndpoint.java:565) at org.apache.tomcat.util.threads.ThreadPool$ControlRunnable.run(ThreadPool.java:619) at java.lang.Thread.run(Thread.java:536) Caused by: java.lang.ClassCastException at mondrian.olap.fun.FunUtil.getMemberArg(FunUtil.java:163) at mondrian.olap.fun.TupleFunDef.evaluate(TupleFunDef.java:61) at mondrian.rolap.RolapEvaluator.xx(RolapEvaluator.java:129) at mondrian.olap.FunCall.evaluate(FunCall.java:247) at mondrian.olap.fun.SetFunDef.evaluate(SetFunDef.java:56) at mondrian.rolap.RolapEvaluator.xx(RolapEvaluator.java:129) at mondrian.olap.FunCall.evaluate(FunCall.java:247) at mondrian.rolap.RolapResult.executeAxis(RolapResult.java:150) at mondrian.rolap.RolapResult.<init>(RolapResult.java:70) at mondrian.rolap.RolapConnection.execute(RolapConnection.java:198) ... 33 more