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

Enterprise Insights: large values on Epic Intake/Benefit tab breaks the SSIS ETL

XMLWordPrintable

    • 1
    • Severity 3 - Minor
    • No

      Issue Summary

      If a very large int value is entered on the Intake/Benefit tab of an Epic, the SSIS ETL breaks trying to convert the nvarchar to int, which stops the load of the data. See some screenshots with the scenario:

      Steps to Reproduce

      1. In Jira Align, create an Epic
      2. Have an Intake and Case Development associated with it
      3. Now add a very large number to Intake or Case Development and save
      4. Wait for the ETL to run
      5. Check ETL logs

      Expected Results

      ETL would run normally no matter the value used.

      Actual Results

      ETL breaks trying to convert the nvarchar to int

      Workaround

      The item with the offending value needs to be corrected, to remove it, allowing the ETL to run once again.

        1. epic_intake.png
          epic_intake.png
          122 kB
        2. etl_failure.png
          etl_failure.png
          63 kB
        3. image-2024-11-05-17-59-22-495.png
          image-2024-11-05-17-59-22-495.png
          359 kB

              942a0c021598 Melissa Hartsock
              a8cff3407f0b Diego Larangeira
              Votes:
              2 Vote for this issue
              Watchers:
              5 Start watching this issue

                Created:
                Updated:
                Resolved: