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
Data purging fails with ORA-02292: integrity constraint (AVUSER.FK_xxxxxx violated - child record found) in RSA Identity G… 181Number of Views Deleting data from Workflow tables throws error in Identity Governance & Lifecycle 28Number of Views Data Purging after Data Archiving run may take longer than expected in RSA Identity Governance & Lifecycle 65Number of Views RSA Identity Governance & Lifecycle startup fails with "Unable to start service WorkflowService. java.lang.IndexOutOfBound… 112Number of Views Data purging fails with "ORA-20001: No jobs were found to delete" in RSA Identity Governance & Lifecycle 7.1.1 61Number of Views
Trending Articles
Quick Setup Guide - Passwordless Authentication in Windows MFA Agent for Active Directory RSA Authentication Manager 8.9 Release Notes (January 2026) How to factory reset an RSA Authentication Manager 8.x hardware appliance without a factory reset button from the Operatio… Deploying RSA Authenticator 6.2.2 for Windows Using DISM Artifacts to gather in RSA Identity Governance & Lifecycle
Don't see what you're looking for?