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

RPM_GET_MILESTONE_LIST function datatype limitation is being reached

    XMLWordPrintable

Details

    • 2
    • Severity 2 - Major
    • No

    Description

      Issue Summary

      The Stored Proc RPM_GET_MILESTONE_LIST has a character limit of 8000 but we are seeing instances where a long list of programs will reach this limit quickly. This should be updated to use large object datatype.

      Steps to Reproduce

      1. Have program names in a portfolio that exceed 8000 characters when concatenated for this query.
        Example use: Loading Portfolio Objectives

      Expected Results

      Query should run and list all available programs

      Actual Results

      Query runs and reaches error:

      STRING_AGG aggregation result exceeded the limit of 8000 bytes. Use LOB types to avoid result truncation.
      

      Workaround

      Reduce Program Names to fall under 8000 character limit.

      Attachments

        Issue Links

          Activity

            People

              dfuller@atlassian.com Don Fuller
              120524bf6ade Jose Sanchez
              Votes:
              3 Vote for this issue
              Watchers:
              11 Start watching this issue

              Dates

                Created:
                Updated:
                Resolved:

                Backbone Issue Sync