Summary

Syncing from an external user directory shows Multiple entries with same key error in the logs. The last synchronization status at the Cog icon > Overview > User Directories page mentions: "Synchronisation failed. See server logs for details."

Environment

Bamboo 7.x versions

Related to: 

BAM-20735 - Unique constraint violation while syncing an external user repository

BAM-21700 - Full Synchronisation fails between Bamboo and Crowd due to multiple users with the same External ID

CWD-5182 - Sync Failures due to duplicated External IDs

Diagnosis

java.lang.IllegalArgumentException: Multiple entries with same key errors can be found at the atlassian-bamboo.log file:

java.lang.IllegalArgumentException: Multiple entries with same key: 
[
	id=1234,
	name=newuser,
	createdDate=2020-11-06 09:46:07.0,
	updatedDate=2020-11-06 09:46:07.0,
	emailAddress=new.user@email.com,
	firstName=New,
	lastName=User,
	displayName=New User,
	lowerName=nuser,
	directoryId=123456789,
	externalId=123:0ce0e16489003840a44430bf8201bba5
] 

[
	id=5678,
	name=olduser,
	createdDate=2020-03-16 13:12:03.0,
	updatedDate=2020-10-30 17:46:14.0,
	emailAddress=old.user@email.com,
	firstName=Old,
    lastName=User,
	displayName=Old User,
	lowerName=ouser,
	directoryId=123456789,
	externalId=123:0ce0e16489003840a44430bf8201bba5
]

Cause

This error is caused by a change to one or more of the following user's information in the external user directory:

• name
• first name
• last name
• email address

Solution

1. Stop Bamboo.
2. Backup Bamboo database.
3. Get the old user id from the message found in the atlassian-bamboo.log.

4. Run the following queries against the Bamboo database:

   DELETE FROM CWD_USER_ATTRIBUTE
   WHERE USER_ID = 5678;
   
   DELETE FROM CWD_MEMBERSHIP 
   WHERE CHILD_ID = 5678;
   
   DELETE FROM CWD_USER_CREDENTIAL_RECORD
   WHERE USER_ID = 5678;
   
   DELETE FROM CWD_USER
   WHERE ID = 5678;

   Replace 5678 with the old user id found in the atlassian-bamboo.log

5. Start Bamboo back