Oracle deadlock condition causes process error

Document ID : KB000122828
Last Modified Date : 10/12/2018
Show Technical Document Details
Issue:
A process that has been running fine for a long time encountered an error:
Error message: [CA Clarity][Oracle JDBC Driver][Oracle]ORA-00060: deadlock detected while waiting for resource.
Why is this happening?
Cause:
ERROR 2018-12-03 15:48:29,058 [Dispatch Time Slicing : bg@server123.casaasops.com (tenant=clarity)] niku.blobcrack (clarity:chapr13@ca.com:58636507__BD41492C-25F7-4673-A8CD-535D66539FAC: Time Slicing) Exception during blobcrack process 
com.niku.union.persistence.PersistenceDeadlockException: 
SQL error code: 60 
Error message: [CA Clarity][Oracle JDBC Driver][Oracle]ORA-00060: deadlock detected while waiting for resource 
Resolution:
Time Slicing job was attempting to update the same table as the process, we could observe it in the bg-ca.log. Workaround you can put in place for the process for example you can check if time slicing job is running before proceeding with an update within the process and if it is running you can wait let's say for 30 seconds and try again, if it is not running you can proceed with process updates.