SAP Knowledge Base Article - Public

3292038 - "Unable to update BizX data: Batch update returned unexpected row count from update [0]..." - SuccessFactors Integration Center

Symptom

Integration Center (IC) job upserting EmpEmploymentTermination entity failing with the error:

"Failed due to - Batch update returned unexpected row count from update [0]; actual row count: 0; expected: 1; statement executed: delete from ";DEFAULT_SCHEMA;".EMP_JOB_INFO_T where JOB_INFO_ID=? and CREATED_BY = ? and CREATED_DATE = ? and USERS_SYS_ID = ? and LAST_MODIFIED_BY = ? and LAST_MODIFIED_DATE = ? and CUSTOM_DATE1 is null and CUSTOM_DATE10 is null and CUSTOM_DATE2 is null and CUSTOM_DATE3 is null and CUSTOM_DATE4 is null and CUSTOM_DATE5 is null and CUSTOM_DATE6 is null and CUSTOM_DAT "

Environment

SAP SuccessFactors HXM Suite

Reproducing the Issue

  1. Create an Inbound or SF to SF IC job upserting data in EmpEmploymentTermination entity;
  2. Run the IC job;

Cause

There may be an issue with the Position Hierarchy adoption that is used to execute synchronously during termination.

Resolution

In Admin Center > Company System and Logo Settings select the checkbox Enable Centralized Services for Termination Details and save (refer to Centralized Services for Employee Data Imports chapter).

Keywords

centralizes services, resignation, API, import, issue, resignation, inbound, SF to SF , KBA , LOD-SF-INT-INC-JOB , Integration Center Job , Problem

Product

SAP SuccessFactors HCM suite all versions