MsgBoxViewer (MBV) Q & A

What is BizTalk MsgBoxViewer (aka "MBV") ?

My Biztalk Tools blog — Thu, 31 Jul 2008 12:01:33 GMT

As the name imply, MBV analyze in details your BizTalk 2004 & 2006 MsgBox Db but also other BizTalk

re: MsgBoxViewer (MBV) Q & A

Jokke — Thu, 07 Aug 2008 08:20:46 GMT

Hi.

Msgbox Database Integrity report gives me following message, what does that mean?

How can i solve what is the Issue ?

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

re: MsgBoxViewer (MBV) Q & A

JP — Fri, 08 Aug 2008 22:40:22 GMT

Hi Jokke,

this warning means that the internal restart control message is missing in your Spool table.

In BizTalk 2004, you have only 1 contol msg inserted in Spool at congiguration time when the msgbow is created.

In bizTalk 2006, you have 4 msgs inserted.

MBV is checking for presence of this msg in Spool table and raise this warning if not present.

to fix that, you can look in Msgboxlogic.sql in your BizTalk install folder and search for "restart control message" string, you should find a INERT INTO statement inserting this restart control msg that you can reuse against your Msgbox db.

Please, run your backup job before to do that and have a backup

re: MsgBoxViewer (MBV) Q & A

Mike — Wed, 01 Oct 2008 13:01:44 GMT

Hi,

Could you confirm the above comment, I have looked in the MsgBoxLogic.sql file for the string "restart control message" and some variations around this and can not be sure which Insert Into statement you mean.

Any help would be appreciated

Mike

re: MsgBoxViewer (MBV) Q & A

JP — Thu, 02 Oct 2008 09:17:48 GMT

Hi Mike,

ok I will add asap a comment on this page with the exact SQL query to repair that

re: MsgBoxViewer (MBV) Q & A

jpierauc — Thu, 02 Oct 2008 19:38:41 GMT

Mike,

it is not really in msgboxlogic.sql as I mentioned before but in "MsgBoxSchema.sql" (mea culpa)

If you open indeed "MsgBoxSchema.sql" in your <BizTalk 2006 Folder>\Schema, you will find that we execute these 4 queries below to insert 4 control messages in the "Spool" table just after its creation.

So execute same queries to reinsert the corresponding missing control message; remember of course to do before a msgbox backup (using the backup job) as usual each time you have to touch "manually" a Msgboxdb in Prod - which should never occur ;-)

MsgBowxSChema.sql :

...

-- 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)

...

re: MsgBoxViewer (MBV) Q & A

Mike — Thu, 30 Oct 2008 02:51:35 GMT

Hi JP

Think I forgot to thank you for this, very helpful.

re: MsgBoxViewer (MBV) Q & A

RAUL Caceres — Mon, 31 Aug 2009 12:43:04 GMT

im execute the last version of MsgBoxViewer above biztalk server 2004 and detected that

Version found in BTS Registry (BizTalk 2004 SP2) seems different than version detected in Mgmt Db (Version Schema: 3.2.0.0=BizTalk 2004) !!look that version in the register hkey/software/microsoft/biztalk/3.0.

whats is the fix that solutions it warning

thank you

regards

re: MsgBoxViewer (MBV) Q & A

jpierauc — Mon, 31 Aug 2009 22:21:38 GMT

Hi Raul,

you can ignore this warning

It is unfortunately a bug in my tool occuring with BT 2004 SP2 environments and I already fixed it in next incoming build