SAP Knowledge Base Article - Public

2872285 - MDF Import fails with error "You are not allowed to enter the value for the field externalCode with the type Auto Number in the object. . ."

Symptom

When creating a record for an MDF object with the External Code field set to Auto Number, the system displays the error: “You are not allowed to enter a value for the External Code field with the type Auto Number in this object.

Environment

  • SAP SuccessFactors HCM Suite
  • Metadata framework (MDF)

Reproducing the Issue

  1. Go to Import and Export Data
  2. Import data for any MDF object with External code/ any field set us Autonumber
  3. Select the csv file for import where there is a value in place for a field that is set as Autonumber and proceed with the import
  4. Go to Monitor Jobs and check the status of Import
  5. Import fails with error "You are not allowed to enter the value for the field externalCode with the type Auto Number in the object XXXX to prevent data corruption. The value for this field type is always set by the system."

Cause

This is because "Autonumber" type of field should not have value during import as the system is assigning a value for this field automatically.

Resolution

To fix the issue, set the “Auto Number” field values as #1, #2, …, #N when performing the import. The import will be successful, and the system will automatically generate and assign the correct values to this field once the import is completed.

See Also

Keywords

AutoNumber, MDF Import fails, SuccessFactors, Metadata Framework, Platform, external code, error, object, field value, Import and Export Data, MDF object , KBA , LOD-SF-MDF-IMP , Import and Export Issues , Problem

Product

SAP SuccessFactors HCM Suite 2511