|Applies To||RSA Product Set: RSA Identity Governance & Lifecycle|
RSA Version/Condition: 7.x
|Issue||After migrating an RSA Identity Governance & Lifecycle database during an upgrade or patch installation, the installation fails with the following errors in the log files:|
|Cause||This problem occurs when dropping a table column from an RSA Identity Governance & Lifecycle database table and corrupt data exists in the retained database statistics history data. Oracle database statistics are retained by default for 31 days. See related RSA Knowledge Base Article 000029937 -- How to change the default Oracle Statistics History Retention period for RSA Identity Governance & Lifecycle on the Oracle statistics history retention period. |
|Resolution||To resolve this error, the database statistics need to be purged until the corrupted data has been purged. The fully documented solution can be found at Oracle Doc ID 2127444.1.|
Here is the resolution from the Oracle web site. Please note these commands must be executed as sysdba or the SYS user:
Once you can drop a table column, the corrupted data has been purged and you can stop further purging of the historical statistics data.