The RSA Governance & Lifecycle Raw Data table for collection run IDs is empty

Originally Published: 2016-08-16

Last Modified: 2023-10-06

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 > Monitoring > Account 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.

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.

Don't see what you're looking for?

Related Articles

Trending Articles