SQL Server Errors or Failures from Error: 6816 to Error: 6839

SQLServerF1

 

Error: 6816, Severity: 16, In the FOR XML EXPLICIT clause, ID, IDREF, IDREFS, NMTOKEN, and NMTOKENS attributes cannot be generated as CDATA, XML, or XMLTEXT in ‘%.*ls’.
Error: 6817, Severity: 16, FOR XML EXPLICIT cannot combine multiple occurrences of ELEMENT, XML, XMLTEXT, and CDATA in column name ‘%.*ls’.
Error: 6819, Severity: 16, The FOR XML clause is not allowed in a %ls statement.
Error: 6820, Severity: 16, FOR XML EXPLICIT requires column %d to be named ‘%ls’ instead of ‘%.*ls’.
Error: 6821, Severity: 16, GROUP BY and aggregate functions are currently not supported with FOR XML AUTO.
Error: 6824, Severity: 16, In the FOR XML EXPLICIT clause, mode ‘%.*ls’ in a column name is invalid.

Error: 6825, Severity: 16, ELEMENTS option is only allowed in RAW, AUTO, and PATH modes of FOR XML.
Error: 6826, Severity: 16, Every IDREFS or NMTOKENS column in a FOR XML EXPLICIT query must appear in a separate SELECT clause, and the instances must be ordered directly after the element to which they belong.
Error: 6827, Severity: 16, FOR XML EXPLICIT queries allow only one XMLTEXT column per tag. Column ‘%.*ls’ declares another XMLTEXT column that is not permitted.
Error: 6828, Severity: 16, XMLTEXT column ‘%.*ls’ must be of a string data type or of type XML.
Error: 6829, Severity: 16, FOR XML EXPLICIT and RAW modes currently do not support addressing binary data as URLs in column ‘%.*ls’. Remove the column, or use the BINARY BASE64 mode, or create the URL directly using the ‘dbobject/TABLE[@PK1=”V1″]/@COLUMN’ syntax.

Error: 6830, Severity: 16, FOR XML AUTO could not find the table owning the following column ‘%.*ls’ to create a URL address for it. Remove the column, or use the BINARY BASE64 mode, or create the URL directly using the ‘dbobject/TABLE[@PK1=”V1″]/@COLUMN’ syntax.
Error: 6831, Severity: 16, FOR XML AUTO requires primary keys to create references for ‘%.*ls’. Select primary keys, or use BINARY BASE64 to obtain binary data in encoded form if no primary keys exist.
Error: 6832, Severity: 16, FOR XML AUTO cannot generate a URL address for binary data if a primary key is also binary.
Error: 6833, Severity: 16, Parent tag ID %d is not among the open tags. FOR XML EXPLICIT requires parent tags to be opened first. Check the ordering of the result set.
Error: 6834, Severity: 16, XMLTEXT field ‘%.*ls’ contains an invalid XML document. Check the root tag and its attributes.
Error: 6835, Severity: 16, FOR XML EXPLICIT field ‘%.*ls’ can specify the directive HIDE only once.
Error: 6836, Severity: 16, FOR XML EXPLICIT requires attribute-centric IDREFS or NMTOKENS field ‘%.*ls’ to precede element-centric IDREFS/NMTOKEN fields.
Error: 6838, Severity: 16, Attribute-centric IDREFS or NMTOKENS field not supported on tags having element-centric field ‘%.*ls’ of type TEXT/NTEXT or IMAGE. Either specify ELEMENT on IDREFS/NMTOKENS field or remove the ELEMENT directive.
Error: 6839, Severity: 16, FOR XML EXPLICIT does not support XMLTEXT field on tag ‘%.*ls’ that has IDREFS or NMTOKENS fields.

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 *