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