Tag | BizTalk Posts

If you want to debug your custom pipeline component you can make use of the Pipeline.exe utility to do this: Set the breakpoint in your Custom Pipeline Component code in Visual Studio. On the properties page of the project containing your Custom Pipeline select the Debug tab. Set the “Start Action” property to "Start external program" and then type or browse to: {Installation Location}\Microsoft BizTalk Server 2010\SDK\Utilities\Pipeline... For the "Start Options > Command line ...
In my last BizTalk post, I showed a project that routed xml messages to different parties based on the destination party name. It worked for simple xml messages, but if you want to work with EDI files you need to set up actual trading partner agreements between the parties, in order to configure the additional information needed to send an EDI X12 message (the ISA & GS segments). We'll build off the solution previously created by adding an X12 schema, mapping the xml purchase order to it, and ...
I recently had a need to create a send port that could output a flat file but I could not determine which flat file schema to use at design time. Or at least I didn’t want to. I wanted to process multiple flat file formats with the same orchestration process and output with the same send port. I have my orchestration dynamically mapping the document to the appropriate flat file document schema. The generated orchestration message type is set to System.XmlDocument so the orchestration can handle the ...
We are currently evaluating BizTalk 360 at one of my clients at the moment and I plan to write a more detailed post in the future about our experiences but in the meantime I wanted to make a comment about something this week which was particularly useful. We have a very large project with many teams and vendors and in our first integration test environment all of the delivery teams do daily deployments to this test environment. From here a successfully tested release could be promoted to other environments ...
BizTalk Server 2010 - Using the WCF-SQL adapter to make multiple stored procedure calls A recent project that I was working on required that I take an incoming flat file, containing multiple transaction records, and load these transactions into a database. Within the source file were multiple instances of any of seven transaction types. The database had a separate table for each transaction type, each with its own stored procedure for inserting a record. So thats seven transaction types and seven ...
BizTalk parties are external entities that BizTalk communicates with. You create parties in the admin console to determine how (or where) messages are routed, as well as controlling various pieces of envelope information for EDI messages. Today I'm going to walk through a very simple method of routing a message through an orchestration to any location based just on the party name. Begin by creating a new BizTalk solution. Add a schema called PurchaseOrder that looks like this: Promote the customer ...
I’ve just published a CTP version of “The Developers Guide to AppFabric”. Any feedback on the content would be great, and I will include it in the full release next week. “The Developer’s Guide to AppFabric” is a free e-book for developers who are exploring and leveraging the capabilities of the Azure AppFabric platform. The goal is to create a resource that will evolve and mature in parallel with the Azure AppFabric technologies. The use of an electronic format will allow sections to be added as ...
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 ...

Hi All

Please Refer the Biztalk Testing Guide

 

URL :http://code.msdn.microsoft.com/BTSTestGuide

 

Thanks

Abhishek Lohani

 

 

At last, I can announce that ‘BizTalk Server 2010 Unleashed’ has been published and is available through major booksellers in both printed and electronic form. The book is not a new edition of the old ‘BizTalk Server 2004 Unleashed’ book from several years ago, although Brian Loesgen, our fearless team leader, provided continuity with that title. Instead, this is entirely new content written by a team of six authors, including myself. BizTalk Server is such a huge subject. It proved a challenge to ...
One benefit of my recent experience on a BA flight was that I got plenty of time to read through “Microsoft BizTalk 2010 Line of Business Systems Integration”. I’d promised the publisher weeks ago that I would take a look and publish some comments, but August has been such a busy month for me, and they have had to be patient. I should point out that, for the sake of transparency, that with another BizTalk book about to be released (next week) which I helped co-author, I have an urgent and obvious ...
The PAL(Performance Analysis of Logs ) tool is used to generate an HTML-based report that graphically charts important performance monitor counters and generates alerts when thresholds for these counters are exceeded. PAL is an excellent tool for identifying bottlenecks in a SQL Server Server , IIS , SharePoint solution ,Biztalk etc to facilitate the appropriate allocation of resources when optimizing the performance of the solution. For more information about the Performance Analysis of Logs (PAL) ...
For the environment that does not have SCCM to monitor BizTalk server health, the following SQL query can be incorporate into a SQL job and have BizTalk server at least on a "constant" check. Note: be aware that the following was tested only against a single suspended instance with a send port. Since BizTalk SQL server does not allow select against the ServiceClass table, I couldn't use a single table join. With the data I currently have, I am not 100% sure the Receive Port, Pipeline, Orchestration ...
Following the previous post, here is a second bit of wisdom. In the Load method of a custom pipeline component, only assign values retrieved from the property bag to your custom properties if the retrieved value is not null. Do not assign any value to a custom property if the retrieved value is null. This is important because of the way in which pipeline property values are loaded at run time. If you assign one or more property values via the Admin Console (e.g., on a pipeline in a Receive Location), ...
Here is a small snippet of BizTalk Server wisdom which I will post for posterity. Say you are creating a custom pipeline component with custom properties. You create private fields and a public properties and write all the code to load and save corresponding property bag values from and too your properties. At some point, when you deploy the BizTalk application and test it, you get an exception from within your pipeline stating, unhelpfully, that "Value does not fall within the expected range." Or ...
I'm sure that over time you've run into the dreaded "File transport does not have read/write privileges for receive location "C:\Flatfile\SAPTestIn\".". Usually you simply go to the folder and either give the BizTalk account full permission (bad) or Everyone full permission (really bad). So for a production environment, what is the absolute minimum permissions required? For the Receive File Adapter the explicit permission are: NTFS Attribute Property Name DELETE Delete Files FILE_READ_DATA List Folder ...
Hi Please refer the link below before building a Custom Adapter in Biztalk . Wizards used from code plex site to build custom Adapter in Biztalk having defect that is not reproducable in System Testing or Integartion Testing that should be reproduce with soak testing or live testing i.e To Save the Cost of Quality of the software developed please refer the below link to fix defects in Requirement stage to coding stage /bloggingabout.net/blogs/we... ...
The following error was encountered when consuming a flat file through a pipeline that made use of the Flat File Disassembler pipeline component: There was a failure executing the receive pipeline: "xxxxxxxxx, xxxxxxxx, Version=1.0.0.0, Culture=neutral, PublicKeyToken=xxxxxxx" Source: "Flat file disassembler" Receive Port: "xxxxxxxxx" URI: "C:\BizTalk Folders\xxxxxxxxx\*.csv" Reason: Cannot access a disposed object. Object name: 'DataReader'. This was resolved by settling 'RecoverableInterchangeProc... ...
While undeploying a BizTalk Applciation recently something went wrong, leaving BizTalk in a strange state. When opening the BizTalk Server Administration Console the following message would be displayed: Schema referenced by Map 'xxxxxxx' 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. The problem with this was that any attempt to refresh the BizTalk group in ...
If your orchestration is heavily rely on WCF SQL adapter based on SQL stored procedures, you may often encounter an issue related to strongly-typed schema and receive an error which is similar to the following. The adapter failed to transmit message going to send port "WcfSendPort" with URL "mssql://sqlserver//databas... It will be retransmitted after the retry interval specified for this Send Port. Details:"System.Data.SqlCli... Invalid object name '#Temp'. This is because of the ...
Microsoft released downloadable training materials for BizTalk 2010 for both Administrators and Developers. Training for Developers: http://www.microsoft.com/do... Training for Administrators: http://www.microsoft.com/do... ...

Well simply put - flat out on a big Government IT project. This is due to go live next month and I'll be writing a number of pieces here on it.

Built on BizTalk, WCF, Windows Foundation, MVC, Entity framework and App Fabric....

Peter Norvig and Sebastian Thrun are offering a free on-line course on AI later this year in conjunction with Stanford University. The course is broadly based on Peter Norvig's book "Artificial Intelligence: A modern Approach" written jointly with Stuart Russell. Along with my colleagues on the Rules Fest committee, we have been following this with interest. In a few days, well over 100,000 people have signed up (112,774 at the time of writing, and still increasing fast). The course broadly overlaps ...
For a period of time, I have access to both an MSDN and a TechNet subscription. Both offer Microsoft software for download. I wondered what the similarities and differences were between the two subscriptions. I copied the two download lists into Excel and aligned them. Most of the material I would never use. Some products I have never heard of. I present the lists, current as of today, for your reviewing pleasure. TechNet MSDN Applications (63) Applications (79) Access 2.0 Access 2003 Access 2003 ...
Everyone has a journey. You start off young & stupid, and 2 decades later, you're closer to understanding the nature of reality. That’s one of the main goals in life, to seek knowledge (justified, true beliefs – pick any 2 J ). I must have read 5000 books in my life. From some of my readings it could be construed that reality computes itself, It from Bit. From others, it can be concluded that Entropy is decreased by increased rates of computation, and in the short span of human civilization, ...

The biztalk videos for BDD and acceptance testing are now on cloudcast

http://www.cloudcasts.net/Default.aspx?category=BizTalk

