9
When deleting an email containing attachments from Dynamics, the corresponding entries in the Attachment and ActivityMimeAttachment tables are not deleted.
Instead, an extra entry is added to the ActivityMimeAttachment table with the 'ComponentState' value of 2 (deleted).
Presumably the data is supposed to be cleared by the daily deletion service. The service appears to run the below via SQL, but as the entries still exist in the ActivityMimeAttachment table, it doesn't find anything to delete:
delete top(@numOfRecordsToBeDeleted) from Attachment where AttachmentId not in (select AttachmentId from ActivityMimeAttachment)
This is causing a large amount of database storage to be wasted, as well as a GDPR compliance issue when email attachments are retained after someone requests their personal data to be deleted.
Instead, an extra entry is added to the ActivityMimeAttachment table with the 'ComponentState' value of 2 (deleted).
Presumably the data is supposed to be cleared by the daily deletion service. The service appears to run the below via SQL, but as the entries still exist in the ActivityMimeAttachment table, it doesn't find anything to delete:
delete top(@numOfRecordsToBeDeleted) from Attachment where AttachmentId not in (select AttachmentId from ActivityMimeAttachment)
This is causing a large amount of database storage to be wasted, as well as a GDPR compliance issue when email attachments are retained after someone requests their personal data to be deleted.
STATUS DETAILS
Needs Votes