SQL Server Errors or Failures from Error: 5235 to Error: 5254

SQLServerF1

 

Error: 5235, Severity: 10, %lsDBCC %ls (%ls%ls%ls)%ls executed by %ls terminated abnormally due to error state %d. Elapsed time: %d hours %d minutes %d seconds.
Error: 5236, Severity: 10, Unable to process object ‘%ls’ because it is a four-part name, which is not supported by any DBCC command.
Error: 5237, Severity: 10, DBCC cross-rowset check failed for object ‘%.*ls’ (object ID %d) due to an internal query error.
Error: 5238, Severity: 16, Unable to process object ID %ld (object ‘%.*ls’) because it is a stored procedure or user-defined function, which is not supported by any DBCC command.
Error: 5239, Severity: 16, Unable to process object ID %ld (object ‘%.*ls’) because this DBCC command does not support objects of this type.

Error: 5240, Severity: 10, File ID %d of database ID %d cannot be shrunk as it is either being shrunk by another process or is empty.
Error: 5241, Severity: 10, File ID %d of database ID %d cannot be shrunk as the target shrink size (%I64d KB) is greater than the actual file size (%I64d KB).
Error: 5242, Severity: 16, An inconsistency was detected during an internal operation in database ‘%.*ls'(ID:%d) on page %S_PGID. Please contact technical support.
Error: 5243, Severity: 16, An inconsistency was detected during an internal operation. Please contact technical support.
Error: 5244, Severity: 16, Repair statement not processed. One or more files in the database are read-only and must be made writeable in order to run repair.
Error: 5245, Severity: 16, Object ID %ld (object ‘%.*ls’): DBCC could not obtain a lock on this object because the lock request timeout period was exceeded. This object has been skipped and will not be processed.

Error: 5246, Severity: 16, Repair operations cannot be performed on the MSSQLSYSTEMRESOURCE database. Consult Books Online topic “Resource Database” for more information.
Error: 5247, Severity: 16, Repair: insert a secondary index row based on its base table row.
Error: 5248, Severity: 10, Repair: Successfully %ls row in index “%ls” in database “%ls”.
Error: 5249, Severity: 10, %.*ls: Page %d:%d could not be moved because shrink could not lock the page.
Error: 5250, Severity: 16, Database error: %ls page %S_PGID for database ‘%.*ls’ (database ID %d) is invalid. This error cannot be repaired. You must restore from backup.
Error: 5251, Severity: 10, %.*ls: Heap page %d:%d could not be moved because maintaining NC indexes associated with the heap failed.
Error: 5252, Severity: 10, File ID %d of database ID %d cannot be shrunk to the expected size. The high concurrent workload is leading to too many deadlocks during the shrink operation. Re-run the shrink operation when the workload is lower.
Error: 5253, Severity: 10, The check statement was aborted. DBCC CHECKALLOC cannot be run on TEMPDB.
Error: 5254, Severity: 10, %.*ls: Heap page %d:%d could not be moved because the table to which it belonged was building the heap by another process.

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 *