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. FIX: BizTalk setup fails on case-sensitive collations due to mismatched case 'nId' instead of 'nID' in BizTalkMgmtDb

FIX: BizTalk setup fails on case-sensitive collations due to mismatched case 'nId' instead of 'nID' in BizTalkMgmtDb

View products that this article applies to.

Symptoms

Assume that you install Microsoft BizTalk Server on an instance of BizTalkMgmtDb that is in case-sensitive collation. For example, Finnish_Swedish_CS_AS. In this scenario, the installation may fail because the mismatched case 'nId' is used instead of 'nID' in BizTalkMgmtDb. Additionally, you may receive the following error message:
"Server = xxxxxxx Database = BizTalkMgmtDb
Taking Backup of tables
Getting Id of Microsoft.BizTalk.GlobalPropertySchemas
SQL Exception occured. An error occured while adding Microsoft.BizTalk.GlobalPropertySchemas
Invalid column name 'nId'."

↑ 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

Resolution

This problem is fixed in the following cumulative update for BizTalk Server:

↑ Back to the top

References

For information about the service packs and cumulative update list for BizTalk Server, see the following article in the Microsoft Knowledge Base:

2555976 Service pack and cumulative update list for BizTalk Server

For more information about BizTalk Server hotfixes, see the following article in the Microsoft Knowledge Base:

2003097 Information about BizTalk hotfixes and Cumulative Update support

↑ Back to the top

Keywords: CI112098, kbHotfixAuto, kbqfe, kbfix, kb, BizTalk 2016 CU6 installation fails

↑ Back to the top

Article Info
Article ID : 4526031
Revision : 9
Created on : 1/22/2020
Published on : 1/22/2020
Exists online : False
Views : 184