Symptom
JAVA Error below is thrown while records from BizX are loaded into LMS via SF User Connector:
Unexpected Error.retrieveDeletedStudentRecord(): Could not get deleted student record.
java.sql.SQLIntegrityConstraintViolationException: ORA-02291: integrity constraint (CUSTOMER_STAGE_TMS.FK_STUD__REGION) violated - parent key not found
ORA-06512: at "CUSTOMER_STAGE_TMS.PKG_STUDENT", line 3383
ORA-06512: at line 1
Environment
SAP SuccessFactors Learning Management System (LMS) - All Supported Versions
Cause
In this case, the Region ID set to the deleted user does not exist in LMS anymore.
Resolution
Create the missing Region in LMS. In case you need to find out what Region ID is missing, it will be required a custom report that brings data from deleted users.
- select * from ph_student where action = 'D'
If further assistance to build a custom report is required, you may engage a Partner or SAP Professional Services.
See Also
2149831 - To contact Professional Services, Partner and Account/Finance Team
Keywords
SF User connector error, parent key not found, Could not get deleted student record, integrity constraint, CUSTOMER_STAGE_TMS.FK_STUD__REGION, ORA-02291 , KBA , LOD-SF-LMS-CON , Connectors , Problem