Geeks With Blogs

News
Stuart Brierley Integration Management - BizTalk and More May 2010 Entries
BizTalk 2009 - Size Functoid Fun
Recently when mapping a flat file from a third party source, I needed to check whether some elements had been sent with any content or not. In the source message these elements were being supplied in the form: <comment /> I though I would try using the size functoid, assuming that it would return a size of 0 for these empty elements. What actully happens is that the Size funtoid returned a size of 1 rather than the 0 I was expecting. To get what I considered to be the correct output I needed ......

Posted On Friday, May 28, 2010 4:00 PM

BizTalk 2009 - Scoped Record Counting in Maps
Within BizTalk there is a functoid called Record Count that will return the number of instances of a repeated record or repeated element that occur in a message instance. The input to this functoid is the record or element to be counted. As an example take the following Source schema, where the Source message has a repeated record called Box and each Box has a repeated element called Item: An instance of this Source schema may look as follows; 2 box records - one with 2 items and one with only 1 ......

Posted On Friday, May 28, 2010 9:57 AM

BizTalk 2009 - Custom Functoid Categories
I recently had cause to code a number of custom functoids to aid with some maps that I was writing. Once these were developed and deployed to C:\Program Files\Microsoft BizTalk Server 2009\Developer Tools\Mapper Extensions a quick refresh allowed them to appear in toolbox. After dropping these on a map and configuring the appropriate inputs I tested the map to check that they worked as expected. All but one of the functoids worked as expecetd, but the final functoid appeared not to be firing at all. ......

Posted On Thursday, May 27, 2010 11:27 AM

BizTalk 2009 - Creating a Custom Functoid Library
If you find that you have a need to created multiple Custom Functoids you may also choose to create a Custom Functoid Library - a single project containing many custom functoids. As previsouly discussed, the Custom Functoid Wizard can be used to create a project with a new custom functoid inside. But what if you want to extend this project to include more custom functoids and create your Custom Functoid Library? First create a Custom Functoid Library project and your first Custom Functoid using the ......

Posted On Wednesday, May 26, 2010 1:39 PM

BizTalk 2009 - Custom Functoid Wizard
When creating BizTalk maps you may find that there are times when you need perform tasks that the standard functoids do not cover. At other times you may find yourself reapeating a pattern of standard functoids over and over again, adding visual complexity to an otherwise simple process. In these cases you may find it preferable to create your own custom functoids. In the past I have created a number of custom functoids from scratch, but recently I decided to try out the Custom Functoid Wizard for ......

Posted On Wednesday, May 26, 2010 9:19 AM

Guid Generation
If you need to create a guid you can obviously make use of the Microsoft GuidGen tool, but what if this tool is not available on the system you are using? I recently came across the online guid gen tool which may be able to come to your rescue: To get a new guid pres the "Create New Guid" button and away you go ......

Posted On Tuesday, May 25, 2010 9:24 AM

BizTalk 2009 - Service Instances: Last 100
Having previously talked about the lack of the traditional HAT in BizTalk 2009, the question then becomes how do you replicate some of the functionality that was previsouly relied on? I have already covered the Last 100 Messages Received, the Last 100 Messages Sent, and the Last 50 Suspended Messages queries so what about service instances? The BizTalk 2009 Group Hub allows you to search for suspended service instances and also running service instances, but not the two together. In BizTalk 2004 ......

Posted On Monday, May 24, 2010 1:29 PM

BizTalk 2009 - Messages: Last 50 suspended
Having previously talked about the lack of the traditional HAT in BizTalk 2009, the question then becomes how do you replicate some of the functionality that was previsouly relied on? I have already covered the Last 100 Messages Received and the Last 100 Messages Sent queries so what about suspended messages? In BizTalk 2004 we had a query in HAT to return the last 100 suspended message instances. Lets create a direct replacement in a BizTalk 2009 Hatless environment. Basically we are creating a ......

Posted On Monday, May 24, 2010 1:22 PM

BizTalk 2009 - Messages: Last 100 Sent
Having previously talked about the lack of the traditional HAT in BizTalk 2009, the question then becomes how do you replicate some of the functionality that was previsouly relied on? I have already covered the Last 100 Messages Received query so what about sent messages? In BizTalk 2004 we had a query in HAT to return the messages sent in the last day. While not a direct replacement the following query replicates some of the usefullness of this query in a BizTalk 2009 Hatless environment. Basically ......

Posted On Monday, May 24, 2010 1:07 PM

BizTalk 2009 - Messages: Last 100 Received
Having previously talked about the lack of the traditional HAT in BizTalk 2009, the question then becomes how do you replicate some of the functionality that was previsouly relied on? In BizTalk 2004 we had a query in HAT to return the messages received in the last day. While not a direct replacement the following query replicates some of the usefullness of this query in a BizTalk 2009 hatless environment. Basically we are creating a query to search for the last one hundred tracked messages that ......

Posted On Monday, May 24, 2010 11:43 AM

