Edmund Zhao's BizTalk abc

24 Posts | 20 Comments

Edmund Zhao's BizTalk abc We share, We learn

Sep 19

ArchitectureWhat is the “environment” The application environment consists in 3 main areas: Infrastructure Configuration Dependencies Infrastructure is the most important element of the environment, as it defines where the application will run, the specific configuration needs and how dependencies need to interact with the application. Configuration ......

Posted On Tuesday, September 3, 2019 9:35 AM

Sep 11

Temp table in strongly typed stored procedure not supported by WCF SQL adapter

Comments (4) | Share

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 ......

Posted On Sunday, September 4, 2011 6:36 PM

Aug 11

"Argument CompositeOperation is invalid" error

Comments | Share

Performing Composite Operations on Oracle Database is very similar to SQL Server Database. I just want to point out one mistake developers might easily make during the send port configuration. For any composite operation, the generated binding script doesn't include the composition operation tag in SOAP action header, therefore a new line needs to be ......

Posted On Friday, August 12, 2011 9:05 PM

Jul 11

Could not open certificate store. The system cannot find the file specified. (System)

Comments (1) | Share

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 ......

Posted On Monday, July 25, 2011 8:12 PM

Jun 11

Save password in WCF adapter binding file

Comments | Share

Binding file for WCF Adapter doesn't save the password no matter it is generated by "Add Generated Items..." wizard in Visual Studio or "Export Bindings..." in administration console. It is by design dut to the consideration of security, but it is very annoying especially when you import bindings which contain multiple WCF send ports. The way to aviod ......

Posted On Monday, June 27, 2011 10:06 PM

Jun 11

Microsoft.ServiceModel.Channels.Common.UnsupportedOperationException: The action was not understood

Comments | Share

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 ......

Posted On Sunday, June 12, 2011 1:03 PM

May 11

WCF adapter change causing BizTalk project build failure due to missing references

Comments (1) | Share

If you organize your BizTalk projects based on the type of artifacts, e.g., a solution contains schema project, pipeline project, map project, orchestration project, you might often encounter build failure problems due to the missing assembly reference. Sometime, even if you have the references properly added and you are able to verify them in object ......

Posted On Thursday, May 5, 2011 6:48 PM

Apr 11

How to add schema to a multiple schemas map without losing existing mapping info

Comments (1) | Share

I've been through a scenario where I had a very complicated multiple schemas map, the left(source) side of the map had two schemas and the right(destination) side had one, for some reason I decided to add one more schema to the left side. BizTalk map editor in 2006/2006 R2/2009/2010 doesn't allow creating multiple schemas map directly, neither does ......

Posted On Thursday, April 7, 2011 8:14 PM

Apr 07

Error "pipeline component load() method failed on IPersisPropertyBag implementation"

Comments (2) | Share

You might receive the "pipeline component load() method failed on IPersisPropertyBag implementation" error message when you try to drag and drop a custom pipeline component into a pipeline stage. The root cause of this issue can be various, but the most common reason for this kind of failure is because ArgumentException is not caught when you develop ......

Posted On Monday, April 2, 2007 3:53 PM

Mar 07

How to re-register BizTalk server in BAS site without application redeployment

Comments | Share

In multiple BizTalk server environment, it is pretty common to re-register another BizTalk server on BAS site, and the process could be tricky sometime if you don't want to undeploy anything from BizTalk solution. The following are the steps need to be performed, 1. Open BizTalk Explorer -> Role -> Sender - Delete all2. Go to TPM Management Tools ......

Posted On Friday, March 9, 2007 2:52 PM

Feb 07

Database is not compatible with the currently installed version of BizTalk Server

Comments | Share

I received a very unusual error message few days ago when I configured a secondary BizTalk Server to join an existing server group (BizTalk 2004). The error message said "The BAM Primary Import Database registered in the BizTalk Management database is not compatible with the currently installed version of BizTalk Server." It happened only when I added ......

Posted On Tuesday, February 13, 2007 10:56 AM

Oct 06

