Groups managed in Jira will not synch with Confluence
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
Symptoms
When using Jira for user management, users synch with Confluence but groups do not.
The following appears in the atlassian-confluence.log:
1
2
2012-04-12 17:09:36,847 ERROR [scheduler_Worker-1] [atlassian.crowd.directory.DbCachingDirectoryPoller] pollChanges Error occurred while refreshing the cache for directory [ 851969 ].
java.lang.IllegalArgumentException: group.name argument cannot be null or blank
Diagnosis
Run the following SQL against the JIRA database, if any results are returned then you are experiencing this issue.
Prior to JIRA 4.3
1SELECT * FROM GROUPBASE WHERE ((ID is null) OR (groupname is null));
JIRA 4.3 and above
1SELECT * FROM cwd_group WHERE ((ID is null) OR (group_name is null) OR (lower_group_name is null) OR (group_name = '') OR (lower_group_name = ''));
Cause
There is a null entry in the JIRA GROUPBASE.
Solution
Resolution
Run the follow SQL command to remove the NULL entries from the GROUPBASE table.
Create a backup of your database before running the following SQL command.
Prior to JIRA 4.3
1
DELETE FROM GROUPBASE WHERE ((ID is null) OR (groupname is null));JIRA 4.3 and above
1
DELETE FROM cwd_group WHERE ((ID is null) OR (group_name is null) OR (lower_group_name is null) OR (group_name = '') OR (lower_group_name = ''));Was this helpful?