SAP Knowledge Base Article - Public

2314289 - Unable to Hire New User via Add New Employee Wizard - JDBC Batch Update Error

Symptom

  • In the Add New Employee Wizard, when trying to save the record of a newly added user, an error popup appears with the following message:

    "Error: Sorry, an error occurred during the hiring process. Wrapped Exception: Wrapped Exception: Wrapped Exception: Exception caught: Could not execute JDBC batch update"

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

Environment

SAP SuccessFactors Employee Central

Reproducing the Issue

  1. Go to Company System and Logo Settings -> Check the current value for the Next Person ID Assigned Setting

    2016-05-05_22-22-26.png

  2. Go to any test user's Personal Information page and change the personId number, in the Biographical Information portlet, to the value identified in the abovementioned

    2016-05-05_22-23-45.png

  3. Add a new user via the Add New Employee Wizard, save the record. The following error will appear:

    2016-05-05_22-26-20.png

Cause

The next available personID is already being used by an existing user. Hence, system is throwing an error.

Resolution

Go to "Company System and Logo Settings! and update the value in the "Next Person Id Assigned" field to a new value that is not used, yet. Then, try to do the hire again.

In order to proactively identify which personId numbers are not yet assigned, you can generate an Ad Hoc Report on Person Information, look for the PERSON_ID_EXTERNAL or personID field.

Keywords

Add New Employee, New Hire, JDBC Batch Update, personId, Error, Next Person Id Assigned, Error: Sorry, an error occurred during the hiring process. Wrapped Exception: Wrapped Exception: Wrapped Exception: Exception caught: Could not execute JDBC batch update, Wrapped Exception, Exception caught, Could not execute JDBC batch update , KBA , LOD-SF-EC-HIR , Hire & Rehire Wizards , Problem

Product

SAP SuccessFactors Employee Central all versions ; SAP SuccessFactors HCM Suite all versions