Welcome to TechNet Blogs Sign in | Join | Help

My Biztalk Tools blog

MsgboxViewer blog
BizTalk MsgBoxViewer - download here the latest version of the tool

Version 10.15.9078. 

Download it : MsgBoxViewer10_15.zip

 

New Features and Fixes :


- Fixed MSDTC/COM+ package Version reported for W7 and W2K8 R2

- Fixed warning reporting incorrectly that Mgmt pack version installed was too old

- Check on ALL BT Servers belonging to a BizTalk 2006 R2 group for R2 SP1 presence and raise yellow warning suggesting it if not present

- Raise yellow warning if TDDS_FailedTrackingData rows > 50 000 (possiblr known issue described in KB 977289)

- Added a rule in "BizTalk Eventlog" query checking for occurrence ofissue described in KB 950048 (MSQC with msg size > 4 MB)

- Added a rule in "Receive Locations" query checking for occurrence of issue described in KB 976306 (MSQC Receive Location using  “Request MSg Body Before” tracking option)

- Addedd mention to KB 978796 when DTA orphaned issue warning is raised

Version 10.15.8978. 

Download it : MsgBoxViewer10_15.zip

 

New Features:


- Fixed issue where all TCP settings were not retrieved from the registry

- Fixed issue preventing properties of Web sites to be displayed in the "Web Sites" Query

- Fixed issue where TEMP DB datasource is incorrectly retrieved in cluster configuration

- Fixed issue where KB 954814 is suggested in a warning for BizTalk 2009 (known issue only for 2006 and 2006 R2)

- New query to check for the presence of BizTalk Mgmt Pack and its version on the server running MBV

- New query to get GAC assemblies and their version on the server running MBV

- New query to get current identity nID of MessageZeroSum table and raise warning suggesting to install KB 970231 if identity is approaching 2  billions (known issue)

- New query to check if row count in a HostQ table >= 2 billions and raise warning of possible arythmetic error on BizTalk 2004 and 2006 environments (known issue)

 

Version 10.15.8478. 

Download it : MsgBoxViewer10_15.zip

 

New Features:

- Include "Tempdb" info  on the "Dbs infos", "Dbs Files", and "Dbs Space" queries
- Query to get list of IIS App pools with their owning Applications and check if an Application is a BizTalk Receive Location
- Query to get list of Web sites with all their propertes App pools with their owning Applications and check if an application is a BizTalk Receive Location
- Get list of active global SQL Trace flags
- Query to get the SQL agent log
- Changed the KB linked to the warning message when AllowOnlySecureRpcCalls  is not set correctly on cluster
- Fixed HotFix queries to get also the 32 bits installed on a X64 machine
- Display now HotFix file(s) with their version
- Fixed the .NET config files to have also the ones from 64 bits version of the Framework
- Get also BTSNTSVC64.exe.Config if found
- Order by DESC the Most recent records in TDDSFailedTRRackingData table for both DTA and BAM dbs
- Fixed an HTML display issue (report can be expanded correctly ) when we fail to connect to  some Dbs
-   Added Autogrow rules for the "DBs File" query to check the current auto grow of BizTalk Dbs against our recommendations for MDF and LOG files

Version 10.15.8078. 

Download it : MsgBoxViewer10_15.zip

 

New Features:

- New query in “Server Info” category: “NET Config files” on all BT servers - not checked by default
- New query in “Server Info”: “Running Processes” on all servers
- New query in “Advanced DB Info” category: “Tracking tables Sequence Number”  -  not checked by default
- New query in “Advanced DB Info” category:  “Tracking tables Sequence Number gaps” - not checked by default
- New query in “Advanced DB Info” category : “Tracking tables Sequence Large BLOBs” - not checked by default
- Provides a rule raising a warning if large table “NotEqualPredicateTables” found (known issue)
- Provides additional EventsLog rules
- Improves MsgBox Database naming convention in some Summary Report categories to be unique in multiple MsgBox scenarios
- Provides “Total Q rows” entry in the “MsgBox Table” Summary Report category
- "Current Error Log" query is modified to list entries in Descendant order
- Provides some rules to the "Current Error Log" query to check for Disk space errors, Db Integrity or Fatal errors, and raise warnings if   found
- "Error Log.1" request in now moved into its dedicated query  - not Checked by default
- Host instance "Start time" is now added in Topology Report "Running Host instance" category
- System Variables are added in Topology Report

 

Version 10.15. 

Download it : MsgBoxViewer10_15.zip

 

New features:

- Can export now into MBV Extension File custom rules created in MBV gui ("Export" button present in the Rule Dialog in MBV gui)
- Get Artefacts per Host
- Get  COM+ rollup version from COM+ & MSDTC modules loaded in BizTalk instances and from the “Important software Layer” query
  and add it in the Topology Report
