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.
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