Groups managed in Jira will not synch with Confluence
症状
When using Jira for user management, users synch with Confluence but groups do not.
atlassian-confluence.log
に次のエラーが返される。
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
診断
Run the following SQL against the JIRA database, if any results are returned then you are experiencing this issue.
Prior to JIRA 4.3
SELECT * FROM GROUPBASE WHERE ((ID is null) OR (groupname is null));
Jira 4.3 以降
SELECT * 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 = ''));
原因
There is a null entry in the JIRA GROUPBASE.
ソリューション
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
DELETE FROM GROUPBASE WHERE ((ID is null) OR (groupname is null));
Jira 4.3 以降
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 = ''));
最終更新日 2018 年 11 月 14 日
Powered by Confluence and Scroll Viewport.