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

XMLWordPrintable

      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. etl_failure.png
          63 kB
          Diego Larangeira
        2. epic_intake.png
          122 kB
          Diego Larangeira
        3. image-2024-11-05-17-59-22-495.png
          359 kB
          Akshay Joshi

            Assignee:
            Melissa Hartsock
            Reporter:
            Diego Larangeira
            Votes:
            2 Vote for this issue
            Watchers:
            5 Start watching this issue

              Created:
              Updated:
              Resolved: