Forecast Report Page Performance Issue

XMLWordPrintable

      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

            Assignee:
            Roman Koshovskyi (Inactive)
            Reporter:
            Allan Silva (Inactive)
            Votes:
            6 Vote for this issue
            Watchers:
            8 Start watching this issue

              Created:
              Updated:
              Resolved: