Find information for orphaned messages

This SQL query is designed for BizTalk version 2006 - 2010. It is created to gather inforamtion from the DTA database to locate orphaned messages. It will provide you with information from the service that creates the orphan message so it can be resolved.This script can also be r

 
 
 
 
 
5 Star
(11)
4,043 times
Add to favorites
Servers
3/6/2012
E-mail Twitter del.icio.us Digg Facebook
  • Also valid for bts 2014 - 2016
    1 Posts | Last post October 07, 2019
    • This script is also compatible with BizTalk Server 2016
  • Query Orphan Message Details
    1 Posts | Last post November 07, 2015
    • Hello, 
      Is there a way to get message details of the Orphan messages?  I was able to use the other articles for getting Suspended Messages details using the "BizTalkOperations" Class (GetMessage(uidMessageId, uidInstanceId, msgBoxDB)) successfully but when I use it for a message that had gone orphan, it couldn't create the message object.  I can see in the backend that the message exists - I just don't have a way of decompressing the message body/part.
      
      Please help, thanks.
  • How can I find the application?
    1 Posts | Last post March 30, 2015
    • This query gives the error message.
      In most cases I can find the application in the text of the error.
      However in some cases the error is NULL.
      I have added the service name but in most cases the servicename is a generic pipeline. So this still doesn't return the application name.
      
      SELECT 
      si.[nServiceInstanceId]
      ,s.[strServiceName]
      ,si.[dtStartTime]
      , REPLACE(REPLACE(SUBSTRING(ErrorInfo,1,10000), CHAR(10),' '),CHAR(13),' ') as foutmelding
      from .[BizTalkDTAdb].[dbo].[dta_ServiceInstances] si, .[BizTalkDTAdb].[dbo].[dta_Services] s
      WHERE s.uidServiceId = si.uidServiceId
      and dtEndTime IS NULL 
      AND uidServiceInstanceId NOT IN (
      SELECT uidInstanceID FROM .[BizTalkMsgBoxDb].[dbo].[Instances] WITH (NOLOCK)
      UNION
      SELECT StreamID
      FROM .[BizTalkMsgBoxDb].[dbo].[TrackingData] with (NOLOCK))
      ORDER BY dtStartTime ASC
  • How can i Solve the orphaned messages?
    2 Posts | Last post March 06, 2012
    • I have 2.294 orphaned messages, how do I delete them?
    • I recommend you to use the Terminator tool to delete the orpahned messages, you can find the terminator tool here: http://www.microsoft.com/download/en/details.aspx?id=2846
      
      You should also investigate the errors and try to resolve them.