SQL Server Errors or Failures from Error: 6370 to Error: 6389

SQLServerF1

 

Error: 6370, Severity: 16, MAX_LENGTH option is not allowed in combination with ‘node()’ for selective XML index ‘%.*ls’.
Error: 6371, Severity: 16, The same name cannot be assigned to more than one path for selective XML index ‘%.*ls’.
Error: 6372, Severity: 16, The same path expression cannot be mapped twice using SQL data types for selective XML index ‘%.*ls’.
Error: 6373, Severity: 16, The expression specified for path ‘%.*ls’ is not allowed for selective XML index ‘%.*ls’. It is only allowed to index simple path expressions without predicates.
Error: 6374, Severity: 16, Specifying path which contains ‘%.*ls’ is not allowed for selective XML index ‘%.*ls’.

Error: 6375, Severity: 16, The data type ‘%.*ls’ is not allowed for selective XML index ‘%.*ls’.
Error: 6376, Severity: 16, For selective XML index ‘%.*ls’, MAX_LENGTH optimization hint cannot be specified if length or maxLength facet is specified in schema for an element.
Error: 6377, Severity: 16, Specifying a path which contains ‘*’ in the last step is not allowed for selective XML index ‘%.*ls’.
Error: 6378, Severity: 16, Table ‘%.*ls’ needs to have a clustered primary key with less than %d columns in it in order to create a selective XML index on it.
Error: 6379, Severity: 16, selective XML index ‘%.*ls’ already exists on column ‘%.*ls’ in table ‘%.*ls’. Multiple selective XML indexes per column are not allowed.
Error: 6380, Severity: 16, Path ‘%.*ls’. Multiple values found when SINGLETON option is specified for selective XML index ‘%.*ls’.
Error: 6381, Severity: 16, Could not find path ‘%.*ls’ in selective XML index ‘%.*ls’.

Error: 6382, Severity: 16, Could not find selective XML index named ‘%.*ls’ on table ‘%.*ls’
Error: 6383, Severity: 16, For selective XML index ‘%.*ls’, SINGLETON option can be specified only for untyped XML.
Error: 6384, Severity: 16, It is not allowed to specify a path which contains ‘*’ only for the URI or only for the name of the node for selective XML index ‘%.*ls’.
Error: 6385, Severity: 16, The selective XML index ‘%.*ls’ does not exist on table ‘%.*ls’ column ‘%.*ls’.
Error: 6386, Severity: 16, Cannot convert a selective XML index to a secondary selective XML index using the DROP_EXISTING option. ‘%.*ls’ is a selective XML index.
Error: 6387, Severity: 16, You cannot remove all paths for selective XML index ‘%.*ls’. A selective XML index must have at least one path specified.
Error: 6388, Severity: 16, Version of Selective DG stored in database is different than version of Selective DG on server for index ‘%.*ls’.
Error: 6389, Severity: 16, Inserted value exceeded maxlength %d for path ‘%.*ls’ for selective XML index ‘%.*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 *