SAP Knowledge Base Article - Public

2670213 - SF User Connector error: "Could not get deleted student record"

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

Product

SAP SuccessFactors Learning all versions