Geeks With Blogs

Paul's Petrov Whiteboard [BizTalk, Enterprise Application Integration, Business Process Automation, SOA, .NET] BizTalk
Microsoft BizTalk 2010 - Line of Business Systems Integration
I just finished reading new book on Microsoft BizTalk 2010 written by BizTalk colleagues Kent Weare, Richard Seroter, Thiago Almeida, Sergei Moukhnitski, and Carl Darski. There are many good books that explore core BizTalk features for beginners, intermediate, and advanced developers. This one stands out by the fact that it covers relatively less documented aspect of BizTalk development – integrating with different line of business applications. The subject is vast and diverse so attempt to fit it ......

Posted On Friday, December 16, 2011 5:58 AM

ESB Off-Ramp with Dynamic Resolver to WCF-SQL Binding
This example is not covered in the ESB Toolkit samples and I bumped my forehead a few times while making it work. I thought it’d be helpful to save other fellow BizTalk'ers from headaches by publishing findings. I have been fun of dynamic generic messaging for quite a while and went long ways to avoid working with typed messages and static bindings when it made sense. Nowadays, with the ESB Toolkit one does not have to spend much effort to achieve this goal. But one has to learn intricacies of configuration ......

Posted On Wednesday, September 28, 2011 12:13 PM

Hotfix for BizTalk WCF Receive Adapter Issue

