Archive Manager - Unable to search, all searches are down (4379138)

Search operations return no results or errors like “search service unavailable,” despite messages existing in the archive.

- The Archive Manager Full Text Search Service is stopped or hung.  
- The AfterMail_TEMP database has grown excessively because its tables were never cleaned up.

RESOLUTION 1  
1. Open the Archive Manager Console → Services, verify Archive Manager Full Text Search Service is Running; if not, restart it.  

RESOLUTION 2

1. In SQL Server Management Studio, connect to your SQL instance and backup the AfterMail_TEMP database.  
2. To drop every table in AfterMail_TEMP, execute:
   USE AfterMail_TEMP;
   EXEC sp_MSforeachtable 'DROP TABLE ?';
Warning: This is meant to be used only for Aftermail_TEMP, do not attempt this on the ArchiveManager database.  
3. Confirm that AfterMail_TEMP now contains zero user tables.  
4. Ensure the SQL Agent job CleanTempTable is scheduled and running nightly to prevent table buildup.  (If non-existent, please contact support for further assistance)
5. Restart the Archive Manager Full Text Search Service and validate that search queries now return results as expected.