All posts by : Robert Rijsdijks BizTalk Server Weblogs

1 of 36 | BizTalk Server 2006 RTM Now Available on MSDN - Very good news !!! BizTalk Server 2006 is now available for download on the MSDN Subscribers Download site!     Also available are the SWIFT, RosettaNet, HL7, and HIPPA Accelerators as well as the Enterprise Application Adapters.     ...

2 of 36 | Nice list of BizTalk 2004 FAQ - Check here...

3 of 36 | BizTalk 2006 Launch yesterday and new packaging announced - Yesterday was a big day for Microsoft and ofcourse also for us developers. Im happy with the next release of Microsoft BizTalk Server. Microsoft announced yesterday that BizTalk Server 2006 packaging has undergone some significant changes, namely all adapters in the box, and inclusion of functionality previous found in Host Integration Server 2004 Enterprise edition. The news about adapters is very significant for our customers. All of the new adapters we`ve purchased from iWay will be included in the box with ALL editions of BizTalk Server, and, require no additional licensing. Also, the SAP adapter will now also be included in the packaging! While we are discontinuing Host Integration S......

4 of 36 | BizTalk 2006 Beta 1 First impressions Part 4 Mapper Improvements - I wanted to test the new Mapper of BTS2006 and I saw that they added some new functoids (IsNil (Logical), Nil Value (Advanced) and Assert (Advanced)). Today I saw a post from Stephen W. Thomas about his experiences with the new Mapper. Read his blog here  ...

5 of 36 | BizTalk 2006 Beta 1 First impressions Part 3 Workaround Group Hub Query - Yesterday I received an email from Microsoft with a workaround of issue (bug) I mentioned earlier , see  here. Indeed the error is a bug in Beta 1 and will be fixed in Beta 2. For a workaround follow the following instructions : ...

6 of 36 | BizTalk 2006 Beta 1 First impression part 2 (BAM Portal) - Today I dived in the new BAM Portal of BTS2006 Beta 1 and had it up and running BAM in about 1 hour. First of all I Migrate a simple project EAISolution (from the Labs of BTS2004 maybe u know it) and I had a BAM xls SalesManagerView.xls copied to my project directory. The migration from VSS2003 to VSS2005 went perfectly. I filled in a new application EAISolution and deployed it. After the deployment of the orchestration and the EAISchemas I started up my new Application. So far so good.  Alse a new feature is the Zoom function This orchestration I zoomed out for 50%.  Now the Business Activity Monitoring was ahead. The first thing I did was search for the BAM.xls as in BTS2004. I couldn`......

