Category: BizTalk


Enable Basic Authentication with BizTalk Deployment Framework

I was having a problem with getting Basic Authentication into BizTalk’s automatic deployment. It’s not something you want to have your administrators do after each deployment, especially not if you have many web services deployed. So I needed a solution for this, but was not succeeding online for my BizTalk specific case. There’s just no way to do it out-of-the-box with the BizTalk Deployment Framework. There’s a pretty easy way...


Increasing BizTalk map performance by mapping in C#

I have been struggling with some performance issues with mappings last year. The received messages could get up to 200 MB and a lot of data had to be looked up from other records in that same request message during the mapping. The only way to improve performance was by using XSLT, on which I wrote a post last year. Eventually even that was not enough and I had to resort to using C#....


Automatically generate c# serialization classes from XSDs

So I have put my first code sample up on MSDN’s Code Gallery. The code sample demonstrates a way to automatically generate serialization classes from XSD schemas using a Text Template (T4 Template). There’s no need to run XSD.exe each time, instead you can run the Custom Tool of the Text Template and have all serialization classes generated of your XSDs. Click here to navigate to the code sample. Copy of the...


BizTalk Administration Console – Failed to enable constraints. One or more rows contain values violating non-null, unique, or foreign-key constraints.

Just a reminder in my own online error log 🙂 I got this error for the first time in my life and came across some solutions online. If you try to expand the Applications node (or refresh your configuration in general), you’ll end up getting the following error: Failed to enable constraints. One or more rows contain values violating non-null, unique, or foreign-key constraints. The solution is simple: Restart the Distributed Transaction Coordinator


Optimizing XSLT to boost your BizTalk map performance

Who hasn’t had this discussion when working with BizTalk? Should you use the built-in BizTalk mapper or go with XSLT instead. For me, it all depends which situation I am in. If there are a lot of BizTalk developers, I would say it’s a no brainer and go with XSLT. But if I have to educate people at a client to work with BizTalk in the first place, people who will only occasionally develop or...


(Re)Finding my way in Microsoft’s Integration Offering

I have, as always, been very busy with integration. On premise that is. Microsoft’s cloud integration offering has been all over the place for the last couple of years and to be honest, I wouldn’t have recommended it to customers. Enterprise customers need some sort of security for the future and can’t rely on services that will be suddenly discontinued. Finally there is some light at the end of the tunnel. Integration is...


Slow down BizTalk using an orchestration

Last week I wrote a blog post about slowing down BizTalk using throttling. This method can be good, but it’s also dependant of other factors, like how busy is your machine? Are there any other processes throttling? How severe is the impact? Different circumstances can influence throttling behavior. So it needs some testing, also on your production machine. It turns out the method is not as easy as it seemed. If we want to make...


Problem deploying Business Rules: The database “BizTalkDb:BizTalkRuleEngineDb” associated with the deployment driver does not match the database “:” specified during product configuration

We encountered a problem when deploying Business Rules on a colleagues development environment, while it wasn’t happening on all the other development environment. We are using the BizTalk Deployment Framework, but the problem will also ocurr when you are not using the Deployment Framework. The error that occurred was: Deploying rule set ‘<RULESET>’ version 1.8… Failed: Microsoft.RuleEngine.RuleEngineDeploymentDBConfigurationMismatchException: The database “BizTalkDb:BizTalkRuleEngineDb” associated with the deployment driver does not match the database...


Deliberately slow down BizTalk by using throttling

BizTalk by itself is not the fastest message broker there is. It relies heavily on SQL Server instead of in-memory queues. BizTalk isn’t slow, far from it, but there are other  systems, like Mule or WSO2, that will process messages even faster. You will loose some control, but that’s the trade-of you make if you need to process messages the fastest way possible. But speed isn’t everything, especially since you rely on the capabilities of...


Shorten the BizTalk HL7 MLLP adapter timeout of 3 seconds (MLLPFlushTimeOut)

Last week I had a problem at a client with the MLLP adapter. All messages sent through an ordered delivery MLLP Send Port were showing delays of about 3 seconds. We kept looking at the wrong places. Since the throughput of the server quadrupled after a merger, we were to focussed on performance problems, but it turned out to be a registry setting. Determined since the messages were sent to systems...