The RSA Governance & Lifecycle Raw Data table for collection run IDs is empty
Originally Published: 2016-08-16
Article Number
Applies To
RSA Version/Condition: 7.0
Issue
This also happens for the Identity Data Collection and Entitlement Data Collection, as well.
Resolution
SELECT * FROM t_system_settings WHERE LOWER(parameter) ='CollectorRawDataSetstoKeep';
If the output of the query shows the value of CollectorRawDataSetsToKeep is 5, for example, it means that the DB Stats job will retain the raw data of the five most recent Collection Run IDs. Anything older than that will be purged. You can update the retention value using the query below, replacing ? with a new value, if you want to retain the data for more days.
UPDATE t_system_settings SET value=? WHERE LOWER(parameter) = 'CollectorRawDataSetstoKeep';In the example below, the value is changed to 8:
UPDATE t_system_settings SET value=8 WHERE LOWER(parameter) = 'CollectorRawDataSetstoKeep';
Note that retaining Raw Data for longer periods of time will use more database space. Hence, this value needs to be set judiciously.
Notes
Related Articles
Script files required to restore a Data Archive in RSA Identity Governance & Lifecycle 47Number of Views Data purging fails with "ORA-20001: No jobs were found to delete" in RSA Identity Governance & Lifecycle 7.1.1 63Number of Views Data Archiving fails in Data Purging step in RSA Identity Governance & Lifecycle 214Number of Views ORA-22285 error running Data Archiving of RSA Identity Governance & Lifecycle 32Number of Views How to run the View Definitions file when restoring a Data Archive in RSA Identity Governance & Lifecycle 42Number of Views
Trending Articles
RSA Authentication Manager 8.9 Setup and Configuration Guide How to 'Trust' the RSA Authentication Manager Security Console Self-Signed Root CA certificate and prevent Cert warnings. RSA Authentication Manager 8.9 Release Notes (January 2026) Configure RSA Authentication Manager as a Secure Proxy Server for Cloud Access Service RSA Authentication Manager Upgrade Process
Don't see what you're looking for?