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

Document created by RSA Customer Support Employee on Jun 5, 2019
Version 1Show Document
  • View in full screen mode

Article Content

Article Number000037524
Applies ToRSA Product Set: Identity Governance & Lifecycle
RSA Version/Condition: 6.9.1, 7.0.0, 7.1.0, 7.1.1
IssueAfter 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


 
CauseThis can occur if one or more tables are locked while generating statistics during the upgrade and migration process.
ResolutionManually 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


 

Attachments

    Outcomes