SQL Server Errors or Failures from Error: 6329 to Error: 6348

SQLServerF1

 

Error: 6329, Severity: 16, Unsupported usage of a QName typed value in node ‘%.*ls’
Error: 6330, Severity: 16, Column ‘%.*ls’ on table ‘%.*ls’ is not of type XML, which is required to create an XML index on it.
Error: 6331, Severity: 16, Primary XML Index ‘%.*ls’ already exists on column ‘%.*ls’ on table ‘%.*ls’, and multiple Primary XML Indexes per column are not allowed.
Error: 6332, Severity: 16, Table ‘%.*ls’ needs to have a clustered primary key with less than %d columns in it in order to create a primary XML index on it.
Error: 6333, Severity: 16, Could not find%ls XML index named ‘%.*ls’ on table ‘%.*ls’
Error: 6334, Severity: 16, Could not create the XML or spatial index on object ‘%.*ls’ because that object is not a table. Create the index on the base table column.

Error: 6335, Severity: 16, XML datatype instance has too many levels of nested nodes. Maximum allowed depth is %d levels.
Error: 6336, Severity: 16, Maximum size of primary index of table ‘%.*ls’ is %d bytes. CREATE XML INDEX requires that such size should be limited to %d bytes
Error: 6337, Severity: 16, ‘%.*ls’ is not a valid XML Index name because it starts with ‘%c’ character. XML Index name should not start with ‘#’ or ‘@’
Error: 6338, Severity: 10, XML DTD has been stripped from one or more XML fragments. External subsets, if any, have been ignored.
Error: 6339, Severity: 16, Specified collection ‘%.*ls’ cannot be modified because it is SQL Server built-in XML Schema Collection.

Error: 6340, Severity: 16, Xml schema collection ‘%.*ls’ referenced by table variable ‘%.*ls’ has been dropped or altered during the execution of the batch. Please re-run the batch.
Error: 6341, Severity: 16, Xml schema collection referenced by column ‘%.*ls’ of table variable ‘%.*ls’ has been dropped or altered during the execution of the batch. Please re-run the batch.
Error: 6342, Severity: 16, Cannot create primary xml, selective xml or spatial index ‘%.*ls’ on table ‘%.*ls’, column ‘%.*ls’, because the column is computed.
Error: 6343, Severity: 16, Cannot create secondary xml or secondary selective xml index ‘%.*ls’ without a USING XML INDEX clause.
Error: 6344, Severity: 16, The primary xml index ‘%.*ls’ does not exist on table ‘%.*ls’ column ‘%.*ls’.
Error: 6345, Severity: 16, The sparse column set ‘%.*ls’ in the table ‘%.*ls’ cannot be indexed by an XML index.
Error: 6346, Severity: 16, Cannot convert a primary XML index to a secondary XML index using the DROP_EXISTING option. ‘%.*ls’ is a primary XML index.
Error: 6347, Severity: 16, Specified collection ‘%.*ls’ cannot be altered because it does not exist or you do not have permission.
Error: 6348, Severity: 16, Specified collection ‘%.*ls’ cannot be created because it already exists or you do not have permission.

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 *