Jim,

This is a known issue with the product. It doesn't hurt anything, but it is
a little annoying. Basically, it doesn't delete the attachment, so when it
tries to delete the activity, it fails due to RI constraints.

If you really want to get rid of the error, you will need to remove the
attachement record yourself.

Matt

"Jim" <jim@kinetic.distillery.com> wrote in message
news:esCGWqhbDHA.2820@tk2msftngp13.phx.gbl...
I have a CRM implimentation that creates Event log entries every 2 hours
"Error: Can't clean up the following tables: Activity."
I have traced his back to when a user deletes an email activity that has an
attachment.
In the Activitybase table the DeletionStateCode = 2 for an email and an
existing entry is in the ActivityMIMEAttachment table. I can either delete
the ActivityMIMEAttachment record or change the DeletionStateCode back to 0.