lunedì 17 novembre 2014

WCF-SQL Adapter Hangs in Active State

Check the Ordered Delivery option. If it is on, the Send port instance will work as a Singleton application. It will be started by first message and lives forever.

giovedì 3 maggio 2012

Error while inserting NULL value to Oracle database table using BizTalk 2010

The scenario:
 Consume Adapter Service to generate the schema structure. The Schema elements have Nillable = True, Min Occurs =0. error:

When there is no value to a particular element, Microsoft.ServiceModel.Channels.Common.XmlReaderParsingException: The value for field "XXX ELEMENT" is invalid. or Microsoft.ServiceModel.Channels.Common.XmlReaderParsingException: The value for field "XXX ELEMENT" is invalid.System.ArgumentNullException: Value cannot be null. Parameter name: numStr

 environment is BizTalk Server 2010 with cu 4 and cu 2 for adapter!

  the solution: When make the map for instance the message , for each element NILLABLE add to map the functoid NIL VALUE (in advanced funtoids) and set the input parameter and the output parameter.









With this funtoid, the Oracle Database adapter interprets a null value in a record to mean that the column should be excluded from the Insert/update operation

Adapter Pack 2 Cumulative update

BizTalk Adapter Pack 2.0Cumulative Update


BizTalk Adapter Pack 2.0 CU5Version: 3.5.5326.0
Release date: January 20, 2012 


For more information, click the following article number to view the article in the Microsoft Knowledge Base:


2649848 Cumulative update package 5 for BizTalk Adapter Pack 2.0


BizTalk Adapter Pack 2.0 CU4Version: 3.5.5325.0
Release date: November 1, 2011


For more information, click the following article number to view the article in the Microsoft Knowledge Base:


2604327 Cumulative update package 4 for BizTalk Adapter Pack 2.0




BizTalk Adapter Pack 2.0 CU3Version: 3.5.5324.0
Release date: August 1, 2011


For more information, click the following article number to view the article in the Microsoft Knowledge Base:


2557150 Cumulative update package 3 for BizTalk Adapter Pack 2.0




BizTalk Adapter Pack 2.0 CU2


Version: 3.5.5320.0
Release date: April 30, 2011


For more information, click the following article number to view the article in the Microsoft Knowledge Base:


2531605 Cumulative update package 2 for BizTalk Adapter Pack 2.0


BizTalk Adapter Pack 2.0 CU1


Version: 3.5.5314.0
Release date: December 8, 2010


For more information, click the following article number to view the article in the Microsoft Knowledge Base:


2444952 Cumulative update package 1 for BizTalk Adapter Pack 2.0

Biztalk 2010 Cumulative Updates for Adapter

BizTalk Adapter Pack 2010

Cumulative Update

BizTalk Adapter Pack 2010 CU2
Version: 3.5.6537.0
Release date: August 31, 2011

For more information, click the following article number to view the article in the Microsoft Knowledge Base:

2572999 Cumulative update package 2 for BizTalk Adapter Pack 2010


BizTalk Adapter Pack 2010 CU1


Version: 3.5.6534.0
Release date: May 6, 2011

For more information, click the following article number to view the article in the Microsoft Knowledge Base:

2539794 Cumulative update package 1 for BizTalk Adapter Pack 2010

Biztalk 2006 updates & SP

BizTalk Server 2006 R2 

Cumulative Update

BizTalk Server 2006 R2 Service Pack 1 CU4

Version: 3.6.2237.12 
Release date: March 30, 2012

For more information, click the following article number to view the article in the Microsoft Knowledge Base: 

2682056 Cumulative update package 4 for BizTalk Server 2006 R2 Service Pack 1

BizTalk Server 2006 R2 Service Pack 1 CU3

Version: 3.6.2224.12
Release date: August 30, 2010

For more information, click the following article number to view the article in the Microsoft Knowledge Base: 

2286501 Cumulative update package 3 for BizTalk Server 2006 R2 Service Pack 1

BizTalk Server 2006 R2 Service Pack 1 CU2

Version: 3.6.2217.12
Release date: June 24, 2010

For more information, click the following article number to view the article in the Microsoft Knowledge Base: 

2211420 Cumulative update package 2 for BizTalk Server 2006 R2 Service Pack 1

BizTalk Server 2006 R2 Service Pack 1 CU1

Version: 3.6.2210.12
Release date: April 12, 2010

For more information, click the following article number to view the article in the Microsoft Knowledge Base: 

982061 Cumulative update package 1 for BizTalk Server 2006 R2 Service Pack 1

Service Pack

BizTalk Server 2006 R2 SP1 

Version: 3.6.2149.10
Release date: January 27, 2010

For more information about the hotfixes that are included in Microsoft BizTalk Server 2006 R2 Service Pack 1, click the following article number to view the article in the Microsoft Knowledge Base:

974563 List of Microsoft BizTalk Server hotfixes that are included in BizTalk Server 2006 R2 Service Pack 1

Biztalk 2009 all cumulative update

BizTalk Server 2009 

Cumulative Update

BizTalk Server 2009 CU6
Version: 3.8.477.2

Release date: April 27, 2012

For more information, click the following article number to view the article in the Microsoft Knowledge Base: 

2689457 Cumulative update package 6 for BizTalk Server 2009

BizTalk Server 2009 CU5
Version: 3.8.475.2

Release date: January 20, 2012

For more information, click the following article number to view the article in the Microsoft Knowledge Base: 

2649852 Cumulative update package 5 for BizTalk Server 2009

BizTalk Server 2009 CU4

Version: 3.8.473.2

Release date: November 1, 2011

For more information, click the following article number to view the article in the Microsoft Knowledge Base: 

2604321 Cumulative update package 4 for BizTalk Server 2009


BizTalk Server 2009 CU3

Version: 3.8.469.2

Release date: August 1, 2011

For more information, click the following article number to view the article in the Microsoft Knowledge Base: 

2557149Cumulative update package 3 for BizTalk Server 2009


BizTalk Server 2009 CU2

Version: 3.8.463.2

Release date: March 17, 2011

For more information, click the following article number to view the article in the Microsoft Knowledge Base: 

2497794 Cumulative update package 2 for BizTalk Server 2009

BizTalk Server 2009 CU1

Version: 3.8.454.2
Release date: December 8, 2010

For more information, click the following article number to view the article in the Microsoft Knowledge Base: 

2429050 Cumulative update package 1 for BizTalk Server 2009

Biztalk 2010 cumulative update 1

BizTalk Server 2010 CU1

Version: 3.9.522.2 
Release date: May 21, 2011

For more information, click the following article number to view the article in the Microsoft Knowledge Base: 

2497789 Cumulative update package 1 for BizTalk Server 2010