Migrating External Memberships Fail Due to Violation of UNIQUE KEY Constraint for cwd_unique_membership

お困りですか?

アトラシアン コミュニティをご利用ください。

コミュニティに質問

症状

When running the script for migrating the external memberships in admin/migrate-external-memberships.action, it fails.

atlassian-confluence.log に次のメッセージが表示される。

2013-11-09 23:46:01,042 INFO [Long running task: Migrate External Memberships] [atlassian.crowd.directory.DelegatedAuthenticationDirectory] importMembership Imported user "Michael XYZ"'s membership of remote group "Group Name" to directory "Delegated Authentication Directory".
....
2013-11-09 23:46:01,167 ERROR [Long running task: Migrate External Memberships] [sf.hibernate.util.JDBCExceptionReporter] logExceptions Violation of UNIQUE KEY constraint 'cwd_unique_membership'. Cannot insert duplicate key in object 'dbo.cwd_membership'.

原因

There are two different entities in LDAP are found with the same value for that attribute (CN). There is a feature request for this:  CONF-23213 - Getting issue details... STATUS

回避策

  1. Change the Group Search Filter in the User Directory Configuration so that it excludes the offending group. Example:

    (&(objectclass=groupOfNames)(!(CN=Group Name)))
  2. Perform the migration again

 

If users are not able to log into Confluence after the migrations completes, please change the Group Search Filter back to the previous filter.

 

Last modified on Mar 30, 2016

この内容はお役に立ちましたか?

はい
いいえ
この記事についてのフィードバックを送信する
Powered by Confluence and Scroll Viewport.