|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:
|Resolution||The View Definitions column is found in the Archiving table (Admin > System > Data Management tab > Archiving):|
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.
This example uses SQL Developer.