How to Recompile Invalid Objects in RSA Identity Governance & Lifecycle
3 years ago
Originally Published: 2014-10-22
Article Number
000066255
Applies To
RSA Product Set: RSA Identity Governance & Lifecycle
RSA Version/Condition: 7.0.x, 7.1.x, 7.2.x
 
Issue
There are times when one or more objects in the RSA Identity Governance & Lifecycle database become INVALID and need to be recompiled. Database objects that may become INVALID and need to be recompiled are:
  • Packages
  • Package Bodies
  • Functions
  • Procedures
  • Triggers
  • Views
  • Synonyms
This RSA Knowledge Base Article explains how to recompile all INVALID objects in the RSA Identity Governance & Lifecycle database.
 
Tasks
To determine if there are any INVALID objects in the RSA Identity Governance & Lifecycle database, run the following SQL query as AVUSER: 
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
To rebuild all INVALID objects in the RSA Identity Governance & Lifecycle database follow these steps:
  1. Login to the application server as user oracle.
  2. 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

Trending Articles

Don't see what you're looking for?