Cumulative update package 2 for BizTalk Server 2009 fails if a BizTalk group uses a database that uses a case-sensitive collation

Symptoms

Consider the following scenario:
  • You configure a BizTalk group to use a database on a computer that is running Microsoft BizTalk Server 2009. The database uses a case-sensitive collation.

    For example, the database uses the Latin1_General_100_CS_AI collation.
  • You try to apply cumulative update package 2 for BizTalk Server 2009.
In this scenario, the installation fails.

For more information about cumulative update package 2 for BizTalk Server 2009, click the following article number to view the article in the Microsoft Knowledge Base:
2497794  Cumulative update package 2 for BizTalk Server 2009

Cause

This issue occurs because of an error in the Bts_tracking_logic.sql file that is included in cumulative update package 2. 

The Bts_tracking_logic.sql file creates a temporary table that has the name of #Permission. However, the Bts_tracking_logic.sql file refers the table as #permission when the script tries to delete the table.

Resolution

Cumulative update information

The hotfix that resolves this issue is included in cumulative update package 3 for BizTalk Server 2009.

For more information about how to obtain the cumulative update package, click the following article number to view the article in the Microsoft Knowledge Base:
2557149 Cumulative update package 3 for BizTalk 2009

Status

Microsoft has confirmed that this is a problem in the Microsoft products that are listed in the "Applies to" section.

More Information

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

2003907 Information about BizTalk Server hotfixes

Properties

Article ID: 2555519 - Last Review: Jul 29, 2011 - Revision: 1

Feedback