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'."
Status
Microsoft has confirmed that this is a problem in the Microsoft products that are listed in the "Applies to" section.
Resolution
This problem is fixed in the following cumulative update for BizTalk Server:
-
Cumulative Update 7 for BizTalk Server 2016
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
