SAP Knowledge Base Article - Public

3463834 - MDF Import failing stating that fields/associations are not maintained in the import file

Symptom

When import data onto a custom MDF object there is an error in the job response stating that fields/associations are required despite them being populated in the import file. 

Example error

  1. XXXXX is a required field/association in Object XXXXX.
  2. XXXXX is a required field/association in Object XXXXX.
  3.  XXXXX is a required field/association in Object XXXXX.

Environment

SAP SuccessFactors HCM

Reproducing the Issue

  1. Log into affected system.
  2. Download template of the object you will be importing the data onto. 
  3. Fill out import template files, add attachments in a separate folder and compress all files and attachments to a zip file.
  4. Validate zip file.
  5. Import the file after successful validation. 
  6. Notice that the import fails.
  7. Go to the Job Manager.
  8. Download the Job Response.
  9. See the errors mentioned present.

Cause

External code has a value of AutoNumber but there is no value for this maintained in the import file causing it to fail.

Resolution

Input a value such as #1, #2, #3 and so forth for the external code and import the file again. 

For example if there are two records with different effective date in these object then use the external code as #1 for both the records.

However, if those entries are totally two different record than put #1 and #2 instead

See Also

Keywords

Custom MDF, MDF, Import and Export, MDF Import, failing, LOD-SF-MDF-IMP, autonumber, required field, required association, attachments, object , KBA , LOD-SF-MDF-IMP , Import and Export Issues , Problem

Product

SAP SuccessFactors HCM Core 2405