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 descriptionIf 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.
- Login to the RSA Identity Governance & Lifecycle database as AVUSER using SQL Developer.
- Click on the pencil icon of the VIEW_DEFINITIONS column.
Image description
- Type Ctrl+A to select the contents of the column.
- Type Ctrl+C to copy the highlighted column contents.
Image description
- In SQL Developer connect to the Data Archive database.
- Type Ctrl+V to paste the contents of the VIEW_DEFINITIONS column into the SQL Developer Worksheet.
- Click F5 to run the script.
Image description