Tuesday, 05 June 2012 17:23

Extract Messages from BizTalk Suspended Messaging Instances

Written by 
Rate this item
(8 votes)

Extract Messages from suspended instances

Scenario:

BizTalk 2010 and SQL 2008 R2 is the environment we have used fore this scenario.

You have problem with some integrations, 1500 suspended instances inside BizTalk and you need to send the actual messages to a customer, and then you properly do not want to manually save out this from BizTalk Administrator.

There are a lot of blogs and Internet resources pointing out vbs, powershell scripts how to do this, but I have used BizTalk Terminator to solve this kind of scenarios.

As you now BizTalk terminator is asking you 3 questions when the tool starts

  1. 1.All BizTalk databases are backed up?
  2. 2.All Host Instances is stopped?
  3. 3.All BizTalk SQL Agents is stopped?

This is ok when you are going to actually change something inside BizTalk databases but this is not what you are going to do in this scenario you are only using the tool to read from BizTalk databases. But you should always have backups off BizTalk databases.

You are always responsible for what you are doing, but when we have used this tools in the way I describe we have not have any problem with this scenario.

So after you have start Terminator tool please click yes to the 3 questions(you dont need to stop anything in this scenario) then connect to the correct environment please do this in your test environment first so you feel comfortable with this scenario, the next step is to choose a terminator task choose Count Instances(and save messages) after this you have to fill in the parameter TAB with correct serviceClass and Hostname and set SaveMessages to True and last set FilesaveFullPath to the correct folder you want to save the messages to.

Then you can choose to click on the Execute Button and depending of the size and how many it can take some time, after this disconnect Terminator do NOT do anything else.

You should now if you have filled in the correct values in the parameter TAB have the saved messages inside the FilesaveFullPath folder.

See attachment for more details

Download BizTalk terminator from this address:

http://www.microsoft.com/en-us/download/details.aspx?id=2846

Read 4554 times Last modified on Tuesday, 05 June 2012 20:10
Peter Winther

Peter Winther is an IT architect at Volvo IT and works with information technology since 1998. He has worked with BizTalk from 2004 inside Volvo IT with BizTalk Operation and he also works with SOA technology, and integration both inside Volvo Group and for external customers.

twitterlinkedin

1 comment

  • Comment Link Lex Hegt Tuesday, 05 June 2012 21:09 posted by Lex Hegt

    Great post Peter!

    I regularly use my self-developed BTSDecompress. This tool even enables me to use XPath queries, so that I only get that part of the message that I need.

Leave a comment

Make sure you enter the (*) required information where indicated. HTML code is not allowed.