How to rebuild the Archive Manager Full Text Index (4246632)

How to rebuild the Archive Manager Full Text Index

Performing a search for an email using the Search or Advanced search doesn't return the expected results. Searching on date range and email address may still be operational. .

Under some circumstances the Full text Index can become corrupt, this can result in the following error being displayed:

Exception Source: mscorlib
Exception Type: System.ArgumentOutOfRangeException
Exception Message: Index was out of range. Must be non-negative and less than the size of the collection.
Parameter name: index
Exception Target Site: get_Item

OR

Could not find file 'D:\Quest Software\ArchiveManager\Index\Message\_9p7kw.fdt'.

OR

The constructor to deserialize an object of type 'Lucene.Net.Index.CorruptIndexException' was not found.

Under some circumstances the Full text Index can become corrupt, this can happen due to system hard booting during indexing, or problems connecting to the SQL server.

The Full Text Index may become corrupt, requiring either repair or reindex/rebuild procedures. Resolution 1 outlines index repair, while Resolution 2 details index rebuild steps.

Resolution 1: Index Repair

To repair the index, follow these steps:

1. Attempt to repair the index using the solution provided in the following article: https://support.quest.com/archive-manager/kb/4263195/how-to-repair-a-corrupted-archive-manager-full-text-index

Resolution 2: Index Rebuild

Perform the following steps to reindex/rebuild the Archive Manager message and attachment index:

1. Stop the ESM Service and disable the Journaling Data Loader if applicable.
2. Allow the Data Load Service to clear out the export directory.
3. Stop all other Archive Manager Services, including Data Load.
4. Execute the following SQL queries against the Archive Manager Database:

DELETE FROM Messagetoindex

DELETE FROM Attachmenttoindex

5. Locate the Attachment and Message folders in the Index folder on the AM server. Move them to a different location.
6. Open a command prompt as the user running the Full Text Index service (typically ArchiveMgr_Service):
   - Navigate to Program Files\Quest\ArchiveManager.
   - Run Archive Full Text Index Service.exe` with the -reindex switch:     

Archive Full Text Index Service.exe -reindex

7. Wait for the reindexing process to complete.
8. Start all Archive Manager services.
9. Monitor the progress by running SQL queries like `Select count(*) from messagetoindex` or `Select count(*) from attachmenttoindex`.

Note: Reindexing duration depends on archive size; search results may be incomplete until reindexing finishes, which could take several days.

It is also possible to reindex messages of a specific date range using the following SQL queries. This can be used in situations where Full Text Search results are not being returned between a specific set of dates: To reindex messages between '24-JUNE-09' and '13-AUGUST-09': USE ArchiveManager INSERT INTO messagetoindex SELECT MessageID FROM Message WHERE Message.DateProcessed > '24-JUNE-09' AND Message.DateProcessed < '13-AUGUST-09' To reindex all messages older than '24-JANUARY-10': USE ArchiveManager INSERT INTO messagetoindex SELECT MessageID FROM Message WHERE Message.DateProcessed < '24-JANUARY-10' To reindex all attachments between '31-JULY-2010' and '1-AUGUST-2010': USE ArchiveManager INSERT INTO attachmenttoindex SELECT attachmentfileid FROM attachment WHERE messageid IN ( SELECT messageid FROM message WHERE Message.DateProcessed > '31-JULY-2010' AND Message.DateProcessed < '1-AUGUST-2010' ) To reindex all messages in a specific user's mailbox (replace `1` with the appropriate `mailboxid`): INSERT INTO messagetoindex SELECT messageid FROM mailboxmessage WHERE mailboxid = 1 If you need to find the `mailboxid` for a user named 'John Doe', use: SELECT * FROM mailbox WHERE name LIKE 'John Doe%' These queries allow targeted reindexing of messages and attachments based on date ranges or specific mailboxes to resolve issues with Full Text Search results.