SAP Knowledge Base Article - Public

3507190 - DRTM Master Data Purge Error: DRTMMasterPurgeApiOptionProfileObjectType SQLException caught

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

Product

SAP SuccessFactors Platform all versions