SAP Knowledge Base Article - Public

3502572 - While Importing MDF Object via Integration Center it throwed a Exception

Symptom

When I run the job to import data to MDF Object via Integration Center

<mdf object name>: UPSERT failed for the row with key: <mdf object name>/effectiveStartDate=2024-07-29T00:00:00.000Z,<mdf object name>/externalCode=MB00012,<mdf object name>/transactionSequence=1. Reason: ???Saving of 2 <mdf object name> throwed a Exception???. The row will not be processed for subsequent entities

Environment

Integration Center

Successfactors

Reproducing the Issue

Error Message: 
<mdf object name>: UPSERT failed for the row with key: <mdf object name>/effectiveStartDate=2024-07-29T00:00:00.000Z,<mdf object name>/externalCode=MB00012,<mdf object name>/transactionSequence=1. Reason: ???Saving of 2 <mdf object name> throwed a Exception???. The row will not be processed for subsequent entities

Resolution

Modify default value of the transaction sequence from "-1" to "<RECORDCOUNT>". 

Fixed value field -  A field that is not associated with a SAP SuccessFactors field.

It allows you to specify constant value parameters such as NOW, which is the date and time that the integration runs, and RECORDCOUNT, which provides a 1-based index of the record.

You can convert a fixed value field to a simple associated field by choosing Change Field Association and choosing a SAP SuccessFactors field.

Recordcount will automatically check the sequence and assign the correct value. 

See Also

Guide: https://help.sap.com/doc/0c0be9005af14c4f89b986a677bf270f/latest/en-US/SF_Integration_Center.pdf

Keywords

Integration Center, MDF, Successfactors, throwed a Exception, RECORDCOUNT , KBA , LOD-SF-INT-INC-JOB , Integration Center Job , Problem

Product

SAP SuccessFactors HCM Suite 2405