Symptom
- Learning History Connector job completed with a warning: "Some records were rejected."
- The job detail shows occurrence of FATAL 1001 unexpected error "unique constraint violated".
Environment
SAP SuccessFactors Learning
Reproducing the Issue
1. Run the Learning History Connector.
2. Observe the job completion status, which shows a warning that some records were rejected.
3. View the job detail to see the occurrence of FATAL 1001 unexpected error. Detailed message example is as follows.
Unexpected Error.Error processing record:
[301]: unique constraint violated: "database schema"."PKG_LEARNINGHST_FULL_PROCESS_CPNT_EVTHST"
Cause
The FATAL 1001 unexpected error is caused by the presence of existing history records in the database.
A record with the same parameters (User Id, Item ID, Item Type ID, Item Revision Date, Completion Status, Completion Date) cannot be inserted again due to primary key constraints.
Resolution
To resolve this issue, ensure that the records being inserted do not already exist in the database.
Keywords
FATAL 1001, Learning History Connector, record rejection, database, primary key constraints, duplicate records , KBA , LOD-SF-LMS-CON , Connectors , Problem