This is a unknown issue with Certificates in BizTalk Server. You see the error every time when you open or save send port configuration, it won't affect the functionality, but very annoying. It usually happens when you remotedly log on to a BizTalk server at which the "Other People Certificate Store" is not initialized. Microsoft has an article talking about this issue, and it suggests to initialized the "Other People Certificate Store" during the Group configuration. However, if you have your BizTalk ...
Article Source: http://geekswithblogs.net/c... What is the best approach for developing a WCF client application that sends messages to the WCF on-ramps exposed by the BizTalk ESB Toolkit? I had considered various approaches: Generate an xml message from a string template using string replacements. Then submit the message to the ESB endpoint using code similar to the Itinerary Test Client provided with the ESB Toolkit. Then for the response use XPath to get the required data. - This is obviously ...

Ive recently done some user group sessions around BizTalk and Behaviour Driven Development and Acceptance Testing.

Ive uploaded the videos and samples for these sessions to the following codeplex site.

http://biztalkbddsample.codeplex.com/

They will also be on CloudCasts soon

Enjoy

 

Today we are glad to announce HERMES, an Open Source Infrastructure for publish subscribe messaging model based on MongoDB and RESTful Services. This is 8th release of an open source project from TellagoDevLabs on Codeplex. Hermes is months of hard work by us, including Silvio Massari, Jose Romaniello and Gustavo Machado. Hermes is not BizTalk Server. BizTalk Server has pub-sub mechanism in its infrastructure but in very traditional way and it hasn’t provided a foundation that can be seamlessly used ...
I was checking the Windows Azure Appfabric June CTP; I was looking at the Azure Service Bus queues and topics. I noticed something interesting to me and hope we can take advantage of these new capabilities in applications like RFID. Working on BizTalk RFID or any RFID project for that matter, you would have noticed using duplicate tag elimination events during tag processing. For any one new to RFID, when RFID device reads tags it can read the same tag information more than once at a given interval. ...
Hi there, Recently we had a requirement to integrate a RESTful Service with BizTalk Server. Well no biggie. You can use WCF – Custom Adapter and use webHTTP binding and add a webHttp Endpoint behavior. Wala. Easy to say, little bit tricky to do. That all is fine, but what if you want to have a polling receive location which needs to go and do an HTTP GET to a RESTful Service. Aahh!! That’s even more trickier. Bunch of you reading this post would have already thought about some or other way of doing ...
When we migrate some BizTalk apps from BizTalk 2006 R2 to BizTalk 2010, and we ran into issue when a .net component called inside the orchestration. In the .net component we are trying to retrieve some promoted property and we also checked in the BizTalk group hub to validate it was promoted, no issues there. Only when we try to access the data into the .net component we had issue. We just moved all the assembly what we had in BizTalk 2006 R2 to BizTalk 2010, didn’t recompile anything in BizTalk ...
In one of our prod server we recently ran into issue when we went and update the web.config and try to browse the service. We started seeing the service was not responding and getting the following warning in the application log. Our service is WCF service, BizTalk orchestration exposed as service. We have other prod server where we never ran into this issue, so what’s different with this server. After going thru lot of forum and came up on some Microsoft service pack and hot fix which related to ...
By default, BizTalk creates the filename of the message dropped to a send port as %MessageID%, which is the unique identifier (GUID) of the message. What if you want to create your own filename? To start, create a simple schema, and a basic orchestration that will receive the message and send it right back out, like this: If you deploy this and wire up the ports, you can drop an xml file into your receive port and have it come out at your send port named something like {7A63CAF8-317B-49D5-871F-9F... ...
Those who are familiar with BizTalk 2006, should know about Development and Deployment modes in Visual Studio. Personally, I never questioned why it's not Debug and Release just like everything else in Visual Studio. Then everything changed in BizTalk 2010. BizTalk and Visual Studio 2010 now uses Debug and Release modes by default. When we upgraded BizTalk 2006 solution to 2010, Development and Deployment modes remained unchanged for all the projects, and code compiled without any issues. Soon, I ...
One of the most common errors we could see when we use WCF adapters is "The action was not understood". This is most likely because the mismatch between the logical port operation identifier in a orchestration and the operation name of SOAP action header in WCF send port confguration. To fix the problem is very easy, just change one of them to have them match. There is a very good article explaining why this happens. Click here to view the article. ...Edmund Zhao ...
This article is a Part 5 of the Interview Questions series. Part 1: BizTalk: Questions for interview without answers Part 2: BizTalk: Interview questions and principles Part 3: WCF: Questions for studying and interviewPart 4: WCF: Questions for studying and interview: DiscoveryPart 5: WCF: Questions for studying and interview: Routing Service Part 6: BizTalk: Advanced Questions WCF, Routing Service Q&A • What are the features of the Routing Service (RS): Protocol bridging; Message transformation; ...
NOTE: The variable PropExists as bool has been already created The Property of interest is BTS.RetryCount The Message is Message_In The list from Using Operators in Expressions (http://msdn2.microsoft.com... has the typical list of stuff that you expect in C#, multiplication, bit operations (shift left and right) and Boolean operators, but a couple of extremely useful constructs are available that are unique to BizTalk. The most important of these (in my humble opinion) ...
When determining infrastructure requirements for a client often the question of whether to use BizTalk Standard or BizTalk Enterprise comes up. If the client is a small enterprise with limited redundancy and scaling needs the Standard Edition of BizTalk should work fine. If the client requires any redundancy or scaling then Enterprise is almost certainly necessary. In other words if your requirements dictate that you require more than one BizTalk server you will need the Enterprise Edition of BizTalk ...
Recently I was building a VM for a BizTalk 2006 R2 project. My VM configuration was : Windows 2003 R2 SQL 2005 with SP4 Visual Studio 2005 with SP1 BizTalk Server 2006R2 I installed the BizTalk Server 2006 R2 SP1 update from the Windows Update. Life was good so far. Next I got requirement to use WCF SQL adapter and there I went and started installing the pre-requisite for it. 1. WCF LOB Adapter SDK SP2 2. Microsoft BizTalk Adapter for SQL Server. After that I went and tried to Add the Adapter metadata ...
This morning I was reading through some of my usual blogs and came across some very interesting and updated information relating to BizTalk performance and hyper-threading. The two source pages are: http://appfabriccat.com/201... http://msdn.microsoft.com/e... If you take a look at these pages, you can see that the recommendations on hyper-threading and the BizTalk platform ...
I was chatting the other day with someone about adapters for connecting to LOB applications and an interesting point came up which I thought id share my thoughts on. The scenarios is that if you have a line of business application for arguments sake lets say its dynamics CRM which has a BizTalk adapter available but also has an existing web service API (or some other protocol based API). Which should you use for integration? In my opinion the answer to this is the usual "it depends" answer. I think ...
I spent some time today summarising the new features in the Windows Azure AppFabric May CTP for SolidSoft consultants. Microsoft released the CTP a couple of weeks ago and has a second CTP coming out later this month. I might as well publish this here, although it has been widely blogged on already. There is nothing that you can’t glean from reading the release documents, but hopefully it will serve as a shorter summary. The May CTP is all about the AppFabric Service Bus. The bus has been extended ...
Microsoft has publically released the content from their BizTalk 2010 training course - this includes the PowerPoint decks (with instructor notes), Word docs of all the modules, 1.5 gigs of videos, and virtual machines (for Hyper-V only) for all the labs. The downloads are available at: BizTalk Server 2010 Developer Training Kit From Microsoft's site: About This Hands-On Lab This five-day instructor-led course consists of a series of hands-on labs that provides students with the knowledge and skills ...

We've been having a problem getting BizTalk to recognize an 837I A2 (00501X223A2) file, and Microsoft just yesterday released a fix for it:

http://support.microsoft.com/kb/2510733

It can be downloaded as part of the new Cumulative update package 1 for BizTalk Server 2010.

Technorati Tags:

We had a process ot using BizTalk to take in a reference file, then send data in via a table_type parameter in a stored procedure. The stored procedure uses a MERGE statement to insert and update; the update part of which does a CHECKSUM first to determine whether an update is even necessary. Then it happened, we had a reference row that should have been updated by the latest file, but it wasn't done. We checked the incoming and outgoing BizTalk Message in and out of the pipeline; everything looked ...
A few weeks ago I did the video about how we were testing what happens inside BizTalk by using the CAT Team Logging Framework and the ETW trace events and then testing the information coming out from our tracing to prove what was happening inside BizTalk. Ive updated the codeplex project so that the code is a little easier for people to use and is packaged better. Also the source code is now available in codeplex and there is some additional documentation. Note that it now works slightly differently ...
Sometimes I need to load a stream from a file in a Biztalk pipeline and I have to determine the Type of the message. Here s how i do that : // This is for sample only. Should refer to the message stream and rewind the stream Stream fs = new FileStream(filepath, FileMode.Open); // End of stream initialisation. XPathDocument sourceDoc = new XPathDocument(fs); XPathNavigator navigator = sourceDoc.CreateNavigator(); navigator.MoveToFirstChild(); string streamDocSchema = navigator.NamespaceURI + "#" + ...