2489865 - Employee History Job Error deadlock (Scheduled Job failed to complete)

SAP Knowledge Base Articles - public

2489865 - Employee History Job Error deadlock (Scheduled Job failed to complete)


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.


  • 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 Customer's 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

and 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.



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.




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.


Employee History File Deadlock This scheduled job failed to complete. , KBA , LOD-SF-VRP , Variable Pay Programs , Problem


SAP SuccessFactors HCM Suite all versions