2085396 - Error - The fields in this header row do NOT match those defined for this section in the data model - Succession

SAP Knowledge Base Article - Public

2085396 - Error - The fields in this header row do NOT match those defined for this section in the data model - Succession

Symptom

  • Import Background Information gives error(s) : "The fields in this header row do NOT match those defined for this section in the data model" when use of hidden data fields

Environment

  • Succession Management

Reproducing the Issue

  • "The fields in this header row do NOT match those defined for this section in the data model" when use of hidden data fields.
  • Importing "Back ground Information" through "Import Extended User Information" gives error :
  • "The csv file was either missing fields, contained extra fields for certai rows, or certain fields contained invalid format or type". Because one or more errors was detected, NONE of the records have been added to the system. Please correct the errors listed below and reimport"

 

  • Below listed the line numbers, Line and individual error message : "The fields in this header row do NOT match those defined for this section in the data model." (See screenshot 3 below).
  • This issue happens even when downloading the template (Download Data Import File Template) for Background information (screenshot 1) , and uploading the empty template without ANY modification via "Import by incredentally adding data". (Screenshot 2 below) :

 

  • Screenshot 1 :

      1.png

 

  • Screenshot 2:

      2.png

 

  •  Screenshot 3:

     3.png

Cause

  • This error might occur if the uploaded employee do not match with the fields in the Data Model.
    The uploaded employee file is either missing fields or has extra fields.
  • But it happens also when Data fields of a background-element are set to hidden="true" !

 

Example of of Data Model :

<background-element id="compensation" type-id="3">
<label>Compensation</label>
<label xml:lang="fr-FR">Rémunération active</label>
<data-field id="sysCompTemplateName" field-name="name" max-length="256" max-file-size-KB="1000">
<label>Review Name</label>
<label xml:lang="fr-FR">Type de rémunération</label>
</data-field>
<data-field id="Merit" field-name="vfld3" hidden="true" max-length="4000" max-file-size-KB="1000">
<label>Merit</label>
<label xml:lang="fr-FR">Merit</label>
</data-field>
<data-field id="curSalary" field-name="vfld7" max-length="4000" max-file-size-KB="1000">
<label>Current Salary before review</label>
<label xml:lang="fr-FR">Précédent</label>
</data-field>
<data-field id="totalRaise" field-name="vfld9" hidden="true" max-length="4000" max-file-size-KB="1000">
<label>Total Raise</label>
<label xml:lang="fr-FR">Variation en %</label>
</data-field>
<data-field id="promotion" field-name="vfld8" hidden="true" max-length="4000" max-file-size-KB="1000">
<label>Contractual Adjustment</label>
</data-field>
<data-field id="finSalary" field-name="vfld11" max-length="4000" max-file-size-KB="1000">
<label>Salary after review</label>
<label xml:lang="fr-FR">Actuel</label>
</data-field>
<data-field id="totalBonus" field-name="ffld1" hidden="true" max-length="999" max-file-size-KB="1000">
<label>Total Bonus</label>
</data-field>
</background-element>

Resolution

There are 2 solutions to get the Data uploaded :

 

1) - Manually adding the missing hidden fields to the template file.

  • Example based on the above back-ground-element :
    • ^UserId, compensation,sysCompTemplateName,Merit,curSalary,totalRaise,promotion,finSalary,totalBonus

 

2) - Download Data Model (Task to be done by Technical Services).

  • Backup Data Model
  • Removing the hidden="true" out of the data model (Task to be done by Technical Services).
  • Downloading a new template (See screenshot 1 above).

 

  • Now the new template should contain the previously hidden fields ; Following the Data Model example shown above the template should look like this :
    • ^UserId,compensation,sysCompTemplateName,Merit,curSalary,totalRaise,promotion,finSalary,totalBonus
  • Re-upload the made backup of the Data Model so that the hidden="true" flags are set back as previously (Task to be done by Technical Services).
  • Upload the Data within the new template as shown in screenshot 2.

Source : Jira EDU-4675<http://jira.successfactors.com/browse/EDU-4675>

Keywords

KBA , sf error messages succession , LOD-SF-SCM , Succession Management , How To

Product

SAP SuccessFactors HCM Core all versions