Skip Navigation Links
Home
Articles
SQL Server 2012
SQL Server 2014
SQL Server 2016
FAQ
Practice Test
Tip of the Day : SQL Server Tutorial - INSERT Statement 101
Error Messages
Home > Tips & Tricks > Error Messages 8501 to 9000
SQL Server Error Messages - Errors 8501 to 9000

A message number uniquely identifies each error message and the error message text describes the problem.  The error message text often includes placeholders for information (such as object names) to be inserted in the error message when it is displayed.  Unfortunately, the error message text does not tell you how to solve or work around the problem.  In this series of Error Messages list, we will try to provide you with ways on how to overcome or work around certain error messages.

Some error messages are self-explanatory and can easily be fixed, such as "Invalid object name".  Others are harder to fix or work around, especially by those who are new to SQL Server.  It is the intent of this page and succeeding pages (to come) to assist you in addressing or working around SQL Server error messages.

Error Severity Description
8501 16 MSDTC on server '%.*ls' is unavailable.
8502 20 Unknown MSDTC token '0x%x' received.
8504 20 Invalid transaction import buffer.
8506 20 Invalid transaction state change requested from %hs to %hs.
8508 20 QueryInterface failed for '%hs': %hs.
8509 20 Import of MSDTC transaction failed: %hs.
8510 20 Enlist of MSDTC transaction failed: %hs.
8511 20 Unknown isolation level %d requested from MSDTC.
8512 20 MSDTC Commit acknowledgement failed: %hs.
8513 20 MSDTC Abort acknowledgement failed: %hs.
8514 20 MSDTC PREPARE acknowledgement failed: %hs.
8515 20 MSDTC Global state is invalid.
8517 20 Failed to get MSDTC PREPARE information: %hs.
8518 20 MSDTC BEGIN TRANSACTION failed: %hs.
8519 16 Current MSDTC transaction must be committed by remote client.
8520 20 Commit of internal MSDTC transaction failed: %hs.
8521 20 Invalid awakening state. Slept in %hs; awoke in %hs.
8522 20 Distributed transaction aborted by MSDTC.
8523 15 PREPARE TRAN statement not allowed on MSDTC transaction.
8524 16 The current transaction could not be exported to the remote provider. It has been rolled back.
8525 16 Distributed transaction completed. Either enlist this session in a new transaction or the NULL transaction.
8601 17 Internal Query Processor Error: The query processor could not obtain access to a required interface.
8602 16 Indexes used in hints must be explicitly included by the index tuning wizard.
8616 10 The index hints for table '%.*ls' were ignored because the table was considered a fact table in the star join.
8617 17 Invalid Query: CUBE and ROLLUP cannot compute distinct aggregates.
8618 17 Warning: The query processor could not produce a query plan from the optimizer because the total length of all the columns in the GROUP BY or ORDER BY clause exceeds 8000 bytes.
8619 17 Warning: The query processor could not produce a query plan from the optimizer because the total length of all the columns in the GROUP BY or ORDER BY clause exceeds 8000 bytes. Resubmit your query without the ROBUST PLAN hint.
8620 17 Internal Query Processor Error: The query processor encountered an internal limit overflow.
8621 16 Internal Query Processor Error: The query processor ran out of stack space during query optimization.
8622 16 Query processor could not produce a query plan because of the hints defined in this query. Resubmit the query without specifying any hints and without using SET FORCEPLAN.
8623 16 Internal Query Processor Error: The query processor could not produce a query plan. Contact your primary support provider for more information.
8624 16 Internal SQL Server error.
8625 16 Warning: The join order has been enforced because a local join hint is used.
8626 16 Only text pointers are allowed in work tables, never text, ntext, or image columns. The query processor produced a query plan that required a text, ntext, or image column in a work table.
8627 16 The query processor could not produce a query plan because of the combination of hints and text, ntext, or image data passing through operators using work tables.
8628 17 A time out occurred while waiting to optimize the query. Rerun the query.
8629 16 The query processor could not produce a query plan from the optimizer because a query cannot update a text, ntext, or image column and a clustering key at the same time.
8630 16 Internal Query Processor Error: The query processor encountered an unexpected error during execution.
8640 17 Internal Query Processor Error: The query processor encountered an unexpected work table error during execution.
8642 17 The query processor could not start the necessary thread resources for parallel query execution.
8644 16 Internal Query Processor Error: The plan selected for execution does not support the invoked given execution routine.
8645 17 A time out occurred while waiting for memory resources to execute the query. Rerun the query.
8646 21 The index entry for row ID %.*hs was not found in index ID %d, of table %d, in database '%.*ls'.
8647 20 Scan on sysindexes for database ID %d, object ID %ld, returned a duplicate index ID %d. Run DBCC CHECKTABLE on sysindexes.
8648 1720 Could not insert a row larger than the page size into a hash table. Resubmit the query with the ROBUST PLAN hint.
8649 17 The query has been canceled because the estimated cost of this query (%d) exceeds the configured threshold of %d. Contact the system administrator.
8650 13 Intra-query parallelism caused your server command (process ID #%d) to deadlock. Rerun the query without intra-query parallelism by using the query hint option (maxdop 1).
8651 17 Could not perform the requested operation because the minimum query memory is not available. Decrease the configured value for the 'min memory per query' server configuration option.
8653 17 Warning: The query processor is unable to produce a plan because the table '%.*ls' is marked OFFLINE.
8654 16 A cursor plan could not be generated for the given statement because it contains textptr ( inrow lob ).
8660 16 An index cannot be created on the view '%.*ls' because the view definition does not include all the columns in the GROUP BY clause.
8661 16 A clustered index cannot be created on the view '%.*ls' because the index key includes columns which are not in the GROUP BY clause.
8662 16 An index cannot be created on the view '%.*ls' because the view definition includes an unknown value (the sum of a nullable expression).
8663 16 An index cannot be created on the view '%.*ls' because the view definition does not include count_big(*).
8664 16 An index cannot be created on the view '%.*ls' because the view definition includes duplicate column names.
8665 16 An index cannot be created on the view '%.*ls' because no row can satisfy the view definition.
8666 10 Warning: The optimizer cannot use the index because the select list of the view contains a non-aggregate expression.
8667 10 Warning: The optimizer cannot use the index because the group-by list in the view forms a key and is redundant.
8680 17 Internal Query Processor Error: The query processor encountered an unexpected error during the processing of a remote query phase.

Error Severity Description
8901 13 Deadlock detected during DBCC. Complete the transaction in progress and retry this statement.
8902 17 Memory allocation error during DBCC processing.
8903 16 Extent %S_PGID in database ID %d is allocated in both GAM %S_PGID and SGAM %S_PGID.
8904 16 Extent %S_PGID in database ID %d is allocated by more than one allocation object.
8905 16 Extent %S_PGID in database ID %d is marked allocated in the GAM, but no SGAM or IAM has allocated it.
8906 16 Page %S_PGID in database ID %d is allocated in the SGAM %S_PGID and PFS %S_PGID, but was not allocated in any IAM. PFS flags '%hs'.
8908 16 Table error: Database ID %d, object ID %d, index ID %d. Chain linkage mismatch. %S_PGID->next = %S_PGID, but %S_PGID->prev = %S_PGID.
8909 16 Table error: Object ID %d, index ID %d, page ID %S_PGID. The PageId in the page header = %S_PGID.
8910 16 Page %S_PGID in database ID %d is allocated to both object ID %d, index ID %d, and object ID %d, index ID %d.
8911 10 The error has been repaired.
8912 10 %.*ls fixed %d allocation errors and %d consistency errors in database '%ls'.
8913 16 Extent %S_PGID is allocated to '%ls' and at least one other object.
8914 10 Incorrect PFS free space information for page %S_PGID, object ID %d, index ID %d, in database ID %d. Expected value %hs, actual value %hs.
8915 10 File %d (number of mixed extents = %ld, mixed pages = %ld).
8916 10 Object ID %ld, Index ID %ld, data extents %ld, pages %ld, mixed extent pages %ld.
8917 10 Object ID %ld, Index ID %ld, index extents %ld, pages %ld, mixed extent pages %ld.
8918 10 (number of mixed extents = %ld, mixed pages = %ld) in this database.
8919 16 Single page allocation %S_PGID in table %ls, object ID %d, index ID %d is not allocated in PFS page ID %S_PGID.
8920 16 Cannot perform a %ls operation inside a user transaction. Terminate the transaction and reissue the statement.
8921 16 CHECKTABLE terminated. A failure was detected while collecting facts. Possibly tempdb out of space or a system table is inconsistent. Check previous errors.
8922 10 Could not repair this error.
8923 10 The repair level on the DBCC statement caused this repair to be bypassed.
8924 10 Repairing this error requires other errors to be corrected first.
8925 16 Table error: Cross object linkage: Page %S_PGID, slot %d, in object ID %d, index ID %d, refers to page %S_PGID, slot %d, in object ID %d, index ID %d.
8926 16 Table error: Cross object linkage: Parent page %S_PGID, slot %d, in object ID %d, index ID %d, and page %S_PGID, slot %d, in object ID %d, index ID %d, next refer to page %S_PGID but are not in the same object.
8927 16 Object ID %d, index ID %d: The ghosted record count (%d) in the header does not match the number of ghosted records (%d) found on page %S_PGID.
8928 16 Object ID %d, index ID %d: Page %S_PGID could not be processed. See other errors for details.
8929 16 Object ID %d: Errors found in text ID %I64d owned by data record identified by %.*ls.
8930 16 Table error: Object ID %d, index ID %d cross-object chain linkage. Page %S_PGID points to %S_PGID in object ID %d, index ID %d.
8931 16 Table error: Object ID %d, index ID %d B-tree level mismatch, page %S_PGID. Level %d does not match level %d from parent %S_PGID.
8932 16 Table error: Object ID %d, index ID %d, column '%.*ls'. The column ID %d is not valid for this table. The valid range is from 1 to %d.
8933 16 Table error: Object ID %d, index ID %d. The low key value on page %S_PGID (level %d) is not %ls the key value in the parent %S_PGID slot %d.
8934 16 Table error: Object ID %d, index ID %d. The high key value on page %S_PGID (level %d) is not less than the low key value in the parent %S_PGID, slot %d of the next page %S_PGID.
8935 16 Table error: Object ID %d, index ID %d. The previous link %S_PGID on page %S_PGID does not match the previous page %S_PGID that the parent %S_PGID, slot %d expects for this page.
8936 16 Table error: Object ID %d, index ID %d. B-tree chain linkage mismatch. %S_PGID->next = %S_PGID, but %S_PGID->Prev = %S_PGID.
8937 16 Table error: Object ID %d, index ID %d. B-tree page %S_PGID has two parent nodes %S_PGID, slot %d and %S_PGID, slot %d.
8938 16 Table error: Page %S_PGID, Object ID %d, index ID %d. Unexpected page type %d.
8939 16 Table error: Object ID %d, index ID %d, page %S_PGID. Test (%hs) failed. Values are %ld and %ld.
8940 16 Table error: Object ID %d, index ID %d, page %S_PGID. Test (%hs) failed. Address 0x%x is not aligned.
8941 16 Table error: Object ID %d, index ID %d, page %S_PGID. Test (%hs) failed. Slot %d, offset 0x%x is invalid.
8942 16 Table error: Object ID %d, index ID %d, page %S_PGID. Test (%hs) failed. Slot %d, offset 0x%x overlaps with the prior row.
8943 16 Table error: Object ID %d, index ID %d, page %S_PGID. Test (%hs) failed. Slot %d, row extends into free space at 0x%x.
8944 16 Table error: Object ID %d, index ID %d, page %S_PGID, row %d. Test (%hs) failed. Values are %ld and %ld.
8945 16 Table error: Object ID %d, index ID %d will be rebuilt.
8946 16 Table error: Allocation page %S_PGID has invalid %ls page header values. Type is %d. Check type, object ID and page ID on the page.
8947 16 Table error: Multiple IAM pages for object ID %d, index ID %d contain allocations for the same interval. IAM pages %S_PGID and %S_PGID.
8948 16 Database error: Page %S_PGID is marked with the wrong type in PFS page %S_PGID. PFS status 0x%x expected 0x%x.
8949 10 %.*ls fixed %d allocation errors and %d consistency errors in table '%ls' (object ID %d).
8950 16 %.*ls fixed %d allocation errors and %d consistency errors not associated with any single object.
8951 16 Table error: Table '%ls' (ID %d). Missing or invalid key in index '%ls' (ID %d) for the row:
8952 16 Table error: Database '%ls', index '%ls.%ls' (ID %d) (index ID %d). Extra or invalid key for the keys:
8953 10 Repair: Deleted text column, text ID %I64d, for object ID %d on page %S_PGID, slot %d.
8954 10 %.*ls found %d allocation errors and %d consistency errors not associated with any single object.
8955 16 Data row (%d:%d:%d) identified by (%ls) has index values (%ls).
8956 16 Index row (%d:%d:%d) with values (%ls) points to the data row identified by (%ls).
8957 10 DBCC %ls (%ls%ls%ls) executed by %ls found %d errors and repaired %d errors.
8958 10 %ls is the minimum repair level for the errors found by DBCC %ls (%ls %ls).
8959 16 Table error: IAM page %S_PGID for object ID %d, index ID %d is linked in the IAM chain for object ID %d, index ID %d by page %S_PGID.
8960 23 Table error: Page %S_PGID, slot %d, column %d is not a valid complex column.
8961 23 Table error: Object ID %d. The text, ntext, or image node at page %S_PGID, slot %d, text ID %I64d does not match its reference from page %S_PGID, slot %d.
8962 23 Table error: The text, ntext, or image node at page %S_PGID, slot %d, text ID %I64d has incorrect node type %d.
8963 23 Table error: The text, ntext, or image node at page %S_PGID, slot %d, text ID %I64d has type %d. It cannot be placed on a page of type %d.
8964 23 Table error: Object ID %d. The text, ntext, or image node at page %S_PGID, slot %d, text ID %I64d is not referenced.
8965 23 Table error: Object ID %d. The text, ntext, or image node at page %S_PGID, slot %d, text ID %I64d is referenced by page %S_PGID, slot %d, but was not seen in the scan.
8966 22 Could not read and latch page %S_PGID with latch type %ls. %ls failed.
8967 16 Table error: Invalid value detected in %ls for Object ID %d, index ID %d. Row skipped.
8968 16 Table error: %ls page %S_PGID (object ID %d, index ID %d) is out of the range of this database.
8969 16 Table error: IAM chain linkage error: Object ID %d, index ID %d. The next page for IAM page %S_PGID is %S_PGID, but the previous link for page %S_PGID is %S_PGID.
8970 16 Row error: Object ID %d, index ID %d, page ID %S_PGID, row ID %d. Column '%.*ls' was created NOT NULL, but is NULL in the row.
8971 16 Forwarded row mismatch: Object ID %d, page %S_PGID, slot %d points to forwarded row page %S_PGID, slot %d; the forwarded row points back to page %S_PGID, slot %d.
8972 16 Forwarded row referenced by more than one row. Object ID %d, page %S_PGID, slot %d incorrectly points to forwarded row page %S_PGID, slot %d; the forwarded row correctly refers back to page %S_PGID, slot %d.
8973 16 CHECKTABLE processing of object ID %d, index ID %d encountered page %S_PGID, slot %d twice. Possible internal error or allocation fault.
8974 16 Text node referenced by more than one node. Object ID %d, text, ntext, or image node page %S_PGID, slot %d, text ID %I64d is pointed to by page %S_PGID, slot %d and by page %S_PGID, slot %d.
8975 16 Table error: Object ID %d, index ID %d. The child page pointer %S_PGID on PageId %S_PGID, slot %d is not a valid page for this database.
8976 16 Table error: Object ID %d, index ID %d. Page %S_PGID was not seen in the scan although its parent %S_PGID and previous %S_PGID refer to it. Check any previous errors.
8978 16 Table error: Object ID %d, index ID %d. Page %S_PGID is missing a reference from previous page %S_PGID. Possible chain linkage problem.
8979 16 Table error: Object ID %d, index ID %d. Page %S_PGID is missing references from parent (unknown) and previous (page %S_PGID) nodes. Possible bad root entry in sysindexes.
8980 16 Table error: Object ID %d, index ID %d. Index node page %S_PGID, slot %d refers to child page %S_PGID and previous child %S_PGID, but they were not encountered.
8981 16 Table error: Object ID %d, index ID %d. The next pointer of %S_PGID refers to page %S_PGID. Neither %S_PGID nor its parent were encountered. Possible bad chain linkage.
8982 16 Table error: Cross object linkage. Page %S_PGID->next in object ID %d, index ID %d refers to page %S_PGID in object ID %d, index ID %d but is not in the same index.
8983 10 File %d. Extents %d, used pages %d, reserved pages %d, mixed extents %d, mixed pages %d.
8984 10 Object ID %d, index ID %d. Allocations for %S_PGID. IAM %S_PGID, extents %d, used pages %d, mixed pages %d.
8985 16 Could not locate file '%.*ls' in sysfiles.
8986 16 Too many errors found (%d) for object ID %d. To see all error messages rerun the statement using "WITH ALL_ERRORMSGS".
8987 16 No help available for DBCC statement '%.*ls'.
8988 10 The schema for database '%ls' is changing. May find spurious allocation problems due to schema changes in progress.
8989 10 %.*ls found %d allocation errors and %d consistency errors in database '%ls'.
8990 10 %.*ls found %d allocation errors and %d consistency errors in table '%ls' (object ID %d).
8991 16 0x%.8x + 0x%.8x bytes is not a valid address range.
8992 16 Database ID %d, object '%ls' (ID %d). Loop in data chain detected at %S_PGID.
8993 16 Object ID %d, forwarding row page %S_PGID, slot %d points to page %S_PGID, slot %d. Did not encounter forwarded row. Possible allocation error.
8994 16 Object ID %d, forwarded row page %S_PGID, slot %d should be pointed to by forwarding row page %S_PGID, slot %d. Did not encounter forwarding row. Possible allocation error.
8995 16 System table '%.*ls' (object ID %d, index ID %d) is in filegroup %d. All system tables must be in filegroup %d.
8996 16 IAM page %S_PGID for object ID %d, index ID %d controls pages in filegroup %d, that should be in filegroup %d.
8997 16 Single page allocation %S_PGID for object ID %d, index ID %d is in filegroup %d; it should be in filegroup %d.
8998 16 Page errors on the GAM, SGAM, or PFS pages do not allow CHECKALLOC to verify database ID %d pages from %S_PGID to %S_PGID. See other errors for cause.
8999 10 Database tempdb allocation errors prevent further %ls processing.

Related Articles :