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
Deleting data from Workflow tables throws error in Identity Governance & Lifecycle 28Number of Views Data purging fails with ORA-02292: integrity constraint (AVUSER.FK_xxxxxx violated - child record found) in RSA Identity G… 180Number of Views Diagnostics and System Data Gathering Feature in RSA Identity Governance & Lifecycle 99Number of Views How to purge table data prior to version 7.0.1 in RSA Identity Governance & Lifecycle 1.14KNumber of Views Why and how to increase Oracle redo log size using RSA Identity Governance & Lifecycle 318Number of Views
Trending Articles
Passwordless Authentication in Windows MFA Agent for Active Directory – Quick Setup Guide RSA Authentication Manager 8.9 Release Notes (January 2026) RSA Authentication Manager Upgrade Process RSA Authentication Manager 8.7 SP2 Setup and Configuration Guide An example of SSO using SAML and ADFS with RSA Identity Management and Governance 6.9.x
Don't see what you're looking for?