SAP Knowledge Base Article - Public

2916456 - Integration Center job fails for ExternalLearner

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:
ExternalLearner.PNG

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)

Operation.JPG

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

Product

SAP SuccessFactors HCM suite all versions