none
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



    RH

    Thursday, September 19, 2019 3:14 PM

All replies