BizTalk Administration Console – Failed to enable constraints. One or more rows contain values violating non-null, unique, or foreign-key constraints.

Just a reminder in my own online error log 🙂 I got this error for the first time in my life and came across some solutions online. If you try to expand the Applications node (or refresh your configuration in general), you’ll end up getting the following error:

Failed to enable constraints. One or more rows contain values violating non-null, unique, or foreign-key constraints.

The solution is simple: Restart the Distributed Transaction Coordinator