Symptoms
Consider the following scenario:
-
You create a clustered columnstore index on a partitioned table.
-
The maximum length of the columns in the table is greater than the 8,060-byte row limit for tables if there are variable length columns.
-
You use the BULK INSERT or INSERT SELECT statement to insert data into the clustered columnstore index.
In this scenario, you receive an error message that resembles the following:
Message 611, Level 16, State 0
Cannot insert or update a row because total variable column size, including overhead, is 1978 bytes more than the limit.
Resolution
This issue is fixed in the following cumulative updates for SQL Server:
Cumulative Update 2 for SQL Server 2017
Cumulative Update 8 for SQL Server 2014 Service Pack 2
Each new cumulative update for SQL Server contains all the hotfixes and security fixes that were in the previous build. Check out the latest cumulative updates for SQL Server:
Latest cumulative update for SQL Server 2017
latest cumulative updates for SQL Server 2014.
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 Microsoft uses to describe software updates.