Users initials is removed from the issues on the board
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
Jira displays the initials of the first name when user has not default avatar. For e.g. In the below screenshot, the username "Rambo" assigned to KANBAN-1 issue has no default avatar and thus its initial is displayed.
However, in KANBAN-2, it displays undefined/blank on boards for some of the users
Environment
9.x.x
Diagnosis
Run below SQL by replacing the affected username, In this e.g user1 and user2 are the affected users whose initials are not displayed.
1
2
3
4
5
select pn.*,u.*, a.* from propertyentry pe
inner join propertynumber pn on pe.id = pn.id
inner join app_user u on pe.entity_id = u.id
inner join avatar a on pn.propertyvalue = a.id
where pe.property_key like '%user.avatar%' and u.lower_user_name in ('user1','user2','user3');
Cause
The default avatar record for the affected users is added by the user by navigating to the User profile page and selecting the avatar explicitly.
Solution
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.
Steps
Ensure you have a complete Database backup
Execute the SQL in the Diagnosis section to find the id of the entries in the tables
Stop Jira Servers
Delete those records from two tables i.e
propertyentryandpropertynumbertables using below sqlStart Jira Servers
Delete
1
2
delete from propertyentry where id in (10800,10804); --for e.g user1,user2
delete from propertynumber where id in (10800,10804); --for e.g user1,user2Was this helpful?