Top navigation bar disappears after upgrade
Platform Notice: Data Center Only - This article only applies to Atlassian products 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
Problem
After upgrading JIRA, the top navigation bar has disappeared. The issue only happens to few users. For other users, the top bar shows up fine.=
There is nothing strange in the logs.
Diagnosis
For the users that do not have the top navigation bar also have a broken avatar in their profile page.
Searching for the default avatar id in the database returns null :
1
select * from propertystring where id in (select id from propertyentry where property_key like '%avatar.user.default%'); Cause
The default user avatar setting is missing in the instance. This is the reason why the avatar for these users is broken. Due to the same reason, the top navigation bar is also missing.
Solution
Resolution
In order to fix the issue we need to insert the default user avatar in the database :
Run this query in the database and note the id:
1select id from propertyentry where property_key like '%avatar.user.default%' ;Run this query and note the id:
1select id from avatar where filename like 'Avatar-default%';Insert the following data in database
1insert into propertystring values (<id from step 1>,<id from step 2>);
Always back up your data before making any database modifications. If possible, test any alter, insert, update, or delete SQL commands on a staging server first.
Was this helpful?