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 How to recover from incorrectly uploading a DER encoded public SSL certificate to the SecurID Access Administration Console 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 filename message when uploading an attachment to a Request Form in RSA Identity Governance & Lifecycle Number of Views
Trending Articles
How to manipulate imported RSA SecurID Software Token(s) on an iPhone or iPad device RSA SecurID software token .sdtid file fails to import into RSA SecurID Software Token 5.0 for Windows RSA Authentication Manager 8.9 Patches and Hotfixes Readme Download RSA SecurID Access Cloud User Event audit logs using Cloud Administration REST API CLU RSA MFA Agent 2.5 for Microsoft Windows Installation and Administration Guide
Don't see what you're looking for?
