You are currently offline, waiting for your internet to reconnect

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: 07/29/2011 19:18:00 - Revision: 1.0

Microsoft BizTalk Server 2009 Branch, Microsoft BizTalk Server 2009 Developer, Microsoft BizTalk Server 2009 Enterprise, Microsoft BizTalk Server 2009 Standard

  • kbqfe kbfix kbexpertiseadvanced kbsurveynew KB2555519
Feedback
tml>.gif?DI=4050&did=1&t=">