Details

    • Type: Bug Bug
    • Status: Closed
    • Priority: Severe Severe
    • 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)

        Activity

        Hide
        Mondrian Importer User added a comment -
        {jhyde}, 08/18/2003: status_id, 1 | {jhyde}

        , 08/18/2003: resolution_id, 100 |

        {jhyde}, 08/18/2003: assigned_to, 312935 | {jhyde}

        , 08/18/2003: close_date, 0

        Show
        Mondrian Importer User added a comment - {jhyde}, 08/18/2003: status_id, 1 | {jhyde} , 08/18/2003: resolution_id, 100 | {jhyde}, 08/18/2003: assigned_to, 312935 | {jhyde} , 08/18/2003: close_date, 0
        Hide
        Mondrian Importer User added a comment -
        {jhyde}

        , 08/18/2003: Logged In: YES
        user_id=312935

        Confirmed fixed, and added testcase.

        Show
        Mondrian Importer User added a comment - {jhyde} , 08/18/2003: Logged In: YES user_id=312935 Confirmed fixed, and added testcase.

          People

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

            Dates

            • Created:
              Updated:
              Resolved: