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
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
Executed:
UPDATE PRTASK
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.
See 141061 - How to search for known Clarity PPM Issues using Self Service