Uploaded image for project: 'Jira Align'
  1. Jira Align
  2. JIRAALIGN-8042

Creating capability using Import functionality in Jira Align creates incorrect data in Enterprise Insights

    • 1
    • Severity 2 - Major
    • No

      Issue Summary

      The "Program Increment List" column in the "Capability History" table shows incorrect data when multiple capabilities are created using the Import functionality

      As a result, the EI data will show a [Program Increment List] column for the [Capability History] table, with the Incorrect data. It displays PIs that are not assigned to the Capability.

      Steps to Reproduce

      1. Create an Excel file to import multiple capabilities (with PI information) (following steps outlined in the help page: https://help.jiraalign.com/hc/en-us/articles/115000088674-Import-objects-via-Excel-overview)
      2. Wait for the Enterprise Insight replication to complete
      3. Run, for example, the following query
        select [Capability Fact Valid To], [FK Capability ID], [Program Increment List] from current_dw.[Capability History] 
        where [FK Capability ID] > "imported Capability ID"
        

      Expected Results

      The "Program Increment List" column should not display the Program Increment IDs that are not linked to Capability

      Actual Results

      "Program Increment List" displays the PIs that are not linked to the Capability

      Workaround

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

            [JIRAALIGN-8042] Creating capability using Import functionality in Jira Align creates incorrect data in Enterprise Insights

            There are no comments yet on this issue.

              942a0c021598 Melissa Hartsock
              7ae3404d318a Ashish Kumar
              Affected customers:
              0 This affects my team
              Watchers:
              2 Start watching this issue

                Created:
                Updated: