locked
The INSERT statement conflicted with the FOREIGN KEY constraint "email_email_hash". RRS feed

  • Question

  • Getting this error from email router process trying to save inbound emails to crm.

    Search on this SQL Server error linked me to a CMUG note that connected it to an error about embedded images in rich text emails.  I'm assuming Donna Edwards had some reason to connect them.  And the KB says this was fixed about 4 years ago.  Yet we are getting them now.  It continues

    The conflict occurred in database "..._MSCRM", table "dbo.ActivityPointerBase", column 'ActivityId'. The INSERT statement conflicted with the FOREIGN KEY constraint "email_email_hash".

    This results in 24 hours of retries, tying up the database and the email router.  This KB, https://support.microsoft.com/en-us/kb/2934043suggests the handling of rich text images is still this way by design.

    I can't, however, believe that the router retries are by design.  Anything else to look into here?

    Monday, July 27, 2015 8:32 PM

All replies