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
回避策
Change the Group Search Filter in the User Directory Configuration so that it excludes the offending group. Example:
(&(objectclass=groupOfNames)(!(CN=Group Name)))
- 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.