Msg 104381 when running INSERT...SELECT statement in Analytics Platform System 2016 or later

Applies to: Microsoft Analytics Platform System

Symptoms


When you run an INSERT ... SELECT statement in Microsoft Analytics Platform System (APS) 2016 or a later version of APS and that statement includes an ORDER BY clause, you receive an error message that resembles the following:

 

Cause


This issue occurs because sort operations aren't valid with the INSERT ... SELECT statement. This is by design.

Resolution


To fix this problem, remove the ORDER BY clause from the statement.

More Information


In earlier versions of APS, no error may have been returned. However, the ORDER BY clause was not honored.