- Get SQL ERROR LOGs
- Get LanManWorkstations parameters of all Servers
- Get Config File of all BT servers
- Get also the list of Stopped services on all servers, raise warning if some BizTalk related services are stopped (EDI, Rules update, etc…) and add this list in the Topçology Report
- Get BAM Portal  config file
- Get BAMQueryService  config file
- Get BAMMgmtService Config File
- Get RPC Settings and Internet Port range on all Servers if found
- Get File list of all BT HotFixes installed on all BT Servers
- Include also in the Perfmon Log query the “Process” counters for all running BTSNTSVCx.EXE and RUNTIMEAGENT.EXE
- Select now by  default "Error and Warning" as type of events to retrieve in the Event Log Query
- Changed DTC Settings and CID duplication queries to be a single VBS query and manage x64 targeded servers (so it should target correctly this time remote x64 registries)
- Check for “FailureActions” changes in BizTalk Services (default  is “Restart Service”)
- Check when max size of a DB file is soon reached (based on his growth) and raise warning if it is 
- Add  SQL Servers Disk Infos in Topology with Disk  types, Capacity, and FreeSpace
- Populate more statistics in the “BizTalk group” category in the Summary Report to reflect very quickly number of BT Servers, SQL ones, 
  DBs,  MsgBoxes, RL, send Ports, pipelines,  ports, etc…
- Identify and include more software versions in the Topology Report  (WCF adapter, MQS client layer, Oracle client layer, SAP client layer, etc..)
- For BT 2009, add UDDI Db in list of Dbs analyzed  if its location is found in registry in the BTS running MBV
- Detect when SMS agent is running and raise a warning suggesting to use latest version of Mgmt Pack (risk of 100 CPU% wiyh previous version of the BizTalk Mgmt Pack)
- Detect if some BizTalk related  services were stopped on BT servers (MSDTC, ENTSSO, EDI, Rule Engine)
- Raise "not supported" warning if W2K8 R2 is detected
- Fixed bug when generating temp .VBS file with path having spaces
- Fixed bug whene generating temp .BAT file with a long filename
- Checks for non unique document namespaces and raise a warning if found

Posted: Tuesday, December 18, 2007 9:49 PM by jpierauc
Attachment(s): MsgBoxViewer10_15.zip

Comments

Jean-Paul Smit said:

On a blogpost by Yossi Dahan I read about a BizTalk tool I didn't know about: MsgBoxViewer Via Google

# May 6, 2008 7:55 AM

EAI world! said:

Cuando necesitamos conocer y/o predecir del comportamiento de nuestro entorno de BizTalk Server entonces,

# May 27, 2008 1:52 PM

Mike said:

Hello JP,

When running the BizTalk MsgBoxViewer, it is dropping and creating the objects sp_who3 and fn_MapWaitResource every time that it runs. Would it be possible to modify the tool to only create the objects if they don't exist? Our DBA group is comfortable giving our support group execute permissions on these objects but not the permission to drop or create objects in the master DB.

Thanks,

Mike

# May 29, 2008 10:46 AM

JP said:

Hi Mike,

your remark make sens but I remember that I already tried this initally and I met some errors;but let me some time this week to investigate that; I already had this remark before and I understand the need.

FYI, this script is comming directly from known Biztalk architect Lee Graber; he reused known 'sp_who' that he modified to help our suport teams to troubleshoot BizTalk Locking situations in the MsgBox.

JP

# May 29, 2008 3:12 PM

Jukka said:

It would be nice if the viewer would report Biztalk Application for each artifact. Even better if the artifacts could be grouped under Applications.

We have a BTS group with tens of Applications and hundreds of ports and orchestrations. We are planning a migration to a HA environment and need to analyze/report which adapters and hosts an application needs.

# June 11, 2008 10:45 AM

jpierauc said:

Hi Jukka,

Thanks for this sugestion but I just would like to understand it better, as currently in the BizTalk Console of BizTak 2006 you can see in the "Resources" node all assembly resources per Application.

Is it what you want or do you want to have a larger view not specific to assemblies ?

thanks

JP

# June 11, 2008 11:35 AM

Manuel Stern said:

Hi JP

In the section "Most CPU Queries (SQL 2K5 only)", MBV shows the entire sp text.

This makes it quite cumbersome to read.

Could you show only the names of the sprocs?

Thanks,

Manuel

# July 2, 2008 6:01 AM

jpierauc said:

humm..very good suggestion Manuel !

it makes so sense that I wonder why I did not do that before !?  it reduce indeed significantly size of output HTML file, History.Log, and XML file (if this option was selected)

I changed that so and uploaded a new  build (9.23.4) :

http://blogs.technet.com/jpierauc/pages/msgboxviewer.aspx

JP

# July 2, 2008 9:40 AM

Atin Agarwal's Blog said:

I have seen most of the issues coming with slow processing of messages in production by Biztalk where

# July 14, 2008 10:58 AM

ламинат said:

w Een plaatje zegt alles, toch ? t  Het volledige rapport is hier te vinden. Lees natuurlijk r  de blogposting. t a

