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

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

XMLWordPrintable

    • 10
    • Severity 2 - Major
    • No

      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

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

              Created:
              Updated:
              Resolved: