How to run the View Definitions file when restoring a Data Archive in RSA Identity Governance & Lifecycle

[#1]

Article Number

000038184

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😞

Image description


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.

Image description
 

3. Type Ctrl+A to select the contents of the column.
4. Type Ctrl+C to copy the highlighted column contents.

Image description

5. In SQL Developer connect to the Data Archive database.
6. Type Ctrl+V to paste the contents of the VIEW_DEFINITIONS column into the SQL Developer Worksheet.
7. Click F5 to run the script.
    

Image description