3780859 - Attribute Import Returns "The default locale is null or empty for the external ID" error – SAP SuccessFactors Talent Intelligence Hub

• Attribute import job fails with HTTP error response code: 400 and message: Attributes validation failed.
• Error messages include:
• "The default locale is null or empty for the external ID ." 
• "The status is null or empty for the external ID ."
• "The attribute name is null or empty for external ID ."
• "The external ID is null or empty."
• "The attribute type ID is null for external ID ."

SAP SuccessFactors Talent Intelligence Hub
SAP SuccessFactors Integration Center

1. Populate attributes in the standard import template (CSV).
2. Upload the CSV file to the SFTP location used for the import.
3. In Integration Center, start the import job.
4. Check Execution Manager: the job fails with HTTP 400 and “Attributes validation failed” including null/empty field errors.
5. Error messages include:
   "The default locale is null or empty for the external ID ." 
   "The status is null or empty for the external ID ."
   "The attribute name is null or empty for external ID ."
   "The external ID is null or empty."
   "The attribute type ID is null for external ID ."

Trailing empty rows/lines at the end of the CSV file (often not visible in spreadsheet editors) create blank records, causing required fields to be read as null or empty during validation.

1. Open the CSV file in a plain text editor (for example, Notepad) to view raw lines.
2. Remove any empty rows/lines at the end of the file so the last data row is the final line.
3. Save the file as CSV.
4. Re-run the attribute import from Integration Center and verify the job completes successfully.

attribute import, attributes validation failed, http 400, default locale is null or empty, status is null or empty, attribute name is null or empty, external id is null or empty, attribute type id is null, csv trailing blank lines, empty rows, sftp, integration center, execution manager, talent intelligence hub, data import errors , KBA , LOD-SF-TIH , Talent Intelligence Hub and Job Profiles , LOD-SF-INT , Integrations , Problem