3211937 - MDF import Job failed and show "unique constraint violated..." error in provisioning job details

MDF import Job failed and show "Full exception:com.successfactors.jobscheduler.ScheduledJobExecutionException: java.lang.RuntimeException: com.sap.db.jdbc.exceptions.SQLIntegrityConstraintViolationExceptionSapDB: [301]: unique constraint violated...." error in provisioning job details.

SuccessFactors HXM Suite

1. Import a csv file of MDF data through Import and Export Data or through provisioning MDF (FTP) import.
2. When the 1st job is running, import another csv file of the same MDF object's data in parallel.
3. Job failed. Checking from provisioning, Job failed with error "Full exception:com.successfactors.jobscheduler.ScheduledJobExecutionException: java.lang.RuntimeException: com.sap.db.jdbc.exceptions.SQLIntegrityConstraintViolationExceptionSapDB: [301]: unique constraint violated...."in provisioning job details.

This issue is due to when performing parallel import of MDF records, a duplicate NEW record exists in both import jobs. It will cause uniqueness violation error, and the job will fail.

 Importing same type of data in parallel is supported in MDF, however, you need to make sure there has no duplicate records in two jobs/csv files:

• For MDF (FTP) recurring jobs, please import data in one job one time, don't import in parallel or please isolate import data in different jobs, make sure there is no overlap when jobs are running.
• For using Import and Export Data to import MDF Data, please make sure two csv files has no duplicate records to avoid such fail. 

parallel, parallel jobs, MDF FTP Jobs, MDF import, import and export data, metadata framework, SF, unique constraint violated error, duplicate same record,  , KBA , LOD-SF-MDF-IMP , Import and Export Issues , Problem