Issue Summary

Enterprise Insights v11.18 doesn't interpret correctly when a Work Item is canceled in Jira Align; this issue may also occur when a work item is canceled in Jira and then synchronized with Jira Align.

When a work item is canceled, the Enterprise Insights schema and table called export_dw.[Features] sets the “Canceled Flag” as “No”, and sets the “Deleted Flag” as “Yes”.

Additionally, the export_dw.[Features History] is setting both columns “Canceled Flag” and “Deleted Flag” as “Yes”.Steps to Reproduce

Steps to Reproduce

1. In Jira or Jira Align, cancel a Feature
   1. In case it was in Jira, wait for the sync from Jira to Jira Align
2. In Jira Align, confirm that the Feature is presented in the Canceled Item
   1. For that go to Feature → More Actions → Access Canceled Items
3. Wait for the sync from Jira Align to EI
4. Go to EI and query for the work item canceled in the [Feature] table and in the [Feature History]

• • select [Canceled Flag], [Deleted Flag], [Feature ID], [Feature Name] from export_dw.[Feature] where [Feature ID] = FEATURE_ID;

• • select [Canceled Flag], [Deleted Flag], [FK Feature ID], [Feature Name] from export_dw.[Feature History] where [FK Feature ID] = FEATURE_ID;

Expected Results

The EI flags correctly the work item canceled in the [Feature] and [Feature History] tables, where the “Canceled Flag” column is set as “Yes”

Actual Results

The EI flags don’t correctly indicate the work item canceled in the [Feature] and [Feature History] tables, where the “Canceled Flag” column is set as “Yes”

Workaround

There is currently no known workaround for this behavior. A workaround will be provided here once available.