The Time Slicing job fails intermittently with a deadlock error in the BG logs.
Transaction (Process ID) was deadlocked on lock resources with another process and has been chosen as the deadlock victim. Rerun the transaction.
SQL error code: 60
Error message: [CA Clarity][Oracle JDBC Driver][Oracle]ORA-00060: deadlock detected while waiting for resource
Note: The failure is not fatal, as the job will recover and process the records the next time it runs.
This can be due one or more of the following causes:
Solution 1: Use the following page (Administration > Data Administration > Reports and Jobs > Time Slicing job > Incompatible Jobs tab)
to check or edit the Time Slicing job incompatibility list:
Any job in the list will wait for the Time Slicing job to finish before it is launched.
The following query can also be used:
Where I.Job_Definition_Id = J.Id
and I.NON_CONCUR_JOB_DEF_ID = K.id
and J.JOB_CODE in ('Time_Slicing')
order by J.JOB_CODE