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

SQLServerF1

 

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.

Thanks,
SQLServerF1 Team
In-Depth Blogs on SQL Server, Information about SQL Server Conferences and Events, SQL Server Frequently asked questions, SQL Server Trainings.

 

SQL Server Errors or Failures Error: 1977 to Error: 1996

SQLServerF1

 

Error: 1977, Severity: 16, Could not create %S_MSG ‘%.*ls’ on table ‘%.*ls’. Only XML Index can be created on XML column ‘%.*ls’.
Error: 1978, Severity: 16, Column ‘%.*ls’ in table ‘%.*ls’ is of a type that is invalid for use as a key column in an index or statistics.
Error: 1979, Severity: 16, Cannot use index option ignore_dup_key to alter index ‘%.*ls’ as it enforces a primary or unique constraint.
Error: 1980, Severity: 16, Index cannot be created on computed column ‘%.*ls’ of table ‘%.*ls’ because the underlying object ‘%.*ls’ has a different owner.
Error: 1981, Severity: 10, Warning: The maximum length of the row exceeds the permissible limit of %d bytes. For some combination of large values, the insert/update operation will fail.

Error: 1982, Severity: 16, Cannot create %S_MSG on view ‘%.*ls’ because the view references non-deterministic or imprecise member function ‘%.*ls’ on CLR type ‘%.*ls’. Consider removing reference to the function or altering the function to behave in a deterministic way. Do not dec
Error: 1983, Severity: 16, Cannot create %S_MSG on view ‘%.*ls’. The function ‘%s’ yields imprecise results. Use a precise system function, or modify the user-defined function to return precise results.
Error: 1984, Severity: 16, Index ‘%.*ls’ cannot be created or rebuilt. The specified row length for this index using the vardecimal storage format exceeds the maximum allowed length of ‘%d’ bytes.
Error: 1985, Severity: 16, Cannot create %S_MSG on view ‘%.*ls’. It contains one or more XML data type methods.

Error: 1986, Severity: 10, Cannot replace non-hypothetical index ‘%.*ls’ with a hypothetical index using the DROP_EXISTING option.
Error: 1987, Severity: 16, Cannot %S_MSG %S_MSG ‘%.*ls’ on %S_MSG ‘%.*ls’ because its %S_MSG is disabled.
Error: 1988, Severity: 16, Cannot rebuild clustered index ‘%.*ls’ online because it is disabled.
Error: 1989, Severity: 16, Cannot enable foreign key constraint ‘%.*ls’ as index ‘%.*ls’ on referenced key is disabled.
Error: 1990, Severity: 16, Cannot define an index on a view with ignore_dup_key index option. Remove ignore_dup_key option and verify that view definition does not allow duplicates, or do not index view.
Error: 1991, Severity: 16, Cannot disable clustered index ‘%.*ls’ on table ‘%.*ls’. Permission denied to disable foreign key ‘%.*ls’ on table ‘%.*ls’ that references this table.
Error: 1992, Severity: 10, Warning: Foreign key ‘%.*ls’ on table ‘%.*ls’ referencing table ‘%.*ls’ was disabled as a result of disabling the index ‘%.*ls’.
Error: 1993, Severity: 16, Cannot partition an index on a table variable or return table definition in table valued function.
Error: 1994, Severity: 16, Cannot create or update statistics on view “%.*ls” because both FULLSCAN and NORECOMPUTE options are required.
Error: 1995, Severity: 16, Cannot rebuild hypothetical index ‘%.*ls’ online.
Error: 1996, Severity: 16, Could not create index enforcing primary key constraint ‘%.*ls’ using DROP_EXISTING option because table has an XML or spatial index. Drop the XML or spatial index, create the primary key contstraint, and recreate the XML or spatial index.

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.

 

SQL Server Errors or Failures Error: 1922 to Error: 1947

SQLServerF1

 

Error: 1922, Severity: 16,
Filegroup ‘%.*ls’ has no files assigned to it. Tables, indexes, and large object columns cannot be created on this filegroup. Use ALTER DATABASE to add one or more files to the filegroup.

Error: 1924, Severity: 16,
Filegroup ‘%.*ls’ is read-only.

Error: 1925, Severity: 16,
Cannot convert a clustered index to a nonclustered index by using the DROP_EXISTING option. To change the index type from clustered to nonclustered, delete the clustered index, and then create a nonclustered index by using two separate statements.

Error: 1927, Severity: 16,
There are already statistics on table ‘%.*ls’ named ‘%.*ls’.

Error: 1929, Severity: 16,
Statistics cannot be created on object ‘%.*ls’ because the object is not a user table or view.

Error: 1930, Severity: 16,
Cannot convert a nonclustered index to a clustered index because a foreign key constraint references the index. Remove the foreign key constraint and then retry the operation.

Error: 1931, Severity: 16,
The SQL statement cannot be executed because filegroup ‘%.*ls’ is offline. Use the sys.database_files or sys.master_files catalog view to determine the state of the files in this filegroup and then restore the offline file(s) from backup.

Error: 1934, Severity: 16,
%ls failed because the following SET options have incorrect settings: ‘%.*ls’. Verify that SET options are correct for use with %S_MSG.

Error: 1935, Severity: 16,
Cannot create index. Object ‘%.*ls’ was created with the following SET options off: ‘%.*ls’.

Error: 1937, Severity: 16,
Cannot create %S_MSG on view ‘%.*ls’ because it references another view ‘%.*ls’. Consider expanding referenced view’s definition by hand in indexed view definition.

Error: 1938, Severity: 16,
Index cannot be created on view ‘%.*ls’ because the underlying object ‘%.*ls’ has a different owner.

Error: 1939, Severity: 16,
Cannot create %S_MSG on view ‘%.*ls’ because the view is not schema bound.

Error: 1940, Severity: 16,
Cannot create %S_MSG on view ‘%.*ls’. It does not have a unique clustered index.

Error: 1941, Severity: 16,
Cannot create nonunique clustered index on view ‘%.*ls’ because only unique clustered indexes are allowed. Consider creating unique clustered index instead.

Error: 1942, Severity: 16,
Cannot create %S_MSG on view ‘%.*ls’. It contains text, ntext, image, FILESTREAM or xml columns.

Error: 1943, Severity: 16,
The index “%.*ls” on table “%.*ls” cannot be reorganized because page level locking is disabled.

Error: 1944, Severity: 16,
Index ‘%.*ls’ was not created because the index key size is at least %d bytes. The index key size cannot exceed 900 bytes. If the index key includes implicit key columns, the index key size cannot exceed 1800 bytes.

Error: 1945, Severity: 10,
Warning! The maximum key length is %d bytes. The index ‘%.*ls’ has maximum length of %d bytes. For some combination of large values, the insert/update operation will fail.

Error: 1946, Severity: 16,
Operation failed. The index entry of length %d bytes for the index ‘%.*ls’ exceeds the maximum length of %d bytes.

Error: 1947, Severity: 16,
Cannot create %S_MSG on view “%.*ls”. The view contains a self join on “%.*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.