SAP Knowledge Base Article - Public

2089382 - Error - User Import Error - Duplicate Username - Platform


  • There is a user with the same Username in the system already, but with a different UserID. This describes how to add a new user with the correct Username-UserID combination.
  • Can duplicate or unwanted users be removed from the system?


  • BizX Platform


     When doing an import, you get this error message:

     User Import Process has reported error(s). You need to fix the following error(s) and re-import the users as necessary:

Failed to add/update user [tthomas] "Tina Thomas" (Sales;ACE Software;Central): Duplicate Username - "tthomas"
  • This error does not mean that your import file has two records in it causing the duplicate. While that might be the case, often the duplicate error is caused by an existing record already in your system conflicting with one new record you are trying to import that is also referring to the same username/userid.
  • To effectively troubleshoot the duplicate error you will need both your import file and  a fresh employee export file. You will want to closely compare both files looking for similar but duplicate records for the user. Be careful if your data contains leading zeros to open your data in an editor that does not strip out any values. E.g. Excel can make 000123 look like 123 making it impossible to find the duplicate.
  • This is what you want to import (abbreviated):
     STATUS,USERID,Username,First Name,Last Name,Middle Name,Gender,

  • This is what you've got in the system already:
     STATUS,USERID,Username,First Name,Last Name,Middle Name,Gender,



  • Step 1. Make user active & change username.
     STATUS,USERID,Username,First Name,Last Name,Middle Name,Gender,



  • Step 2. Import that user data file.
  • Step 3. In Admin Tools -> Set User Status, Deactivate that changed user ("tthomas_OLD").
  • Step 3. Import the original file.
     STATUS,USERID,Username,First Name,Last Name,Middle Name,Gender,


Note: This will not migrate any data from the old user to the new user. It will only create a new, completely separate, user.

  • If needed, while both records are active, login as employeeA_OLDopen any completed forms you want employeeA to have a copy of and use the "SEND COPY" button if you have that feature enabled for that form template. Copies can only be viewed and cannot be edited.
  • Use admin tools > Objective (Goal) Transfer to transfer goals to the new userID.
  • Use export/import features in admin tools for personal information, background data and trend data to associate data with the new userID.
  • IT IS NOT POSSIBLE to transfer in-progress forms to any new USERID. History for any employee will ALYAYS remain with the USERID it was launched to. You can however import historical scores (not forms) for the new userID using admin tools > Managing Documents > Import Overall Scores.
  • Once you have transferred the possible data from employeeA_OLD to employeeA as outlined above, set the status of employeeA_OLD to INACTIVE via admin tools > Manage Users > Set user Status.


Can duplicate or unwanted users be removed from the system?

  • At this time SuccessFactors does not offer an option to purge from the system user accounts/records that have been created in error or are no longer needed. While it would seem a simple task on the surface, the option should be considered from the aspect that any user record could have multiple records in many modules, with many dependencies interconnecting data for any one person and all their forms, goals, records. So even though a new record may not have this, programatically we cannot assume that is the case, and why we currently have no standard option to allow users to remove records once created. The only supported option is to set the user as INACTIVE.


KBA , sf error messages platform , sf email , sf platform , LOD-SF-PLT , Foundational Capabilities & Tools , Problem


SAP SuccessFactors HCM Core all versions