Return
-
Title
Error When Running Retention Cannot insert duplicate key in object 'dbo.#TempMessages' -
Description
An error is generated when running retention similar to:
Retention.Service: ERROR - Full text search returns Error: Violation of PR
IMARY KEY constraint 'PK__#TempMessages_____4A29AA95'. Cannot insert duplicate key in object 'dbo.#TempMessages'.
The statement has been terminated. -
Resolution
Stop Archive Full Text Search service and Full Text index service and drop all the temp tables from the AfterMail_TEMP database by running bellow SQL query. Verify that you run the command below only against the AfterMail_Temp database and NOT the Archive Manager database.
USE Aftermail_Temp
EXEC SP_MSForEachTable'DROP TABLE ?'Once the above SQL query has been ran, start the Archive Full Text Search service and Full Text index service