SQL Server Errors or Failures from Error: 5215 to Error: 5234

SQLServerF1

 

Error: 5215, Severity: 10, %.*ls: Page %d:%d could not be moved because the partition to which it belonged was dropped.
Error: 5216, Severity: 10, %.*ls: Heap page %d:%d could not be moved because the table to which it belonged was dropped.
Error: 5217, Severity: 10, %.*ls: Page %d:%d could not be moved because it is an empty non-leaf level index page.
Error: 5218, Severity: 10, %.*ls: Heap page %d:%d could not be moved because the table name could not be found.
Error: 5219, Severity: 10, %.*ls: Heap page %d:%d could not be moved.

Error: 5220, Severity: 10, %.*ls: Index Allocation Map (IAM) page %d:%d could not be moved.
Error: 5221, Severity: 10, %.*ls: Index Allocation Map (IAM) page %d:%d from a dropped allocation unit could not be moved.
Error: 5222, Severity: 10, %.*ls: Page %d:%d from a dropped allocation unit could not be deallocated.
Error: 5223, Severity: 10, %.*ls: Empty page %d:%d could not be deallocated.
Error: 5224, Severity: 10, %.*ls: Empty large object page %d:%d could not be deallocated.
Error: 5225, Severity: 10, %.*ls: Not all ghost records on the large object page %d:%d could be removed. If there are active queries on readable secondary replicas check the current ghost cleanup boundary.
Error: 5226, Severity: 10, %.*ls: Page %d:%d (type UNLINKED_REORG_PAGE) could not be deallocated.

Error: 5227, Severity: 10, %.*ls: Page %d:%d (type BULK_OPERATION_PAGE) could not be deallocated.
Error: 5228, Severity: 16, Table error: object ID %d, index ID %d, partition ID %I64d, alloc unit ID %I64d (type %.*ls), page %S_PGID, row %d. DBCC detected incomplete cleanup from an online index build operation. (The anti-matter column value is %d.)
Error: 5229, Severity: 16, Table error: Object ID %d, index ID %d, partition ID %I64d, alloc unit ID %I64d (type %.*ls) contains an anti-matter column, but is not a nonclustered index.
Error: 5230, Severity: 10, The check statement was aborted. DBCC CHECKCATALOG cannot be run on TEMPDB.
Error: 5231, Severity: 10, Object ID %ld (object ‘%.*ls’): A deadlock occurred while trying to lock this object for checking. This object has been skipped and will not be processed.
Error: 5232, Severity: 10, DBCC CHECKDB will not check SQL Server catalog or Service Broker consistency because a database snapshot could not be created or because WITH TABLOCK was specified.
Error: 5233, Severity: 16, Table error: alloc unit ID %I64d, page %S_PGID. The test (%.*ls) failed. The values are %ld and %ld.
Error: 5234, Severity: 10, DBCC SHRINKDATABASE: File ID %d of database ID %d was skipped because trying to adjust the space allocation for the file was failed.

This is applicable on below versions of SQL Server

SQL Server 2005
SQL Server 2008 R2
SQL Server 2012
SQL Server 2014

Hope this was helpful.

Thanks,
SQLServerF1 Team
In-Depth Blogs on SQL Server, Information about SQL Server Conferences and Events, SQL Server Frequently asked questions, SQL Server Trainings.

 

Leave a Reply

Your email address will not be published. Required fields are marked *