000028886 - How to Recompile Invalid Objects in RSA Identity Governance & Lifecycle

Document created by RSA Customer Support Employee on Jun 14, 2016Last modified by RSA Customer Support on Apr 29, 2020
Version 3Show Document
  • View in full screen mode

Article Content

Article Number000028886
Applies ToRSA Product Set: RSA Identity Governance & Lifecycle
RSA Version/Condition: 7.0.x, 7.1.x, 7.2.x
 
IssueThere 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.
 
TasksTo 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.
 
ResolutionTo 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


 

Attachments

    Outcomes