Symptom
Slow performance when trying to upsert EmpJobRelationships via Integration Center.
Image/data in this KBA is from SAP internal systems, sample data, or demo systems. Any resemblance to real data is purely coincidental.
Environment
SAP SuccessFactors HXM Suite
- Integration Center
Reproducing the Issue
1. Approximately 10,000 EmpJobRelationships need to be uploaded.
2. Integration Center takes more than 10 hours to complete the task.
Cause
The Integration Center uploads 1,000 data pieces per page, and for each page, it calls SF's internal service layer to load the relevant history for these users. This results in data bloat and increases the processing time of the Integration Center.
Resolution
We recommend reducing the Source Page size to 50, which will significantly reduce the processing time.
Please note that this issue is specific to Integration Center jobs. When running the same data through an SF UI EC import job, it only takes 37 minutes. This is because EC Import inserts these records internally in batches of 50/100, making each transaction lighter and faster.
Keywords
EC Odata API, more than 10 hours, too slow, Job run time, Soure page size, 1000, 50 , KBA , LOD-SF-INT-INC-JOB , Integration Center Job , Problem
Product
Attachments
Pasted image.png |