Created On:  30 November 2010

Problem:

The following error is generated in the log file when running an online purge:

"Cannot insert duplicate key row in object 'dbo.purged_attachment_ids' with unique index"

Resolution:

This is caused by a record containing a NULL character in the "purged_attachments_ids" table. To remove this record execute the following SQL statement,

DELETE FROM purged_attachment_ids
WHERE attachmentid = ''

When this has completed, restart the server and then re-start the online purge.
Incident #2470151