Below error is frequently observed in bg-ca.log when Update % Complete job is run.
ERROR 2019-12-05 15:55:57,429 [Dispatch Update % Complete : [email protected](tenant=clarity)] projmgr.functions (clarity:jobrun:zzzzzz__zzzzzz-zzz-zzz-zzzzzz: Update % Complete) ProjectPercentFunction.eval() exception in project 500343
SQL error code: 60
Error message: [CA Clarity][Oracle JDBC Driver][Oracle]ORA-00060: deadlock detected while waiting for resource
SET IS_PCT_DIRTY = NULL
WHERE PRPROJECTID = ?
AND IS_PCT_DIRTY = 1
A deadlock error can indicate another job was running at the same time that may be updating one of the tables the Update % complete job is updating.
Release : All Supported Releases
Component : CA PPM INTEGRATIONS & INSTALLATIONS
3. Check to see what jobs were running at the same time as the error that may updating the same table.
How to search for known Clarity PPM Issues using Self Service