Unable to remove group from Jira's Project Roles

Still need help?

The Atlassian Community is here for you.

Ask the community

Platform notice: Server and Data Center only. This article only applies to Atlassian products on the Server and Data Center platforms.

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

Clicking in the Remove button to delete a group from the Project Role in Jira does not actually remove group.

No errors are shown.

Environment

Jira connected to Crowd or LDAP.

Diagnosis

Group is associated to multiple User Directories with different casing.

This can be confirmed with the SQL query below in Jira's database.

select G.group_name, D.directory_name, D.directory_position 
from cwd_group G
join cwd_directory D on G.directory_id = D.id
where lower_group_name = '<group name in lower cases>'
order by D.directory_position ;

Cause

Cause 1:

Group has different casing than what is associated to the top User Directory as example below.

jira-software-users

Jira Internal Directory

0

Jira-Software-Users

Active Directory server

1

Cause 2:

No groups are returned by the query above, meaning the group has been removed from the cwd_group table but the project role reference was kept. This can happen when we have an incorrect collation in the database.


Solution

Cause 1:

  1. Move Directory with the same casing above the other directories
  2. Remove group from Project Role
  3. Move Directory to the original position

Please note moving directory position may change user's group membership and cause permission problems while the change is being made so it may be safer to schedule the fix for off-business hours.

Cause 2: 

  1. Create a new group with the same name in Jira's internal directory
  2. Remove the group from the project role
  3. Remove the group from Jira

The current behaviour of crowd/LDAP groups is that when the deletion is done from the crowd/LDAP side and it gets synched to Jira, the operation to cascade deletion of the group from roles does not happen. This is documented in the bug tickets below:

JRASERVER-70842 - Getting issue details... STATUS

JRASERVER-73108 - Getting issue details... STATUS


Last modified on Nov 23, 2022

Was this helpful?

Yes
No
Provide feedback about this article
Powered by Confluence and Scroll Viewport.