SAP Knowledge Base Article - Public

3085045 - Integration Center - Not all error messages are included in the log file while upserting FOCostCenter entity

Symptom

 - You are upserting FOCostCenter entity via Integration Center "Scheduled CSV Input Integration" from SFTP to SF.

 - You have some problems in the logs files similar like this 

"Integration Process Warning","WARNING","2022-FEB-02 22:22:22","FOCostCenter: UPSERT failed for the row with key: FOCostCenter/externalCode="XXX", FOCostCenter/startDate="1990-01-01T00:00:00.000+01:00. Reason: Invalid reference '(effectiveStartDate=null, externalCode=XXX)' for valid when association 'cust_toLegalEntity'.. The row will not be processed for subsequent entities",""

 - You also noticed that here are other records not properly imported/updated even if they are not highlighted in the issue log

Environment

  • SAP SuccessFactors HXM Core
  • Integration center

Reproducing the Issue

Steps to replicate issue:

  1. Create a simple input Integration Center job
  2. Run the job to upsert data for FOCostCenter entity
  3. Notice that the job finished but with errors"
  4. Checking the log file you can see similar errors like mentioned above

Cause

Integration Center uses $Batch for upsert calls. In batch upsert, if one record upsert failed other records would also be reverted even though they pass the validation. These records will not be properly imported and logged as error in the log file.

"Upsert operations in a $batch ChangeSet follow the "all-or-nothing" rule. That means, if one record fails to upsert, all other changes will roll back."

Resolution

To avoid this situation you need to be sure that data in the csv import file is maintained correctly. (No mismatch in the file, missing/incorrect values, values which are not exist on SF side, etc...)

You need to fix each known issue one by one from the log file until the job finishes Successfully without errors.


See Also

https://help.sap.com/viewer/d599f15995d348a1b45ba5603e2aba9b/2105/en-US/7613ec6d0d014112b7654085a6b403fb.html

Keywords

FOCostCenter, upsert, Integration Center, Invalid reference, The row will not be processed for subsequent entities
 
, KBA , LOD-SF-INT-INC , Integration Center , LOD-SF-INT , Integrations , Problem

Product

SAP SuccessFactors HXM Suite all versions