7 of 36 | BizTalk 2006 Beta 1 bug First impression part 1 - This week I have time to look at the new version of BizTalk and I participate with the BizTalk 2006 Beta program. Im really impressed to see how this Beta 1 version is rolled out. I`ve got some problems to install Windows Sharepoint Services , but when u follow the Install Instructions it will be solved. The only thing I saw was a Query Error in the BizTalk Administration Console so far. When I do a refresh on the BizTalk Group I see the following error : I run Microsoft SQL Server 2000 with SP4. Anyone have an idea Of course I submit this issue to Microsoft. Hope they will come with an answer very soon. ...

8 of 36 | BizTalk 2006 - BTSTask - BizTalk 2006 comes with a new handy tool called BTSTask. For more information about this new tool read here : http://blogs.conchango.com/matthall/archive/2005/08/02/1908.aspx Its the new version of the BTSDeploy.exe of BizTalk 2004 with much more new features like import export MSI files.  ...

9 of 36 | BizTalk Server New Adapters - Microsoft is providing eight new application adapters forBizTalk Server that it has acquired from iWay software early in 2006. The adapters in question are: Oracle Db Oracle Apps SAP PeopleSoft Siebel TIBCO Rendezvous TIMCO JMS Clarify Scott Woodgate has made a brief comment on this announcement....

10 of 36 | BizTalk Server 2006 Beta Program -  Biztalk 2006 Beta is now available for public sign up.   Biztalk Server 2006 greatly simplifies the administration and deployment process.  Some of the other key enhancements are the flat file schema wizard, calling pipeline from an Orchestration, improved BAM, and suspended message routing, just to name a few.  To sign up for the beta program follow these easy steps:  1.  Go to http://beta.microsoft.com  2.  Sign in with your passport  3.  At the top of the page it should say something like “if you have a Guest Id click here”.   4.  Enter: BizTalkBetaTeam (case sensitive) as your guest id.  5.  Fill out the survey.  I think the link is located on the left side of the screen.  Make s......

11 of 36 | Chapter 10 Improving Web Services Performance (Patterns and Practices) New - Once you`ve got your SOA all sorted - IIS can run out of available connections pretty quick due to things like Web Services calling other WebServices on the same box using up valuable connections. Here`s a great MSDN Article that gives you the tech. details so your WebServices will hum. http://msdn.microsoft.com/library/default.aspurl=/library/en-us/dnpag/html/scalenetchapt10.asp...

12 of 36 | SQL Adapter Wizard Query twice - When u want to receive XML data from your stored procedure which containts a SELECT and UPDATE (processed records) statement, you can have some problems to Generate the SQL Adapter XSD. When u press the last Window in the Wizard you could get an error message Failed to execute queury. What we saw in the SQL Profiler is that the Generate SQL Adapter Wizard Executes twice the stored procedure Oops. The first one from Application name SQLClient provider and the second one from Visual Studio .NET 2003. The first query execute returns the XMLDATA (XML Schema) , but also the stored procedure update. The second run executes the stored procedure once again without your XMLData schema. So disabl......

13 of 36 | Chapter 10 Improving Web Services Performance (Patterns and Practices) New - Once you`ve got your SOA all sorted - IIS can run out of available connections pretty quick due to things like Web Services calling other WebServices on the same box using up valuable connections. Here`s a great MSDN Article that gives you the tech. details so your WebServices will hum. http://msdn.microsoft.com/library/default.aspurl=/library/en-us/dnpag/html/scalenetchapt10.asp...

14 of 36 | SQL Adapter Wizard Query twice - When u want to receive XML data from your stored procedure which containts a SELECT and UPDATE (processed records) statement, you can have some problems to Generate the SQL Adapter XSD. When u press the last Window in the Wizard you could get an error message Failed to execute queury. What we saw in the SQL Profiler is that the Generate SQL Adapter Wizard Executes twice the stored procedure Oops. The first one from Application name SQLClient provider and the second one from Visual Studio .NET 2003. The first query execute returns the XMLDATA (XML Schema) , but also the stored procedure update. The second run executes the stored procedure once again without your XMLData schema. So disabl......

15 of 36 | BizTalk Server 2004 and SQL Server 2000 SP4 - I found a post on the BizTalk Discussion Groups about SQL Server 2000 SP4 in combination with BizTalk Server 2004 Here his post : Installed SQL Server 2000 SP4 on two development servers over the weekend with no problems and on two production server on Monday with only slight problems during the Analysis Server SP4 installation. The problem (bug) has been reported to MS and they`re issuing a KB article. It`s related to the MDAC update on servers running MOM2005. ...

16 of 36 | DBNETLIB Errors (Network Errors) after adding Multiple Publication MessageBoxes BizTalk Server 2004 SP1 / Microsoft SQL Server 2000 SP3 - At one of our customers we installed a complete new BizTalk infrastructure to improve the performance (throughput). The following machines are involved:  1 x SQL Server dedicated to master message box processing wit publication disabled, single default instance.       Software      Microsoft SQL Server 2000 with SP3a and BizTalk SQL Hotfix SQL2000-KB810185-8.00.0878-ENU.exe      Microsoft Windows Server 2003 SP1      Database Instance BizTalkMsgBoxDb  2 x SQL Servers dedicated to message box publication, each 1 named instance.       Software      2 x Microsoft SQL Server 2000 with SP3a and BizTalk SQL Hotfix SQL2000-KB810185-8.00.0878-NU.exe      Microsoft Windows Server 2003 SP1      Data......

17 of 36 | BizTalk Server 2004 and SQL Server 2000 SP4 - I found a post on the BizTalk Discussion Groups about SQL Server 2000 SP4 in combination with BizTalk Server 2004 Here his post : Installed SQL Server 2000 SP4 on two development servers over the weekend with no problems and on two production server on Monday with only slight problems during the Analysis Server SP4 installation. The problem (bug) has been reported to MS and they`re issuing a KB article. It`s related to the MDAC update on servers running MOM2005. ...

18 of 36 | DBNETLIB Errors (Network Errors) after adding Multiple Publication MessageBoxes BizTalk Server 2004 SP1 / Microsoft SQL Server 2000 SP3 - At one of our customers we installed a complete new BizTalk infrastructure to improve the performance (throughput). The following machines are involved:  1 x SQL Server dedicated to master message box processing wit publication disabled, single default instance.       Software      Microsoft SQL Server 2000 with SP3a and BizTalk SQL Hotfix SQL2000-KB810185-8.00.0878-ENU.exe      Microsoft Windows Server 2003 SP1      Database Instance BizTalkMsgBoxDb  2 x SQL Servers dedicated to message box publication, each 1 named instance.       Software      2 x Microsoft SQL Server 2000 with SP3a and BizTalk SQL Hotfix SQL2000-KB810185-8.00.0878-NU.exe      Microsoft Windows Server 2003 SP1      Data......

19 of 36 | BizTalk Server 2004 Performance Characteristics now online MSDN - As you should know there is a BizTalk Server 2004 Performance Characteristics WhitePaper available. This whitepaper is now also available on MSDN : Check it out here....

20 of 36 | BizTalk Server 2004 Performance Characteristics now online MSDN - As you should know there is a BizTalk Server 2004 Performance Characteristics WhitePaper available. This whitepaper is now also available on MSDN : Check it out here....

21 of 36 | Another good initiative: BizTalk 2004 Performance Blog - After the BAM Online Lounge and some other good BizTalk blogs Wayne Clark started up a real nice performance blog. I definitly ask Wayne some questions :)). At one of our customers we had “big” performance issues. Some of them were fixed by SP1 but I wanne learn more about the inside of BTS2004 :)). Via Scotts blog....

22 of 36 | Another good initiative: BizTalk 2004 Performance Blog - After the BAM Online Lounge and some other good BizTalk blogs Wayne Clark started up a real nice performance blog. I definitly ask Wayne some questions :)). At one of our customers we had “big” performance issues. Some of them were fixed by SP1 but I wanne learn more about the inside of BTS2004 :)). Via Scotts blog....

23 of 36 | A complete list of all the MSDN BizTalk 2004 Web Casts untill now... - When you have nothing to do or time left , and want to know something more about BizTalk 2004 check out one of below 17 Microsoft Web casts. This is a list of the MSDN web casts Im aware of :)). Have fun....  MSDN Webcast: Extending Mainframe Applications using BizTalk Server 2004 and Host Integration 2004May 24, 2004Paul Larsen, GROUP PROGRAM MANAGER, MicrosoftThis webcast demonstrates how to integrate your existing IBM mainframe assets with new enterprise solutions based on BizTalk® Server using Host Integration Server 2004. HIS provides the key enabling technologies you need to extend your IBM network, security, messaging, data and application systems running on these IBM host computers.......

24 of 36 | A complete list of all the MSDN BizTalk 2004 Web Casts untill now... - When you have nothing to do or time left , and want to know something more about BizTalk 2004 check out one of below 17 Microsoft Web casts. This is a list of the MSDN web casts Im aware of :)). Have fun....  MSDN Webcast: Extending Mainframe Applications using BizTalk Server 2004 and Host Integration 2004May 24, 2004Paul Larsen, GROUP PROGRAM MANAGER, MicrosoftThis webcast demonstrates how to integrate your existing IBM mainframe assets with new enterprise solutions based on BizTalk® Server using Host Integration Server 2004. HIS provides the key enabling technologies you need to extend your IBM network, security, messaging, data and application systems running on these IBM host computers.......

25 of 36 | Post SP1 Hotfix BTS2004 - When u have problems with your BizTalk solution and u use BizTalk Mappings in combination with DBLookUp values and you see strange values in your output XML messages , contact Microsoft for Hotfix 888309. You can`t find this one in the Microsoft Article database. Also this Hotfix is not part of SP1. This is the short description : DB lookup functoid intermittantly returns cached values...

