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

Article translations Article translations
Article ID: 2555519 - View products that this article applies to.
Expand all | Collapse all

On This Page

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: July 29, 2011 - Revision: 1.0
APPLIES TO
  • Microsoft BizTalk Server 2009 Branch
  • Microsoft BizTalk Server 2009 Developer
  • Microsoft BizTalk Server 2009 Enterprise
  • Microsoft BizTalk Server 2009 Standard
Keywords: 
kbqfe kbfix kbexpertiseadvanced kbsurveynew KB2555519

Give Feedback

 

Contact us for more help

Contact us for more help
Connect with Answer Desk for expert help.
Get more support from smallbusiness.support.microsoft.com