Live Roadmap is not loading the grid

Problem

On Jira Align, the Roadmap screen is not loading the "Roadmap Chart" when a "Team" is selected in the T1 bar.

Environment

Jira Align Cloud 10.112.2

Steps to Reproduce

1. On the T1 bar, select a "Team" and a "PI"
2. Go to Roadmap
3. Select the "Work" View

Expected Results

The live Roadmap loads the full page.

Actual Results

The live Roadmap is not loading the page when a "Team" is selected in the T1 bar.

The problem is a timeout when depending on the criteria selected based on the configuration bar filter.

• Request URL: https://XXXXXX.jiraalign.com/privateapi/roadmaps/capabilities?ReleaseType=ran_ids&ViewByPrimaryProgramOn=false&IsUnassigned=0&SkipNumber=0&TakeNumber=25&IsObjectivesOn=false&MonthByQuarter=false&SortingType=5&IsGroupByOn=false
• Request Method: POST
• Status Code: 500
• Message:

  • • {"Timestamp":"2022-11-03T17:42:24.4604467-04:00","Level":"Fatal","MessageTemplate":"API","RenderedMessage":"API","Exception":"System.Data.SqlClient.SqlException (0x80131904): Execution Timeout Expired. The timeout period elapsed prior to completion of the operation or the server 
      is not responding.

Checking the IIS log, we can see an error 500 related to the timeout problem:

2022-11-03 21:42:24 172.22.16.20 POST /privateapi/roadmaps/capabilities ReleaseType=ran_ids&ViewByPrimaryProgramOn=false&IsUnassigned=0&SkipNumber=0&TakeNumber=25&IsObjectivesOn=false&MonthByQuarter=false&SortingType=5&IsGroupByOn=false 443 27871 172.22.19.70 Mozilla/5.0+(Windows+NT+10.0;+Win64;+x64)+AppleWebKit/537.36+(KHTML,+like+Gecko)+Chrome/107.0.0.0+Safari/537.36 https://XXXXXX.jiraalign.com/Roadmaps?Teams=XXX&Releases=XXX 500 0 0 30019

Workaround

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

Notes