Symptom
Application error occurs when approving hire workflow.
Environment
SAP SuccessFactors Employee Central
Reproducing the Issue
- Manage Pending Hire > Draft(onboarding).
- Submit Hire > Workflow triggered.
- Proxy as first approver > try to approve workflow.
- Application error appears.
Resolution
- Product Engineering is investigating a solution.
- Click on star to bookmark this article to receive updates about this issue. For more information about updates from subscribed KBAs, you can refer to the KB Article 2171560 - How to be notified of new or updated SAP Notes or KBAs.
Keywords
INC8464862, b2405, 1H2024, KI2405, Workflow error, Application error, Time stamp error, workflow, Onboarding, Hire workflow, manage pending hire,com.successfactors.db.dao.DAOException: HibernateException thrown could not execute statement at com.successfactors.hris.dao.hibernate.HrisTemporalDAOImpl.getEntityListForUser, org.hibernate.exception.ConstraintViolationException: could not execute statement at org.hibernate.dialect.AbstractHANADialect$3.convert(AbstractHANADialect.java:994), com.sap.db.jdbc.exceptions.SQLIntegrityConstraintViolationExceptionSapDB: [301]: unique constraint violated: Table(EMP_PERSONAL_INFO_T), Index(UC_EMP_PERSONAL_INFO_KEY) with error: unique constraint violation for table SFV4_STOCKPM214111:EMP_PERSONAL_INFO_Ten, constraint='$uc_UC_EMP_PERSONAL_INFO_KEY$', key value='13347', pos=0; indexname=UC_EMP_PERSONAL_INFO_KEY , KBA , LOD-SF-EC-INT , Manage Pending Hires (Integration RCM/ ONB/ OBX + UI) , LOD-SF-EC-WFL , Workflows - Configuration, Tools, Objects & Rules , LOD-SF-EC-INT-ONB , Onboarding 1.0 to EC Integration , LOD-SF-EC-HIR , Hire & Rehire Wizards , Bug Filed