Group names showing as "empty"

[tulasi8]

Hi Community,

For one of the user in "sys_user"  table group names showing as empty. Can you please let me know the reason for this. @Ankur Bawiskar 

Regards,

Tulasi

[Dr Atul G- LNG]

https://support.servicenow.com/kb?id=kb_article_view&sysparm_article=KB0692496

In ServiceNow, when a specific user sees duplicate roles more than three times, it usually means the user has those roles assigned through multiple overlapping groups, or a recursive group structure has duplicated the entries.

How to Fix Duplicate Roles

• Check the sys_user_has_role table for direct role records linked to that user.

• Open the user profile and look at the Roles related list to see if direct and inherited roles overlap.

• Inspect the sys_group_has_role table for all groups the user belongs to.

• Look for nested groups where a group contains another group that grants the same role. [1, 2, 3, 4, 5]

Steps to Troubleshoot

• Navigate to User Administration > Users and open the affected user.

• Scroll to the Groups related list to see every group assigned to the user.

• Open each group and check the Roles related list.

• Remove duplicate group memberships or clean up nested parent-child groups that assign the same roles twice.

If you'd like, let me know:

• Are these roles assigned directly or through groups?
• Do you see the duplicates in the sys_user_has_role table?

[tulasi8]

@Dr Atul G- LNG 

Are these roles assigned directly or through groups - They are inherited from the group , only one role role that was inherited from that group it's showing same role 4k times .

• Do you see the duplicates in the sys_user_has_role table - Yes 

[Dr Atul G- LNG]

So, it means the role is coming from multiple groups. You need to check and correct the group data, buddy.

[tulasi8]

@Dr Atul G- LNG  its inherited by single group only . 

[Dr Atul G- LNG]

This could be the reason, or it might be because multiple groups have the same role assigned.