2500641 - Assignment Profile Synchronization/Propagate completes with errors: ORA-02291 integrity constraint violated - parent key not found

Assignment Profile Synchronization/Propagate completes with errors:

• Error processing (Batch # 1) ERROR MESSAGE:(SQLException - Failed in AP Student Batch create !)
• Error while processing AP (<AP_ID>) action Add Students.
• Error processing (Batch # 1) ERROR MESSAGE:(SQLException - Failed in AP Student Batch create !)
• caused by: java.sql.BatchUpdateException: ORA-02291: integrity constraint (SCHEMA.FK_STUD_QUAL_CPNT__QUAL_CPNT) violated - parent key not found

SAP SuccessFactors Learning Management System (LMS)

1. Schedule the Assignment Profile Synchronization automatic process (APM) to run regularly
2. (LMS Admin > System Admin > Automatic Processes > Assignment Profile Synchronization)
3. Note that some completions show errors:
1. Error processing (Batch # 1) ERROR MESSAGE:(SQLException - Failed in AP Student Batch create !)
2. Error while processing AP (<AP_ID>) action Add Students.
3. Error processing (Batch # 1) ERROR MESSAGE:(SQLException - Failed in AP Student Batch create !)
4. caused by: java.sql.BatchUpdateException: ORA-02291: integrity constraint (<SCHEMA>.FK_STUD_QUAL_CPNT__QUAL_CPNT) violated - parent key not found

This is caused by the deletion of Items from the Curricula being assigned via the Assignment Profile Synchronization APM while it is running

• Be sure to schedule the Assignment Profile Synchronization to run during off peak hours when modifications won't be made to the learning that the APM may be assigning
• Be sure to schedule automatic processes that could modify the learning the APM may be assigning, such as the Curricula/Program Clean-up APM
• Make sure there are not multiple Assignment Profile Propagations

To check the schedule times of the Automatic Processes in the LMS:

1. Login as a Learning Administrator
2. Navigate to System Admin > Automatic Processes
3. Click the individual APMs and check their schedule times
4. Clean-up APMs should be scheduled prior to the Synchronization APMs with enough time to complete prior to the Synchronization APMs start times

AP Assignment Profile LMS Learning Management System SF SuccessFactors java.sql.BatchUpdateException: ORA-02291: integrity constraint complete with errors exception java failed SQLException Add Student Batch FK_STUD_QUAL_CPNT__QUAL_CPNT LRN-19377 COSD-16100 Propagation , KBA , LOD-SF-LMS-ASP , Assignment Profile , LOD-SF-LMS , Learning Management System , Problem