SAP Knowledge Base Article - Public

3415041 - "UPSERT failed for the row with key... Reason: Cannot be merged as the conflict value found for properties" error - Integration Center

Symptom

Inbound Integration Center job failing with:

"<entity name>: UPSERT failed for the row with key: <entity name>/<entity field>=xxxxxx. Reason: Cannot be merged as the conflict value found for properties: <entity field>"

Environment

SAP SuccessFactors HXM Suite

Cause

In the preview payload (under Configure Fields > Field Mapping View) there are probably multiple upserts for the same records (with the same business keys/identifiers). For example:

{
        "businessKey1": "12345",
        "businessKey2": "/Date(12345)/",
        "field1": "abcde",
        "field2": "xxxxx",
        ...
}

{
        "businessKey1": "12345",
        "businessKey2": "/Date(12345)/",
        "field1": "abcde",
        "field2": "yyyyy",
        ...
}

NOTE: You can find the list of business keys of an entity under OData/SFAPI API Dictionary.

In the example above, different values for "field1" are trying to be upserted for the same record in the same payload which led to system cannot decide which one to be used, so backend throws out the error instead of overriding it with some implicit logic.

This is being caused by the insufficient mapping between the source entity business keys and the target entity business keys.

Resolution

To solve that you'll need to review the integration mapping logic (refer to Integration Center guide).

In case of involving custom objects, review the object business keys may be necessary as well (refer to MDF guide).

For consulting matters (configuration, how-to questions and implementation suggestions) the recommendation is speak with your CSM (refer to KBA 2671448) about Professional Services options or about engaging an SAP Authorized Partner (instructions in KBA 2149831).

See Also

KBA 2857750 - [1911] OData API edit behavior for MDF foundation objects - SuccessFactors HCM Suite 

Keywords

UPSERT failed for the row with key, Cannot be merged as the conflict value found for properties, upsert, upserting, insert, inserting, update, updating, integration center, IC, custom object, custom entity, custom portlet

, KBA , LOD-SF-INT-INC , Integration Center , Problem

Product

SAP SuccessFactors HXM Suite all versions