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