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

Failure/Extreme slowness in loading program board


    • 3
    • Severity 1 - Critical
    • No

      Issue Summary

      • During PI planning week, there is extreme slowness/failures in loading Jira Align
      • ProgramBoard fails to load with 500 error dues to SQL Query Timeout
      • Roadmap page failing to load which is being addressed in JIRAALIGN-4548.

        Steps to Reproduce

      > Cannot be replicated on demand. Next PI planning is after a few months.

      Expected Results

      > No slowness/failures to load pages during high usage days i.e. PI planning week.

      Actual Results

      The below exception is thrown in the IIS log:

      2022-12-09 06:13:00 POST /AddStory |289|80040e31|Query_timeout_expired 443 568 Mozilla/5.0+(Windows+NT+10.0;+Win64;+x64)+AppleWebKit/537.36+(KHTML,+like+Gecko)+Chrome/ https://xxxxx.jiraalign.com/ProgramBoard?FirstTime=True&stfilter=true&Solutions=6&Releases=16 500 0 0 30102

      The below exception is thrown in the ASP log

         ASP_function: OOFunctionsSql.SetRSParamsCursor
         correlationid: igFLJAykr8VW6onxq7HqrKhqRghJw9v/j1U1lkphpb4=
         customer_db: xxxxxxxx
         error_description: Query timeout expired
         error_id: 5549
         error_number: -2147217871
         error_source: Microsoft SQL Server Native Client 11.0
         log_type: exception
         logfrom_location: Website-ASP
         sql: EXEC RPM_PROGRAM_BOARD_REPORT 39,'16',1,1,1,1,1,1,1,1,NULL,NULL,NULL,NULL,NULL,NULL,'-1','-1', NULL, NULL
         timestamp: 2022-12-08T01:14:22.717000-05:00
         url: https://xxxxxxx.jiraalign.com:443/ProgramBoard.asp?FirstTime=True&Programs=39&Releases=16
         urlverb: GET
         user: 4287


      Currently, there is no known workaround for this behaviour.

            dfuller@atlassian.com Don Fuller
            1b55d4e67612 Manideep Neeli
            3 Vote for this issue
            16 Start watching this issue