Monitor Biztalk Server Biztalkmgmtdb Sql Agent

Asked By jess wwagner 0 points N/A Posted on - 07/08/2019

In BizTalk Server 2013 R2, there is a command called Monitor BizTalk Server (BizTalkMgmtDb). This job checks the administration and tracking databases and looks for inconsistencies. If none exists, the job completes successfully. If there are inconsistencies, the job fails. The failed job simply indicates that you need to deal with inconsistencies.

Error message:

Run as user: AD-ENT \ DBA_LIFTS_SQL_SSDE_N. 67981 Orphan DTA service instances in WUPWD02V0310 \ BTBAMUAT.BizTalkDTADb [SQLSTATE 42000] (Error 50000). The step failed.

How can I solve this?

• Status: Open
• Question Views: 66
• Answer Count: 1
• Vote Up 0 Vote Down

• Answer Accepted: No
• Question Category: Hardware
• Question Tags: Monitor

Answered By Raymond J Corbin 0 points N/A #319999

Monitor Biztalk Server Biztalkmgmtdb Sql Agent

You can solve it using BizTalk Terminator or BizTalk Health Monitor will likely solve your problems. If you want to know more about queries running in the background when troubleshooting, follow these steps: Run a SQL Profiler to check for running database queries. While this may violate some EULAs, you can even decompile binary files to understand exactly what’s going on.

This will get your problem resolved!

About Raymond J Corbin

Questions
4

Answers
4

Best Answers
0

• Vote Up 0 Vote Down

• Posted on - 07/08/2019
• Question Category: Hardware