ORA-20005 error occurs after a patch or version upgrade of RSA Identity Governance & Lifecycle during migration

[#1]

Article Number

000037524

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');

2. Once this is done, you may need to restart the RSA Identity Governance & Lifecycle application:

acm restart