FIX: A dump file is generated when you run DBCC CHECKDB on a database that has tables with clustered columnstore index in SQL Server 2017

Gælder for: SQL Server 2017 Developer on WindowsSQL Server 2017 Enterprise on WindowsSQL Server 2017 Enterprise Core on Windows


Assume that you have a database that contains tables with clustered columnstore index in SQL Server 2017. When you run the statement DBCC CHECKDB WITH ALL_ERRORMSGS, NO_INFOMSGS, PHYSICAL_ONLY in the database, a dump file is generated and you may receive error messages that resemble the following:

Table error: Object ID ObjectID, index ID IndexID, partition ID PartitionID, alloc unit ID ID (type In-row data). The off-row data node at page (1:1749624), slot 1, text ID TextID is referenced by page (0:0), slot 0, but was not seen in the scan. 
CHECKDB found 0 allocation errors and 1 consistency errors in table 'TableName' (object ID ObjectID). 
CHECKDB found 0 allocation errors and 1 consistency errors in database 'DatabaseName'
repair_allow_data_loss is the minimum repair level for the errors found by DBCC CHECKDB (DatabaseName).


This issue is fixed in the following cumulative update for SQL Server:

       Cumulative Update 11 for SQL Server 2017


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


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