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.

tip/resting Created with Sketch.

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.