Unable to Terminate BizTalk Orchestration Instances

I had several orchestration instances in BizTalk 2006 that would not terminate. I tried tons of different things, but finally happened upon the MsgBoxViewer tool. When I ran the tool, I received the following error messages:

Missing Restart Msg in Spool table (can prevent some svc instances to be resumed, terminated or suspended) !!

Missing Suspend Msg in Spool table (can prevent some svc instances to be resumed, terminated or suspended) !!

Missing Terminate Msg in Spool table (can prevent some svc instances to be resumed, terminated or suspended) !!

Missing ResumeInDebugMode Msg in Spool table (can prevent some svc instances to be resumed, terminated or suspended) !!

They pointed me to an article which referred to a Terminator tool. But, apparently that tool is presently only available from Microsoft support. I didn’t want to open a support incident and go through that process.

I Googled “Missing Restart Msg in Spool table” and came across a blog post that gave me what I needed. Apparently, in my zeal to destroy these instances I deleted some control records in the Spool table of the message box DB. After replacing them with the following script, I restarted the host instances and the instances terminated successfully.

— Inserting Restart Message for use in service recovery
INSERT INTO Spool (uidMessageID, nNumParts, nCounter, imgContext) VALUES (N’61EAA7FC-AC85-42d9-BF3E-1BED258B82BE’, 0, 0, 0xD4E0906C1849D311A24200C04F60A53302000000090000009800000050006100720074004E0061006D00650073005E0068007400740070003A002F002F0073006300680065006D00610073002E006D006900630072006F0073006F00660074002E0063006F006D002F00420069007A00540061006C006B002F0032003000300033002F006D006500730073006100670065006100670065006E0074002D00700072006F007000650072007400690065007300000001000000010820010000000000000000000700000098000000540069006D0065007200490044005E0068007400740070003A002F002F0073006300680065006D00610073002E006D006900630072006F0073006F00660074002E0063006F006D002F00420069007A00540061006C006B002F0032003000300033002F0078006C0061006E00670073002D00720075006E00740069006D0065002D00700072006F0070006500720074006900650073000000010000000008004A000000300030003000300030003000300030002D0030003000300030002D0030003000300030002D0030003000300030002D003000300030003000300030003000300030003000300030000000)

— Inserting Suspend Control message
INSERT INTO Spool (uidMessageID, nNumParts, nCounter, imgContext) VALUES (N’2BE3D5B8-5685-40F2-BD97-51ADA3D02347′, 0, 0, 0xD4E0906C1849D311A24200C04F60A53303000000000000001E000000420069007A00540061006C006B0043006F006E00740072006F006C000000020000000008002A000000410064006D0069006E00530075007300700065006E00640049006E007300740061006E00630065000000000000000C0000004A006F006200490044000000020000000008004E0000007B00340037004100450033003300380034002D0031003000410041002D0034003400430033002D0038003200350036002D003200350033003400380045004200390032004200320031007D000000090000009800000050006100720074004E0061006D00650073005E0068007400740070003A002F002F0073006300680065006D00610073002E006D006900630072006F0073006F00660074002E0063006F006D002F00420069007A00540061006C006B002F0032003000300033002F006D006500730073006100670065006100670065006E0074002D00700072006F00700065007200740069006500730000000100000001082001000000000000000000)

— Inserting Terminate Control message
INSERT INTO Spool (uidMessageID, nNumParts, nCounter, imgContext) VALUES (N’57E5E753-0207-435D-8BE7-2B9F3C6556F9′, 0, 0, 0xD4E0906C1849D311A24200C04F60A53303000000000000001E000000420069007A00540061006C006B0043006F006E00740072006F006C000000020000000008002E000000410064006D0069006E005400650072006D0069006E0061007400650049006E007300740061006E00630065000000000000000C0000004A006F006200490044000000020000000008004E0000007B00350032003500390031004600310031002D0046003700370034002D0034003600330038002D0042004300390041002D003200380034003800380034003600300034003500450032007D000000090000009800000050006100720074004E0061006D00650073005E0068007400740070003A002F002F0073006300680065006D00610073002E006D006900630072006F0073006F00660074002E0063006F006D002F00420069007A00540061006C006B002F0032003000300033002F006D006500730073006100670065006100670065006E0074002D00700072006F00700065007200740069006500730000000100000001082001000000000000000000)

–Inserting Resume in Debug Mode message
INSERT INTO Spool (uidMessageID, nNumParts, nCounter, imgContext) VALUES (N’50D173AF-5D6F-4D5F-AE23-1A7178CEBDC3′, 0, 0, 0xD4E0906C1849D311A24200C04F60A53303000000000000001E000000420069007A00540061006C006B0043006F006E00740072006F006C0000000200000000080026000000410064006D0069006E004400650062007500670049006E007300740061006E00630065000000000000000C0000004A006F006200490044000000020000000008004E0000007B00330032003800330030004500450045002D0035004400330041002D0034003700370037002D0041003200440035002D003100320033004100450035004600340044004500420039007D000000090000009800000050006100720074004E0061006D00650073005E0068007400740070003A002F002F0073006300680065006D00610073002E006D006900630072006F0073006F00660074002E0063006F006D002F00420069007A00540061006C006B002F0032003000300033002F006D006500730073006100670065006100670065006E0074002D00700072006F00700065007200740069006500730000000100000001082001000000000000000000)

The scripts run off the page on the blog, but they came from the MsgBoxSchema.sql file in the “C:\Program Files\Microsoft BizTalk Server 2006\Schema” folder. I copied them from there.

Hopefully this will be helpful to someone else. I want to be sure and keep track of these tools for future reference!

Advertisements

One thought on “Unable to Terminate BizTalk Orchestration Instances

Leave a Reply

Fill in your details below or click an icon to log in:

WordPress.com Logo

You are commenting using your WordPress.com account. Log Out / Change )

Twitter picture

You are commenting using your Twitter account. Log Out / Change )

Facebook photo

You are commenting using your Facebook account. Log Out / Change )

Google+ photo

You are commenting using your Google+ account. Log Out / Change )

Connecting to %s