Monitor BizTalk Server (BizTalkMgmtDb) job failing

In BizTalk Server 2010 there's a job called Monitor BizTalk Server (BizTalkMgmtDb). This job checks the management and tracking databases and looks for any inconsistencies. If there are none then the job completes successfully. If there are inconsistencies, then the job fails.

The job failing is simply telling you that you must take care of the inconsistencies.

Error message:
Executed as user: [ my user]. 2 Orphaned DTA Service Instances in USWBIZDBSTG01.BizTalkDTADb, 1 Messages with refcount less than 0 in USWBIZDBSTG01.BizTalkMsgBoxDb [SQSTATE 42000] (Error 50000). The step failed.

The numbers may change based on how many inconsistencies the job finds. So don't be surprised if you have more than what I've specified here.

To fix the issue simply run BizTalk Terminator. A search on Microsoft.com will point you to the free download.

• To fix "messages with refcount less than 0" error run Repair Refcounts for All Messages in BTS Terminator.
• To fix "orphaned DTA service instances" error run DELETE Orphaned DTA Service Instance Expections in BTS Terminator.