Biztalk 2010 Cumulative update 6 and BizTalk Adapter Pack cumulative update 3

On July 16th, the new CU (cumulative update) package for BizTalk 2010 became available . This CU contains lot of kb (see the list below)

For BizTalk 2010, you can download here : http://support.microsoft.com/kb/2855367/en-us

BizTalk Server EDI support

KB article number	Description
2777584	FIX: The value for the « maxOccurs » attribute is invalid when you validate the BizTalk X12 EDI 835 schema in a BizTalk EDI application in BizTalk Server 2010
2778133	FIX: Message is suspended when you try to receive an encrypted AS2 message together with asynchronous MDN in BizTalk Server 2010
2858166	FIX: « Too many data elements » error when you receive an EDI X12 997 message in BizTalk Server 2010

BizTalk Server Adapters

KB article number	Description
2811803	FIX: First submitted message takes longer to process than expected after periods of inactivity when you use a BizTalk Server 2010 WCF-Custom adapter
2855762	FIX: SQL connection leak when you use WCF-based SQL Adapter one-way send port to return a result set from a database in BizTalk Server 2010
2813294	FIX: 2-way WCF-BasicHttp receive port does not respond to a WCF client when the « failed message routing » feature is enabled in BizTalk Server 2010
2823757	FIX: The memory that a BizTalk host process consumes increases when there are no messages in the queue in BizTalk Server 2010
2804250	FIX: You cannot send files from an FTP server to BizTalk Server 2010 by using the FTP adapter when you specify a temporary folder as an absolute path
2742875	FIX: JDE and TibcoEMS adapter property assemblies contain no namespace and all properties are missing in BizTalk Server 2010

BizTalk Server Design Tools

KB article number	Description
2818904	FIX: NullReferenceException exception when you use the « BizTalk WCF Service Publishing Wizard » to publish schemas as WCF services

BizTalk Server Message Runtime, Pipelines, and Tracking

KB article number	Description
2792865	FIX: A send port that subscribes to an ErrorReport namespace context property cannot deliver an output message in BizTalk Server 2010
2802453	FIX: Pipeline on receive locations reverts to pass-through after you update the schema assembly in BizTalk Server 2010
2836801	FIX: « The transaction has already been implicitly or explicitly » error message when you deploy a large tracking profile in BizTalk Server 2010
2689953	FIX: XML declaration is removed at a receive location that uses BAM tracking and the PassThruReceive pipeline in BizTalk Server 2010

BizTalk Server Administration Tools and Management APIs

KB article number	Description
2728652	FIX: The tracking settings of PassThruTransmit and PassThruReceive pipelines are unexpectedly discarded when you remove a BizTalk application in BizTalk Server 2010
2749592	FIX: Slow performance when System Center Operations Manager monitors a computer in BizTalk Server 2010

BizTalk Server Orchestration engine

KB article number	Description
2835689	FIX: « The InnerText property is write only » error message when you use System.Xml.XmlDocument in BizTalk Server 2010

For BizTalk Adapter pack, you can download here : http://support.microsoft.com/kb/2617150

VSTS bug number	KB article number	description
1249726	2845542	FIX: Package variables trigger operations fail when you use BizTalk Adapter for Oracle Database to connect to Oracle Database
1249588	2845538	FIX: « Column ‘PROVIDERTYPE’ does not belong to table SchemaTable » exception when you use BizTalk Adapter for Oracle Database to connect to an Oracle database
1266767	2845536	FIX: Messages become stuck in SM58 when you use a WCF-based SAP Adapter in BizTalk Server 2010
1243883	2836739	FIX: WCF-SAP adapter receive location freezes under heavy load when it works as a tRFC server
1158982	2800376	FIX: WCF-based SQL Adapter stops polling data when daylight saving time ends
1152657	2795080	FIX: SQL Server connections are not released when invalid messages are passed by the WCF-SQL adapter
1055658	2761439	FIX: Configured time-out value for adapter binding properties does not work when a WCF workflow application uses an adapter to connect an LOB Server instance
1031951	2746855	FIX: Database connection leak when you use Microsoft BizTalk Adapter for Oracle Database to receive messages from an Oracle database in BizTalk Server 2010

Performance issue in Development plateform : one solution clean your BizTalk DB

My dev machine works so slowly, so I decided to clean it. I found a guide to perform it.

But don’t do it on production plateform, it won’t be supported

Here are few steps to clean up BizTalk Message Box Database.

1. There is a Stored Proc bts_CleanupMsgbox in BizTalkMsgBoxDb Database. By default this stored proc does nothing. It’s Dummy. This is to prevent accidental execution in the Production Server.

2. Execute a script to recreate bts_CleanupMsgbox. Script can be found at <BizTalk Dir>\Schema\msgbox_cleanup_logic.sql. This script should be executed in BizTalkMsgBoxDb Database.

3. Stop BizTalk services from the Services (Start -> Run -> Services.msc).

4. Reset IIS server incase if you have any running isolated host instances

5. Execute stored procedure bts_CleanupMsgbox on your message box database

This SP will take an input parameter @fLeaveActSubs.
Values for this should be ’0′ or ’1′. ’1′ is the default incase if you dont supply a value.

Setting the value to ’0′ results in clearing the active subscriptions and you may have to redeploy the application. Think twice before doing this.

6. The above will not clear off all the subscription but will mark for deletion . Execute the stored procedure bts_PurgeSubscriptions on your message box database to purge them all.

7. Start BizTalk services

To clean up the Tracking data in BizTalkDTADb Database

1. Stop BizTalk services from the Services (Start -> Run -> Services.msc).

2. Execute stored procedure dtasp_CleanHMData on BizTalkDTADb database.

3. Start the BizTalk services