Microsoft has released official hotfix related to the problem I described earlier (see:

The knowledge base article and link to hotfix download are located at

Posted On Tuesday, January 4, 2011 8:57 AM

Integration with Multiple Versions of BizTalk HL7 Accelerator Schemas
Microsoft BizTalk Accelerator for HL7 comes with multiple versions of the HL7 implementation. One of the typical integration tasks is to receive one format and transmit another. For example, system A works HL7 v2.4 messages, system B with v2.3, and system C with v2.2. The system A is exchanging messages with B and C. The logical solution is to create schemas in separate namespaces for each system and assign maps on send ports. Schematic diagram of the messaging solution is shown below: Nothing is ......

Posted On Monday, January 3, 2011 4:50 PM

Mapping Repeating Sequence Groups in BizTalk
Repeating sequence groups can often be seen in real life XML documents. It happens when certain sequence of elements repeats in the instance document. Here’s fairly abstract example of schema definition that contains sequence group: <xs:schemaxmlns:b="http:... xmlns:xs=" xmlns="NS-Schema1" targetNamespace="NS-Schema1" > <xs:elementname="Repeati... <xs:complexType> <xs:sequencemaxOccurs="1... ......

Posted On Sunday, January 2, 2011 1:06 PM

BizTalk HL7 Receive Pipeline Exception
If you experience sequence of errors below with BizTalk HL7 MLLP receive ports you may need to request a hotfix from Microsoft. Knowledge base article number is 2454887 but it’s still not available on the KB site. The hotfix is recently released and you may need to open support ticket to get to it. It requires three other hotfixes installed: · 970492 (DASM 3.7.502.2) · 973909 (additional ACK codes) · 981442 ( 3.7.509.2) If the exceptions below repeatedly appear ......

Posted On Sunday, January 2, 2011 12:59 PM

Custom Pipeline Component for High Performance Message Transformation
When developing pure messaging solutions (no orchestrations) in BizTalk often there’s a need to apply transformation on the message. BizTalk has out of the box functionality to execute maps on receive (inbound map) and send (outbound map) ports. Sometimes using classic BizTalk map is not the best solution, for example for complex transformations with grouping (for example, using Muenchian Method). In other cases, it’s strongly preferable to keep transformation easily configurable to be able to change ......

Posted On Wednesday, October 13, 2010 12:07 PM

Inside BizTalk Web Service Proxy - Operation Binding
In service-oriented solution I designed there was an interface where some operations were handled by BizTalk while some were just straight data services with no need for orchestration. The idea was to keep web service operations in one endpoint for business reasons, security and operational considerations. Using WCF way of describing interface example may look like this: [ServiceContract(Name="Test... Namespace = " public interface ITestService{ [OperationContract(Name ......

Posted On Monday, August 28, 2006 8:30 PM

Problem with WCF-SQL Adapter
When using WCF receive adapter with SQL binding in Polling mode please be aware of the following problem. Problem: At some regular but seemingly random intervals the application stops processing new requests, places a lock on the database and prevent other application from accessing it. Initially it looked like DTC issue, as it was distributed transaction that stalled most of the time. Symptoms: Orchestration instances in Dehydrated state, receive location not picking up new messages, exclusive locks ......

Posted On Monday, May 17, 2010 3:31 PM

BizTalk 2006 Service Pack 1 Beta
BizTalk 2006 R2 Service Pack 1 Beta 1 has been released. It's available through MS Technology Adoption Program at List of features

Posted On Wednesday, October 14, 2009 11:10 AM

Setting relative path of the key file in Visual Studio 2005 project
If you like to keep solutions organized, keep common things together, store keys separately, and use automated builds you’d probably get frustrated by the new Signing tab of the Project Settings UI. Don’t get lured by the fancy look-n-feel of this dialog – it won’t let you set relative path of the strong key file. If you browse to the existing file, IDE will try to copy it into the project folder. Type things like “..\key.snk” and it just barks at you that such ......

Posted On Monday, February 6, 2006 5:08 PM

Party resolution with SOAP adapter and client certificates
After trying for a while to make the subject working I gave up and turned to the BizTalk product team. It was confirmed that SOAP adapter would not populate message context with client certificate as HTTP adapter does and the new bug was filed. Apparently, it's pretty major fix and won't probably make it to the RTM. The alternative is to use resolution by SecurityID (AllowByCert=false; AllowBySID=true in the pipeline's party resolution component). The client certificate mapping to windows accounts ......

Posted On Tuesday, January 17, 2006 6:45 PM

How to save password for WCF Adapter in BizTalk binding file
Generally, it is not recommended to store passwords in the binding file and by default BizTalk administration UI clears it out when exporting binding to the xml file. But in development environment where you have automated continuous integration build and deployment not having password in the binding file will prevent application from starting and CI process fail. It can become tedious in staging deployments (TEST, UAT) as well, especially if you have multiple endpoints that use accounts with passwords. ......

Posted On Thursday, August 27, 2009 2:31 PM

Default Database Instance in WCF Adapter URI
Recently during migration BizTalk project from SQL to WCF adapter had some rather confusing moment. After deploying to test environment WCF ports started generate errors like this: Failed to open Microsoft.ServiceModel.Chan... Faulted Microsoft.ServiceModel.Chan... Faulted System.ServiceModel.Channel... Failed to open System.ServiceModel.Channel... After few frustrating troubleshooting sessions ......

Posted On Thursday, July 2, 2009 11:14 AM

Microsoft ESB Guidance installation
I just installed Microsoft Enterprise Service Bus Guidance framework (November 2007 version for BizTalk 2006 R2). Although lengthy installation process is well documented in the accompanying help file I ran into multiple issues and it took a couple of days to sort everything out. I'd like to mention here major problems/solutions in case somebody decides to go through the same. First, if you install on other than default location (C:/%PROGRAM_FILES% and C:/Projects) make sure to update all scripts ......

Posted On Friday, February 20, 2009 6:58 PM

SSO Configuration Tool Updated

Uploaded new version of SSO Config Tool including fix for the browsing SSO Config Store application and some usability/UI improvements. Download source code.

Posted On Friday, December 5, 2008 12:21 AM

Handling SOAP Exceptions in BizTalk Orchestrations with WCF Send Adapter
Below is an idea how to improve SOAP exception handling in BizTalk to WCF communication. Let’s consider approach recommended in BizTalk SDK documentation (Catch Typed Fault Exception sample): Add custom WCF fault to the service contract and add corresponding exception handler in the BizTalk orchestration. In BizTalk orchestration add hander that expects System.Web.Services.Protoco... to catch any general SOAP exceptions This allows catching any custom WCF faults and handling them gracefully. ......

Posted On Monday, June 23, 2008 12:29 PM

Storing BizTalk settings in custom configuration file using Enterprise Library
Choice of configuration settings storage is an important topic when it comes to enterprise BizTalk application planning. One of the many options is to use regular .Net configuration files. Some prefer this way over the Enterprise SSO database option for reasons of simplicity and familiarity. I wanted to show how it can be done with Microsoft Enterprise Library configuration application block. In this case Enterprise Library configuration section is placed in the BTNTSvc.exe.config file while application ......

Posted On Wednesday, June 11, 2008 3:12 PM

MSBuild Tasks for BizTalk Continuous Integration
If you store BizTalk application settings in Enterprise SSO database and adapt continuous integration you'll find this MS Build task useful. DeploySSOConfigStore task reads settings from XML configuration file and saves them to the SSO database. The XML can be created (exported) using Richard Seroter's SSO tool which I modified to support this operation. So, if you change your configuration settings, just update XML file in the source control and build process will pick it up and propagate changes ......

Posted On Monday, June 9, 2008 8:04 PM

Improved SSO Configuration Data Store Tool
Richard Seroter published useful utility to store/retrieve BizTalk configuration settings in Enterprise SSO database. I added some more functionality to it. First, I added Export/Import functions allowing to actually save values in the external XML file (Richard's implementation allowed storing only field names, calling for extra work should you delete and restore SSO aplication). I kept file format the same but added values stored as text nodes: <sso> <application name="eCommerce.BizTalk.Con... ......

Posted On Friday, May 16, 2008 3:54 PM

Copyright © Paul Petrov | Powered by: