SQL Server Errors or Failures from Error: 6390 to Error: 6508



Error: 6390, Severity: 16, ALTER SCHEMA COLLECTION failed because path ‘%.*ls’ indexed with selective XML index ‘%.*ls’ on table ‘%.*ls’ would be invalidated. Either the schema or the specified path should be altered so that validation does not find any mismatches.
Error: 6391, Severity: 16, Path ‘%.*ls’ is promoted to a type that is invalid for use as a key column in a secondary selective XML index.
Error: 6392, Severity: 16, It is not allowed to create secondary selective XML index on the path ‘%.*ls’ because ‘node()’ is specified.
Error: 6393, Severity: 16, The same path expression cannot be mapped twice with same XSD types for selective XML index ‘%.*ls’.

Error: 6394, Severity: 16, Found non leaf element indexed for the value with path ‘%.*ls’ for selective XML index ‘%.*ls’.
Error: 6395, Severity: 16, The maximum key length is %d bytes. The secondary selective XML index ‘%.*ls’ over path ‘%.*ls’ has maximum length of %d bytes. For some combination of large values, the insert/update operation will fail.
Error: 6396, Severity: 16, The number of promoted paths for selective XML index ‘%.*ls’ exceeds the maximum of %d.
Error: 6397, Severity: 16, Path ‘%.*ls’ specified for selective XML index ‘%.*ls’ is too deep. The maximum allowed depth is %d levels.
Error: 6398, Severity: 16, The MAXLENGTH option value specified for the path ‘%.*ls’ for Selective XML Index ‘%.*ls’ is not allowed. The value should be in the range %d – %d.

Error: 6399, Severity: 16, The XML path ‘%.*ls’ of selective XML index ‘%.*ls’ cannot be dropped because it is used by secondary selective XML Index ‘%.*ls’.
Error: 6401, Severity: 16, Cannot roll back %.*ls. No transaction or savepoint of that name was found.
Error: 6500, Severity: 16, %ls failed because method ‘%ls’ of class ‘%ls’ in assembly ‘%ls’ returns %ls, but CLR Triggers must return void.
Error: 6501, Severity: 16, %s ASSEMBLY failed because it could not open the physical file ‘%.*ls’: %ls.
Error: 6502, Severity: 16, %s ASSEMBLY failed because it could not read from the physical file ‘%.*ls’: %ls.
Error: 6503, Severity: 16, Assembly ‘%.*ls’ was not found in the SQL catalog.
Error: 6504, Severity: 16, The value returned from %.*ls.%.*ls is not allowed to be NULL.
Error: 6505, Severity: 16, Could not find Type ‘%s’ in assembly ‘%s’.
Error: 6506, Severity: 16, Could not find method ‘%s’ for type ‘%s’ in assembly ‘%s’
Error: 6507, Severity: 16, Failed to open malformed assembly ‘%ls’ with HRESULT 0x%x.
Error: 6508, Severity: 16, Could not find field ‘%s’ for type ‘%s’ in assembly ‘%s’.

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.

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 *