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

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