Thursday, September 30, 2004

Biztalk 2004 Message Archive problems

It seems that there is a problem with the Message Archive object that was released in the hotfix: http://www.kbalertz.com/kb_838454.aspx.

The Tracking_Spool information in the SQL stored proc is not referencing the correct table.

Using Reflector, I was able to figure out the problem and fix the issue.

Also, the hotfix install is very difficult. Seems to have the "Insert Disk" issue that the July docs had.

How to Extract a dll from the GAC

It was pointed out to me that some dlls are not stored on the Biztalk server, but in the GAC. To retreive these dlls, the following steps must be taken [from Microsoft]:

Currently, VS.NET does not allow you to add references to assemblies in the GAC. You have to extract it first, add a reference to a copy of the dll, outside of the GAC. At the time you add the reference, VS.NET will in fact add a reference to the GACed dll.

How To Extract:

Open up the command prompt and CD into \assembly\GAC\Microsoft.BizTalk.MessageBoxOM

Do a DIR and you will see a folder name like 3.0.1.0__.

CD into that folder and do a DIR.

You will find Microsoft.BizTalk.MessageBoxOM.dll.

Run the following command to copy the dll to a folder you can access it from:

copy *.dll C:\folder

You can then reference that file from VS.NET