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
RSA Identity Governance and Lifecycle - Purge monitor tasks 34Number of Views Data Purging after Data Archiving run may take longer than expected in RSA Identity Governance & Lifecycle 65Number 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 Access denied insufficient privileges error when clicking on entitlement Information icon in RSA Identity Governance and L… 97Number of Views How to purge table data prior to version 7.0.1 in RSA Identity Governance & Lifecycle 1.15KNumber of Views
Trending Articles
RSA Release Notes for RSA Authentication Manager 8.8 Downloading RSA Authentication Manager license files or RSA Software token seed records Quick Setup Guide - Passwordless Authentication in Windows MFA Agent for Active Directory RSA Authentication Manager Patch Updates RSA Authentication Manager 8.7 SP2 Setup and Configuration Guide
Don't see what you're looking for?