How to run the View Definitions file when restoring a Data Archive in RSA Identity Governance & Lifecycle
4 years ago
Originally Published: 2019-11-26
Article Number
000064892
Applies To
RSA Product Set: Identity Governance & Lifecycle 
RSA Version/Condition: 7.1.x
 
Issue
When restoring a Data Archive in RSA Identity Governance & Lifecycle (Admin > System > Data Management tab > Archiving), there are specific instructions for restoring the archived data. This information may be found in the online help. In the user interface, click on the ? in the top right corner, search for Archiving, click on Archiving Data, scroll to the bottom and click on Restore a Data Archive for an Audit.

On this online help page, there are instructions to:
  • download the file from the View Definitions column, and
  • run the View Definitions file on the database server
but no detailed explanation on how to download or run the View Definitions file. This RSA Knowledge Base Article provides details on how to achieve this.

 
Resolution
The View Definitions column is found in the Archiving table (Admin > System > Data Management tab > Archiving):

User-added image


If you do not see this column, go to the Table Options icon in the top right corner of the table and check the box next to this column.

Copy and pasting this column from the user interface into SQL Developer for execution results in an error when executed. Saving this table to a CSV file and copying the contents of the cell into SQL Developer for execution also results in an error when executed.

The method that can be used is to copy the output of the VIEW_DEFINITIONS column (clob datatype) from the T_ARCHIVE table in the AVUSER schema and execute the results on the database server where the archive is to be restored.
 

STEPS:

This example uses SQL Developer.
  1. Login to the RSA Identity Governance & Lifecycle database as AVUSER using SQL Developer. 
  2. Click on the pencil icon of the VIEW_DEFINITIONS column.

t_archive
 
  1. Type Ctrl+A to select the contents of the column.
  2. Type Ctrl+C to copy the highlighted column contents.

t_archive copy View Definitions value
 
  1. In SQL Developer connect to the Data Archive database.
  2. Type Ctrl+V to paste the contents of the VIEW_DEFINITIONS column into the SQL Developer Worksheet.
  3. Click F5 to run the script.
     
SQL Developer Data Archive Database SQL Worksheet

 
Don't see what you're looking for?