0

Find Orphaned DTA Service Instances with SQL Query

Posted by Chris Straw on October 26, 2013 in BizTalk, SQL Server |

Tweet I was trying to find what messages were being orphaned, so I started doing a little digging to figure out how I could get more detail. With that being said, I still use the Terminator to fix the issue.  I do NOT recommend updating or changing any messages in the messagebox without consent from […]

Tags: ,

0

SQL Query to list BizTalk Hosts

Posted by Chris Straw on October 26, 2013 in BizTalk, SQL Server |

Tweet This query will give you a list of the BizTalk Hosts:

Tags: ,

2

Monitor BizTalk Server (BizTalkMgmtDb) SQL Job Fails

Posted by Chris Straw on May 1, 2012 in BizTalk, SQL Server |

Tweet A client was experiencing failures with the BizTalk job Monitor BizTalk Server (BizTalkMgmtDb), which calls stored procedure [dbo].[btsmon_Inconsistent]. This proc calls several other stored procedures to cleanup the messagebox and other meta-tables within BizTalk. These procs generate dynamic SQL scripts and to run against the tables within the BizTalk databases.  Depending on your configuration, […]

Tags: ,

0

How to Clear or Purge the Biztalk Tracking Database

Posted by Chris Straw on April 7, 2012 in BizTalk, SQL Server |

Tweet Stop all running Biztalk services, load up SQL Management Studio, on the BiztalkDTADb database run the following script. Note that this script does not archive data. The last part shrinks the database and log files.

Tags: ,

0

One or more instances of the orchestration still exist – BizTalk 2010

Posted by Chris Straw on November 28, 2011 in BizTalk |

Tweet When I tried to deploy a biztalk application to the server, I got an the error “Could not change the bindings for orchestration ‘orchestration_name_here’, Version=x.x.x.x,Culture=neutral, PublicKeyToken=sometoken’ as one or more instances of the orchestration still exist”. Now what? What does it mean? Quite simply, you have a resumable message sitting in the queue. If […]

0

View Message Count by BizTalk Orchistration

Posted by Chris Straw on November 27, 2011 in BizTalk, SQL Server |

Tweet This script will give you a count of all messages by orchestration within BizTalk. This includes currently processing messages.

0

Count of Active or Started Messages in BizTalk.

Posted by Chris Straw on November 27, 2011 in BizTalk, SQL Server |

Tweet This script will give you a count of active messages within BizTalk. This includes currently processing messages, as well as suspended resumable messages. Run this against the BizTalkDTADb.

Tags: ,

0

SQL Script for suspended message detail in BizTalk

Posted by Chris Straw on November 27, 2011 in BizTalk, SQL Server |

Tweet This Script will give you detailed information on suspended message in BizTalk. Run this script against the BizTalkMsgBoxDb.

Tags: ,

0

Count of Suspended Messages in BizTalk

Posted by Chris Straw on November 27, 2011 in BizTalk, SQL Server |

Tweet This SQL Script will give you the count of all suspended messages in BizTalk. Run this against the BizTalkMsgBoxDb.

Tags: ,

0

BizTalk Macros

Posted by Chris Straw on June 27, 2011 in BizTalk |

Tweet Here is a list of the File Name Macros.  You can use a combintation of these to create your file names in the FILE transport properties (see screen shot below). Macro Definition %datetime% Coordinated Universal Time (UTC) date time in the format YYYY-MM-DDThhmmss (for example, 1997-07-12T103508). %datetime_bts2000% UTC date time in the format YYYYMMDDhhmmsss, […]

Tags:

Copyright © 2011-2019 Chris Straw All rights reserved.
This site is using the Desk Mess Mirrored theme, v2.5, from BuyNowShop.com.