How to promote a secondary server to be master secret server

Comments | Share

Does master secret server always have to be clustered? My answer is practically it is not. The environment I'm working on has 8 BizTalk servers in each server group. Master secret server is on one of these BizTalk servers, not being clustered. The following is how to have the Biztalk server groups to be recovered in case any failure of the master secret ......

Posted On Tuesday, October 31, 2006 4:40 PM

Sep 06

How to clean up BizTalk Message Box

Comments (2) | Share

It is usually a very important task to clean up a BizTalk mseeage box during stress testing with large amount of messages. Below are the steps to clean up the message box in order to prepare for the new test. 1. Stop all BizTalk services 2. Type “iisreset” at command line to recycle IIS service 3. Execute the stored procedure “bts_CleanupMsgbox... ......

Posted On Monday, September 11, 2006 7:28 AM

Mar 06

Dynamic Send Port in BizTalk 2004

Comments (8) | Share

There are two types of dynamic ports in BizTalk 2004. They are Dynamic One-Way Port and Dynamic Solicit-Response Port. The following sample is based on Dynamic One-Way Port, using the other one will be very similar. 1. Create a new BizTalk project.2. Create a schema to the new project. 3. Promote “Destination” to be a distinguished field.4. ......

Posted On Monday, March 6, 2006 1:47 PM

Feb 06

Microsoft Exam 74-135 Developing E-Business Solutions Using Microsoft BizTalk Server 2004

Comments | Share

I passed the exam 74-135 yesterday. It was really tough, might be one of the most difficult exams provided by Microsoft. The reason I took this exam was because my company wanted to join BizTalk 2006 Jump Start program, and one of the requirements to participate the program was at least having a consultant passed 74-135. I spent almost a month to prepare ......

Posted On Wednesday, February 8, 2006 12:04 PM

Feb 06

Achieve BizTalk Server 2004 high availability by clustering SQL Server, Analysis Services and Enterprise Single Sign-On

Comments | Share

BizTalk Server 2004 is not cluster aware, therefore it is not recommended to install BizTalk 2004 on a MSCS based server cluster. However, to achieve high availability of you BizTalk solution, you can still take the following actions. (I assume you are installing BizTalk 2004, SQL Server 2000 on Windows Server 2003) 1. Setup an Active\Passive server ......

Posted On Wednesday, February 1, 2006 9:30 AM

Jan 06

BizTalk 2004 naming conventions

Comments (2) | Share

So far, the most complete document about BizTalk 2004 naming conventions is still in the MSDN article “Developing Integration Solutions with BizTalk Server 2004”. However, if you want to adopt these naming conventions, you need to be aware of the following issues in the document, Naming conventions for some BizTalk artifacts are not defined. ......

Posted On Friday, January 6, 2006 8:30 AM

How to separate map file from orchestration project when orchestration consumes web services

Comments | Share

One important pattern in BizTalk is to partitioning the solution especially when it is big. But some time it’s really difficult to move a file to another project or even just a different folder in same project. This happens most likely when there is an automatically generated file involved. In this example, an orchestration needs to consume a ......

Posted On Friday, January 6, 2006 9:01 AM

Dec 05

Out Of Memory issue when processing large messages in BizTalk

Comments | Share

A follow developer got “Out of memory” error on BizTalk server and he forwarded me the solution he build and the data he used to test. The solution is pretty straightforward. He needs process about 50 flat files at same time. In average, the file size is about 2MB. Each file contains 8 sections and each section has multiple items with same ......

Posted On Wednesday, December 21, 2005 2:00 PM

Dec 05

Internal SOAP Processing Failure - Testing web services generated by BizTalk Web Services Publishing Wizard

Comments (6) | Share

Lots of BizTalk developers were facing similar problems when they built their own .NET test applications to test the web services generated by BizTalk Web Services Publishing Wizard. The debugging process stopped at “this.Invoke()”, and usually there will be an error message of “Internal SOAP Processing Failure”. If you check ......

Posted On Wednesday, December 14, 2005 7:13 AM