SAP Knowledge Base Article - Public

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


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 


SAP SuccessFactors Learning Management System (LMS) - All Supported Versions


In this case, the Region ID set to the deleted user does not exist in LMS anymore.


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


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


SAP SuccessFactors Learning all versions