Skip Navigation Links
Home
Articles
SQL Server 2012
SQL Server 2014
SQL Server 2016
FAQ
Practice Test
Tip of the Day : How to Join with an Inline User-Defined Function
Error Messages
Home > Tips & Tricks > Error Messages 9001 to 9500
SQL Server Error Messages - Errors 9001 to 9500

SQL Server Error Message - Errors 9001 to 9500

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
9001 21  The log for database '<Database Name>' is not available.
9002 17 The log file for database '<Database Name>' is full. Back up the transaction log for the database to free up some log space.
9003 20 The LSN <LSN Number> passed to log scan in database '<Database Name>' is invalid.
9004 21 An error occurred while processing the log for database '<Database Name>'.
9005 16 Either start LSN or end LSN specified in OpenRowset(DBLog, ...) is invalid.
9006 10 Cannot shrink log file <Log File Name> (%s) because total number of logical log files cannot be fewer than %d.
9007 10 Cannot shrink log file <Log File Name> (%s) because requested size (%dKB) is larger than the start of the last logical log file.
9008 10 Cannot shrink log file <Log File Name> (%s) because all logical log files are in use.
9009 10 Cannot shrink log file <Log File Name> (%s) because of minimum log space required.
9010 14 User does not have permission to query the virtual table, DBLog. Only members of the sysadmin fixed server role and the db_owner fixed database role have this permission.
9011 14 User does not have permission to query backup files with the virtual table DBLog. Only members of the sysadmin fixed server role has this permission.
9012 10 There have been %d misaligned log IOs which required falling back to synchronous IO. The current IO is on file %ls.
9013 10 The tail of the log for database %ls is being rewritten to match the new sector size of %d bytes. %d bytes at offset %I64d in file %ls will be written.
9014 21 An error occurred while processing the log for database '%ls'. The log block version %d is unsupported. This server supports log version %d to %d.
9015 24 The log record at LSN %S_LSN is corrupted.
9016 21 An error occurred while processing the log for database '%.*ls'. The log block could not be decrypted.
9017 10 Database %ls has more than %d virtual log files which is excessive. Too many virtual log files can cause long startup and backup times. Consider shrinking the log and using a different growth increment to reduce the number of virtual log files.
9018 16 The log for database '%ls' does not allow user writes.
9019 21 The virtual log file sequence 0x%08x at offset 0x%016I64x bytes in file '%ls' is active and cannot be overwritten with sequence 0x%08x for database '%ls'.
9020 16 The log for database '%ls' failed to grow while shrink in progress. Please retry.
9021 16 Cannot accept virtual log file sequence 0x%08x for database '%ls' because file %d does not exist yet.
9022 14 The log can not be initialized because the log files are not fully formatted.
9023 16 The log for database '%ls' cannot be shrunk until all secondaries have moved past the point where the log was added.
9100 23 Possible index corruption detected. Run DBCC CHECKDB..
9101 16 auto statistics internal.
9104 16 auto statistics internal.
9105 16 The provided statistics stream is corrupt.
9106 16 Histogram support not allowed for input data type 0x%08x.
9107 16 The name, '%.*ls', is invalid. The suffix '_readonly_database_statistic' is reserved. Select another name without using the reserved suffix.
9201 10 %d active query notification subscription(s) in database '%.*ls' owned by security identification number '%.*ls' were dropped.
9202 16 The query notification subscription message is invalid.
9204 16 The query notification subscription timeout is invalid. The allowed range is 1 through 2147483647.
9205 16 User "%.*ls" does not have permission to request query notification subscriptions on database "%.*ls".
9206 16 The query notification subscription "%ld" cannot be deleted because it does not exist or it has already been fired.
9207 10 The query notification dialog on conversation handle '%.*ls' closed due to the following error: '%.*ls'.
9208 16 Query notification subscription could not get dialog endpoint. Could not open service broker dialog for service name '%.*ls' of broker instance '%.*ls'.
9209 16 Query notification subscription could not begin dialog with service name '%.*ls' of broker instance '%.*ls'.
9210 10 Query notification delivery could not send message on dialog '%.*ls'. Delivery failed for notification '%.*ls' because of the following error in service broker: '%.*ls'.
9211 10 Failed to check for pending query notifications in database "%d" because of the following error when opening the database: '%.*ls'.
9213 10 Query notification subscription could not access database with id %d. Could not open broker dialog for service name '%.*ls' of broker instance '%.*ls'.
9214 16 The query notification delivery failed to decode the error message from the Service Broker.
9215 16 Query notification delivery failed to encode message. Delivery failed for notification '%.*ls'.
9216 10 Failed to delete the expired query notification subscription "%d".
9217 10 Failed to drop the unused internal query notification table "%d" in database "%d".
9218 16 Query notifications reached the internal limit of the maximum number of objects.
9219 16 The query notification subscriptions cleanup operation failed. See previous errors for details.
9220 10 Query notification dialog on conversation handle '%.*ls' closed due to an unknown service broker error.
9221 10 Query notification delivery could not get dialog endpoint for dialog '%.*ls'. Delivery failed for notification '%.*ls' because of the following error in service broker '%.*ls'.
9222 16 Internal query notification table has an outdated schema and the table has been dropped. Query notification cleanup has not been performed for this table.
9223 10 %d active query notification subscription(s) owned by security identification number '%.*ls' were dropped.
9224 10 Query notification delivery could not access database with id %d. Delivery failed for notification '%.*ls'.
9225 16 The notification options identifier string has %d characters. The maximum allowed length is %d characters.
9226 16 A string value within the notification options identifier is too long. String with prefix '%.*ls' must be %d characters or less.
9227 16 Unmatched quote in notification options identifier string.
9228 16 Name expected in notification options identifier option.
9229 16 Unknown option name '%.*ls' present in notification options identifier. The following are valid option names: 'Service', 'Broker Instance', 'Local Database'. Option names cannot be quoted.
9230 16 Option '%ls' was specified multiple times in the notification options identifier.
9231 16 An equal (=) character was expected after the option name. Found '%.*ls' instead.
9232 16 A semicolon (;) must be use to separate options in a notification options identifier. String '%.*ls' was found following an option.
9233 16 The option 'Service' must be specified in the notification options identifier.
9234 16 The options 'Broker Instance' and 'Local Database' were both specified in the notification options identifier.
9235 16 Value missing for option '%ls' in notification options identifier.
9236 16 Database %.*ls is not a valid local database.
9237 16 Database %.*ls is not a valid broker database.
9238 16 Query notification subscriptions are not allowed under an active application role context. Consider re-issuing the request without activating the application role.
9239 16 Internal query notifications error: The garbage collector corrected an inconsistency.
9240 10 Service broker dialog '%.*ls' could not be closed due to a broker error in database with id '%d' because of the following error in service broker: '%.*ls'.
9241 16 Service broker dialog '%.*ls' could not be closed because the database with id '%d' is not available. Consider closing the dialogs manually once the database is available again.
9242 10 Query notification delivery could not get dialog endpoint for dialog '%.*ls'. Query notification delivery failed because of the following error in service broker: '%.*ls'. See the error log for additional information.
9243 10 Query notification delivery could not send message on dialog '%.*ls'. Query notification delivery failed because of the following error in service broker: '%.*ls'. See the error log for additional information.
9244 16 Query notification cleanup could not access metadata for database "%d". Check whether the database is successfully restored and online.
9245 16 During the last time interval %d query notification errors were suppressed.

Error Severity Description
9300 16 %sIn this version of the server, the 'fn:id()' function only accepts an argument of type 'IDREF *'.
9301 16 %sIn this version of the server, 'cast as %s' is not available. Please use the 'cast as ?' syntax.
9302 16 %sThe context item in which the 'fn:id()' function is used must be a node.
9303 16 %sSyntax error near '%ls', expected '%ls'.
9304 16 %sThis version of the server only supports XQuery version '1.0'.
9305 16 %sOnly type names followed by '?' are supported in the target of 'instance of'.
9306 16 %sThe target of 'replace value of' cannot be a union type, found '%ls'.
9308 16 %sThe argument of '%ls' must be of a single numeric primitive type or 'http://www.w3.org/2004/07/xpath-datatypes#untypedAtomic'. Found argument of type '%ls'.
9309 16 %sThe target of 'replace value of' cannot be 'http://www.w3.org/2001/XMLSchema#anySimpleType', found '%ls'.
9310 16 %sThe 'with' clause of 'replace value of' cannot contain constructed XML.
9311 16 %sHeterogeneous sequences are not allowed in '%ls', found '%ls' and '%ls'.
9312 16 %s'%ls' is not supported on simple typed or 'http://www.w3.org/2001/XMLSchema#anyType' elements, found '%ls'.
9313 16 %sThis version of the server does not support multiple expressions or expressions mixed with strings in an attribute constructor.
9314 16 %sCannot implicitly atomize or apply 'fn:data()' to complex content elements, found type '%ls' within inferred type '%ls'.
9315 16 %sOnly constant expressions are supported for the name expression of computed element and attribute constructors.
9316 16 %sCannot use 'xmlns' in the name expression of computed attribute constructor.
9317 16 %sSyntax error near '%ls', expected string literal.
9318 16 %sSyntax error at source character '0x%02x' near '%ls', expected string literal.
9319 16 %sStatic simple type validation: Invalid simple type value '%ls'.
9320 16 %sThe result of applying the 'parent' axis on the document node is statically 'empty'.
9321 16 %sThe result of applying 'parent::%ls' is statically 'empty'.
9322 16 %sTwo consecutive '-' can only appear in a comment constructor if they are used to close the comment ('-->').
9323 16 %sUsing ':' in variable names is not supported in this version of the server.
9324 16 %sFound '}' without matching '{'. If you want to use the characters '{' or '}', you need to escape them as '{{' or '}}' respectively.
9325 16 %sComputed processing instruction constructors are not supported.
9326 16 %sComputed comment constructors are not supported.
9327 16 %sAll prolog entries need to end with ';', found '%ls'.
9328 16 %sType specification expected, found '%ls'.
9330 16 %sOnly comparable types are allowed in '%ls', found '%ls'.
9331 16 %sSyntax error near '%ls', expected '%ls' or '%ls'.
9332 16 %sSyntax error near '%ls', expected 'where', '(stable) order by' or 'return'.
9333 16 %s'//' followed by 'self', 'parent' or 'descendant-or-self' axes is not supported when it encounters simple typed or 'http://www.w3.org/2001/XMLSchema#anyType' elements, found '%ls'.
9334 16 %sThe 'form' attribute cannot be specified on a local attribute or element definition that has the 'ref' attribute. Location: '%ls'.
9335 16 %sThe XQuery syntax '%ls' is not supported.
9336 16 %sThe XML Schema syntax '%ls' is not supported.
9337 16 %sThe XML Schema type 'NOTATION' is not supported.
9338 16 %sThe value of a namespace declaration attribute must be a string literal. It cannot contain expressions.
9339 16 %sThe 'form' attribute cannot be specified on a global attribute or element definition. Location: '%ls'.
9340 16 %sExplicit import of the current target namespace is invalid. References to items in the current target namespace that have already been loaded in the schema collection will be resolved implicitly.
9341 16 %sSyntax error near '%ls', expected a step expression.
9342 16 %sAn XML instance is only supported as the direct source of an insert using sql:column/sql:variable.
9343 16 %sThe XML instance referred to by sql:column() and sql:variable() must be either untyped XML or must be typed with the same XML schema collection as the context XML instance on which the XML method is being applied to.
9344 16 %sThe SQL type '%s' is not supported with sql:column() and sql:variable().
9400 16 XML parsing: line %d, character %d, unexpected end of input
9401 16 XML parsing: line %d, character %d, unrecognized encoding
9402 16 XML parsing: line %d, character %d, unable to switch the encoding
9403 16 XML parsing: line %d, character %d, unrecognized input signature
9410 16 XML parsing: line %d, character %d, whitespace expected
9411 16 XML parsing: line %d, character %d, semicolon expected
9412 16 XML parsing: line %d, character %d, '>' expected
9413 16 XML parsing: line %d, character %d, A string literal was expected
9414 16 XML parsing: line %d, character %d, equal expected
9415 16 XML parsing: line %d, character %d, well formed check: no '<' in attribute value
9416 16 XML parsing: line %d, character %d, hexadecimal digit expected
9417 16 XML parsing: line %d, character %d, decimal digit expected
9418 16 XML parsing: line %d, character %d, '[' expected
9419 16 XML parsing: line %d, character %d, '(' expected
9420 16 XML parsing: line %d, character %d, illegal xml character
9421 16 XML parsing: line %d, character %d, illegal name character
9422 16 XML parsing: line %d, character %d, incorrect document syntax
9423 16 XML parsing: line %d, character %d, incorrect CDATA section syntax
9424 16 XML parsing: line %d, character %d, incorrect comment syntax
9425 16 XML parsing: line %d, character %d, incorrect conditional section syntax
9426 16 XML parsing: line %d, character %d, incorrect ATTLIST declaration syntax
9427 16 XML parsing: line %d, character %d, incorrect DOCTYPE declaration syntax
9428 16 XML parsing: line %d, character %d, incorrect ELEMENT declaration syntax
9429 16 XML parsing: line %d, character %d, incorrect ENTITY declaration syntax
9430 16 XML parsing: line %d, character %d, incorrect NOTATION declaration syntax
9431 16 XML parsing: line %d, character %d, NDATA expected
9432 16 XML parsing: line %d, character %d, PUBLIC expected
9433 16 XML parsing: line %d, character %d, SYSTEM expected
9434 16 XML parsing: line %d, character %d, name expected
9435 16 XML parsing: line %d, character %d, one root element
9436 16 XML parsing: line %d, character %d, end tag does not match start tag
9437 16 XML parsing: line %d, character %d, duplicate attribute
9438 16 XML parsing: line %d, character %d, text/xmldecl not at the beginning of input
9439 16 XML parsing: line %d, character %d, namespaces beginning with "xml" are reserved
9440 16 XML parsing: line %d, character %d, incorrect text declaration syntax
9441 16 XML parsing: line %d, character %d, incorrect xml declaration syntax
9442 16 XML parsing: line %d, character %d, incorrect encoding name syntax
9443 16 XML parsing: line %d, character %d, incorrect public identifier syntax
9444 16 XML parsing: line %d, character %d, well formed check: pes in internal subset
9445 16 XML parsing: line %d, character %d, well formed check: pes between declarations
9446 16 XML parsing: line %d, character %d, well formed check: no recursion
9447 16 XML parsing: line %d, character %d, entity content not well formed
9448 16 XML parsing: line %d, character %d, well formed check: undeclared entity
9449 16 XML parsing: line %d, character %d, well formed check: parsed entity
9450 16 XML parsing: line %d, character %d, well formed check: no external entity references
9451 16 XML parsing: line %d, character %d, incorrect processing instruction syntax
9452 16 XML parsing: line %d, character %d, incorrect system identifier syntax
9453 16 XML parsing: line %d, character %d, '?' expected
9454 16 XML parsing: line %d, character %d, no ']]>' in element content
9455 16 XML parsing: line %d, character %d, illegal qualified name character
9456 16 XML parsing: line %d, character %d, multiple colons in qualified name
9457 16 XML parsing: line %d, character %d, colon in name
9458 16 XML parsing: line %d, character %d, redeclared prefix
9459 16 XML parsing: line %d, character %d, undeclared prefix
9460 16 XML parsing: line %d, character %d, non default namespace with empty uri
9461 16 XML %ls starting with '%.*ls' is %d characters long, which exceeds the limit. Maximum allowed length is %d characters.
9462 16 XML parsing: line %d, character %d, not all chunks of value have been read
9463 16 XML parsing: line %d, character %d, xml:space has a non-legal value
9464 16 XML parsing: line %d, character %d, XML namespace prefix 'xml' can only be associated with the URI http://www.w3.org/XML/1998/namespace. This URI cannot be used with other prefixes.
9465 16 XML parsing: line %d, character %d, XML namespace prefix 'xmlns' is reserved for use by XML.
9466 16 XML parsing: line %d, character %d, XML namespace xml namespace URI (http://www.w3.org/XML/1998/namespace) must be assigned only to prefix 'xml'.
9467 16 XML parsing: line %d, character %d, xmlns namespace URI (http://www.w3.org/2000/xmlns/) is reserved and must not be used.
9480 16 XML parsing: line %d, character %d, unsupported xml
9500 16 The data type '%.*ls' used in the VALUE method is invalid.

Related Articles :