FIX: DBCC CHECKFILEGROUP reports false inconsistency errors on database that has partitioned table in SQL Server 2014


Assume that you have a database that contains a partitioned table in Microsoft SQL Server 2014. The table has a columnstore index, and the partitions of the table are mapped to different filegroups. When you run the DBCC CHECKFILEGROUP statement, you receive the following false inconsistency error messages:
Msg 8965, Level 16, State 1
Table error: Object ID <object id>, index ID <index id>, partition ID <partition id>, alloc unit ID <alloc unit id> (type LOB data). The off-row data node at page (<page id>), slot <slot id>, text ID <text id> is referenced by page (<page id>), slot <slot id>, but was not seen in the scan.CHECKFILEGROUP found 0 allocation errors and N consistency errors in table 'PageArchive' (object ID <object id>).
However, when you run the DBCC CHECKDB statement, you don't receive any consistency error messages. Additionally, running the DBCC CHECKDB statement 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 a reporting bug that can be ignored.


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


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


Artikkel-ID: 3099323 – Forrige gjennomgang: 19. okt. 2015 – Revisjon: 1