Tag | BizTalk Posts

Rules Fest 2010 kicks off at the Dolce Hayes Mansion Resort in San Jose, California on Monday 11th October, just a few short weeks away. Registrations are coming in thick and fast. The early-bird discount has been extended to tomorrow (Friday 17th September), so if you have not yet registered, the time to do so is NOW. You get the best prices, and we cannot guarantee rooms at the hotel beyond the deadline. Rules Fest provides three days to solid wall-to-wall technical content for everything to do ...
Hi, Shown below is one of the most easiest way to configure a BizTalk Receive Location which can receive any WCF Message based on the Binding type you provide in the configuration. This uses the WCF Custom WebService Host Factory. Where you can use this type of configurations? · Scenario where you need to send a WCF Message from .NET Code. · BizTalk Unit Testing. · Receive Locations which will be using ESB Toolkit receive locations. · and Many more. Anyways, below are the steps: - Create a IIS Virtual ...
Hi there everyone, We have a Webinar coming up for BizTalk Governance using SO-Aware on Thursday, October 28th 2010 (2:00PM to 3:00PM EST). Like you guys might be knowing now that SO-Aware is a "WCF RESTful Registry solution" and its one of the attractive feature is Centralizing Configurations. This webinar will be showing you some of those features and also how you can use SO-Aware extensively with other BizTalk Solutions. You can register/sign up here: http://tellagostudios.com/h... Meanwhile ...

If you experience some difficulties with a stored proc that contains some dynamic SQL, or if you intend to design such a procedure that will be executed by BizTalk (or more generally the WCF-SQL adapter), maybe this article can help :

http://geekswithblogs.net/SERivas/articles/biztalk-wcf-sql-and-dynamic-sql.aspx

