Symptom
Application error "Error message: "java.lang.IllegalStateException: java.lang.IllegalStateException: com.successfactors.genericobject.app.exception.MDFSQLException: com.sap.db.jdbc.exceptions.BatchUpdateExceptionSapDB: [301]: unique constraint violated: Table(GENERIC_OBJECT_T), Index(UK_GENERIC_OBJECT_T_EXT_CODE)(input position -1)"." occurs when attempting to rehire a user.
Environment
- SAP SuccessFactors HCM Suite
- SAP SuccessFactors Employee Central
Reproducing the Issue
- Navigate to the Manage Pending Hires (MPH) page and open the draft for the affected user
- When trying to save the hire a application error is faced
Cause
The error is caused by a conflict involving a MDF object being created/updated during hire process, which leads to a unique constraint violation in the database.
Resolution
You will need to remove the affected MDF object from the hiring page. To help troubleshooting, you can use a rule trace (2257064) to check if there are any rules setting MDF objects data, like payment information or a custom MDF object, to narrow down the possibilities.
If you are not able to delete the section MDF during the hire process(like there is no trash icon in the page), you will need to delete the MDF object from the hire template, under Manage Data. This way, the section will not show in the hire process and will not cause the error.
See Also
Keywords
application error, rehire, custom MDF object, payment information, unique constraint violated, hiring process, SAP SuccessFactors Employee Central, Manage Pending Hires, rule trace, BatchUpdateException, MDFSQLException. , KBA , LOD-SF-EC-HIR-NEW , Add New Employee Wizard , Problem
SAP Knowledge Base Article - Public