SAP Knowledge Base Article - Public

2697825 - Error Message Occurred After Importing Foundation Data - Pay Component

Symptom

You receive an error after importing foundation data Pay component.

The Import response file error shows: This operation has led to unique key constraint violation. Please check your data.

Image/data in this KBA is from SAP internal systems, sample data, or demo systems. Any resemblance to real data is purely coincidental. 

Environment

SAP SuccessFactors Employee Central - Foundation Data -Pay Component

Reproducing the Issue

Step 1:

  1. Go to import foundation data.
  2. Select Pay component.
  3. Select Full purge or ncremental Load
  4. Select the file and click on submit.

Result: Your file has been uploaded to the server successfully, and will be examined for the proper text file format. An email notification will be generated once your file has been processed indicating the final status of your request. The import/ validation process can take up to an hour, depending on the size of the uploaded file. If you do not receive an email notification regarding your process, please contact our technical support.

Step 2: Check Import Reponse file in Monitor Job

  1. Go to Monitor
  2. Download and review Response file
  3. Error: This operation has led to unique key constraint violation. Please check your data.

Cause

Data Issue caused by End Date

Resolution

Import Pay Component in full purge mode without the end-date. end-date is usually calculated by the system, hence it should be left blank.

  1. Go to import foundation data.
  2. Select Pay component.
  3. Select Full purge 
  4. Select the file and click on submit.

3332recurring.png

Keywords

Import, end-date, This operation has led to unique key constraint violation, Please check your data,foundation data,ECT-106394 , KBA , LOD-SF-EC-CMP , Compensation Information & One-Time Bonus , LOD-SF-EC-EDP , Import Employee Data (EC Core only) , LOD-SF-EC-FOO , Foundation Objects (Organisation, Pay and Job Structures) , Problem

Product

SAP SuccessFactors Employee Central all versions