Monday, May 27, 2013

Message Box Viewer (MBV) 13 does not work with BizTalk 360 v6.0

From Saravana Blog post I came to know that the new Message Box Viewer 13 is available now at JPBlog. I thought of integrating it with BizTalk360 v6.0 but I was not able to do so, ans was getting the below mentioned error:

Could not load file or assembly 'MYHC, Version=, Culture=neutral, PublicKeyToken=null' or one of its dependencies.
The located assembly's manifest definition does not match the assembly reference. (Exception from HRESULT: 0x80131040) 
File name: 'MYHC, Version=, Culture=neutral, PublicKeyToken=null'    
at Kovai.BizTalk360.MBVConsole.MBVFacade.Init(String[] args)    
at Kovai.BizTalk360.MBVConsole.Program.Main(String[] args)
in c:\B360.Main\src\v6.0\Kovai.BizTalk360\Kovai.BizTalk360.InfoTrack\Kovai.BizTalk360.MBVConsole\Program.cs:line 13    

I tried to investigate it and here is my finding:
When you extracted the zip file you get the following list of executable and files. 

As mentioned in the error the part of BizTalk360 which execute MBV is Kovai.BizTalk360.MBVConsole.exe and it uses the MYHC.dll. Moreover this file gets copied to the Service folder in the installation directory of BizTalk360 as shown below:

The problem is in MBV 13 version the assembly version of MYHC.dll has been changed to and this assembly has been strongly named i.e. signed and as a result there is no easier way of binding redirection to this new signed assembly from unsigned version. I hope recompiling the code of Kovai.BizTalk360.MBVConsole.exe with updated reference in some future version would fix this issue.

Rohit Sharma

Monday, May 13, 2013

BizTalk360: Counter for number of required host instances for healthy environment

Just like me if you have created the host instances for all the hosts on every machine ( 2 in this example )  in BizTalk group and still wondering why you are not getting the count of host instance equal to number of host multiplied by the BizTalk server (in above case 17*2=34) then this could be the answer.

- In this example there were 3 isolated hosts; BizTalk360 was not considering the host instances for these isolated hosts as part of this count, may be because just like BizTalk the BizTalk360 does not access the status information for external processes, so the count get reduced to 28.

Still there is difference of 2.

- In this example two hosts were cluster. BizTalk360 was adding only 1 to the host instances count for each cluster host as only one instance will be active at a time.

So in nutshell this counter indicate how many host instances should be in active state to consider the environment as healthy and it's not count of  total number of host instances.

Rohit Sharma

Thursday, May 2, 2013

Message Box Viewer (MBV) Integration with BizTalk 360 v6.0

I was getting this error when trying to Run MBV from BizTalk 360.

Leaving Execute(Kovai.BizTalk360.InfoTrack.ActivitiesImpl.MBVSvc.MBVActivityImpl).
Fatal exception in generating Message Box Viewer Reports.
System.Exception: MBVActivityImpl:GenerateReport. IsReadyForMBVExecution check failed. Error EULA for MBV Console application must be accepted 

I came across this post by Steef-Jan on this topic. The below mentioned registry key that was working for Steef was already there as the machine was 64-bit in this case too


Then I manually created the below mentioned registry key as pointed by Steef


And it resolved the issue. I was able to run MBV and reports were getting generated properly.

BizTalk360 MBV
But later I found that generating only the below mentioned key also fix the same problem:


Seems BizTalk360 is looking for either one of these registry keys so create any of these two to fix this problem.

Rohit Sharma

Monday, April 22, 2013

Error: Schema referenced by Map has been deleted. The local, cached version of the BizTalk Server group configuration is out of date.

One of my colleges started getting following error on the development machine:

Schema referenced by Map '<Namespace>.<MappName>' has been deleted. The local, cached version of the BizTalk Server group configuration is out of date. You must refresh the BizTalk Server group configuration before making further changes. (Microsoft.BizTalk.Administration.SnapIn)

The deployment script stop working as deploying any DLL using BTSTask.exe was causing the same error:

I figured out that this issue has been fixed for BizTalk Server 2010 as part of KB2516201 and suggested to install the Cumulative Update 1 for BizTalk Server 2010. But it turned out that installing the KB article was not helping in this scenario.

Apart from the bugs fixed in Cumulative Update 1 this error can be caused by one more reason which was the case in this scenario.

You can re-produce this error by following these steps:

Step 1: Create a BizTalk project and add 2 sample schemas to it.
Step 2: Create another project add reference to the above BizTalk Project and add a mapper and use the 2 sample schemas created in Step 1 as source and destination in this map.
Step 3: Deploy the solution to BizTalk.
Step 4: Add another sample schema to the project created in Step 1.
Step 5: Update the mapper created in step 2 and replace either the source or destination schema with the new schema created in Step 4.
Step 6: Deploy only the DLL for the mapper project only.
Step 7: Try to refresh the BizTalk group in the BizTalk Administration Console or use the BTSTask you will start getting this error.

So be careful when using the deployment script and in script try to deploy the assemblies having schema first and if the deployment of any BizTalk assemblies having schema have been failed then script should not  proceed further.

As BTSTask was not able to add/remove any resource so the entry for this mapper from the BizTalk Management DB was removed manually by executing the following queries in SQL management studio:

Step 1: Open the SQL management Studio and connect to the instance having BizTalkMgmtDb. Run this query:

SELECT [id] FROM [BizTalkMgmtDb].[dbo].[bts_item]
WHERE FullName = '<CopyTheNameOfTheMapFromErrorMessage>'

Step 2: Get the value of id and replace it in below query:

DELETE FROM [BizTalkMgmtDb].[dbo].[bt_MapSpec] WHERE itemid = <Value of id from above query>

It will delete the entry for map from the BizTalk Management Database now you can rectify the issue with your deployment script and can redeploy the solution.

Rohit Sharma

Friday, April 19, 2013

Installing 64-bit Oracle Data Access Components (ODAC) for BizTalk 2010

I didn't find any good reference on this so though of documenting the steps that worked for me

Step 1: Go to 64-bit Oracle Data Access Components (ODAC) Downloads page and download 64-bit ODAC 11.2 Release 5 ( Xcopy for Windows x64

Step 2: Unzip the file downloaded in Step 1 it to a folder location.

Step 3: Create a folder to install Oracle Client. I created C:\Oracle\ODAC_11_2_Release_5_64_Bit 

Step 4: Run the command prompt as Administrator and browse to location where the zip file was extracted in Step 2. 

Step 5: Install Oracle Instant Client and Oracle Data Provider for .NET 2 by executing the following command on Command prompt: 

install.bat odp.net2 C:\oracle\ODAC_11_2_Release_5_64_Bit OraClient11g_home1 true

Step 6: Install Oracle Data Provider for .NET 4 by executing the following command on Command prompt:

install.bat odp.net4 C:\oracle\ODAC_11_2_Release_5_64_Bit OraClient11g_home1 false

Note: Use the same name OraClient11g_home1 for Oracle home in all commands.

Step 7: Install Oracle Service for MTS by executing the following command on Command prompt:

install.bat oramts C:\oracle\ODAC_11_2_Release_5_64_Bit OraClient11g_home1 false

Step 8: Add the install directory (C:\oracle\ODAC_11_2_Release_5_64_Bit) and install directory's bin subdirectory (C:\oracle\ODAC_11_2_Release_5_64_Bit\bin) to the system environment variable PATH.

Step 9: Create the system environment variable ORACLE_HOME and set it’s value to C:\oracle\ODAC_11_2_Release_5_64_Bit

Step 10: Copy over/Create the tnsnames.ora to/at default location %ORACLE_HOME%/network/admin

Step 11: This step is optional if you need to change the language, territory or character set for the oracle client then in this case you need to change the value of registry key NLS_LANG available at path:


Note: If you have specified different name for oracle home instead of OraClient11g_home1 in above commands then you need to look for KEY_<OracleHome>

That's all you are done with installation. In my case I was using only 64-bit host for WCF-Oracle but if you want 32-bit host then you need to install 32-bit oracle client by follow the above steps but do create different folder.

Rohit Sharma

Friday, March 1, 2013

There was a failure executing pipeline "BTAHL72XPipelines.BTAHL72XSendPipeline". Error details: "Body schema is missing".

If you want to know how to execute BTAHL72XSendPipeline in an orchestration or are facing error "Body schema is missing" while executing the BTAHL72XSendPipeline in orchestration then do download the code sample "How to execute BTAHL72XSendPipeline in an orchestration

Rohit Sharma

Wednesday, February 6, 2013

Invoking a web service returning ISO-8859-1 encoded data with BizTalk Server 2010

The TextMessageEncodingBindingElement of WCF supports only the UTF-8, UTF-16 and Big Endean Unicode encodings. If the web service returns response in some other encoding e.g. ISO-8859-1 need to be consumed in BizTalk Server 2010 then the following error get logged in the event viewer:

System.ServiceModel.ProtocolException: The content type text/xml of the response message does not match the content type of the binding (application/soap+xml; charset=utf-8). If using a custom encoder, be sure that the IsContentTypeSupported method is implemented properly.

I have published the solution to above problem along with the code at MSDN.

Rohit Sharma