26 of 36 | Post SP1 Hotfix BTS2004 - When u have problems with your BizTalk solution and u use BizTalk Mappings in combination with DBLookUp values and you see strange values in your output XML messages , contact Microsoft for Hotfix 888309. You can`t find this one in the Microsoft Article database. Also this Hotfix is not part of SP1. This is the short description : DB lookup functoid intermittantly returns cached values...

27 of 36 | Some MSMQ properties doesn`t work - I was playing around with the new MSMQ Adapter for BizTalk Server 2004 and saw a strange thing. I want to use a property MSMQ.SourceMachine, its handy when u want to drop a response massage on the same machine. What I saw in the Message Context that this property wasn`t there. Strange Anyone got a idea ...

28 of 36 | Some MSMQ properties doesn`t work - I was playing around with the new MSMQ Adapter for BizTalk Server 2004 and saw a strange thing. I want to use a property MSMQ.SourceMachine, its handy when u want to drop a response massage on the same machine. What I saw in the Message Context that this property wasn`t there. Strange Anyone got a idea ...

29 of 36 | Bug in Setup BizTalk Server 2004 Adapter for MSMQ v2.0 - At one of my customers I use the new BizTalk 2004 MSMQ Adapter. I read this Adapter is much beter in performance then the Out-of-the-Box MSMQT Adapter therefor I want to use this new Adapter. You can download the Adapter here After the installation of the Adapter I wanted to send messages to a Private MSMQ. I get the following error : The Messaging Engine failed to create the receive adapter "MSMQ".Reason: "File or assembly nameMicrosoft.Samples.BizTalk.Adapters.MSMQC.Runtime.dll, or one of itsdependencies, was not found.". Microsoft Comment : This is a bug, and here is the solution.(1) Open your Adm_Adapter table in BizTalkMgmtDB database that your Biztalk server is using.(2) Identify th......

30 of 36 | Bug in Setup BizTalk Server 2004 Adapter for MSMQ v2.0 - At one of my customers I use the new BizTalk 2004 MSMQ Adapter. I read this Adapter is much beter in performance then the Out-of-the-Box MSMQT Adapter therefor I want to use this new Adapter. You can download the Adapter here After the installation of the Adapter I wanted to send messages to a Private MSMQ. I get the following error : The Messaging Engine failed to create the receive adapter "MSMQ".Reason: "File or assembly nameMicrosoft.Samples.BizTalk.Adapters.MSMQC.Runtime.dll, or one of itsdependencies, was not found.". Microsoft Comment : This is a bug, and here is the solution.(1) Open your Adm_Adapter table in BizTalkMgmtDB database that your Biztalk server is using.(2) Identify th......

31 of 36 | Microsoft BizTalk Adapter for WSE 2.0 now Available. - We just released the WSE 2.0 adapter for BizTalk Server!  In my opinion this is an important milestone: webservices are increasingly fast becoming the number one interoperable transport both inside and between companies.  The need for security, trust and policy is crucial to further extend the wealth of scenario`s that webservices enable.  I find it an exciting idea to know that Web Services within your business processes now have become just a matter of configuration!  Get it here: http://www.microsoft.com/downloads/details.aspxFamilyId=BA643360-E9DC-4FC5-8D60-8E6C5ECA7861&displaylang=en...

