SQL Server Errors or Failures from Error: 6718 to Error: 6815

SQLServerF1

 

Error: 6718, Severity: 16, XQuery: Invalid ordpath string: “%s”
Error: 6739, Severity: 16, XQuery: SQL type ‘%s’ is not supported in XQuery.
Error: 6743, Severity: 16, XQuery: The maximum allowed depth in XML instances is %d levels. One of the paths in the query tries to access nodes at a lower level.
Error: 6744, Severity: 16, XQuery: One of the paths specified in the query is too deep. The maximum allowed depth is %d levels.
Error: 6745, Severity: 16, XQuery: Internal compiler error.
Error: 6800, Severity: 16, FOR XML AUTO requires at least one table for generating XML tags. Use FOR XML RAW or add a FROM clause with a table name.

Error: 6801, Severity: 16, FOR XML EXPLICIT requires at least three columns, including the tag column, the parent column, and at least one data column.
Error: 6802, Severity: 16, FOR XML EXPLICIT query contains the invalid column name ‘%.*ls’. Use the TAGNAME!TAGID!ATTRIBUTENAME[!..] format where TAGID is a positive integer.
Error: 6803, Severity: 16, FOR XML EXPLICIT requires the first column to hold positive integers that represent XML tag IDs.
Error: 6804, Severity: 16, FOR XML EXPLICIT requires the second column to hold NULL or nonnegative integers that represent XML parent tag IDs.
Error: 6805, Severity: 16, FOR XML EXPLICIT stack overflow occurred. Circular parent tag relationships are not allowed.
Error: 6806, Severity: 16, Undeclared tag ID %d is used in a FOR XML EXPLICIT query.
Error: 6807, Severity: 16, Undeclared parent tag ID %d is used in a FOR XML EXPLICIT query.
Error: 6808, Severity: 16, XML tag ID %d could not be added. The server memory resources may be low.

Error: 6809, Severity: 16, Unnamed tables cannot be used as XML identifiers as well as unnamed columns cannot be used for attribute names. Name unnamed columns/tables using AS in the SELECT statement.
Error: 6810, Severity: 16, Column name ‘%.*ls’ is repeated. The same attribute cannot be generated more than once on the same XML tag.
Error: 6812, Severity: 16, XML tag ID %d that was originally declared as ‘%.*ls’ is being redeclared as ‘%.*ls’.
Error: 6813, Severity: 16, FOR XML EXPLICIT cannot combine multiple occurrences of ID, IDREF, IDREFS, NMTOKEN, and/or NMTOKENS in column name ‘%.*ls’.
Error: 6814, Severity: 16, In the FOR XML EXPLICIT clause, ID, IDREF, IDREFS, NMTOKEN, and NMTOKENS require attribute names in ‘%.*ls’.
Error: 6815, Severity: 16, In the FOR XML EXPLICIT clause, ID, IDREF, IDREFS, NMTOKEN, and NMTOKENS attributes cannot be hidden in ‘%.*ls’.

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 *