MSMQ is a protocol that can benefit from the odd tweak to the registry. Unfortunately it is not always obvious what you can change to improve performance so I've tried to pull together the various sources of documentation. The first place to look is the Resource Kit Registry Reference which is pretty comprehensive. The Windows 2003 version is here but is dated "March 28, 2003" so doesn't include any new registry values introduced through hotfixes. Also, not every registry value is included for whatever ...
Here I had a plan to post in September almost the same way I did in May, June and July, but business has been good (and I hope to not jinx it). There has been plenty of stuff going on, TFS 2010 left and right, MSDN Forums, SharePoint (all flavors and variations), BizTalk, SQL Server, Commerce Server, even Host Integration Server. And of course Hyper-V. A lot has been explored and equal in the realm of learning. From writing a Microsoft Official Course, giving self-publishing a try, creating some ...
New standard the UDDI was announced several years ago [see the history in Wikipedia]. The UDDI future was promising. I was sure for that. I thought, the future is for Web-services [WS], and it is. Isn't that mean, we need services to search Web-services in internet, some Registries/Catalogs of the Web-services? How we could find the WS in internet? Google Search was not effective in this; it is still not effective now. By any means, the UDDI idea should win; all WS-s should work with UDDI Registries. ...
I recently got the following errors when starting Enterprise Single Sign-On on a pre-production BizTalk Server: The SSO service failed to start. Error Code: 0x80131700 The first error gives two suggestions on how to fix this error. The first suggestion is to reinstall SSO. I tried a repair which did not do the job so what about a full re-install? Unfortunately I could not uninstall Enterprise Single Sign-On due it being used by other programs (BizTalk anyone?). The second suggestion is to run regasm ...
Nationwide, the world’s largest building society realised the benefits of Faster Payments with the help of Microsoft Services and interestingly enough a team of BizTalk experts from Solidsoft. For a number of years Solidsoft has provided senior software consultants expert in Microsoft BizTalk server and many other Microsoft products support of Microsoft Service led developments. The Nationwide project has proved no different with Solidsoft providing a team of 6 to support the successful development ...
This is a quick post … after a lot of challenges with a recent deployment of BizTalk Server 2009, it is important to keep the following very much in mind. BizTalk Server 2009 and SQL Server 2008 R2 are not the best match, work with SQL Server 2008 with SP1. .NET 4.0 has the ability of breaking a not yet configured BizTalk deployment. Where? Enterprise SSO configuration will refuse to talk to the SSODB (mind you, the process will create the DB). There are fixes for this last one, just make sure you ...
August for some reason has been the busiest month I recall in a while. It has had a good doze of the products I love to work with, and it has given me the opportunity to get into one more, Azure. There has been BizTalk Server, SharePoint, SQL Server and Team Foundation Server and the surrounding tools. But I have been enjoying working with Azure. It’s a nice complexity full of good stuff (so far). In working with a client’s deployment the task came to needing to monitor the implementation. And since ...
Recently we had a couple of defects in the development of one of our integration solutions where we hadn't handled date times correctly in relation to day light saving. When we looked for some guidance to help us it seemed that there is a fair bit of discussion around .net implications of this but little recent content about BizTalk. Probably the most useful background articles are the following: http://msdn.microsoft.com/e... http://geekswithblogs.net/d... ...
I've been taking quite a prolonged break from blogging, partly because my attention has been elsewhere. Writing several chapters for BizTalk Server 2010 Unleashed (due to be published towards the end of the year) has taken up a lot of time. I'm also involved in helping or organise Rules Fest 2010. And then there is the day job,...and four kids,...and two cats,...and management of a local youth club,...and organising my wife's 50th, etc., etc. Anyway, this is an unashamed plug for the conference. ...
[UPDATE: 2010-10-15] This update is long overdue. Once we implemented all the changes, we were still getting that error from time to time. The sympton was that we would not get that error for hours, even days, but once we get it, the error keeps coming. After fiddling with some settings, we found that setting the "PollWhileDataFound" to False did the trick. We have not seen the error since. [UPDATE: 2010-08-26] We were able to fix our problem by setting the WCF-SQL receive location transaction isolation ...
Damn, forgot to do this every time! http://blogs.msdn.com/b/ric... HKEY_LOCAL_MACHINE\SOFTWARE... (DWORD) or HKEY_LOCAL_MACHINE\SOFTWARE... (DWORD) 0 - This is the default key, and pretty much mimics the behavior of BizTalk Server 2004 where an instance of an object is always required as an input fact, and the method is only called when the rule is evaluated or executed. 1 ...
After my last post, I discovered a side effect of registering the BizTalk Assembly Viewer. The Assembly Viewer is seen, essentially, as a system drive, but one that opens VERY slowly. The side effect is that when you're in Microsoft Office (and possibly other apps) and try to Save As..., the file dialog hangs. I'm not sure if it will eventually respond, but I got tired of waiting and simply unregistered the Assembly Viewer. To unregister: 1. Open up a Visual Studio Command Prompt 2. Navigate to <BizTalk ...
This summer Inmeta ASA, a leading Norwegian IT company, bought Osiris Data. It means we’re now more than 150 consultants, up from 30 as we were. It means a lot for us, as we now can take on larger projects, more projects and with even more colleagues we will have better competency on more areas. It is also very exciting to be in a larger company, be “exposed” to more projects and more opportunities. Osiris Data was founded late autumn 1996, and started operation in January 1997, with 3 people. The ...
UPDATE: 22/09/2010. I have posted an update on this issue. My root problem turned out to overheating, although I still advocate a number of optimisations for VirtualBox. I have a Dell laptop with 8GB RAM and a dual core processor running Windows 7. I use my machine quite intensively. Quite often I run virtual images under Oracle's VirtualBox. I'm currently using an image that contains an installation of the BizTalk Server 2010 beta. For months, I found that every time I fired up images under VirtualBox, ...
I have recently started to look at EDI communications through BizTalk. Part of the EDI features in BizTalk is the use of BAM to track messaging. Amongst the applications we currently have built in BizTalk we do some SharePoint communication. This is also a possible component to our EDI solution. We also have plans to move to BizTalk 2010 in the near future, so today I started to build my new BizTalk Dev machine. I got a bit of a surprise when 2 parts of the required set had me setting a flag “Enable ...
[Source: http://geekswithblogs.net/E... If you're doing cross-reference lookups in a BizTalk map you have a few design options (see BizTalk Pattern: Mapping Reference Data), and the BizTalk native XRef lookup can provide lookup caching (see BizTalk XRef Undocumented feature) - and you'll need caching if your maps runs against large messages. I prefer not to use the native XRef option because the values are hidden away in the BizTalk schema, are cumbersome to load, and are only available ...

Just wondering how many people actually do dynamic versioning of their BizTalk projects with Cruise Control or Team Build.

The reason I ask is you dont see that many things on the forums or blogs about it.  I find that it can be quite challenging at times so Im not sure if we are just doing it the hard way or its something most people dont do?

Ive been having some problems with versioning for BizTalk recently and in particular it was centred around one map. Initially the problems were related to the configuration manager but then when this was resolved there was another little gotcha which is probably worth bearing in mind. So on the development machine everything versions as 999.999.999.999 and this is usually pretty pain free. On the build server though a version number is applied from cruise control and replaces anything with 999.999.999.999 ...
You may have read on my recent posts about how the Visual Studio Configuration Manager again caused me problems for my BizTalk 2006 R2 project where the release/debug/deployment/de... configuration settings seem to get out of sync and it ends up causing you various problems. I got sick of this happening so I've created an MsBuild task which I can use in my build script to inspect the solution file and highlight any issues with the configuration. Basically the task will read through the file ...
Chances are that for anyone running a development BizTalk machine, you've deployed quite a few solutions as you've tested various things. It's easy enough to delete them from the BTS Administration Console with a right-click, but (assuming you've kept the default properties) they're also sitting in the GAC as well. In most cases this won't cause a problem, but eventually you may run into the dreaded "Message can not be serialized as the schema <schema name> could not be located. Either the ...
[Source: http://geekswithblogs.net/E... In my previous post, Cloud Services and Command-Query Separation: Part 2, I walked through a sample Command-Query Separated service bus solution using readily available cloud services for communication. In this one, I'll look at some of the implications of shifting systems integration to the cloud, compared to an on-premise ESB. The focus here is mainly on Amazon Web Services, but I'll cover Azure with a dedicated sample project. Cost & Non-Functional ...
Hi there folks, I have created few more ESB Itineraries samples which uses the SO-Aware ESB Resolver for different kinds of scenarios. Scenarios like: 1. Two Way Itinerary : Msg In -- Transform -- Route -- ReqestResponse WCF Svc (Registed in SoAware) -- Transform -- Route -- Destination WCF Service (Registered in SoAware). 2. One Way Routing: Msg in -- Resolve Routing parameters -- WCF Service (Registered in SOAware) Thanks and Happy SO-Awaring with ESB and BizTalk. ;-) -Vishal Mody ...
Hey folks, Recently, Tellago Studios released its first product SO-Aware, A WCF RESTful Service Metadata Repository. Now talking about WCF Services and how can we forget them being used extensively by BizTalk Server. Let’s check it out with a simple scenario. Say you are using SO-Aware as a central repository for all your Web Services. Some of those services are also integrated with BizTalk. Now on one hand you have a central repository for your services and your life is going smooth but when it ...
I had a very painful experience this week on a project. We were implementing some new features in an existing BizTalk application and the first builds on the build server were good then suddenly a number of the tests started failing with the below error in the event log. Event Type: Error Event Source: XLANG/s Event Category: None Event ID: 10030 Date: 8/4/2010 Time: 1:36:21 PM User: N/A Computer: ------------------ Description: Uncaught exception (see the 'inner exception' below) has suspended an ...
[Source: http://geekswithblogs.net/E... Overview Cloud services available from Microsoft Azure and Amazon Web Services both offer message queues and data storage, combinations which enable a very simple SOA solution based on Command-Query Separation. Consumers and service providers communicate through the cloud message queuing service, using a pair of queues. One queue is public, where the service provider listens for request messages which can be sent by any consumer. The second queue ...
Introduction On many BizTalk projects you have to deal with managing mapping of reference data. A number of times in the past I've spoken about the features in BizTalk for mapping reference data however they do have some limitations which mean that it is very common for a project to implement their own tables in a custom database to hold mapping reference data. While this is entirely valid you often end up with the pain of how do you manage the reference data mappings. One of the simplest ways is ...
Recently when creating a new BizTalk 2009 Orchestration I encountered a build error that I have not previously encountered. The Orchestration build error given was: Preprocessor directive must appear as the first token on a line After a small amount of investigation I discovered that the cause of this error was the Filter Expression that I had applied to the receive shape in my Orchestration. I had put: BTS.MessageType == http://targetnamespace#root... This should have been: BTS.MessageType == "http://targetnamespace#roo... ...
I’m going to toot my own horn here for a bit, highlighting some accomplishments from the last almost-decade I’ve been in the IT industry: Stayed up almost 48 hours straight creating suite of Crystal Reports for a start-up company’s initial product (which launched at the end of that 48 hour period btw). Wrote my own markup language for declaring formatting within an XSL:FO doc that would be translated through a Java app to output a PDF. Introduced initial prototype of web-based application ported ...
An interesting ‘rant’ by my fellow Solidsoft buddy Russell Smith: Thought you chaps would be interested in this after hearing my rantings yesterday about the WCF-SQL adapter and notification issues. I got to the bottom of the issue, it wasn’t the adapter in the end it was the database and not the adapter at all. This was a database supplied by PICT that was restored onto my image. Apparently in order for the notification mechanism to work there are some strict requirements on the database SET options ...
We at Tellago, Inc. had recently open sourced first version of BizTalk Data Services by Jesus Rodriguez and ESB ToolKit 2.0 Extensions by Dwight Goins on Codeplex. The BizTalk Data Services was more about based on Querying, Browsing for BizTalk Artifacts via RESTful interface. Today we have a new release for the BizTalk Data Services which is an extension of the earlier release. The new release v0.6 contains: · IUpdatable · Enabling and Disabling Receive Locations · Starting and Stopping Send Ports ...
Two posts on one day? Is he on his holidays? Yes! We had a lot of trouble with this error: ...Error Description: System.ServiceModel.Communi... An error (The request was aborted: The request was canceled.) occurred while transmitting data over the HTTP channel.... You find a few posts about it in the www but the answers are somewhat conflicting and not very nice. No, I will not tell you the answer in this post, because we still do not really have it, but I want to show you how to perform ...
You created classes from your XML-Schemas (using XSD.exe for example) and want to use them in BizTalk. There may be several reasons for and against doing it. But I do not want to discuss that here. Just assume you want to do it. ;-) After you deployed your BizTalk App and start sending the first messages to your ReceiveLocation with an XML Receive Pipeline of a MessageType that a schema and a class exist for. BizTalk is not able to decide whether class or schema should be used and gives you a nice ...
Let’s develop a SharePoint WebPart for executing BAM SSIS Packages. The SharePoint site can be on remote server other than the BizTalk Database Server. This won’t be a fancy UI WebPart, just a basic dropdown to select a BAM SSIS Package and execute it. ;-) The approach I am used is of using a asp.net User Control hosted as a sharepoint webpart. There are bunch of different ways you can develop Sharepoint webpart. This is just one of them and easier one. Less error prone and easily debug able. · Create ...
The BizTalk Scheduled Task Adapter is an in process receive adapter that can be implemented on a receive location to execute a prescribed task on a daily, weekly or monthly schedule. I have previously talked about the installation of the Scheduled Task Adapter with BizTalk Server 2009, detailed below are details of how this adapter can be configured on a receive port. Within the BizTalk Administration console, right click and add a new one way receive location. Select the receive port that your receive ...
The BizTalk Scheduled Task Adapter is an in process receive adapter that can be configured to execute a prescribed task on a daily, weekly or monthly schedule. "The adapter is configured entirely within Biztalk, all config is stored within the SSODB and can be exported and imported via binding files. The schedule capabilities are similar to those available with the Windows Scheduled Task Service." Although defined on codeplex as an adapter for BizTalk Server 2004 or BizTalk Server 2006, the Scheduled ...
I have recently been having discussions with some of the guys from our Ops Team about the GAC and BizTalk. One of the things they had observed was that when we upgraded some of our BizTalk applications using the technique where you are able to drain the system and fully remove then replace the application the uninstallation and reinstallation process left the assemblies from the previous version in the GAC. I explained the relationship between the management database in BizTalk and the storage of ...
I was recently working on a BizTalk 2004 project where I encountered an issue with capturing exceptions (inside my orchestration) occurring from an external source. Like database server down, non-existing stored procedure, … I thought I might write-up this in case it might help someone … To reproduce an issue, I just rename the database to something different. The orchestration was failing at the point where I make a SQL request via a Response-Request Port. The exception handlers were bypassed but ...
Background While the xpath function in a BizTalk orchestration is a very powerful feature I have often come across the situation where someone has hard coded an xpath expression in an orchestration. If you have read some of my previous posts about testing I've tried to get across the general theme like test-driven or test-assisted development approaches where the underlying principle is that your building up your solution of small well tested units that are put together and the resulting solution ...
As previsouly noted in my post on Schema Generation using the Community ODBC Adapter, I ran into a problem when trying to generate a schema to represent a MySQL stored procedure that had input parameters. After a bit of investigation and a few deadends I managed to figure out a way around this issue - detailed below are both the problem and solution in case you ever run into this yourself. The Problem Imagine a stored procedure that is coded as follows in MySQL: StuTest(in DStr varchar(80)) BEGIN ...
I have previously talked about the installation of the Community ODBC adapter and also using the ODBC adapter to generate schemas and laterly the creation of a receive port using the ODBC Adapter. But what about creating a send port? Select to add a new Send Port, select the ODBC Adapter and click configure. Clicking Connection string will open the DataSource window. Choose one of your system datasources and press OK. This will now update the Transport properties. Select okay. All that remains is ...
I have previously talked about the installation of the Community ODBC adapter and also using the ODBC adapter to generate schemas. But what about creating a receive location? An ODBC receive location will periodically poll the configured database using the stored procedure or SQL string defined in your request schema. If you need to, begin by adding a new receive port to your BizTalk configuration. Create a new receive location and select to use the ODBC adapter and click Address. You will now be ...
Having previously detailed the installation of the Community ODBC Adapter for BizTalk 2009, the next thing I will be looking at is the generation of schemas using this ODBC adapter. Within your BizTalk 2009 project, right click the project and select Add Generated Items. In the resultant window choose Add Adapter Metadata and click Add to open the Add Adapter Wizard. Check that the BizTalk Server and Database names are correct, select the ODBC adapter and click next. You must now set the connection ...
I have previsouly detailed the installation of MySQL, the configuration of MySQL and the installation of the ODBC Data Connector for MySQL. The reason I needed to install and configure these servers was to provide a test environment for a BizTalk Server 2009 solution I am working on where BizTalk will be querying and populating a MySQL database. To do this I then needed to install and add the Community ODBC adapter from Two Connect: "The Community BizTalk Adapter for ODBC is based on the code that ...
Having previsouly installed and then configured MySQL, you may now need to install the ODBC Data Connector driver in order to connect to your MySQL database. Following the Splash screen the first thing to choose is the Setup Type for your installation. As usual I chose custom so that I could see the components that were actually being installed. In this case the custom set up screen allows you to choose to install the driver and the documentation. Finally you can complete the installation Assuming ...
If you’re developing BizTalk 2009 solutions (Orchestrations) and you’ve split your schemas out into alternative assemblies (projects) – sometimes you’ll get odd not found issues with some (if not all) of the types in those referenced assemblies. You can try everything – recompile, de-gac, re-gac, – doesn’t matter. Well there’s a hotfix for this: http://support.microsoft.co... FIX: You experience various problems when you develop a BizTalk project that references another BizTalk project ...
When mapping in BizTalk you will find there are times when you need to map from flat and dispersed elemements in your source schema to a repeated record with child elements in your destination schema. Below is an example of how you can make use of the Table Looping Functoid to bring together these flat elements and create your repeated group. Although this example is purposely simple, I have previsouly encounted this issue on a much more complex scale when mapping the response from a credit scoring ...