Details

    • Type: Bug
    • Status: Closed
    • Severity: Medium
    • Resolution: Fixed
    • Affects Version/s: None
    • Fix Version/s: None
    • Component/s: None
    • Labels:
      None
    • Notice:
      When an issue is open, the "Fix Version/s" field conveys a target, not necessarily a commitment. When an issue is closed, the "Fix Version/s" field conveys the version that the issue was fixed in.

      Description

      Results: Error:
      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.internalDo
      Filter(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$StandardPipeli
      neValveContext.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$StandardPipeli
      neValveContext.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$StandardPipeli
      neValveContext.invokeNext(StandardPipeline.java:643)
      at
      org.apache.catalina.valves.ErrorDispatcherValve.invoke
      (ErrorDispatcherValve.java:171)
      at
      org.apache.catalina.core.StandardPipeline$StandardPipeli
      neValveContext.invokeNext(StandardPipeline.java:641)
      at org.apache.catalina.valves.ErrorReportValve.invoke
      (ErrorReportValve.java:172)
      at
      org.apache.catalina.core.StandardPipeline$StandardPipeli
      neValveContext.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$StandardPipeli
      neValveContext.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$Http11Connec
      tionHandler.processConnection(Http11Protocol.java:392)
      at org.apache.tomcat.util.net.TcpWorkerThread.runIt
      (PoolTcpEndpoint.java:565)
      at
      org.apache.tomcat.util.threads.ThreadPool$ControlRunna
      ble.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
      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)
      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.internalDo
      Filter(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$StandardPipeli
      neValveContext.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$StandardPipeli
      neValveContext.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$StandardPipeli
      neValveContext.invokeNext(StandardPipeline.java:643)
      at
      org.apache.catalina.valves.ErrorDispatcherValve.invoke
      (ErrorDispatcherValve.java:171)
      at
      org.apache.catalina.core.StandardPipeline$StandardPipeli
      neValveContext.invokeNext(StandardPipeline.java:641)
      at org.apache.catalina.valves.ErrorReportValve.invoke
      (ErrorReportValve.java:172)
      at
      org.apache.catalina.core.StandardPipeline$StandardPipeli
      neValveContext.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$StandardPipeli
      neValveContext.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$Http11Connec
      tionHandler.processConnection(Http11Protocol.java:392)
      at org.apache.tomcat.util.net.TcpWorkerThread.runIt
      (PoolTcpEndpoint.java:565)
      at
      org.apache.tomcat.util.threads.ThreadPool$ControlRunna
      ble.run(ThreadPool.java:619)
      at java.lang.Thread.run(Thread.java:536)
      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)
      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.internalDo
      Filter(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$StandardPipeli
      neValveContext.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$StandardPipeli
      neValveContext.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$StandardPipeli
      neValveContext.invokeNext(StandardPipeline.java:643)
      at
      org.apache.catalina.valves.ErrorDispatcherValve.invoke
      (ErrorDispatcherValve.java:171)
      at
      org.apache.catalina.core.StandardPipeline$StandardPipeli
      neValveContext.invokeNext(StandardPipeline.java:641)
      at org.apache.catalina.valves.ErrorReportValve.invoke
      (ErrorReportValve.java:172)
      at
      org.apache.catalina.core.StandardPipeline$StandardPipeli
      neValveContext.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$StandardPipeli
      neValveContext.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$Http11Connec
      tionHandler.processConnection(Http11Protocol.java:392)
      at org.apache.tomcat.util.net.TcpWorkerThread.runIt
      (PoolTcpEndpoint.java:565)
      at
      org.apache.tomcat.util.threads.ThreadPool$ControlRunna
      ble.run(ThreadPool.java:619)
      at java.lang.Thread.run(Thread.java:536)

      The problem seems to be with the implicit conversion of
      a dimension [Customers] to a member
      [Customers].DefaultMember. The workaround is to write

      ...
      where ([Time].[1997],[Customers].DefaultMember)

        Attachments

          Activity

            People

            • Assignee:
              ebengtso ebengtso
              Reporter:
              jhyde Julian Hyde
            • Votes:
              0 Vote for this issue
              Watchers:
              0 Start watching this issue

              Dates

              • Created:
                Updated:
                Resolved: