Microsoft KB Archive Search

Notice: This website is an unofficial Microsoft Knowledge Base (hereinafter KB) archive and is intended to provide a reliable access to deleted content from Microsoft KB. All KB articles are owned by Microsoft Corporation. Read full disclaimer for more details.

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

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

View products that this article applies to.

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

↑ Back to the top

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.

↑ Back to the top

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

↑ Back to the top

Status

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

↑ Back to the top

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

↑ Back to the top

Keywords: kbqfe, kbfix, kbexpertiseadvanced, kbsurveynew, kb

↑ Back to the top

Article Info
Article ID : 2555519
Revision : 2
Created on : 9/10/2018
Published on : 9/11/2018
Exists online : False
Views : 410