How to Recompile Invalid Objects in RSA Identity Governance & Lifecycle
Originally Published: 2014-10-22
Last Modified: 2023-10-06
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
How to recover from incorrectly uploading a DER encoded public SSL certificate to the SecurID Access Administration Console Number of Views You uploaded an invalid file error during Quick Setup of the RSA SecurID Appliance 8.x Number of Views Invalid filename message when uploading an attachment to a Request Form in RSA Identity Governance & Lifecycle Number of Views An Invalid Content Type error occurs when uploading images in RSA Identity Governance & Lifecycle 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
Trending Articles
How to manipulate imported RSA SecurID Software Token(s) on an iPhone or iPad device Manual synchronization introduced in RSA Authentication Manager 8.2 Service Pack 1 patch 6 Quick Setup Guide - Passwordless Authentication in Windows MFA Agent for Active Directory How to verify NTP server synchronization is not working in RSA Authentication Manager 8.x RSA Governance & Lifecycle 8.0.0 Installation Guide
Don't see what you're looking for?
