2810883 - Integration Center Batch Upsert Limit :1000 Records Error : com.sap.db.jdbc.exceptions.BatchUpdateExceptionSapDB: 301: unique constraint violated(input position 3). The row will not be processed for subsequent entities]

Integration Center Import Job fails to complete import for 1000+ batch upsert from a direct query on a SuccessFactors to SuccessFactors Integration Job Type.

Error :

UPSERT failed for the row with key:

Reason: com.sap.db.jdbc.exceptions.BatchUpdateExceptionSapDB: 301: unique constraint violated(input position 3). The row will not be processed for subsequent entities]

Or :

AccrualCalculationBase: UPSERT failed for the row with key:

Reason: com.sap.db.jdbc.exceptions.BatchUpdateExceptionSapDB: [301]: unique constraint violated(input position 3). The row will not be processed for subsequent entities

Image/data in this KBA is from SAP internal systems, sample data, or demo systems. Any resemblance to real data is purely coincidental.

• SAP Successfactors HCM Suite
  • Integration Center

UPSERT failed for the row with key, Integration Center, Reason: com.sap.db.jdbc.exceptions.BatchUpdateExceptionSapDB: 301: unique constraint violated(input position 3), AccrualCalculationBase, timeoff account, page size limit, batch size , KBA , LOD-SF-INT-EC , Employee Central SFAPI & OData Entities , LOD-SF-INT , Integrations , LOD-SF-INT-ODATA , OData API Framework , LOD-SF-INT-INC , Integration Center , Problem