|Applies To||RSA Product Set: Archer|
RSA Product/Service Type: Archer
RSA Version/Condition: 5.x
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?
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