ESB Toolkit 2.0 – Microsoft.Data.SqlXml issue

|  Posted: June 10, 2009  |  Categories: BizTalk Server

I started doing some prototype using ESB Toolkit 2.0 Exception management framework and encountered the following exception when FaultMessage was transmitted to the Exception Management database via the generic ALL.Exceptions SQL send port under Microsoft.Practices.ESB application.

The adapter failed to transmit message going to send port “ALL.Exceptions” with URL “SQL://(local)/EsbExceptionDb/”. It will be retransmitted after the retry interval specified for this Send Port. Details:”Could not load file or assembly ‘Microsoft.Data.SqlXml, Version=10.0.0.0, Culture=neutral, PublicKeyToken=89845dcd8080cc91′ or one of its dependencies. The system cannot find the file specified.”.

Looking at the GAC, there were couple of Assemblies with the name Microsoft.Data.SqlXml with version number 3.* and 9.*. But in our case its looking for 10.*. Doing some quick search revealed the dll is part of SQLXML 4.0 SP1, download and installation of SQLXML 4.0 SP1 (which is part of Microsoft SQL Server 2008 Feature Pack, October 2008) from the following link resolved the issue.

http://www.microsoft.com/downloads/details.aspx?familyid=228DE03F-3B5A-428A-923F-58A033D316E1&displaylang=en

Author: Saravana Kumar

Saravana Kumar is the Founder and CTO of BizTalk360, an enterprise software that acts as an all-in-one solution for better administration, operation, support and monitoring of Microsoft BizTalk Server environments.

One Platform Operations, Monitoring and Analytics Software
BizTalk360

microsoft biztalk

Learn more

Over 500 customers across 30+ countries depend on BizTalk360

ServiceBus360

Azure service bus

Learn more

Start managing your Azure Service Bus namespaces in minutes

One Platform - Operations, Monitoring and Analytics Software
BizTalk360

microsoft biztalk

Learn more

Over 500 customers across 30+ countries depend on BizTalk360

One Platform - Operations, Monitoring and Analytics Software
ServiceBus360

Azure service bus

Learn more

Start managing your Azure Service Bus namespaces in minutes

Back to Top