Enterprise Insights ETL does not update current_dw.[Jira Custom Team Mapping]

XMLWordPrintable

      Issue Summary

      Updates made in production on Jira Custom Team Mapping does not update in Enterprise Insights. Investigation found that ETL service doesn't update this table due to records with [Jira Project Key] = NULL being skipped in ETL, despite this being valid for some customers.

      This is reproducible on Data Center: Yes

      Steps to Reproduce

      1. Search the tables 'Jira Team Value' and 'Jira Align Team'
      2. IfNotExists – Click "Add New" at the bottom of the list
      3. At the top a new empty row will appear
      4. Enter the TeamName in the 'Jira Team Value' TextBox
      5. Select the TeamName in the 'Jira Align Team' DropDown
      6. Click "Update Teams" at the bottom of the list
      7. Validate the TeamName now exists in the list
      8. Run the following query in Enterprise Insights
       SELECT
           [Jira Custom Team Mapping ID]
          ,[Jira Team Value]
          ,[Child Team Value]
          ,[Jira Project Key]
          ,[FK Jira Align Team ID]
          ,[FK Jira Project ID]
          ,[FK Connector ID]
      FROM current_dw.[Jira Custom Team Mapping]
      

      Expected Results

      Added Custom Team Mapping ID will appear in query results.

      Actual Results

      New Custom Team Mapping ID does not appear in queries or table data in Enterprise Insights.

      Workaround

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

            Assignee:
            Sam Tsubota
            Reporter:
            Christopher Stringari
            Votes:
            1 Vote for this issue
            Watchers:
            4 Start watching this issue

              Created:
              Updated:
              Resolved: