SAP Knowledge Base Article - Public

3507190 - DRTM Master Data Purge Error Resolution

Symptom

- An attempt to purge an INACTIVE user resulted in an error: DRTMMasterPurgeApiOptionProfileObjectType SQLException caught

Environment

Data Retention Management

Reproducing the Issue

1. Attempt to purge an INACTIVE user.
2. Observe that the purge request completes with errors.
3. Go to purge request monitor and check the  DRTM Master Data Purge requestId
4. Completed report shows the user failed to purge with error
DRTMMasterPurgeApiOptionProfileObjectType SQLException caught  DRTMMasterPurgeApiOptionProfileObjectType 

Cause

This SQL exception is referring to an existing profile data for the user we are attempting to purge. 

Resolution

You just need to go to Manage API Option Profile page to delete profile data for the user .Then to purge this user again .

See Also

For reference, please see KBA - https://me.sap.com/notes/2088892

Keywords

DRTM, Master Data Purge, Purge Error, INACTIVE user, SAP SuccessFactors, LOD-SF-PLT-DRM, LOD-SF-PLT-AUDR, SAP SuccessFactors HCM Core, SAP SuccessFactors Recruiting, LOD-SF-PLT, Error Resolution, SF-ECT-User Management-Product , KBA , LOD-SF-PLT-DRM , Data Retention Management , Problem

Product

SAP SuccessFactors Platform all versions