000033570 - Database table tblNotificationQueue_tmp consuming large amount of disk space in RSA Archer GRC 5.x

Document created by RSA Customer Support Employee on Jul 20, 2016Last modified by RSA Customer Support Employee on Apr 21, 2017
Version 2Show Document
  • View in full screen mode

Article Content

Article Number000033570
Applies ToRSA Product Set: Archer
RSA Product/Service Type: Archer
RSA Version/Condition: 5.x
 
Issue

In the Archer Configuration Report - Instance Report, in the top 10 tables section, there is a table called tblNotificationQueue_tmp consuming around ~12GB. There is historic data in this table from several years ago and nothing from recent times.  This table does not exist in other Archer instance databases.  What is this table?  Is it necessary?

Resolution

This table was created by the "migration scripts" used to upgrade Archer from version 4.x to 5.x.  The table should have been dropped at the end of the process, but for some reason it was not.  This table is not necessary and can be deleted by running the following SQL command against the Instance database:


DROP TABLE tblNotificationQueue_tmp

Attachments

    Outcomes