SQL Server Errors or Failures from Error: 6860 to Error: 6879

SQLServerF1

 

Error: 6860, Severity: 16, FOR XML directive XMLDATA is not allowed with ROOT directive or row tag name specified.
Error: 6861, Severity: 16, Empty root tag name can’t be specified with FOR XML.
Error: 6862, Severity: 16, Empty FOR XML target inline schema URI is not allowed.
Error: 6863, Severity: 16, Row tag omission (empty row tag name) is not compatible with XMLSCHEMA FOR XML directive.
Error: 6864, Severity: 16, Row tag omission (empty row tag name) cannot be used with attribute-centric FOR XML serialization.
Error: 6865, Severity: 16, FOR XML does not support CLR types – cast CLR types explicitly into one of the supported types in FOR XML queries.

Error: 6866, Severity: 16, Use of a system reserved XML schema URI is not allowed.
Error: 6867, Severity: 16, ‘xmlns’ is invalid in XML tag name in FOR XML PATH, or when WITH XMLNAMESPACES is used with FOR XML.
Error: 6868, Severity: 16, The following FOR XML features are not supported with WITH XMLNAMESPACES list: EXPLICIT mode, XMLSCHEMA and XMLDATA directives.
Error: 6869, Severity: 16, Attempt to redefine namespace prefix ‘%.*ls’
Error: 6870, Severity: 16, Prefix ‘%.*ls’ used in WITH XMLNAMESPACES clause contains an invalid XML identifier. ‘%c'(0x%04X) is the first character at fault.
Error: 6871, Severity: 16, Prefix ‘%.*ls’ used in WITH XMLNAMESPACES is reserved and cannot be used as a user-defined prefix.
Error: 6872, Severity: 16, 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.
Error: 6873, Severity: 16, Redefinition of ‘xsi’ XML namespace prefix is not supported with ELEMENTS XSINIL option of FOR XML.

Error: 6874, Severity: 16, Empty URI is not allowed in WITH XMLNAMESPACES clause.
Error: 6875, Severity: 16, URI ‘%.*ls’ used in WITH XMLNAMESPACES is invalid. ‘%c'(0x%04X) is the first character at fault.
Error: 6876, Severity: 16, URI used in WITH XMLNAMESPACES is too long. The maximum length is %d characters.
Error: 6877, Severity: 16, Empty namespace prefix is not allowed in WITH XMLNAMESPACES clause.
Error: 6878, Severity: 16, FORXML XMLSCHEMA cannot be used with a typed XML column whose schema collection is empty.
Error: 6879, Severity: 16, ‘xml’ is an invalid XML processing instruction target. Possible attempt to construct XML declaration using XML processing instruction constructor. XML declaration construction with FOR XML is not supported.

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 *