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