Symptom
When running the employee history file in SF the customer gets the below errors:
This scheduled job failed to complete. For details, please contact SuccessFactors customer support.
com.successfactors.jobscheduler.ScheduledJobExecutionException: java.rmi.RemoteException: Wrapped Exception: ; nested exception is:
com.successfactors.sca.service.ServiceLegacyRollbackException: Wrapped Exception: failed to delete Employee History Records.SQLException caught: ORA-00060: deadlock detected while waiting for resource.
Environment
SAP Successfactors Variable Pay
Reproducing the Issue
- Navigate to Admin Centre>Variable Pay>Compensation Home>Variable Pay Template>Plan Setup>Manager Users>Import Employee History.
- From here Customers can import the Employee History File and also have the option of importing the file from EC.
- Now navigate to Admin Center>Monitor Jobs to check the Employee History File status and you will see that your latest Job Type: Employee History Import has failed
- When you click Download Status the error that will be thrown is the above mentioned.
- You can also see the Job Failed in Provisioning.
- You can check from Monitor Jobs if Mass Update or Bonus Calculation were running at the same time of the Employee Import and identify the jobs that are causing the deadlock.
Cause
- The issue here is that when running the job for Importing Employee History Records, the job will delete existing obsolete employee history records
- and related assignment records, etc.
- At same time, it will appear that some other operation is trying to update those records, too.
- It could be bonus payout calculation job, mass update forms job, or other save form operation.
- This causes a deadlock in the system.
- The deadlock happens when the import job would like to delete obsolete records, but other save operation would like to update records.
- This causes the import job to fail.
Resolution
The workaround that we can provide is to run another employee import when mass update job,
save form operation or bonus payout calculation job is not running for the same template.
Keywords
Employee History File Deadlock This scheduled job failed to complete. , KBA , LOD-SF-VRP , Variable Pay Programs , Problem