Blank page when loading Advanced Roadmaps plan in Jira Data Center
Platform Notice: Data Center Only - This article only applies to Atlassian apps on the Data Center platform.
Note that this KB was created for the Data Center version of the product. Data Center KBs for non-Data-Center-specific features may also work for Server versions of the product, however they have not been tested. Support for Server* products ended on February 15th 2024. If you are running a Server product, you can visit the Atlassian Server end of support announcement to review your migration options.
*Except Fisheye and Crucible
Summary
A specific user experiences a completely blank page when attempting to open an Advanced Roadmaps plan, while other users can access the same plan without issues.
Environment
Jira Software Data Center 8.15.x and above.
Diagnosis
Looking into the HAR file collected during plan loading, the HTTP response is 200 OK, and the user has FullEditor permission:
Request URL https://jira.xxxx.xxxx.xxx:xxxx/jira/secure/PortfolioPlanView.jspa?id=730&sid=786 Request Method GET Status Code 200 OKThe user's active view has been modified. The
Content-lengthin this view's preferences is extremely large, containing hundreds of expanded issue/team combinations:Request URL:https://jira.xxxx.xxxx.xxx:xxxx/jira/rest/jpo/1.0/plans/730/userProperties/viewSwitching-modifiedView-3207 Request Method:GET Status Code:200 Remote Address:xx.xxx.x.xxxx Response: Connection:keep-alive Content-Length:5276
Cause
The issue is caused by a bloated or corrupted user preference state for a specific plan view. When a user heavily modifies a view (such as expanding hundreds of issue and team combinations), the stored metadata becomes too large. The frontend JavaScript fails to render the page while processing this oversized view state, resulting in a blank screen.
Solution
To resolve this issue, you must bypass or reset the corrupted view preferences for the affected user. Follow these methods in order.
Method 1: Switch to a predefined view
If you can access the plan by impersonating the user, or if the user can briefly see the UI before it goes blank, try switching the view settings :
Open the affected Advanced Roadmaps plan.
Locate the Views switcher menu (usually labelled with the current view's name, such as Basic).
Select an unmodified predefined view or a different saved view that is known to work for other users.
If the plan loads correctly, save this as a new view or continue using the working view.
Method 2: Clear plan preferences via the database
Warning: Backup your database before proceeding.
Before running any SQL in this article, create a full backup of your Jira database. This is a database-level operation with no undo other than restoring from backup. Only proceed if you're comfortable running SQL directly against the Jira database, and test on a staging or cloned environment first, wherever possible.
If the page is completely inaccessible, you must manually clear the user's stored preferences from the Jira database. This will reset the user's view to the plan defaults.
Identify the USER_KEY for the affected user and the PLAN_ID of the problematic plan.
Run the following SQL in the Jira Database to locate the specific preference rows:
SELECT * FROM "AO_D9132D_PLAN_USER_PROPERTY" WHERE "USER_KEY" = '<USER_KEY>' AND "PLAN_ID" = '<PLAN_ID>';After confirming the results match the affected user and plan, delete those rows:
DELETE FROM "AO_D9132D_PLAN_USER_PROPERTY" WHERE "USER_KEY" = '<USER_KEY>' AND "PLAN_ID" = '<PLAN_ID>';Ask the user to reload the plan in their browser.
Was this helpful?