BizTalk 2009 - How do I do t"HAT"?
In my previous life working with BizTalk Server 2004, I came to view HAT (the Health and Activity Tracking tool) as one of my first ports of call in the case of problems with any of our BizTalk solutions. When you move to BizTalk Server 2009 it is quickly apparent that HAT is no longer with us. HAT was useful in BizTalk 2004 mainly as it provided developers and administrators with a number of useful queries and views of what was going on inside BizTalk at runtime; when and what type of messages were ......

Posted On Monday, May 24, 2010 10:15 AM

BizTalk 2009 - Error when Testing Map with Flat File Source Schema
I have recently been creating some flat file schemas using the BizTalk Server 2009 Flat File Schema Wizard. I have then been mapping these flat file schemas to a "normal" xml schema format. I have not previsouly had any cause to map flat files and ran into some trouble when testing the first of these flat file maps; with an instance of the flat file as the source it threw an XSL transform error: Test Map.btm: error btm1050: XSL transform error: Unable to write output instance to the following <file:///C:\Documents ......

Posted On Wednesday, May 19, 2010 3:36 PM

BizTalk 2009 - Project Creation Failed
A couple of weeks ago I had some issue with my BizTalk Server 2009 development environment which resulted in a reinstall of Visual Studio 2008 and the Visual Studio 2008 Service Pack 1. Following this reinstall I began to have problems when trying to create BizTalk 2009 projects: Error Details: “Create BizTalk Project …. Project Creation Failed” It turns out that this is a known issue with BizTalk Server 2009 and Visual Studio 2008, whereby the installation of the Visual Studio Service Pack 1 can ......

Posted On Wednesday, May 19, 2010 10:17 AM

BizTalk 2009 - BizTalk Benchmark Wizard: Running a Test
The BizTalk Benchmark Wizard is a ultility that can be used to gain some validation of a BizTalk installation, giving a level of guidance on whether it is performing as might be expected. It should be used after BizTalk Server has been installed and before any solutions are deployed to the environment. This will ensure that you are getting consistent and clean results from the BizTalk Benchmark Wizard. The BizTalk Benchmark Wizard applies load to the BizTalk Server environment under a choice of specific ......

Posted On Tuesday, May 18, 2010 12:07 PM

BizTalk 2009 - BizTalk Benchmark Wizard: Installation
As previously detailed, I have completed a single server installation of BizTalk Server 2009 standard on my development laptop; a MacBook Pro Core2Duo running at 2.16Ghz with 2Gb of RAM. Following this I also posted on my use of the BizTalk Server Best Practices Anaylser and how to configure the BizTalk SQL Server Jobs. All of which means that I should have some confidence that I have a decent working BizTalk Server 2009 environment, Next I thought that it would be a good idea to try and get some ......

Posted On Tuesday, May 18, 2010 9:05 AM

BizTalk 2009 - SQL Server Job Configuration
Following the installation of Biztalk Server 2009 on my development laptop I used the BizTalk Server Best Practice Analyser which highlighted the fact that two of the SQL Server Agent jobs that BizTalk relies on were not running successfully. Upon investigation it turned out that these jobs needed to be configured before they would run successfully. To configure these jobs open SQL Server Management Studio, expand SQL Server Agent > Jobs and double click on the appropriate job. Select Steps and ......

Posted On Monday, May 17, 2010 4:47 PM

BizTalk 2009 - BizTalk Server Best Practice Analyser
The BizTalk Server Best Practices Analyser allows you to carry out a configuration level verification of your BizTalk installation, evaluating the deployed configuration but not modifying or tuning anything that it finds. The Best Practices Analyser uses "reading and reporting" to gather data from different sources, such as: Windows Management Instrumentation (WMI) classes SQL Server databases Registry entries When I first ran the analyser I got a number of errors, if you get any errors these should ......

Posted On Monday, May 17, 2010 2:35 PM

BizTalk 2009 - Installing BizTalk Server 2009 on XP for Development
At my previous employer, when developing for BizTalk Server 2004 using Visual Studio 2003, we made use of separate development and deployment environments; developing in Visual Studio on our client PCs and then deploying to a seperate shared BizTalk 2004 Server from there. This server was part of a multi-server Standard BizTalk environment comprising of separate BizTalk Server 2004 and SQL Server 2000 servers. This environment was implemented a number of years ago by an outside consulting company, ......

Posted On Monday, May 17, 2010 10:39 AM

The Coming Storm of Blog Entries
Well, maybe. I have realised that I have many many ideas and notes for blogs entries dotted around my desk, along with a number of half completed entries that I have been meaning to get sorted and finished and posted. I am hoping that over the next couple of weeks I will be able to get some of these online, including my experineces installing BizTalk 2009 on two different types of environment, some useful utilities I have used and also some notes on issues that I have encountered recently and not ......

Posted On Friday, May 14, 2010 4:11 PM

Copyright © Stuart Brierley | Powered by: GeeksWithBlogs.net