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
SAP Knowledge Base Article - Public