How to run the View Definitions file when restoring a Data Archive in RSA Identity Governance & Lifecycle
Originally Published: 2019-11-26
Last Modified: 2022-06-20
Article Number
Applies To
RSA Version/Condition: 7.1.x
Issue
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
Resolution
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.- Login to the RSA Identity Governance & Lifecycle database as AVUSER using SQL Developer.
- Click on the pencil icon of the VIEW_DEFINITIONS column.
- Type Ctrl+A to select the contents of the column.
- Type Ctrl+C to copy the highlighted column contents.
- 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.
Related Articles
Data Archiving fails with 'Error saving data archival job for the date range' in RSA Identity Governance & Lifecycle 114Number of Views Purge Status column showing "In Progress" on the Archive page in RSA Identity Governance & Lifecycle 13Number of Views Risk Data Processing run fails in RSA Governance & Lifecycle 128Number of Views Data Archiving fails in Data Purging step in RSA Identity Governance & Lifecycle 218Number of Views New Archive run cannot be created due to overlapping with existing archives error in RSA Identity Governance & Lifecycle 41Number of Views
Trending Articles
RSA Authentication Manager 8.9 Patches and Hotfixes Readme RSA MFA Agent 2.5 for Microsoft Windows Installation and Administration Guide RSA-2026-24: RSA Authentication Manager Security Update for Third-Party Component Vulnerabilities IDR SSO - Step 3: Deploy the Identity Router RSA Authentication Manager 8.9 Setup and Configuration Guide
Don't see what you're looking for?