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

Document created by RSA Customer Support Employee on Aug 31, 2016Last modified by RSA Customer Support Employee on Apr 21, 2017
Version 4Show Document
  • View in full screen mode

Article Content

Article Number000033800
Applies ToRSA Product Set: RSA Governance & Lifecycle (RSA GNL)
RSA Version/Condition: 7.0
IssueWhen 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
ResolutionThe 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.

NotesYou can check the settings you have for the Database Statistics Collection from Collectors > Scheduling.
User-added image