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

SAP Knowledge Base Article - Public

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

Symptom

Assignment Profile Synchronization 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

Environment

SAP SuccessFactors Learning Management System (LMS)

Reproducing the Issue

  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

Cause

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

Resolution

  • 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

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

Keywords

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 , KBA , LOD-SF-LMS-ASP , LMS AP , LOD-SF-LMS , SuccessFactors Learning , Problem

Product

SAP SuccessFactors Learning 1602