Final Version of BizTalk Terminator Tool Released

I just wanted to announce that the final version of the standalone BizTalk Terminator tool – v2.5 – has just been released. Terminator functionality is not going away. All further development will continue via the maintenance node in BizTalk Health Monitor (BHM). Below is a quick comparison of the two versions of Terminator:   Tool Version…


BizTalk 2013 R2 CU1 install failing with “Package does not contain compatible branch patch”

We’ve had a number of people run into the following issue so I just wanted to provide an explanation and solution.   Issue: BizTalk 2013 R2 Cumulative Update 1 (CU1) install fails with “Package does not contain compatible branch patch” error:   Explanation: This issue is happening in environments where a version of BizTalk Health…


BizTalk Terminator STILL Not Cleaning Up Caching Items?

I originally published my BizTalk Terminator Not Cleaning Up Caching Items blog back in 2011 where I suggested to use the Terminate Multiple Instances (Hard Termination) task if the normal WMI-based Terminate Cache Instances task doesn’t clean up all the caching instances. Since then, I’ve come across a caching cleanup scenario that even the hard…


BizTalk Terminator – Now Available via BHM

I just wanted to let everyone know that BizTalk Terminator is now also available as a part of BizTalk Health Monitor (BHM) – the new BizTalk tool that integrates MBV and Terminator functionality into an MMC Snap-In that you can run as a part of your BizTalk Admin Console.   Update:  Final version of standalone Terminator…


BizTalk 2013 or 2010 Hosts Crashing

I’ve seen some posts on some discussion boards and blogs and support cases opened on this BTS2013 issue so I just wanted to provide some general information about the problem, what your workaround options are, and details on the fix.  Problem Periodically, your BizTalk host process crashes with the following errors in the eventlogs.  Note the…


Duplicate key row in object ‘dbo.bts_LogShippingJobs’

A customer was setting up Log Shipping disaster recovery for their BizTalk Server 2006 R2 environment.  They had gotten to the step where they run the stored procedure bts_ConfigureBizTalkLogShipping. They received the error “Msg 2601, Level 14, State 1,  Procedure bts_ImportSQLAgentJobs, Line 56 Cannot insert duplicate key row in object ‘dbo.bts_LogShippingJobs’ with unique index…


BizTalk EDI Leap Year Fix FAQ

As you  may have heard, there is an issue in the BizTalk 2006 R2 and 2009 EDI Engines that results in a failed EDI transaction if the EDI message contains a date node that has a leap year value – for example 2/29/2012.  This issue and hotfix is documented at  With 2/29/2012 just days…


Creating partitioned View in the BAM Archiving Database

  Carl Nolan of the UK Solution Development Team wrote an excellent blog post on the above topic.  He includes a script for creating partitioned views that can be used if modifications to the existing activity items are continuing to be made.


BizTalk Terminator Not Cleaning Up Caching Items?

  UPDATE:  See BizTalk Terminator STILL Not Cleaning Up Caching Items for additional info on this plus a new cache cleanup task that can simplify all of this.   I’ve been pinged a number of times on this so thought I should blog the workaround and an explanation.  First, let’s say MBV shows you something…