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
- Go to Provisioning and schedule an Employee Data Import job with a file coming from SFTP
- Run the job
- Import fails with error "The system has encountered an unknown error on import. Please contact the System Administrator."
- Try to import the same file in the instance via Import Employee Data
- 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
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