source (http://masteringbiztalkserver.wordpress.com/tag/dtasp_cleanhmdata/)

BAM’s guide

Another great skill in BizTalk, the BAM.

This tool is very powerfull but never really used, and often misunderstood.

For helping, Technet did a great job with these series of article about BAM. You can get general informations or very technical ones.

I’ve got just one remark, there is no explanation for when implementing BAM or about the potential, my coleague Hugues Moore wrote an article about the BAM capabilities. In a futur article, I’ll write about how to use it in real condition.

For the moment here is the link I talked about

http://social.technet.microsoft.com/wiki/contents/articles/5599.aspx

Articles from Technet wiki about BizTalk 2010

The TechNet Wiki is a library of information about Microsoft technologies written by the community for the community. It’s a big useful article library where we can find lot information about all BizTalk part

here is some articles  found for BizTalk Server 2010 :

• Working with BizTalk AppFabric Connect
  • Installing the BizTalk Server 2010 AppFabric Connect feature
  • BizTalk + WF/WCF, Better Together
  • BizTalk Server 2010 AppFabric Connect feature Frequently Asked Questions (FAQ)
• Exposing LOB Services on the Cloud Using AppFabric Connect for Services
• Exposing BizTalk Applications on the Cloud using AppFabric Connect for Services
• Load Testing BizTalk Server Solutions with Visual Studio 2010
• Create a Load Test to Perform Multiple Unit Tests Simultaneously
• Install and Configure BAM (Business Activity Monitoring) in a Multi-Computer Environment
• Invoking ReSTful Web Services with BizTalk Server 2010
• How to use NServiceBus to do Broadcast Message Distribution with BizTalk Server RFID
• Querying and Creating Records in Dynamics CRM 2011 from BizTalk Server 2010
• BizTalk Server integration with SharePoint Server using WSS Adapter
• Typed Polling with WCF-SQL Adapter: Best Practices and Troubleshooting Tips 
• BizTalk Server 2010 Exam 70-595 Preparation
• BizTalk Databases: Survival Guide
• BizTalk Server 2010 Beginners Guide
• BizTalk Server 2010
• BizTalk Server Adapter Pack 2010
• BizTalk Server Documentation

Hopefully you find one of more article that are useful for you to learn about capabilities of BizTalk or new ways to integrate with BizTalk.

(source : http://soa-thoughts.blogspot.com/2011/10/biztalk-server-technet-wiki-articles.html)

Install and Configure BizTalk Adapter pack 2010

In BizTalk 2010, the adapter pack is not out of the box component, and you need to install them.

 

The BizTalk Adapter Pack 2010 provides connectivity to SAP, Oracle E-Business Suite, Siebel and SQL and Oracle Databases. The BizTalk Adapter Pack can be installed in conjunction with, or separately from, BizTalk Server.

BizTalk Poster

During Web surfing, I found an interesting page. Microsoft provide some BizTalk Poster for presentation.

Those are very usefull to present an architecture, or when I provide training, they permit to all trainee to locate which brick we’ve manipulate

Poster theme :

• BizTalk Server 2010 ESB Toolkit Architecture Poster
• BizTalk Server 2010 Capabilities Poster
• BizTalk Server 2010 Run-Time Architecture Poster
• BizTalk Server 2010 Scale-out Configurations Poster
• BizTalk Server 2010 Database Infrastructure Poster
• BizTalk Server 2010 BAM Poster
• BizTalk Adapter Pack 2010 Poster

http://msdn.microsoft.com/en-us/biztalk/dd807494.aspx

All poster are available for BizTalk 2009 too

Cumulative Update Package 2 for BizTalk Server 2010 and BizTalk Adapter Pack are available

Here is a greate update for BizTalk 2010 :

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

And another one for the adapter pack :

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

As you can read by following these links there is a great update and it’s important to updating our server

BizTalk MSDN virtual Labs

I’ve finally found the BizTalk 2010 lab’s

• MSDN Virtual Lab: BizTalk Server 2010: Examining a BizTalk Application
• MSDN Virtual Lab: BizTalk Server 2010: Creating a BizTalk Orchestration
• MSDN Virtual Lab: BizTalk Server 2010: Creating Transactional Business Processes
• MSDN Virtual Lab: BizTalk Server 2010: Monitoring Business Activity
• MSDN Virtual Lab: BizTalk Server 2010: Automating Business Processes
• MSDN Virtual Lab: BizTalk Server 2010: Calling a Web Service from an Orchestration
• MSDN Virtual Lab: BizTalk Server 2010: Creating a BizTalk Map
• MSDN Virtual Lab: BizTalk Server 2010: Creating and Configuring BizTalk Schemas
• MSDN Virtual Lab: BizTalk Server 2010: Creating Pipelines
• MSDN Virtual Lab: BizTalk Server 2010: Deploying and Managing BizTalk Applications
• MSDN Virtual Lab: BizTalk Server 2010: Integrating with Adapters
• MSDN Virtual Lab: BizTalk Server 2010: Routing BizTalk Messages

WCF custom vs WCF with IIS

In a previous blog entry, I wrote about exposing wcf port without IIS. But now when I use IIS and when I don’t use it ?

Actually, when I use IIS I’ve got a new technic layer and increase the resource used.

So what IIS bring more.As we can see with or without IIS doesn’t influence response time (click on the picture to zoom).

Usefull Visual studio Shortcut

I draw up a comprehensive visual studio shortcut list for BizTalk use :

Shortcut	Action
F2 on a variable	rename it
ctrl+K,R	Find all reference
ctrl+K,D	format document (very usefull when you open a map as XmlDocument)
ctrl+M,L	Roll Up/down text block
shift+del	delete line
alt+click	column edition mode
ctrl+K,S	surround with

Tell Me if you’ve got some interesting shortcut