Error while changing UserName and Email

|
Published

Scenario:

UserName and Email of user abc@xyz.com was Deactivated and later changed to def@xyz.com.

Now user def@xyz.com needs to have UserName and Email changed to abc@xyz.com. However, EUM is showing error.

Change_UserName_Email_Error.JPG

Further investigation in Extranet_API_V4 log shows

EXCEPTION: Username cannot be changed to abc@xyz.com. That username is already in use.

Solution:

The solution involves changes in the EUM Database, and would require someone who as Admin access to the database

  1. Search abc@xyz.com in User table by UserName. Verify that it does not exist.
  2. Search for abc@xyz.com in Users table by Username. Note UserId value.
  3. Search for the user in Memberships table by UserId. Delete record.
  4. Search for the user in Profiles table by UserId. Delete record.
  5. Search for the user in UsersInRoles table by UserId. Delete record.
  6. Search for the user in Users table by UserName. Delete record.

Now if in the EUM User details page for def@xyz.com, first change the username to abc@xyz.com and Update. Then change the email to abc@xyz.com and Update. Both should display Success message.