RSA Product Set: RSA Identity Governance & Lifecycle
RSA Version/Condition: 8.0.x

When adding custom attributes may fail with LockAcquisitionException error with a dead lock 

AveksaServer.log shows:

[com.aveksa.gui.pages.admin.customAttrs.newEdit.BaseAttributePageData]
javax.persistence.OptimisticLockException: org.hibernate.exception.LockAcquisitionException: could not execute statement
Caused by: java.sql.SQLException: ORA-04020: deadlock detected while trying to lock object SYS.AQ$_REG_INFO

ORA-06508: PL/SQL: could not find program unit being called: "SYS.DBMS_SCHEDULER"
ORA-06512: at "AVUSER.TRIG_PUBLIC_SCHEMA_1", line 8

There are many objects are invalid in SYS user. As part of schema extension IGL calls DBMS_SCHEDULER but it fail to execute as DBMS_SCHEDULER referenced SYS object DBMS_AQADM_SYS in invalid state. 

This can be checked using query below:

 select * from user_dependencies where referenced_name ='DBMS_AQADM_SYS';

Using Oracle Support Doc 3030913.1, apply the recommended action to resolve the deadlock issue. 

Note: The system should be less loaded or better in application maintenance mode when extending the role object or adding custom attributes.