SAP Knowledge Base Article - Public

3368148 - Unknown error on import when import is running from Provisioning - Employee Central

Symptom

Employee Data import is failing with error "The system has encountered an unknown error on import. Please contact the System Administrator" when the Import job is scheduled in Provisioning. While making the import in the instance via Import Employee Data, the file gets imported with no errors.

Environment

SAP SuccessFactors Employee Central

Reproducing the Issue

  1. Go to Provisioning and schedule an Employee Data Import job with a file coming from SFTP
  2. Run the job
  3. Import fails with error "The system has encountered an unknown error on import. Please contact the System Administrator."
  4. Try to import the same file in the instance via Import Employee Data
  5. Import is successful

Cause

Job Owner of the Import Job in Provisioning does not have valid data in Employee Central, especially on Personal Information. Due to that, system is unable to write their name as the creator of the new record for the users.

Error on Internal logs is: cannot insert NULL or update to NULL: Not nullable "CREATED_BY" column

Resolution

Correct the Personal Information details of the job owner in the Employee Profile.

See Also

2174088 - Internal System error encountered while importing record - Employee Central

Keywords

employee import, personal information, cannot insert NULL or update to NULL: Not nullable "CREATED_BY" column, import employee data, SFTP, job owner, employee data import, employee central, Provisioning, The system has encountered an unknown error on import. Please contact the System Administrator , KBA , LOD-SF-EC-EDP , Import Employee Data (EC Core only) , LOD-SF-EC-PER-PRS , Personal Info - Config, Rules, RBP, UI , LOD-SF-PLT-JOBS , Scheduled Jobs , LOD-SF-EC-EDP-CMP , Compensation Information Imports , Problem

Product

SAP SuccessFactors Employee Central all versions ; SAP SuccessFactors HCM suite all versions