Spectrum Report Manager Data Retention Policy and Data Retention Period usage

Document ID : KB000048439
Last Modified Date : 14/02/2018
Show Technical Document Details

Description:

The following is an explanation around the usage of the Spectrum Report Manager (SRM) data retention policy and data retention period which is set via the OneClick (OC) web user interface / Administration / Report Manager / Preferences.

Further information around this can also be found in the SRM Installation and Administration guide under section "Configure Data Retention".

Solution:

  1. The data retention policy can override the data retention period.
  2. If the data retention policy is set to all data this means that no data is purged or archived, everything is kept and the retention periods set are not in force.
  3. In order for the retention periods for the transformed and event tables to be applied you need to set to purge or archive.
  4. Purging retains data in the transformed and event tables up to the number of days specified then deletes older records.
  5. Archive keeps data up to the retention period but then archives data older than that- However Spectrum SRM cannot use this archived data.
  6. It should be considered that certain reports are generated using transformed tables or the event table.
  7. This means that for example a report such as an alarm report that pulls data from the transformed tables will only be able to be run a report for the number of days set in the retention period specified for the transformed tables.
  8. Similarly a report that pulls data from the event table will only be able to be run a report for the number of days set in the retention period specified for the event table.
  9. If you change the retention policy to either purge or archive you need to restart the OC / SRM tomcat process.
  10. The purging process starts at midnight.
  11. The archiving process starts at 00:30

NOTE: There is a limit of 1.4 million records returned in SRM reports.