The RSA Governance & Lifecycle Raw Data table for collection run IDs is empty
2 years ago
Originally Published: 2016-08-16
Article Number
000065529
Applies To
RSA Product Set: RSA Governance & Lifecycle (RSA GNL)
RSA Version/Condition: 7.0

 

Issue
When accessing previous Collection Run IDs (Admin > MonitoringAccount Data Collection), the Raw Data table has no entries, even though the Task Results table shows entries.

This also happens for the Identity Data Collection and Entitlement Data Collection, as well.
User-added image
Resolution
The Raw Data table would have been purged by the RSA GNL Database Statistics Job. This deletion is based on the output of the following SQL query:
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
You can check the settings you have for the Database Statistics Collection from Collectors > Scheduling.
 
User-added image