SAP Knowledge Base Article - Public

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

Symptom

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.

Environment

SuccessFactors HXM Suite

Reproducing the Issue

  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.

    Cause

    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.

     

    Resolution

     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. 

    Keywords

    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

    Product

    SAP SuccessFactors HCM Suite all versions