Symptoms
As the size of the database grows, you notice that the element orders in schemas that are generated and used in runtime by the WCF-SQL adapter are random.
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 updates for BizTalk Server:
-
Cumulative Update 1 for BizTalk Server 2020
-
Cumulative Update 8 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