The following warning and error are logged in Event Log after retention policy is run
Event Type: Warning
Event Source: Message Retention Policy Service
Event Category: None
Event ID: 0
Date: 23/01/2010
Time: 23:00:20
User: N/A
Computer: ServerName
Description:
Retention.Service: Policy execution failed.
Event Type: Error
Event Source: Message Retention Policy Service
Event Category: None
Event ID: 0
Date: 23/01/2010
Time: 23:00:20
User: N/A
Computer: ServerName
Description:
Retention.Service: Error detected while logging ExecutionLogItem: Delete: Policy context FTS error
Event Type: Error
Event Source: Message Retention Policy Service
Event Category: None
Event ID: 0
Date: 23/01/2010
Time: 23:00:20
User: N/A
Computer: ServerName
Description:
Retention.Service: Full text search returns Error: Invalid object name AfterMail_TEMP.dbo.MFT_XXXXXXXXXXXXXXXXXXXXXXXXXXXX.
Invalid object name AfterMail_TEMP.dbo.MFT_XXXXXXXXXXXXXXXXXXXXXXXXXXXX.
EXEC6: INSERT INTO #TempMessages (MessageID) SELECT DISTINCT Message.MessageID
FROM Message (nolock)
JOIN AfterMail_TEMP.dbo.MFT_XXXXXXXXXXXXXXXXXXXXXXXXXXXX MessageFullText ON Message.MessageID = MessageFullText.MessageID
WHERE Message.MessageDate BETWEEN @DateFrom AND @DateTo
NOT USING CACHE: INSERT INTO AfterMail_TEMP.dbo.E_YYYYYYYYYYYYYYYYY (MessageID) SELECT Messages.MessageID
FROM #TempMessages Messages
JOIN Message ON Messages.MessageID = Message.MessageID
WHERE Message.Pending = 0
.
The FTI search service is not able to find and create AfterMail_TEMP.dbo.MFT_XXXXXXXXXXXXXXXXXXXXXXXXXXXX
Searching the phrase used in retention policy returns no results saying the search criteria is too broad.
Increase the Full Text Index Max result configuration editors value to enable FTI search to return more results.
Restart Archive Full Text Index Search Service.
