BizTalk Server 2006 (including R2 apparently – see warning section of this page) seems to have a bug, for which I’ve seen no fix, that affects the performance and size of the DTA (BizTalkDTADb) database because it fills it up with orphaned instances. You can detect these using the following query:
select count(*) from [dbo].[dta_ServiceInstances] […]
Thanks to everyone who attended. Here are the slides –
And the demos –
Check out my BizTalk
R2 Training.
Yesterday we encountered a worrying blocking error when expanding the Application node under a BizTalk Group in the 2006 Administration Console:
Failed to create ApplicationNode (Microsoft.BizTalk.SnapIn.Framework)
Additional Information:
Exception has been thrown by the target of an invocation. (mscorlib)
Failed to enable constraints. One or more rows contain values violating non-null , unique or foreign-key constraints. (System.Data)
All of the […]
Just a few days ago I tried, and I fit perfectly into the suite, in which I came into the United States from Russia in now so old 1996 year.
Since that I fattened a lot on Cola, pizzas and other dubious food substitutes from 195 pounds to almost 255 pounds last October (2007). In October vacation at La Push I decided that enough is enough, and began dieting. And now I am back to 200 pounds plus eight new holes in my belt about one inch from one another. And now I fit well into clothes I brought with myself from Russia including the three-piece suite with 19th century style chained watch piece made by St.Petersburg/Lomonosov factory. Yes, I know, it’s a small stuff. But it makes me happier.
In a follow up to my initial discovery of the new context property (largely undocumented as far as I can tell) called BTAHL7Schemas.MessageEncoding we were converting a working process from 2004 to 2006 R2 and we started getting this error:
Event Type: Error
Event Source: BizTalk Server 2006
Event Category: BizTalk Server 2006
Event ID: 5720
Date: Date
Time: Time
User: N/A
Computer: ComputerName
Description:
There was a failure executing the send pipeline: “BTAHL72XPipelines.BTAHL72XSendPipeline, BTAHL72XPipelines, Version=1.3.0.0, Culture=neutral, PublicKeyToken=31bf3856ad364e35” Source: “BTAHL7 2.X Assembler” Send Port: “MLLPSendPort” URI: “localhost:11000” Reason: Object reference not set to an instance of an object.
So we put the MessageEncoding in and then started getting the following error:
Event Type: Error
Event Source: BizTalk Server 2006
Event Category: BizTalk Server 2006
Event ID: 5720
Date: Date
Time: Time
User: N/A
Computer: ComputerName
Description:
There was a failure executing the send pipeline: “BTAHL72XPipelines.BTAHL72XSendPipeline, BTAHL72XPipelines, Version=1.3.0.0, Culture=neutral, PublicKeyToken=31bf3856ad364e35” Source: “BTAHL7 2.X Assembler” Send Port: “HL7_SP” URI: “C:\Labs\HL7_Outbound\%MessageID%.txt” Reason: Specified cast is not valid.
Low and behold, hot fix 947261 that deals with these two error message. If you check version the following file Microsoft.solutions.btahl7.hl72fasm.dll, ours was at 2.0.302.0
Another one of the gotchas (yes, my blog seems to be full of them) is the ‘association’ of the acknowledgment with the original message that is generated from the BTAHL7 receive pipeline. In the BTAHL7 Configuration explorer, by default the Acknowledgment settings are as follows:
Notice that the MSH15 and MSH16 overrides are set to AL- Always generate the System and Application Acknowledgment, and that below the Route ACK to send pipeline on request-response receive port is checked. This means that the default behavior of the pipeline is to generate two acknowledgments, and route one of them back along the receive location’s send pipeline. What is it supposed to do with the second acknowledgment that it created?
That is where the error message is generated: Event ID 5778: The Messaging engine failed to process a message submitted by adapter: MLLP Source URL:{whaver server:port} Details: The published message could not be routed because no subscribers were found. This error occurs if the subscribing orchestration or send port has not been enlisted, or if some of the message properties necessary for subscription evaluation have not been promoted.
The resolution: a simple solution is to create a send port for this data and drop it off as a file.
Not quite the elegant solution that I want to deal with, as now there is a maintenance aspect of making sure that this folder is purged.
Let’s just not create the application acknowledgment. You do this by changing the parties definition from Original to Enhanced mode and turning the application acknowledgment to NE (never).
While trying to drop some files for Thomson’s BizTalk applications to load I found out that for the UPS order application they have built in a lot of logging and archiving. One nice feature is the Uploaded folder which archives messages for a particular dropped file. It looks like this:
These messages can tell you things like what went wrong in the application or if your fields weren’t properly formatted in the file you dropped. This is what I saw initially in one of the files. I needed only the incoming message segment and copied that out.
Copying the black just to see the xml makes it easier to read, and I saw the following (just an example):
One of the most useful things I came across when doing the asp.net project that i wrote about in my last 2 posts was this article and sample solution by Jason Bock on mocking the HttpContext session state in .net 1.1 and 2.0. Actually this is not a ‘mock’ interface in the sense of mock […]
Over the past month I've been working really hard on our new BizTalk Expert Series class for Business Activity Monitoring. I have to say that I'm really excited to start teaching it. In the class we manage to cover almost everything one could want to know about BAM in three days. The most interesting part of it for me is the data consumption lab. I've never been very fond of the BAM Portal. It's nice but certainly not something that I'd like to parade in front of a CEO of a big company, don't get me wrong, the capabilities are awesome, but the way it looks and some of its behaviors aren’t the best. In the consumption lab, we examine how to create custom consumption models for BAM data using PerformancePoint, SQL Reporting Services, and an AJAX based web site. I'd never worked with PerformancePoint before and I was surprised by how easy it was to create a dashboard based on the BAM OLAP cube.
The next Auckland Connected Systems User Group meeting has been confirmed.
AS2 and EDI support in BizTalk R2 by David Hall
REGISTRATION CLICK HERE
Abstract: A new feature introduced in BizTalk R2 is native support for EDI data exchange and AS2 data transport. David goes through the basics, demos, the business value, and some tips and tricks picked […]