SAP Knowledge Base Article - Public

3421751 - Slow performance when trying to upsert EmpJobRelationships via Integration Center.

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

SAP SuccessFactors HXM Core 2311

Attachments

Pasted image.png