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
RSA MFA Agent 2.3.6 for Microsoft Windows Installation and Administration Guide RSA Authentication Manager 8.9 Release Notes (January 2026) How to install the jTDS JDBC driver on WildFly for use with Data Collections in RSA Identity Governance & Lifecycle RSA Authentication Manager 8.8 Setup and Configuration Guide Artifacts to gather in RSA Identity Governance & Lifecycle
Don't see what you're looking for?