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

[JIRAALIGN-2178] Program Increment Progress Report time out error

    XMLWordPrintable

Details

    • 10
    • Severity 2 - Major
    • No

    Description

      Issue Summary

      When trying to access Program Increment Progress Report it fails with the error
      "Whoops... Something when wrong while displaying this page"

      Steps to Reproduce

      1. Set Tier 1 filter to a Program Increment
      2. Navigate to Program > Track > Program Increment Progress

      Expected Results

      Report to render correctly

      Actual Results

      Depending on the amount of data the report does not load and fails with the error "Whoops"
      At the browser data we see that "ReleaseBurnDown" took 31 seconds:

      In The logs, the query timed out

         ASP_function: OOFunctionsSql.SetRSParamsCursor
         correlationid: edUpPdpdSiPJ7l/6hIg+iFTElNEZTACpHWIlpPIUK/o=
         customer_db: XXXXXXX
         error_description: Query timeout expired
         error_id: 29701
         error_number: -2147217871
         error_source: Microsoft SQL Server Native Client 11.0
         log_type: exception
         logfrom_location: Website-ASP
         sql: exec RPM_GET_STORY_POINTS_TREND_FOR_RELEASE ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?
         timestamp: 2020-10-13T12:24:15.588000-04:00
         url: https://XXXXXXX.jiraalign.com:443/ReleaseBurndown.asp?FirstTime=True
         urlverb: GET
         user: A543123
         version: 10.80.0.9728
      

      Workaround

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

      Proposal

      https://hello.atlassian.net/wiki/spaces/JALN/pages/2192935524/Program+Increment+Performance+Improvements

      Attachments

        Issue Links

          Activity

            People

              940aaf7b0db4 Sheila Kelly
              7b5a6a24aeb0 Allan Silva
              Votes:
              8 Vote for this issue
              Watchers:
              24 Start watching this issue

              Dates

                Created:
                Updated:
                Resolved:

                Backbone Issue Sync