Symptom
Failed to add/update user [123456] "TEST USER" ABCD (XXXXXXX): User is purged in database
Environment
SAP SuccessFactors HXM Suite
Reproducing the Issue
Import a user from Admin Tools->Employee Import.
OR
User is imported via "Employee Import" scheduled background job.
The error "Failed to add/update user [123456] "TEST USER" ABCD (XXXXXXX): User is purged in database" appears in the notification email.
Cause
Username and UserID are unique. Neither the username nor the userid can be mapped to more than one individual. This holds good even if the users are purged in the database.
Consider the below scenario:
At an earlier point in time, you had username 'abcd' mapped to userid 001234. Later on you decided to revise the userids to not have leading zeroes. So you purge this user id. This is how the purged user gets saved in the backend.
UserID | Username | First Name | Last Name |
001234 | abcd | Purged | User |
Now, you are trying to map the username 'abcd' to userid 1234. You will receive the error like this:
Failed to add/update user [1234] "TEST USER" ABCD (XXXXXXX): User is purged in database.
This is because username 'abcd' already exists in the system against userid '001234'. In short, there are two user IDs mapped to one username.
Resolution
- Prior to B1611 release this required support to create and run a script on your behalf. However since B1611 you can now reactivate these users via the user import. Or you can permanently purge the users using the permanent purge in data retention management tool.
- To find the steps to purge or reactivate the username and userID, refer to KBA 2088065 - Data Retention Management - Purge Data - Platform
- Once reactivated, you need to change the username corresponding to the reactivated userid to something else. For e.g. if the username 'abcd' was mapped to userid '001234', you may change the username to 'abcdx'.
- Thereafter, you can purge this user again.
Now the entry in the system is as below:
UserID | Username | First Name | Last Name |
001234 | abcdx | Purged | User |
As the username 'abcd' is no more mapped against any other userid, you should be able to import this username successfully with userid 1234.
Keywords
- import error
- purged user
- Failed to add/update user [123456] "TEST USER" ABCD (XXXXXXX): User is purged in database
- soft purge
- permanent purge