Monitor BizTalk Server (BizTalkMgmtDb)job is failing RRS feed

  • Question

  • On my server the Monitor BizTalk Server (BizTalkMgmtDb)job is failing.

    It shows error as  : 372 Orphaned DTA Service Instances in (mysql servername).BizTalkDTADb
                         672 Orphaned DTA Service Instances in (mysql servername).BizTalkMsgBoxDb

    When I run this query it shows me the count :

    SELECT * FROM [BizTalkMgmtDb].[dbo].[btsmon_Inconsistancies]

    Well for BizTalkMsgBoxDb I can see the records when I run this query :

    SELECT * FROM [BizTalkMsgBoxDb].[dbo].[Spool] S join [BizTalkMsgBoxDb].[dbo].[MessageRefCountLogTotals] mrlfon s.[uidMessageID ]=mrlf.[uidMessageID ] where mrlf.snRefCount='-1' ORDER BY dtTimeStamp desc

    I know BTSTerminator tool is recommended by Microsoft, its a long process stopping databases, jobs and all. Moreover
    our Management denied to do this.

    So, is there a way I can write delete statement for the above query to terminate the Orphaned messages ?

    Is there a query for doing the same terminate the Orpaned messages from BizTalkDTADb ?

    Please advise


    Thursday, September 19, 2019 3:14 PM

All replies