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.


Symptoms

When the custoemer sets up any queries by location on location directives an error is thrown : "The specified sequence of Group By and Order By fields is not supported" and the sort does not save when attempting to add a sort to a location directive.

↑ Back to the top


Resolution

This hotfix resolves the issue by changing the join mode from ExistsJoin to InnerJoin.

↑ Back to the top


More information

Note This is a "FAST PUBLISH" article created directly from within the Microsoft support organization. The information contained here in is provided as-is in response to emerging issues. As a result of the speed in making it available, the materials may include typographical errors and may be revised at any time without notice. See Terms of Use for other considerations.

↑ Back to the top


Article Info
Article ID : 4039265
Revision : 1
Created on : 8/10/2017
Published on : 8/10/2017
Exists online : False
Views : 172