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

Forecast Report Page Performance Issue

XMLWordPrintable

    • 1
    • Severity 1 - Critical
    • No

      Issue Summary

      Timeout/exception errors when attempting to expand the Program Increment list for a large portfolio of 5 or more programs during peak hours.
      Loading Smaller datasets and/or loading the data outside peak hours works correctly

      Steps to Reproduce

      It is required to have a high volume of data.

      1. During peak hours, for example: in the US the issue was observed at 08:15 PM UTC
      2. Go to Forecast Report
      3. Set the Configuration to a Portfolio or list of Programs that have one Program Increment in common
      4. Select View Type: Agile by Program
      5. Click on the > symbol to Expand the Program Increment

      Expected Results

      Program Increment expand correctly

      Actual Results

      After 60 seconds a Cloudflare warning is shown on the browser, the Program Increment never complete expanding 

      The Below warning are identified regarding performance for RPM_GET_FORECAST_MASS_UPD_REPORT

      { [-]
         ASP_function: OOFunctionsSql.LogToSqlTiming
         correlationid: sKV2HkkLnFke8885oWozu5kDLsIY26JdNKiTwf5pLPY=
         customer_db: XXXXXXX
         log_type: warning
         logfrom_location: Website-ASP
         sql: EXEC RPM_GET_FORECAST_MASS_UPD_REPORT ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?
         sqlCount: 101
         sqlFunction: SetRSParams
         sqlTime: 3607
         timestamp: 2021-05-27T11:56:48.850000-04:00
         url: https://XXXXXXX.jiraalign.com:443/Forecast/ajax/ForecastSortReleaseTable.asp?ReleaseID=99&ViewBy=1&ViewType=1
         urlverb: POST
         user: 7060
         version: 10.94.0.17591
      }
      

      Workaround

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

              eac07d2d8a35 Roman Koshovskyi (Inactive)
              7b5a6a24aeb0 Allan Silva
              Votes:
              6 Vote for this issue
              Watchers:
              8 Start watching this issue

                Created:
                Updated:
                Resolved: