Full Text attachment indexing with Bridgehead fails after upgrading to Archive Manager (AM) 4.1 o (4276334)

The following error is logged in the Archive Manager event log when using Bridgehead on Archive Manager 4.1 or 4.1.1:

Event Type: Error
Event Source: FTIAttachmentWorker
Event Category: None
Event ID: 0
Date: 14/12/2009
Time: 09:27:22
User: N/A
Computer: SERVER1
Description:
FullTextIndex.AttachmentIndexer
System.NullReferenceException: Object reference not set to an instance of an object.
at Quest.ArchiveManager.FullTextIndex.AttachmentIndexer.FetchAttachmentsToIndexFromDb(SqlConnection attachmentConnection)
at Quest.ArchiveManager.FullTextIndex.AttachmentIndexer.IndexAttachments()

The following error is logged in the C:\Program Files\ArchiveManager\FTIAttachmentWorker.exe.log log file:

Exception Source: AfterMail Business Layer
Exception Type: System.NullReferenceException
Exception Message: Object reference not set to an instance of an object.
Exception Target Site: GetConnectionStringParameter
Date and Time: 9/14/2009 4:23:26 PM
Machine Name: SERVER1
IP Address: 192.1.1.0
Current User: DOMAIN\ArchiveMgr_Service
CLR Version: 2.0.50727.3053
Platform (version): Win32NT (5.2.3790.131072)
Application Domain: FTIAttachmentWorker.exe
Assembly Codebase: file:///C:/Program Files/ArchiveManager/FTIAttachmentWorker.exe
Assembly Fullname: FTIAttachmentWorker, Version=4.1.1.436, Culture=neutral, PublicKeyToken=null
Assembly Version: 4.1.1.436


---- Stack Trace ----
at AfterMail.BusinessLayer.BridgeheadManager.GetConnectionStringParameter(String keyname, String def)
at AfterMail.BusinessLayer.BridgeheadManager.get_ApplicationName()
at AfterMail.BusinessLayer.BridgeheadManager..ctor()
at AfterMail.BusinessLayer.BridgHeadAttachment.GetFileFromBridgehead()
at AfterMail.BusinessLayer.Br

1. Delete any temp files from "C:\Documents and Settings\ArchiveMgr_Service\Local Settings\Temp"
    
2. Disable Doctor Watson as per: http://support.microsoft.com/kb/188296
    
3. Stop the Full Text Index Service and run it in console mode by running the following command in a DOS prompt:
   
   "C:\Program Files\ArchiveManager\Archive Full Text Index Service.exe" -console
    
4. Ignore any error message windows that pop up, do not click OK.

It is also recommended that the number of attachments pending index be cleaned up to remove duplicate entries and non-indexable files.

There are two SQL queries that can reduce the amount of unecessary entries in the attachmenttoindex table, the first is a script that will remove all duplicates entries in the attachmenttoindex table:

USE ArchiveManager
SELECT DISTINCT * INTO attachmenttoindex_temp FROM attachmenttoindex GROUP BY attachmentfileid HAVING COUNT(attachmentfileid) > 1
DELETE attachmenttoindex WHERE attachmentfileid IN (SELECT attachmentfileid FROM attachmenttoindex_temp)
INSERT attachmenttoindex SELECT * FROM attachmenttoindex_temp

DROP TABLE attachmenttoindex_temp

The second script is one that will remove all 'jpg','gif','mp3','bmp','mpg' and 'tif' files from the attachmenttoindex table:

USE ArchiveManager
delete from attachmenttoindex where attachmentfileID in (select attachmentfileID from attachmentfile where FileType in ('jpg','gif','mp3','bmp','mpg','tif'))

Running both of these scripts (in any order) will reduce the amount of unecessary entries in the attachmenttoindex table and streamline the process of indexing attachments.