Pentaho Analysis - Mondrian
  1. Pentaho Analysis - Mondrian
  2. MONDRIAN-257

Crossjoin gives "Execute unparse results" error in XMLA

    Details

    • Type: Bug Bug
    • Status: Closed
    • Priority: Severe Severe
    • Resolution: Fixed
    • Affects Version/s: None
    • Fix Version/s: None
    • Component/s: None
    • Labels:
      None

      Description

      Matt Campbell wrote:

      > I'm seeing a new error in Mondrian when running
      > through XMLA. If I run a query like the following:
      >
      > SELECT CrossJoin({[Product].[All Products].children},
      > {[Customers].[All Customers].children}) ON columns
      > FROM Sales
      >
      > Mondrian throws the following exception:
      > mondrian.xmla.XmlaException: Mondrian Error:XMLA
      > Execute unparse results error
      >
      > Queries without crossjoins work fine for me, and
      > crossjoin queries run fine outside of XMLA. Has anyone
      > else seen this behavior?

      I have reproduced this. I have checked in a testcase (disabled) into XmlaBasicTest.

      Richard, Over to you.

        Activity

        Hide
        Mondrian Importer User added a comment -
        {jhyde}, 02/06/2007: IP, Artifact Created: 64.81.57.79 |
        {emberson}, 02/08/2007: IP, Comment Added: 209.172.110.66 |
        {emberson}, 02/08/2007: IP, Comment Added: 209.172.110.66 |
        {emberson}, 02/08/2007: status_id, 1 |
        {emberson}, 02/08/2007: close_date, 0
        Show
        Mondrian Importer User added a comment - {jhyde}, 02/06/2007: IP, Artifact Created: 64.81.57.79 | {emberson}, 02/08/2007: IP, Comment Added: 209.172.110.66 | {emberson}, 02/08/2007: IP, Comment Added: 209.172.110.66 | {emberson}, 02/08/2007: status_id, 1 | {emberson}, 02/08/2007: close_date, 0
        Hide
        Mondrian Importer User added a comment -
        {emberson}, 02/08/2007: Logged In: YES
        user_id=543347
        Originator: NO

        Caused by: java.lang.UnsupportedOperationException:
        mondrian.rolap.RolapAxis$MemberArrayIterable$MIPosition.get
        at mondrian.util.UnsupportedList.get(UnsupportedList.java:48)
        at mondrian.xmla.XmlaHandler$MDDataSet_Multidimensional.calculate
        DisplayInfo(XmlaHandler.java:1598)
        at mondrian.xmla.XmlaHandler$MDDataSet_Multidimensional.writeMember(XmlaHandler.java:1537)
        at mondrian.xmla.XmlaHandler$MDDataSet_Multidimensional.axis(XmlaHandler.java:1504)
        at mondrian.xmla.XmlaHandler$MDDataSet_Multidimensional.axes(XmlaHandler.java:1400)
        at mondrian.xmla.XmlaHandler$MDDataSet_Multidimensional.unparse(XmlaHandler.java:1243)
        at mondrian.xmla.XmlaHandler.execute(XmlaHandler.java:269)
        ... 27 more
        Show
        Mondrian Importer User added a comment - {emberson}, 02/08/2007: Logged In: YES user_id=543347 Originator: NO Caused by: java.lang.UnsupportedOperationException: mondrian.rolap.RolapAxis$MemberArrayIterable$MIPosition.get at mondrian.util.UnsupportedList.get(UnsupportedList.java:48) at mondrian.xmla.XmlaHandler$MDDataSet_Multidimensional.calculate DisplayInfo(XmlaHandler.java:1598) at mondrian.xmla.XmlaHandler$MDDataSet_Multidimensional.writeMember(XmlaHandler.java:1537) at mondrian.xmla.XmlaHandler$MDDataSet_Multidimensional.axis(XmlaHandler.java:1504) at mondrian.xmla.XmlaHandler$MDDataSet_Multidimensional.axes(XmlaHandler.java:1400) at mondrian.xmla.XmlaHandler$MDDataSet_Multidimensional.unparse(XmlaHandler.java:1243) at mondrian.xmla.XmlaHandler.execute(XmlaHandler.java:269) ... 27 more
        Hide
        Mondrian Importer User added a comment -
        {emberson}, 02/08/2007: Logged In: YES
        user_id=543347
        Originator: NO

        checkin 8684
        Quick fix: have XmlaHandler always request a LIST
        rather than an ITERABLE.
        Show
        Mondrian Importer User added a comment - {emberson}, 02/08/2007: Logged In: YES user_id=543347 Originator: NO checkin 8684 Quick fix: have XmlaHandler always request a LIST rather than an ITERABLE.
        Hide
        Gretchen Moran added a comment -
        Temporary open to allow setting the resolution field.
        Show
        Gretchen Moran added a comment - Temporary open to allow setting the resolution field.
        Hide
        Gretchen Moran added a comment -
        Bulk changed the resolution field from NONE to FIXED in order for JIRA to report properly.
        Show
        Gretchen Moran added a comment - Bulk changed the resolution field from NONE to FIXED in order for JIRA to report properly.

          People

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

            Dates

            • Created:
              Updated:
              Resolved: