{"id":249,"date":"2009-01-22T00:21:06","date_gmt":"2009-01-21T23:21:06","guid":{"rendered":"http:\/\/www.tsls.co.uk\/?p=249"},"modified":"2026-03-11T10:41:19","modified_gmt":"2026-03-11T10:41:19","slug":"bts-2004-control-message-check-missing-restart-msg-in-spool-table","status":"publish","type":"post","link":"https:\/\/www.tsls.co.uk\/index.php\/2009\/01\/22\/bts-2004-control-message-check-missing-restart-msg-in-spool-table\/","title":{"rendered":"BTS 2004 Control Message Check Missing Restart Msg in Spool table"},"content":{"rendered":"

After running Biztalk MessageBoxViewer (MBV) http:\/\/blogs.technet.com\/jpierauc\/default.aspx<\/a><\/p>\n

You recieve the following error<\/p>\n

Control Message Check Missing Restart Msg in Spool table (can prevent some svc instances to be resumed, terminated or suspended)<\/p><\/blockquote>\n

Navigate to <drive>:<BizTalk 200x Folder>Schema,
\nOpen “MsgBoxSchema.sql”
\nFind INSERT INTO Spool (uidMessageID… copy the statment into query analyser and run.
\nBelow are the ones you should execute<\/p>\n

NOTE: Remember to backup your databases before running<\/p>\n


\n-- ******************************************************
\n-- For 2004 you will need the following 1 control message<\/code><\/p>\n

— ******************************************************
\n— Inserting Restart Message for use in service recovery
\nIF (SELECT COUNT (*) FROM Spool WHERE uidMessageID = N’61EAA7FC-AC85-42d9-BF3E-1BED258B82BE’) = 0
\nBEGIN
\n INSERT INTO Spool (uidMessageID, nNumParts, nCounter, imgContext) VALUES (N’61EAA7FC-AC85-42d9-BF3E-1BED258B82BE’, 0, 0, 0xD4E0906C1849D311A24200C04F60A53302000000090000009800000050006100720074004E0061006D00650073005E0068007400740070003A002F002F0073006300680065006D00610073002E006D006900630072006F0073006F00660074002E0063006F006D002F00420069007A00540061006C006B002F0032003000300033002F006D006500730073006100670065006100670065006E0074002D00700072006F007000650072007400690065007300000001000000010820010000000000000000000700000098000000540069006D0065007200490044005E0068007400740070003A002F002F0073006300680065006D00610073002E006D006900630072006F0073006F00660074002E0063006F006D002F00420069007A00540061006C006B002F0032003000300033002F0078006C0061006E00670073002D00720075006E00740069006D0065002D00700072006F0070006500720074006900650073000000010000000008004A000000300030003000300030003000300030002D0030003000300030002D0030003000300030002D0030003000300030002D003000300030003000300030003000300030003000300030000000)
\n INSERT INTO MessageRefCountLogTotals (uidMessageID, snRefCount) VALUES (N’61EAA7FC-AC85-42d9-BF3E-1BED258B82BE’, 1)
\nEND
\nGO<\/p>\n

— *******************************************************
\n— For 2006 you will need the following 4 control messages
\n— *******************************************************<\/p>\n

— Inserting Restart Message for use in service recovery<\/p>\n

INSERT INTO Spool (uidMessageID, nNumParts, nCounter, imgContext) VALUES (N’61EAA7FC-AC85-42d9-BF3E-1BED258B82BE’, 0, 0, 0xD4E0906C1849D311A24200C04F60A53302000000090000009800000050006100720074004E0061006D00650073005E0068007400740070003A002F002F0073006300680065006D00610073002E006D006900630072006F0073006F00660074002E0063006F006D002F00420069007A00540061006C006B002F0032003000300033002F006D006500730073006100670065006100670065006E0074002D00700072006F007000650072007400690065007300000001000000010820010000000000000000000700000098000000540069006D0065007200490044005E0068007400740070003A002F002F0073006300680065006D00610073002E006D006900630072006F0073006F00660074002E0063006F006D002F00420069007A00540061006C006B002F0032003000300033002F0078006C0061006E00670073002D00720075006E00740069006D0065002D00700072006F0070006500720074006900650073000000010000000008004A000000300030003000300030003000300030002D0030003000300030002D0030003000300030002D0030003000300030002D003000300030003000300030003000300030003000300030000000)<\/p>\n

— Inserting Suspend Control message<\/p>\n

INSERT INTO Spool (uidMessageID, nNumParts, nCounter, imgContext) VALUES (N’2BE3D5B8-5685-40F2-BD97-51ADA3D02347′, 0, 0, 0xD4E0906C1849D311A24200C04F60A53303000000000000001E000000420069007A00540061006C006B0043006F006E00740072006F006C000000020000000008002A000000410064006D0069006E00530075007300700065006E00640049006E007300740061006E00630065000000000000000C0000004A006F006200490044000000020000000008004E0000007B00340037004100450033003300380034002D0031003000410041002D0034003400430033002D0038003200350036002D003200350033003400380045004200390032004200320031007D000000090000009800000050006100720074004E0061006D00650073005E0068007400740070003A002F002F0073006300680065006D00610073002E006D006900630072006F0073006F00660074002E0063006F006D002F00420069007A00540061006C006B002F0032003000300033002F006D006500730073006100670065006100670065006E0074002D00700072006F00700065007200740069006500730000000100000001082001000000000000000000)<\/p>\n

— Inserting Terminate Control message<\/p>\n

INSERT INTO Spool (uidMessageID, nNumParts, nCounter, imgContext) VALUES (N’57E5E753-0207-435D-8BE7-2B9F3C6556F9′, 0, 0, 0xD4E0906C1849D311A24200C04F60A53303000000000000001E000000420069007A00540061006C006B0043006F006E00740072006F006C000000020000000008002E000000410064006D0069006E005400650072006D0069006E0061007400650049006E007300740061006E00630065000000000000000C0000004A006F006200490044000000020000000008004E0000007B00350032003500390031004600310031002D0046003700370034002D0034003600330038002D0042004300390041002D003200380034003800380034003600300034003500450032007D000000090000009800000050006100720074004E0061006D00650073005E0068007400740070003A002F002F0073006300680065006D00610073002E006D006900630072006F0073006F00660074002E0063006F006D002F00420069007A00540061006C006B002F0032003000300033002F006D006500730073006100670065006100670065006E0074002D00700072006F00700065007200740069006500730000000100000001082001000000000000000000)<\/p>\n

–Inserting Resume in Debug Mode message<\/p>\n

INSERT INTO Spool (uidMessageID, nNumParts, nCounter, imgContext) VALUES (N’50D173AF-5D6F-4D5F-AE23-1A7178CEBDC3′, 0, 0, 0xD4E0906C1849D311A24200C04F60A53303000000000000001E000000420069007A00540061006C006B0043006F006E00740072006F006C0000000200000000080026000000410064006D0069006E004400650062007500670049006E007300740061006E00630065000000000000000C0000004A006F006200490044000000020000000008004E0000007B00330032003800330030004500450045002D0035004400330041002D0034003700370037002D0041003200440035002D003100320033004100450035004600340044004500420039007D000000090000009800000050006100720074004E0061006D00650073005E0068007400740070003A002F002F0073006300680065006D00610073002E006D006900630072006F0073006F00660074002E0063006F006D002F00420069007A00540061006C006B002F0032003000300033002F006D006500730073006100670065006100670065006E0074002D00700072006F00700065007200740069006500730000000100000001082001000000000000000000)<\/p>\n

For more information please see http:\/\/blogs.technet.com\/jpierauc\/archive\/2008\/07\/22\/msgboxviewer-mbv-q-a.aspx<\/a><\/p>\n","protected":false},"excerpt":{"rendered":"

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<\/p>\n","protected":false},"author":11,"featured_media":0,"comment_status":"closed","ping_status":"closed","sticky":false,"template":"","format":"standard","meta":{"jetpack_post_was_ever_published":false,"_jetpack_newsletter_access":"","_jetpack_newsletter_tier_id":0,"footnotes":"","jetpack_publicize_message":"","jetpack_is_tweetstorm":false,"jetpack_publicize_feature_enabled":true,"jetpack_social_post_already_shared":false,"jetpack_social_options":{"image_generator_settings":{"template":"highway","enabled":false}}},"categories":[21],"tags":[131,421],"class_list":["post-249","post","type-post","status-publish","format-standard","hentry","category-microsoft","tag-131","tag-biztalk"],"jetpack_publicize_connections":[],"yoast_head":"\r\nBTS 2004 Control Message Check Missing Restart Msg in Spool table - TSLS - Luke Smith<\/title>\r\n<meta name=\"robots\" content=\"index, follow, max-snippet:-1, max-image-preview:large, max-video-preview:-1\" \/>\r\n<link rel=\"canonical\" href=\"https:\/\/www.tsls.co.uk\/index.php\/2009\/01\/22\/bts-2004-control-message-check-missing-restart-msg-in-spool-table\/\" \/>\r\n<meta property=\"og:locale\" content=\"en_GB\" \/>\r\n<meta property=\"og:type\" content=\"article\" \/>\r\n<meta property=\"og:title\" content=\"BTS 2004 Control Message Check Missing Restart Msg in Spool table - TSLS - Luke Smith\" \/>\r\n<meta property=\"og:description\" content=\"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\" \/>\r\n<meta property=\"og:url\" content=\"https:\/\/www.tsls.co.uk\/index.php\/2009\/01\/22\/bts-2004-control-message-check-missing-restart-msg-in-spool-table\/\" \/>\r\n<meta property=\"og:site_name\" content=\"TSLS - Luke Smith\" \/>\r\n<meta property=\"article:published_time\" content=\"2009-01-21T23:21:06+00:00\" \/>\r\n<meta property=\"article:modified_time\" content=\"2026-03-11T10:41:19+00:00\" \/>\r\n<meta name=\"author\" content=\"Luke Smith\" \/>\r\n<meta name=\"twitter:label1\" content=\"Written by\" \/>\n\t<meta name=\"twitter:data1\" content=\"Luke Smith\" \/>\n\t<meta name=\"twitter:label2\" content=\"Estimated reading time\" \/>\n\t<meta name=\"twitter:data2\" content=\"3 minutes\" \/>\r\n<script type=\"application\/ld+json\" class=\"yoast-schema-graph\">{\"@context\":\"https:\/\/schema.org\",\"@graph\":[{\"@type\":\"WebPage\",\"@id\":\"https:\/\/www.tsls.co.uk\/index.php\/2009\/01\/22\/bts-2004-control-message-check-missing-restart-msg-in-spool-table\/\",\"url\":\"https:\/\/www.tsls.co.uk\/index.php\/2009\/01\/22\/bts-2004-control-message-check-missing-restart-msg-in-spool-table\/\",\"name\":\"BTS 2004 Control Message Check Missing Restart Msg in Spool table - TSLS - Luke Smith\",\"isPartOf\":{\"@id\":\"https:\/\/www.tsls.co.uk\/#website\"},\"datePublished\":\"2009-01-21T23:21:06+00:00\",\"dateModified\":\"2026-03-11T10:41:19+00:00\",\"author\":{\"@id\":\"https:\/\/www.tsls.co.uk\/#\/schema\/person\/e4d7dac4fe1b3f8df31f3857bb3ebda7\"},\"breadcrumb\":{\"@id\":\"https:\/\/www.tsls.co.uk\/index.php\/2009\/01\/22\/bts-2004-control-message-check-missing-restart-msg-in-spool-table\/#breadcrumb\"},\"inLanguage\":\"en-GB\",\"potentialAction\":[{\"@type\":\"ReadAction\",\"target\":[\"https:\/\/www.tsls.co.uk\/index.php\/2009\/01\/22\/bts-2004-control-message-check-missing-restart-msg-in-spool-table\/\"]}]},{\"@type\":\"BreadcrumbList\",\"@id\":\"https:\/\/www.tsls.co.uk\/index.php\/2009\/01\/22\/bts-2004-control-message-check-missing-restart-msg-in-spool-table\/#breadcrumb\",\"itemListElement\":[{\"@type\":\"ListItem\",\"position\":1,\"name\":\"Home\",\"item\":\"https:\/\/www.tsls.co.uk\/\"},{\"@type\":\"ListItem\",\"position\":2,\"name\":\"BTS 2004 Control Message Check Missing Restart Msg in Spool table\"}]},{\"@type\":\"WebSite\",\"@id\":\"https:\/\/www.tsls.co.uk\/#website\",\"url\":\"https:\/\/www.tsls.co.uk\/\",\"name\":\"TSLS - Luke Smith\",\"description\":\"- Knowledge - Thoughts - Microsoft -\",\"potentialAction\":[{\"@type\":\"SearchAction\",\"target\":{\"@type\":\"EntryPoint\",\"urlTemplate\":\"https:\/\/www.tsls.co.uk\/?s={search_term_string}\"},\"query-input\":\"required name=search_term_string\"}],\"inLanguage\":\"en-GB\"},{\"@type\":\"Person\",\"@id\":\"https:\/\/www.tsls.co.uk\/#\/schema\/person\/e4d7dac4fe1b3f8df31f3857bb3ebda7\",\"name\":\"Luke Smith\",\"image\":{\"@type\":\"ImageObject\",\"inLanguage\":\"en-GB\",\"@id\":\"https:\/\/www.tsls.co.uk\/#\/schema\/person\/image\/\",\"url\":\"https:\/\/secure.gravatar.com\/avatar\/29abc50f07a4ebe68cb4f31981884f89b2157d7e4ed63b09631d40c0717faa94?s=96&d=mm&r=g\",\"contentUrl\":\"https:\/\/secure.gravatar.com\/avatar\/29abc50f07a4ebe68cb4f31981884f89b2157d7e4ed63b09631d40c0717faa94?s=96&d=mm&r=g\",\"caption\":\"Luke Smith\"},\"description\":\"I\u2019ve been working with Microsoft Technologies for over 20 years, my main focus now being Microsoft Online Services. I manage the Cloud Services at ElysianIT Limited and as a P-SELLER at Microsoft. I have worked with many organisations from SMC to Enterprise. I\u2019ve been working with Microsoft Technologies since DOS 5.0, to date I have been working on Microsoft\u2019s latest cloud technology Windows Azure, Windows 10 Office 365 and Microsoft SharePoint\",\"sameAs\":[\"http:\/\/www.tsls.co.uk\"],\"url\":\"https:\/\/www.tsls.co.uk\/index.php\/author\/luke\/\"}]}<\/script>\r\n<!-- \/ Yoast SEO plugin. -->","yoast_head_json":{"title":"BTS 2004 Control Message Check Missing Restart Msg in Spool table - TSLS - Luke Smith","robots":{"index":"index","follow":"follow","max-snippet":"max-snippet:-1","max-image-preview":"max-image-preview:large","max-video-preview":"max-video-preview:-1"},"canonical":"https:\/\/www.tsls.co.uk\/index.php\/2009\/01\/22\/bts-2004-control-message-check-missing-restart-msg-in-spool-table\/","og_locale":"en_GB","og_type":"article","og_title":"BTS 2004 Control Message Check Missing Restart Msg in Spool table - TSLS - Luke Smith","og_description":"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","og_url":"https:\/\/www.tsls.co.uk\/index.php\/2009\/01\/22\/bts-2004-control-message-check-missing-restart-msg-in-spool-table\/","og_site_name":"TSLS - Luke Smith","article_published_time":"2009-01-21T23:21:06+00:00","article_modified_time":"2026-03-11T10:41:19+00:00","author":"Luke Smith","twitter_misc":{"Written by":"Luke Smith","Estimated reading time":"3 minutes"},"schema":{"@context":"https:\/\/schema.org","@graph":[{"@type":"WebPage","@id":"https:\/\/www.tsls.co.uk\/index.php\/2009\/01\/22\/bts-2004-control-message-check-missing-restart-msg-in-spool-table\/","url":"https:\/\/www.tsls.co.uk\/index.php\/2009\/01\/22\/bts-2004-control-message-check-missing-restart-msg-in-spool-table\/","name":"BTS 2004 Control Message Check Missing Restart Msg in Spool table - TSLS - Luke Smith","isPartOf":{"@id":"https:\/\/www.tsls.co.uk\/#website"},"datePublished":"2009-01-21T23:21:06+00:00","dateModified":"2026-03-11T10:41:19+00:00","author":{"@id":"https:\/\/www.tsls.co.uk\/#\/schema\/person\/e4d7dac4fe1b3f8df31f3857bb3ebda7"},"breadcrumb":{"@id":"https:\/\/www.tsls.co.uk\/index.php\/2009\/01\/22\/bts-2004-control-message-check-missing-restart-msg-in-spool-table\/#breadcrumb"},"inLanguage":"en-GB","potentialAction":[{"@type":"ReadAction","target":["https:\/\/www.tsls.co.uk\/index.php\/2009\/01\/22\/bts-2004-control-message-check-missing-restart-msg-in-spool-table\/"]}]},{"@type":"BreadcrumbList","@id":"https:\/\/www.tsls.co.uk\/index.php\/2009\/01\/22\/bts-2004-control-message-check-missing-restart-msg-in-spool-table\/#breadcrumb","itemListElement":[{"@type":"ListItem","position":1,"name":"Home","item":"https:\/\/www.tsls.co.uk\/"},{"@type":"ListItem","position":2,"name":"BTS 2004 Control Message Check Missing Restart Msg in Spool table"}]},{"@type":"WebSite","@id":"https:\/\/www.tsls.co.uk\/#website","url":"https:\/\/www.tsls.co.uk\/","name":"TSLS - Luke Smith","description":"- Knowledge - Thoughts - Microsoft -","potentialAction":[{"@type":"SearchAction","target":{"@type":"EntryPoint","urlTemplate":"https:\/\/www.tsls.co.uk\/?s={search_term_string}"},"query-input":"required name=search_term_string"}],"inLanguage":"en-GB"},{"@type":"Person","@id":"https:\/\/www.tsls.co.uk\/#\/schema\/person\/e4d7dac4fe1b3f8df31f3857bb3ebda7","name":"Luke Smith","image":{"@type":"ImageObject","inLanguage":"en-GB","@id":"https:\/\/www.tsls.co.uk\/#\/schema\/person\/image\/","url":"https:\/\/secure.gravatar.com\/avatar\/29abc50f07a4ebe68cb4f31981884f89b2157d7e4ed63b09631d40c0717faa94?s=96&d=mm&r=g","contentUrl":"https:\/\/secure.gravatar.com\/avatar\/29abc50f07a4ebe68cb4f31981884f89b2157d7e4ed63b09631d40c0717faa94?s=96&d=mm&r=g","caption":"Luke Smith"},"description":"I\u2019ve been working with Microsoft Technologies for over 20 years, my main focus now being Microsoft Online Services. I manage the Cloud Services at ElysianIT Limited and as a P-SELLER at Microsoft. I have worked with many organisations from SMC to Enterprise. I\u2019ve been working with Microsoft Technologies since DOS 5.0, to date I have been working on Microsoft\u2019s latest cloud technology Windows Azure, Windows 10 Office 365 and Microsoft SharePoint","sameAs":["http:\/\/www.tsls.co.uk"],"url":"https:\/\/www.tsls.co.uk\/index.php\/author\/luke\/"}]}},"jetpack_featured_media_url":"","jetpack_sharing_enabled":true,"jetpack_shortlink":"https:\/\/wp.me\/p2gf1k-41","_links":{"self":[{"href":"https:\/\/www.tsls.co.uk\/index.php\/wp-json\/wp\/v2\/posts\/249","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/www.tsls.co.uk\/index.php\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/www.tsls.co.uk\/index.php\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/www.tsls.co.uk\/index.php\/wp-json\/wp\/v2\/users\/11"}],"replies":[{"embeddable":true,"href":"https:\/\/www.tsls.co.uk\/index.php\/wp-json\/wp\/v2\/comments?post=249"}],"version-history":[{"count":1,"href":"https:\/\/www.tsls.co.uk\/index.php\/wp-json\/wp\/v2\/posts\/249\/revisions"}],"predecessor-version":[{"id":6409,"href":"https:\/\/www.tsls.co.uk\/index.php\/wp-json\/wp\/v2\/posts\/249\/revisions\/6409"}],"wp:attachment":[{"href":"https:\/\/www.tsls.co.uk\/index.php\/wp-json\/wp\/v2\/media?parent=249"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/www.tsls.co.uk\/index.php\/wp-json\/wp\/v2\/categories?post=249"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/www.tsls.co.uk\/index.php\/wp-json\/wp\/v2\/tags?post=249"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}