SAP Knowledge Base Article - Public

3478730 - Application error when approving hire workflow -1H2024

Symptom

Application error occurs when approving hire workflow.

Environment

SAP SuccessFactors Employee Central

Reproducing the Issue

  1. Manage Pending Hire > Draft(onboarding).
  2. Submit Hire > Workflow triggered.
  3. Proxy as first approver > try to approve workflow.
  4. Application error appears.

Resolution

  1. Product Engineering is investigating a solution.
  2. 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

Product

SAP SuccessFactors Employee Central 2405