How to Recompile Invalid Objects in RSA Identity Governance & Lifecycle
Originally Published: 2014-10-22
Article Number
Applies To
RSA Version/Condition: 7.0.x, 7.1.x, 7.2.x
Issue
- Packages
- Package Bodies
- Functions
- Procedures
- Triggers
- Views
- Synonyms
Tasks
select count(*) from user_objects where status='INVALID' and
object_type in ('PROCEDURE', 'PACKAGE', 'PACKAGE BODY', 'TRIGGER', 'VIEW', 'FUNCTION', 'SYNONYM')
If the above query returns any results, there are INVALID objects in the database that need to be recompiled. See the Resolution section for a solution.Resolution
- Login to the application server as user oracle.
- Execute the following commands:
$ cd $AVEKSA_HOME/database $ ./Recompile_All.sh executing migration/recompileAll.sql The log is available at: /home/oracle/database/log/createMigrateTool.log
Related Articles
You uploaded an invalid file error during Quick Setup of the RSA SecurID Appliance 8.x Number of Views Invalid content type error when uploading attachments to change requests in RSA Identity Governance & Lifecycle Number of Views RSA AM 7.1: Security Vulnerability reported by IBM Rational AppScan 'Potential Order Information Found' Number of Views How to Add HSTS headers to Authentication Manager, AM service responses, even for invalid URLs which return error such as 404 Number of Views "Invalid authentication handle" reported by the Cisco AnyConnect client when using RSA SecurID Access Cloud Authentication… Number of Views
Trending Articles
RSA Authentication Manager 8.9 Setup and Configuration Guide RSA Authentication Manager 8.9 Release Notes (January 2026) RSA MFA Agent 2.3.6 for Microsoft Windows Installation and Administration Guide How to 'Trust' the RSA Authentication Manager Security Console Self-Signed Root CA certificate and prevent Cert warnings. RSA Authentication Manager Upgrade Process
Don't see what you're looking for?
