SAP Knowledge Base Article - Public

2886381 - DRTM Master Data or Permanent Purge error "The import file contains invalid ID's"

Symptom

  • User is trying to perform System Identifier Purge or DRTM Master Data Purge and uses the template file with "Assignment ID" as identifier (in the title column).
  • User is trying to perform System Identifier Purge or DRTM Master Data Purge and receives the error "The import file contains invalid IDs".
  • Validation error shows "The import file contains invalid IDs".
  • Purge email received says "No users or user records were purged from the application because the job failed. The job failed due to: The userId list provided is not correct."

Environment

SAP SuccessFactors HCM Suite

Reproducing the Issue

  1. Navigate to Data Retention Management > System Identifier Purge
  2. Choose file
  3. Validation error shows "The import file contains invalid ID's"
  4. Ignore error and submit
  5. Go to Monitor Jobs
  6. Job execution is successful
  7. However, user receives email saying "No users or user records were purged from the application because the job failed. The job failed due to: The userId list provided is not correct."

Or

  1. Navigate to Data Retention Management > select DRTM Master Data Purge
  2. Choose file
  3. Validation error shows "The import file contains invalid ID's"

Cause

Cause 1:

There is a defect when using "Assignment ID" as the identifier/title column for System Identifier Purge or DRTM Master Data Purge file.

Cause 2:

There are some invalid IDs in the file for DRTM Master Data Purge or System Identifier Purge. It is possible that leading zeros are missing from the IDs to be purged and it causes purge to point to invalid users.

Resolution

Resolution 1:

As a workaround, you may change the "Assignment ID" title to "User ID" as the identifier in the file then proceed with the DRTM Master Data Purge or System Identifier Purge.

Resolution 2:

Kindly review the ID used in the file is the proper one by opening Employee Export (UDF) file in Notepad or Notepad++ instead of Excel. KBA 2087490 for reference.

See Also

  • 2392076 - User Permanent Purge feature
  • 2158399 - Unable to import user - Platform
  • 2615360 - DRTM Master Data Purge for Inactive Users

Keywords

permanent purge, file, assignment id, user id, the import file contains invalid IDs, no users or user records were purged from the application because job failed due to user id list is not correct, DRTM, master data purge, leading zeros , KBA , LOD-SF-PLT-DRM , Data Retention Management , LOD-SF-PLT , Platform Foundational Capabilities , Problem

Product

SAP SuccessFactors HCM Core all versions