Troubleshooting Searches and Keywords issues in Archive Manager (4279636)

There are possibly diferent issues why the searches 

1. Get the FTI and the FTS logs (You can find them in Quest\ArchiveManager\Logs) and send it to Support.

    They will check the FTI log for any noticeable errors and the FTS.log to see what search criteria you are using.  

2. Restart the Full Text Index and Full Text Search services and try your search again.

3. Check the index Status under Index Dashboard | Message Index Tab Or  Attachment index Tab|Status table 

4. Open SQL Server Management Studio and expand the AfterMail_Temp database. How many tables are here? If there is a lot; stop the "FTS and FTI  Services" and run the following script that will clear out the Temp tables:

Warning Note: It is important that you run the script against the AfterMail_TEMP database. What this script does is that it drops all tables. If you run it by accident against another database you will drop all the tables and Quest Software does not assume any liability for mis-use of a query. It is always a best practice to ensure your SQL databases are backed up. However, for the AfterMail_TEMP tables, we're clearing out the tables as they're temp anyway, and can impact searches with previously cached results.

                              USE AfterMail_TEMP 

                              exec sp_MSforeachtable "DROP TABLE ? PRINT '? dropped' "

                              GO 

5. Open the Configuration Console on the Archive Manager machine and click Advanced.

    Navigate to Full Text Max Search Results, set the value to 50 million.

                              E.g. 50000000

6. Once that has been confirmed and the Temp tables are dropped:

• Start the FTS and FTI Services.
• Close the browser that you were doing a Search with.
• Perform an IISReset on the Archive Manager machine from Command Prompt.
• Try your Search Again.