After running Biztalk MessageBoxViewer (MBV) http://blogs.technet.com/jpierauc/default.aspx
You recieve the following error
Control Message Check Missing Restart Msg in Spool table (can prevent some svc instances to be resumed, terminated or suspended)
Navigate to <drive>:<BizTalk 200x Folder>Schema,
Open “MsgBoxSchema.sql”
Find INSERT INTO Spool (uidMessageID… copy the statment into query analyser and run.
Below are the ones you should execute
NOTE: Remember to backup your databases before running
-- ******************************************************
-- For 2004 you will need the following 1 control message
— ******************************************************
— Inserting Restart Message for use in service recovery
IF (SELECT COUNT (*) FROM Spool WHERE uidMessageID = N’61EAA7FC-AC85-42d9-BF3E-1BED258B82BE’) = 0
BEGIN
INSERT INTO Spool (uidMessageID, nNumParts, nCounter, imgContext) VALUES (N’61EAA7FC-AC85-42d9-BF3E-1BED258B82BE’, 0, 0, 0xD4E0906C1849D311A24200C04F60A53302000000090000009800000050006100720074004E0061006D00650073005E0068007400740070003A002F002F0073006300680065006D00610073002E006D006900630072006F0073006F00660074002E0063006F006D002F00420069007A00540061006C006B002F0032003000300033002F006D006500730073006100670065006100670065006E0074002D00700072006F007000650072007400690065007300000001000000010820010000000000000000000700000098000000540069006D0065007200490044005E0068007400740070003A002F002F0073006300680065006D00610073002E006D006900630072006F0073006F00660074002E0063006F006D002F00420069007A00540061006C006B002F0032003000300033002F0078006C0061006E00670073002D00720075006E00740069006D0065002D00700072006F0070006500720074006900650073000000010000000008004A000000300030003000300030003000300030002D0030003000300030002D0030003000300030002D0030003000300030002D003000300030003000300030003000300030003000300030000000)
INSERT INTO MessageRefCountLogTotals (uidMessageID, snRefCount) VALUES (N’61EAA7FC-AC85-42d9-BF3E-1BED258B82BE’, 1)
END
GO
— *******************************************************
— For 2006 you will need the following 4 control messages
— *******************************************************
— 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)
For more information please see http://blogs.technet.com/jpierauc/archive/2008/07/22/msgboxviewer-mbv-q-a.aspx
0 thoughts on “BTS 2004 Control Message Check Missing Restart Msg in Spool table”