3571730 - Error Message Deleting Job Information: unique constraint violated: Table(BE_TLM_ACCOUNT_DATE_REF), Index(UK_BE_TLM_ACCOUNT_DATE_REF_EC)

When deleting a time slice in Job Information this message is raised: java.lang.IllegalStateException: com.successfactors.genericobject.app.exception.MDFSQLException: com.sap.db.jdbc.exceptions.BatchUpdateExceptionSapDB: [301]: unique constraint violated: Table(BE_TLM_ACCOUNT_DATE_REF), Index(UK_BE_TLM_ACCOUNT_DATE_REF_EC)(input position -1)

SAP SuccessFactors Employee Central

1. Access the employee profile.

2. Access the job history.

3. Attempt to delete a record and error message will appear.

This is under investigation by Engineering Team.

As a workaround, follow the steps below to remove the job info from the History slice.

Step 1: Navigate to Manage Data and search for the "Time Account Type Date Reference" object of the affected user.
Step 2: The Date Reference for this user has 2 slices of records, each with a different Effective Start Date, which is incorrect.
Step 3: Delete the date reference slice with the incorrect Effective Start Date.

After completing the above 3 steps, the user will be able to delete the job info history.

java.lang.IllegalStateException: com.successfactors.genericobject.app.exception.MDFSQLException: com.sap.db.jdbc.exceptions.BatchUpdateExceptionSapDB: [301]: unique constraint violated: Table(BE_TLM_ACCOUNT_DATE_REF), Index(UK_BE_TLM_ACCOUNT_DATE_REF_EC)(input position -1), TIM-49296 , KBA , LOD-SF-EC-TIM-JOB , Time Management in Job Info - Records & Objects , Bug Filed