FIX: DBCC CHECKFILEGROUP reports false inconsistency error 5283 on a database that contains a partitioned table in SQL Server


Consider the following scenario:
  • You have a database that contains a partitioned table in Microsoft SQL Server 2012,2014 or 2016. 
  • The table has a columnstore index, and the partitions of the table are mapped to different filegroups.
  • You run the DBCC CHECKFILEGROUP statement.
In this scenario, you receive the following false inconsistency error message:
Msg 5283, Level 16, State 1The Cross Rowset check on columnstore index object ID <object id>, index ID <index id>, partition ID <partition id>. Drop and recreate the columnstore index.

However, when you run the DBCC CHECKDB statement, you don't receive any consistency error messages. Additionally, running the DBCC CHECKDB statement together with the REPAIR_ALLOW_DATA_LOSS option doesn't fix the consistency errors. That's because the consistency error that's reported by DBCC CHECKFILEGROUP is a false positive and represents a reporting bug that can be ignored.


Cumulative Update information

The issue was fixed in the following cumulative update for SQL Server: Recommendation Install the latest cumulative update for SQL Server.

Each new cumulative update for SQL Server contains all the hotfixes and all the security fixes that were included with the previous cumulative update. We recommend that you download and install the latest cumulative updates for SQL Server:


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

Article ID: 3108537 - Last Review: 17 Jan 2017 - Revision: 3

Microsoft SQL Server 2016 Developer, Microsoft SQL Server 2016 Enterprise, Microsoft SQL Server 2016 Enterprise Core, Microsoft SQL Server 2016 Standard, Microsoft SQL Server 2014 Service Pack 1, Microsoft SQL Server 2014 Developer, Microsoft SQL Server 2014 Enterprise, Microsoft SQL Server 2014 Enterprise Core, Microsoft SQL Server 2014 Standard, Microsoft SQL Server 2012 Service Pack 3, Microsoft SQL Server 2012 Developer, Microsoft SQL Server 2012 Enterprise, Microsoft SQL Server 2012 Enterprise Core, Microsoft SQL Server 2012 Standard