BizTalk Server Administration Error: Troubleshooting and Solving

Introduction

I recently encountered an error during some troubleshooting related to BizTalk. The was new to me and I wanted to share the solution with the community. So, in the future, if anyone faces this issue then they can try this option as well.

When I was trying to expand the applications, the below error popped up and it was failed to load the applications.

Error

------------------------------

Failed to enable constraints. One or more rows contain values violating non-null, unique, or foreign-key constraints. (Microsoft.BizTalk.Administration.SnapIn) 

------------------------------

BUTTONS: OK

Even I was able to open Host & HostInstance.

Cause

There could be multiple causes for this issue, and the most common cause is a connectivity issue between the BizTalk application and the database. So, to troubleshoot this issue, we have to check the connectivity and then event log for any type of errors.

Resolution

In such cases, first check if you are able to connect BizTalk databases, mainly BizTalkMgmtDb. If you can, then your connection is not the problem.,

Now, the second step is to check if the DTC (Distributed Transaction Coordinator) service is running on the BizTalk application server. If DTC service is stopped, then start it; if it's already running, then just restart the DTC service

Verification

Once the issue is resolved, refresh the BizTalk admin console and, boom, you're all set to go!