Symptom
An attempt to purge an inactive user resulted in an error: DRTMMasterPurgeApiOptionProfileObjectType SQLException caught
Environment
SAP SuccessFactors HCM Suite
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 who is being purged.
Resolution
Go to Manage API Option Profile page to delete profile data for the user. After this proceed the purge again.
Keywords
DRTM, Master Data Purge, Purge Error, inactive user, SAP SuccessFactors, sfsf, DRTMMasterPurgeApiOptionProfileObjectType, SQLException. , KBA , LOD-SF-PLT-DRM , Data Retention Management , Problem
SAP Knowledge Base Article - Public