Symptom
- Error encountered when attempting to terminate a permanent employee:
'java.lang.IllegalStateException: com.successfactors.db.dao.DAOException: HibernateException thrown could not prepare statement' - Error encountered when attempting to terminate a contract employee via a work order:
'Please try again later, or notify support (with the error information of errorID=ea21e885-b3e5-4900-af99-d86ac00b34ba, timestamp=xxx, and the version information from the current screen) if the issue keeps occurring'
Environment
- SAP SuccessFactors Employee Central
- Termination
Reproducing the Issue
- Locate the employee you wish to terminate
- For permanent employees, select "Action Menu" and then "Terminate"
- For contract employees, navigate through the "Work Order" and attempt to end the contract date.
- Error message shows up.
Cause
- Incorrect HRIS sync mapping in the data model.
- The mapping included the "status" field, which is handled by the system via hardcoded logic.
Resolution
- Access "Manage Business Configuration" and verify that no mapping is present for the "status" field.
- If "status" is not reflecting in the mappings, still check it in the following way: export the data model to identify any existing mappings for the "status" field.
- Locate and remove the following mapping from the data model:
<hris-mapping>
<hris-field-ref refid="emplStatus"/>
<standard-element-ref refid="status"/>
</hris-mapping> - Reimport the updated data model without the "status" mapping.
- Retest the termination process for both permanent and contract employees to confirm resolution.
See Also
Keywords
termination error, java.lang.IllegalStateException, DAOException, HRIS sync mapping, employee status, contract employee termination, permanent employee termination, termination process, status field mapping, errorID ea21e885-b3e5-4900-af99-d86ac00b34ba, hire, rehire, terminate, Exception caught: Illegal string value 'A'. Legal values are 't', 'f', 'T', 'F', 'v', 'x', 'e', 'd' , KBA , LOD-SF-EC-TER , Termination Details , LOD-SF-EC-HIR , Hire & Rehire Wizards , How To
Product
SAP SuccessFactors Employee Central all versions
SAP Knowledge Base Article - Public