3448909 - FATAL 1001 unique constraint violated error occurs for Learning History Connector - SuccessFactors Learning

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

SAP SuccessFactors Learning

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"

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.

To resolve this issue, ensure that the records being inserted do not already exist in the database.

FATAL 1001, Learning History Connector, record rejection, database, primary key constraints, duplicate records , KBA , LOD-SF-LMS-CON , Connectors , Problem