FIX: "Cannot bulk load" error when you run a query that contains an UPDATE statement in SQL Server 2016

Applies to: SQL Server 2016 DeveloperSQL Server 2016 EnterpriseSQL Server 2016 Enterprise Core More

Symptoms


When you run a query that contains an UPDATE statement in Microsoft SQL Server 2016, you may receive an error message that resembles the following:
Msg 4819, Level 16, State 1
Cannot bulk load. The bulk data stream was incorrectly specified as sorted or the data violates a uniqueness constraint imposed by the target table. Sort order incorrect for the following two rows: primary key of first row: <row_id>, primary key of second row: <row_id>.

Resolution


This problem was fixed in the following cumulative updates for SQL Server:

Status


Microsoft has confirmed that this is a problem in the Microsoft products that are listed in the "Applies to" section.

References


Learn about the terminology  that Microsoft uses to describe software updates.