SAP Knowledge Base Article - Public

2214284 - Cannot approve new hire or rehire for specific user in Employee Central

Symptom

When attempting to approve a new hire or rehire workflow for a specific user in Employee Central you receive an application error or the following message in the final step of the workflow:

Untitled.png

or

DAO Exception.png

Environment

  • SAP SuccessFactors HXM Suite 
  • SAP SuccessFactors Employee Central

Reproducing the Issue

  1. Add a new employee and trigger a workflow 
  2. When the last approver tries to approve it an error above is faced or an application error 

or

  1. Rehire an Employee and trigger a workflow
  2. When the last approver tries to approve it an error above is faced or an application error  

Cause

The cause of the problem is a data issue for this specific user.

Resolution

To avoid this error and complete the new hire or rehire for this user, use the following steps:

  • If it is a Rehire you will need to follow these steps:
    1. Go to the previous employee personal information and delete the existing phone information and email information records
    2. Now approve the rehire workflow 
    3. The workflow should be approved without error
  • If it is a New Hire you will need to follow these steps:
    1. Delete the phone information and email information for the user affected 
    2. Now approve the new hire workflow
    3. The workflow should be approved without error. 

See Also

2569559 - Application Error when hiring employee from Manage Pending Hire

2835017 - Application Error When Rehiring an Employee via Employee Central

2379964 - Unable to Save or Approve a Rehire Request - Application Error or JDBC Batch Update Error

Keywords

SF, EC; rehire workflow error; wrapped exception, add new employee, add new recruit, add new hire, workflow request, cannot approve, could not execute JDBC batch update, DAOException, DAO, expection, Wrapped Exception: HibernateException thrown could not execute statement, Caused by: com.sap.db.jdbc.exceptions.SQLIntegrityConstraintViolationExceptionSapDB: [301]: unique constraint violated: Table(EMP_PHONE_INFO), Index(UC_EMP_PHONE_INFO_KEY) with error: unique constraint violation for table SFV4_STOCKPM192026:EMP_PHONE_INFOen , KBA , LOD-SF-EC-HIR , Hire & Rehire Wizards , How To

Product

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