Symptom
You wish to understand why an Integration Center inbound job with starting entity ExternalLearner is not completing successfully. The event log points to an unsupported feature: batch upsert
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
- SAP SuccessFactors OData API
- Integration Center
Reproducing the Issue
Process an Integration Center job with ExternalLearner as starting entity as follows:
Cause
Currently Batch Upserts are not supported for External User.
Batch Upserts are not supported for External User, the reason being the system will always upsert one external user at a time to the database, thus causing a delay.
There are no plans currently to speed up these jobs or support batch upserts, so if you have a strong business scenario, we would advise you raise an enhancement request:
We welcome inputs from customers to improve the functionality of our products. All enhancement requests are reviewed by our Product Management team and, if successful, are developed and implemented in a future product release:
2280285 - Create an enhancement request on API/Integration Topic at Community portal.
2090228 - How to Submit Enhancement Requests for SAP SuccessFactors Products
Resolution
Change the Integration Center job Operation from Upsert - Multiple to Upsert - Single, which will allow success of records even if some records fail. (more information on OData Operations and Purge Types at KBA 2670250)
See Also
2670250 - OData Operations and Purge Types For Inbound Integrations
2280285 - Create an enhancement request on API/Integration Topic at Community portal.
2090228 - How to Submit Enhancement Requests for SAP SuccessFactors Products
Keywords
ExternalLearner: UPSERT failed for the row with key: . Reason: COE0025-Unsupported feature: batch upsert. The row will not be processed for subsequent entities Integration Center , KBA , LOD-SF-INT-INC , Integration Center , LOD-SF-LMS-EXT , Sites and External Users , How To