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

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, 1 year ago
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]) ]
via Pentaho BI Platform Tracking by Julian Hyde, 2 years ago
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]) ]
via Pentaho BI Platform Tracking by janheise, 1 year ago
Internal error: %1
via Pentaho BI Platform Tracking by hhaas, 1 year ago
Internal error: not found
via Pentaho BI Platform Tracking by hhaas, 1 year ago
Internal error: not found
via Pentaho BI Platform Tracking by hhaas, 1 year ago
Internal error: while building member cache; sql=[select `product`.`brand_name` as `c0` from `product` as `product` where `product_class`.`product_subcategory` = 'Flavored Drinks' and `product_class`.`product_category` = 'Drinks' and
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 rowsfrom [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