32 of 36 | Microsoft BizTalk Adapter for WSE 2.0 now Available. - We just released the WSE 2.0 adapter for BizTalk Server!  In my opinion this is an important milestone: webservices are increasingly fast becoming the number one interoperable transport both inside and between companies.  The need for security, trust and policy is crucial to further extend the wealth of scenario`s that webservices enable.  I find it an exciting idea to know that Web Services within your business processes now have become just a matter of configuration!  Get it here: http://www.microsoft.com/downloads/details.aspxFamilyId=BA643360-E9DC-4FC5-8D60-8E6C5ECA7861&displaylang=en...

33 of 36 | Using SQLXML`s at-identity with BizTalk 2004 (UpdateGram) - Last year we tried to insert multiple parent-child tables with the SQL Adapter by Updategrams at one of our customers. But without results. Now Stephen Kaufman wrote a nice article about this to get it done. This reduces roundtrips in your BizTalk Server Business Processes and ofcourse Persistance Points. Read his article here...

34 of 36 | Using SQLXML`s at-identity with BizTalk 2004 (UpdateGram) - Last year we tried to insert multiple parent-child tables with the SQL Adapter by Updategrams at one of our customers. But without results. Now Stephen Kaufman wrote a nice article about this to get it done. This reduces roundtrips in your BizTalk Server Business Processes and ofcourse Persistance Points. Read his article here...

35 of 36 | BizTalk Server 2004 SP1 and Adapter Migration Toolkit Out Now !!! - Get it here.  I strongly recommend that everybody trys this in your test environments and then puts it into production.  Along with the usual bug fixes provided in service packs you can expect up to a 10% performance increase in some scenarios.  This is thoroughly recommended and has been well tested by our EAP customer (thanks). Along with Service Pack 1 we are also releasing the BizTalk Server 2004 Adapter Migration Toolkit. The adapter migration provides interfaces for BizTalk Server 2002 components and adapters such as AICs and Pre-processors. If you are migrating you will find this helpful. See Scott`s weblog for more information....

36 of 36 | BizTalk Server Future plans PathFinder BizTalk 2006 / LongHorn BizTalk 2007 - Computerworld has published an article describing some of the futures for BizTalk Server.   However, for an even better description of what is coming, go straight to the source - Woodgate`s blog entry from last December....