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
