Issue Summary

The [Current Value Flag] column shows Yes for multiple rows in the current_dw.[Hierarchy Health History] table for the same [FK Hierarchy ID]

This is reproducible on Data Center: (yes) 

Note: This was reported for Atlassian Analytics (AA) but Support is able to reproduce this in the underlying Enterprise Insights (EI).

This is regarding the Health status available on the Custom Room page in Jira Align UI. 

Issue:

In the Enterprise Insights [Hierarchy Health History] table, there are multiple rows with the same [FK Hierarchy ID] and having a 'Yes' value for [Current Value Flag].

There should only be one row per [FK Hierarchy ID] that is the 'Current Value' in the above EI table. EI should set only one record as current, as there is no way to have 2 records on this case that would be current.

Steps to Reproduce

• So to test this, in the Jira Align UI, from the top Custom Rooms menu, select a specific custom room/hierarchy level
• Then on the Custom Room page, on the right side, there is the Health section, which by default initially shows 'None Reported'
• Now change this Health status to something by clicking on it. For example, changing it from 'None Reported' to 'On Hold'
• Now the Health in the UI shows 'On Hold' as expected
• Once this syncs to Enterprise Insights (EI), check the EI
  current_dw.[Hierarchy Health History] table with the query similar to the below for that same hierarchy ID:

   select * from current_dw.[Hierarchy Health History] where [FK Hierarchy ID]=xx

• The above EI table will correctly reflect the Health value. It shows the correct Health value in the [Hierarchy Health] column and shows 'Yes' in the [Current Value Flag] column. This is all good at this time.

• Now go back to the same Jira Align Custom Room UI above, change Health to a different value, for example, change it to any different value such as 'Off Track'
• The UI now displays the Health as 'Off Track' correctly
• Now once this sync, check the EI database, and the same table query above again
• Notice the EI table current_dw.[Hierarchy Health History] now displays two rows for the same [FK Hierarchy ID].
• Notice in the above EI result, the past and current Health value in the  [Hierarchy Health] column which is fine but both rows show 'Yes' in the [Current Value Flag] column. This is not expected because only one Health value that is currently showing in the JA UI should have the [Current Value Flag] as 'Yes' in EI. The other past Health value should show 'No' in the [Current Value Flag] column in EI.

Expected Results

• There should be only one row per [FK Hierarchy ID] that has 'Yes' in the [Current Value Flag] in the above EI table
• The same fix should be reflected in Atlassian Analytics as well.

Actual Results

• In the Enterprise Insights table [Hierarchy Health History] table, there are multiple rows with the same [FK Hierarchy ID] and having a 'Yes' value for [Current Value Flag]

Workaround

Currently there is no known workaround for this behavior. A workaround will be added here when available