SAP Knowledge Base Article - Public

2276084 - Not able to Import Job Relationships

Symptom

Unable to import job relationships, where one of the following is occurring:

  1. An import of Job Relastionships is continuously loading
  2. The import is failing for a large import size, but imports correctly for a smaller file size. 

Environment

Employee Central - Imports

Reproducing the Issue

This issue occurs when importing Job Relaitions with incremental or full purge import:
    >Admin Center > Import Employee Data >Job Relationships

Cause

There are 2 probable causes :

1. Performance issue.

2. Thread deadlock.

Resolution

To resolve this issue the following two settings must be updated:

1. Set a batch size for imports:
    When carrying out imports, for the best performance we recommend setting a batch size for you imports. This will prevent errors such as continuous loading of the import file or the import working for a smaller file size only. 
    It's always recommended to go with the minimum threshold value that is being set in the:
    Admin Center -> Company System and logo settings -> Batch size for EC and foundation data import (500 is the default value but 50 is more stable value).
    If the actual number of records is less than the threshold value specified, the system attempts for a synchronous upload.
    If the actual number of records is greater than the threshold value specified then the system goes for the asynchronous mode by scheduling the jobs in the back end.

2. Set a threshold for processing direct subordinates and job relationships offline:
    When carrying out actions in the UI or imports which update managers, direct reports and job relationships, we recommend setting a threshold values to updated the users profiles asynchronously. 
    It's always recommended to go with the minimum threshold value that is being set in the
    Admin Center -> Company System and logo settings -> The threshold for processing direct subordinates and job relationships offline.
    We recommend setting this value to 25 - 50.
    Please be aware that this may need to be lower in your instance depending on the amount of relationships you have defined and the amount of business rules that need to be triggered, this may need to be set to 10 if you are still having issues after setting to 25. 
    If the actual number of records is less than the threshold value specified, the system attempts for a synchronous upload.
    If the actual number of records is greater than the threshold value specified then the system goes for the asynchronous mode by scheduling the jobs in the back end.

 

Keywords

job relationship import, loading, failed import, job relationship, company system and logo settings, Batch size, threshold, direct subordinates , KBA , LOD-SF-EC-EDP , Import Employee Data (EC Core only) , LOD-SF-EC-JOB , Job Information , Problem

Product

SAP SuccessFactors Employee Central all versions ; SAP SuccessFactors HCM Core 1511