[url=http://skuper.ru]ламинат купить [/url] 4u

# August 12, 2008 1:01 AM

ламинат said:

xik Een plaatje zegt alles, toch ? uzz  Het volledige rapport is hier te vinden. Lees natuurlijk m  de blogposting. t n

Thanks for interesting post! lsj

[url=http://skuper.ru]ламинированный парке[/url] 1d

# August 13, 2008 4:58 AM

かめログ2 said:

プロフェッショナル BizTalk Server 2006 を立ち読み http://go.microsoft.com/?linkid=8877305 ( http://ec.nikkeibp.co.jp

# November 4, 2008 12:39 AM

かめログ2 said:

MsgBoxViewer(MBV) というフリーのツールを最近発見しました。 http://blogs.technet.com/jpierauc/pages/msgboxviewer.aspx 上のリンクからダウンロードすることができます

# November 4, 2008 5:06 AM

Yong Hee Park's Blog said:

최근 BizTalk Troubleshooting을 진행 하면서 많은 사이트 들에서 가장 쉬운 부분에 대한 관리가 원활하기 진행되지 않으면서 사이트의 서비스 지연, 오류의 증가와 수십

# December 3, 2008 9:04 PM

My Biztalk Tools blog said:

Hello, Long time I did not write a post about MBV ! two reasons mainly : I was quite busy in my BizTalk

# December 11, 2008 7:18 PM

鸡尾虾的壳 said:

http://blogs.technet.com/jpierauc/pages/msgboxviewer.aspx 一个不错的收集Biztalk MessageBox信息的工具。

# December 17, 2008 10:40 PM

Yong Hee Park's Blog said:

이미 BizTalk 서버를 이용해서 개발하시거나 관리하시는 분들은 잘 아시고 계실 것으로 압니다만 MessageBoxViewer는 BizTalk서버의 실행 상태나 설정등을 한눈에 알아

# December 30, 2008 12:37 AM

search pdf said:

Thanks for BizTalk MsgBoxViewer download links

# January 22, 2009 12:18 AM

My Biztalk Tools blog said:

Hello, Let me discuss about a new feature that I introduced in version 10.11 that I released recently

# March 11, 2009 9:09 AM

BizTalkTrainer said:

Thanks jpierauc,

We teach alot of BizTalk Administrator courses and tools like this (SQL vs. BTS AdminConsole) are always popular with our students, so we go out of way to try them out and incorporate them in our courses.

I'll send you a video clip of any administrator course that includes a demo of this tool in our online classes at www.biztalktrainers.com

# April 1, 2009 5:24 PM

Tsvika Palgy said:

Does this version of MBV run also on X64 platform ?

# July 1, 2009 1:00 PM

Tsvika Palgy said:

Ok, launched the current version on X64 - it launches OK.

# July 1, 2009 1:13 PM

JP said:

Hi Tskika,

Yes it is running ok on x64

Some important info however :

1) As MBV is 32 bits, some queries of REGISTRY type will look ONLY in the 32 bit portion of the registry of a x64 (limitation of .NET) ! so if some reg entries of your 32 registry have different values (ex for MSDTC) than the x64, some results can be wrong in the report.

I will workaround that in a futur release by creating .VBS queries to access regkeys in VBS scripts instead of doing that in C#.

2) Remember anwyay that you can run MBV on any server and not only BT Server. When runnin on a non-BT server, you just have to specify manually the BizTalk Mgmt db location.

# July 2, 2009 1:53 AM

Nelson said:

Hi,

I have a strange problem running the MBV in my servers that I hope you can help me with.

Whenever I run the MBV, it always stops at a certain point. Looking at the Status.log, it appears to stop at the middle of a line (e.g. 17:02:50.6811483         GENERATING TEMP VB) an always when it reaches 216KB.

Heres the catch. if I change the querys (disable Running Services and Server Date), it stops at a different line in the Status.log but again when the Status.log reaches 216KB.

Does this makes any sense?

OS Version: Windows 2003 5.2 R2 Standard x64 Edition (Build 3790.srv03.sp2_rtm.070216-1710: Service Pack 2)

Biztalk Server Version: 3.6.1404.0 (Enterprise Edition)

Thanks,

NFS

# November 17, 2009 9:10 AM

jpierauc said:

Hi Nelson,

which build do you use ? can you try with latest if you use prev version ?

is it same when you run it on a different server ?

JP

# November 17, 2009 3:38 PM

Kelvin said:

Hi,

It's a great tool! We recently upgrade from Biztalk 2006 to 2009.  Does this tool works for BizTalk 2009?  Are there any changes in performance counters?

KT

# February 3, 2010 4:55 PM

jpierauc said:

Hi Kelvin,

Thanks first for you comment!

yes MBV is working perfectly with BizTalk 2009

I did not implement changes recently in the perfmon counters query; can I know which type of changes you would hope ?

JP

# February 5, 2010 12:23 PM
Leave a Comment

(required) 

(required) 

(optional)

(required) 

  
Enter Code Here: Required

Comment Notification

If you would like to receive an email when updates are made to this post, please register here

Subscribe to this post's comments using RSS

Page view tracker