Issue Summary

EI view [MAP Objective to Epic], as for some of their Objectives, the count of items on the UI x EI doesn't match.

This is reproducible on Data Center: yes

Steps to Reproduce

1. Create an Objective in Jira Align for a specific Program
2. Create multiple Epics and Capabilities related to a specific Program
3. In the Objective panel screen add the Epics and Capabilities created to relate the Objective to all Epics created.
4. After waiting the ETL job to run, execute the following SQL query and check if the Epics listed to Objetive match with the ones listed in Jira Align UI.

   select * from current_dw.[MAP Objective to Epic]
   where [FK Objective ID]=1261

5. Remove one of the Epics of the Objective and wait for the ETL job to run, check in the view the Epic will be removed on current_dw schema, it will show with deleted flag in export_dw schema
6. Add back the removed Epic to the Objective and wait for the ETL job to run, check in the view the Epic will be added back on the current_dw schema.

SQL Query:

select * from current_dw.[MAP Objective to Epic]
where [FK Objective ID]=1261

Interestingly when we look at the below screenshot, we can see that on upd_map_objective_epic, the ones that are appearing on EI have the [fk capability id] as null, while all the other ones have it as the same as the [fk epic id] (and this is the point I believe your comment touches, and why they are missing)

Expected Results

All Epics and Capabilities to reflect in [MAP Objective to Epic] in Enterprise Insights as the Portfolio Epics list for the Objective in JA UI.

Actual Results

Only Epics are listed in [MAP Objective to Epic] in Enterprise Insights

Workaround

No workaround available.