How to fix "At least one object must implement IComparable." from Marketo after copying Episerver database?

  • Page Owner: Not Set
  • Last Reviewed: 2019-01-07

I copied an Episerver database from one environment to another, and now I'm getting a "At least one object must implement IComparable" error that appears to be coming from the Marketo add-on. What is causing this error and how can I resolve it?


Answer

The Marketo settings are stored in DDS, encrypted with the server's machine key. When the database moves, the new server's machine key will be unable to decrypt the settings. Your options are to ensure both servers have the same machine key, or delete and recreate the settings on the new server through the admin.

To delete the settings and start over, execute this SQL: DELETE FROM tblBigTable WHERE StoreName LIKE 'EPiServer.MarketingAutomationIntegration%'