Symptoms

Error when syncing users from LDAP server. 

The following appears in the atlassian-jira.log:

com.atlassian.crowd.embedded.ofbiz.db.DataAccessException: org.ofbiz.core.entity.GenericEntityException: while inserting: [GenericEntity:Membership][id,58623][membershipType,GROUP_
GROUP][lowerParentName,pq-sales-sersol-global][parentId,10078][childId,10054][childName,PQ-Sales-SerSol-APAC][lowerChildName,pq-sales-sersol-apac][directoryId,10000][parentName,PQ-
Sales-SerSol-Global] (SQL Exception while executing the following:INSERT INTO jiraschema.cwd_membership (ID, parent_id, child_id, membership_type, group_type, parent_name, lower_pa
rent_name, child_name, lower_child_name, directory_id) VALUES (?, ?, ?, ?, ?, ?, ?, ?, ?, ?) (Cannot insert duplicate key row in object 'jiraschema.cwd_membership' with unique inde
x 'uk_mem_parent_child_type'.))

Cause

A group name was changed on the LDAP server side, such as from upper case to lower case letters. There is a known bug for this,  JRA-27353 - Getting issue details... STATUS  - please vote and watch on it for future updates from the developers.

Resolution

Please refer to the suggested workaround in JRA-27353 - Getting issue details... STATUS

 Please see our Troubleshooting LDAP User Management documentation for further assistance with diagnosing LDAP problems.