Uploaded image for project: 'Pentaho Analysis - Mondrian'
  1. Pentaho Analysis - Mondrian
  2. MONDRIAN-286

NullPointerException for certain mdx using [Sales 2]

    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

      RolapStar #73 introduced this bug

      Following mdx fails with NullPointerException when run in cmdrunner:

      with member [Time].[COG_OQP_USR_Aggregate(Time)] as 'Aggregate(

      {[Time].DefaultMember}

      )', SOLVE_ORDER = 4.0
      select NON EMPTY

      {[Product].[Product Department].Members}

      DIMENSION PROPERTIES PARENT_LEVEL, PARENT_UNIQUE_NAME ON COLUMNS,
      NON EMPTY [Time].Members}, {[Time].[COG_OQP_USR_Aggregate(Time)] DIMENSION PROPERTIES PARENT_LEVEL, PARENT_UNIQUE_NAME ON ROWS,

      {[Measures].[Unit Sales]}

      DIMENSION PROPERTIES PARENT_LEVEL, PARENT_UNIQUE_NAME ON PAGES
      from [Sales 2];

      RolapHierachy #61 rewriteRelationWithAliases throws null pointer exeception at line 621 as starTable instance is null

      RolapStar.cubeToRelationNamesToStarTableMapMap does not have any entry added for [Sales 2].

      If the [Sales 2] cube definition is moved to the 1st position in FoodMart.xml then this query executes successfully.

      In RolapStar - synchronized Table addJoin() moving following lines

      Map<String, RolapStar.Table> map =
      star.getRelationNamesToStarTableMap(cube);
      String relationNames =
      relation.toString() + relation.getAlias();
      map.put(relationNames, starTable);

      after if (starTable == null) block seems to resolve this issue

        Attachments

          Activity

            People

            • Assignee:
              ruchen Rushan Chen
              Reporter:
              ajit_joglekar ajit_joglekar
            • Votes:
              0 Vote for this issue
              Watchers:
              0 Start watching this issue

              Dates

              • Created:
                Updated:
                Resolved: