-
Bug
-
Resolution: Fixed
-
Highest
-
10.114.3
-
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 172.28.0.194 POST /AddStory |289|80040e31|Query_timeout_expired 443 568 172.28.169.62 Mozilla/5.0+(Windows+NT+10.0;+Win64;+x64)+AppleWebKit/537.36+(KHTML,+like+Gecko)+Chrome/108.0.0.0+Safari/537.36+Edg/108.0.1462.46 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 version: 10.114.2.26278 }
Workaround
Currently, there is no known workaround for this behaviour.
- is related to
-
JIRAALIGN-5060 Slowness in loading Program Board
-
- Closed
-
-
ACE-3275 Loading...
- resolves
-
ACE-3281 Loading...
-
ALIGNSP-16910 Loading...
-
ALIGNSP-18199 Loading...
-
ALIGNSP-18742 Loading...
-
PS-122177 Loading...
-
PS-125044 Loading...
-
PS-125876 Loading...
-
PS-127064 Loading...