After a patch or version upgrade of RSA Identity Governance & Lifecycle, the following error message is seen in the RSA Identity Governance & Lifecycle User Interface, in the /home/oracle/wildfly-10.1.0.Final/standalone/log/aveksaServer.log, and/or in the /home/oracle/wildfly-10.1.0.Final/standalone/log/migration.log:
ORA-20005: object statistics are locked (stattype = ALL)
ORA-06512: at "SYS.DBMS_STATS", line 17079
ORA-06512: at "AVUSER.STATISTIC_OPERATIONS", line 281
ORA-06512: at "AVUSER.DATABASE_STATISTICS", line 345
ORA-06512: at line 2
This can occur if one or more tables are locked while generating statistics during the upgrade and migration process.
Manually unlock the tables in the database.
Login to SQL*Plus as avuser and run the following query:
Once this is done, you may need to restart the RSA Identity Governance & Lifecycle application: