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.
