ORA-20005 error occurs after a patch or version upgrade of RSA Identity Governance & Lifecycle during migration
Originally Published: 2019-05-22
Last Modified: 2022-06-20
Article Number
000042096
Applies To
RSA Product Set: Identity Governance & Lifecycle
RSA Version/Condition: 6.9.1, 7.0.0, 7.1.0, 7.1.1
Issue
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

 
Cause
This can occur if one or more tables are locked while generating statistics during the upgrade and migration process.
Resolution
Manually unlock the tables in the database.
  1. Login to SQL*Plus as avuser and run the following query:
EXEC DBMS_STATS.unlock_schema_stats('AVUSER');
  1. Once this is done, you may need to restart the RSA Identity Governance & Lifecycle application:
acm restart

 

Related Articles

Trending Articles

Don't see what you're looking for?