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.

FIX: Element orders in the schema generated by WCF-SQL adapter differ between SQL Server 2012 and SQL Server 2014


View products that this article applies to.

Symptoms

Consider the following scenario:
  • You create a table on both Microsoft SQL Server 2012 and Microsoft SQL Server 2014.
  • You create a Microsoft BizTalk Sever 2013 R2 project and use the Consume Adapter Service Add-in to generate a schema, for example, the Select operation for the table.
In this scenario,  the element order in generated schema with SQL Server 2012 is different from the one with SQL Server 2014.

↑ Back to the top


Cause

The issue occurs because the column order returned by the query that is executed by WCF-SQL adapter cannot be guaranteed without using order by. Additionally, When you generate a schema, the implementation between SQL Server 2014 and SQL Server 2012 is changed. And the compatibility was compromised between the two versions SQL Server.

↑ Back to the top


Resolution

Cumulative update information

This issue was first fixed in the following cumulative update of BizTalk Server:

↑ 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


References

For information about the service packs and cumulative update list for BizTalk Server, see KB 2555976: Service pack and cumulative update list for BizTalk Server .

For more information about BizTalk Server hotfixes, see KB 2003907: Information about BizTalk hotfixes and Service Pack support .

↑ Back to the top


Keywords: kb, kbqfe, kbsurveynew, kbexpertiseadvanced, kbfix, kbbts

↑ Back to the top

Article Info
Article ID : 3067999
Revision : 1
Created on : 1/7/2017
Published on : 4/13/2016
Exists online : False
Views : 443