SQL Server Errors or Failures from Error: 22511 to Error: 22530

SQLServerF1

 

Error: 22511, Severity: 16, The merge completed successfully.
Error: 22512, Severity: 16, Cannot use partition groups with unfiltered publications. Set “use_partition_groups” to “false” using sp_changemergepublication.
Error: 22513, Severity: 16, Cannot use partition groups because the join filter between the following articles contains one or more functions: “%s” and “%s”.
Error: 22514, Severity: 16, Cannot use partition groups because one or more filters reference the following view, which contains functions: “%s”.

Error: 22515, Severity: 16, The publication cannot use precomputed partitions because there is at least one circular reference in the join filters specified for the articles in the publication. To use precomputed partitions, ensure that no circular join filter relationships exist.
Error: 22516, Severity: 16, The publication “%s” was defined as having dynamic filters, but it does not contain any dynamic filters.
Error: 22517, Severity: 16, The publication was defined as having no dynamic filters, but contains one or more dynamic filters.

Error: 22518, Severity: 16, Cannot use column of type image, ntext, xml, CLR type, varchar(max), nvarchar(max), or varbinary(max) in a subset or join filter for article: ‘%s’.
Error: 22519, Severity: 16, Cannot add a logical record relationship between tables “%s” and “%s” because a text, image, ntext, xml, varchar(max), nvarchar(max), or varbinary(max) column was referenced in the join clause.
Error: 22520, Severity: 10, A filtering type changed for the article. Any pending or future changes made in this article by a Subscriber in a given partition will no longer be propagated to Subscribers in other partitions. Check the documentation for details.
Error: 22521, Severity: 10, Unable to synchronize the row because the row was updated by a different process outside of replication.
Error: 22522, Severity: 16, Article ‘%s’ cannot be published because it is published in another merge publication. An article that has a value of 3 for the @partition_options parameter of sp_addmergearticle (nonoverlapping partitions with a single subscription per partition) cannot
Error: 22523, Severity: 16, An article cannot use @partition_options 2 or 3 (nonoverlapping partitions) and be a part of a logical record relationship at the same time. Check article “%s”.
Error: 22524, Severity: 16, Article ‘%s’ is published in another merge publication, with a different value specified for the @partition_options parameter of sp_addmergearticle. The specified value must be the same in all merge publications. Either specify the same value as the exist
Error: 22525, Severity: 16, The publication “%s” cannot allow multiple subscriptions per partition if it contains articles using @partition_options = 3.
Error: 22526, Severity: 16, An invalid value was specified for %s. Valid values are 0 (none), 1 (enforced partitions), 2 (nonoverlapping partitions with multiple subscriptions per partition), and 3 (nonoverlapping partitions with single subscription per partition).
Error: 22527, Severity: 16, Invalid value specified for %s. Valid values are ‘day’, ‘days’, ‘dd’, ‘year’, ‘years’, ‘yy’, ‘yyyy’, ‘month’, ‘months’, ‘mm’, ‘week’, ‘weeks’, ‘wk’, ‘hour’, ‘hours’, ‘hh’, ‘minute’, ‘minutes’, ‘mi’.
Error: 22528, Severity: 16, Cannot use a retention period unit other than “days” for publication “%s” because the compatibility level of the publication is lower than 90. Use sp_changemergepublication to set publication_compatibility_level to 90RTM.
Error: 22529, Severity: 16, Cannot change the retention period unit for publication “%s” because the compatibility level of the publication is lower than 90. Use sp_changemergepublication to set publication_compatibility_level to 90RTM.
Error: 22530, Severity: 16, Cannot update any column in article “%s” that is used in a logical record relationship clause.

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 from Error: 6611 to Error: 6717

SQLServerF1

 

Error: 6611, Severity: 16, The XML data type is damaged.
Error: 6613, Severity: 16, Specified value ‘%ls’ already exists.
Error: 6621, Severity: 16, XML encoding or decoding error occurred with object name ‘%.*ls’.
Error: 6622, Severity: 16, Invalid data type for column “%ls”. The data type cannot be text, ntext, image, binary, varchar(max), nvarchar(max), varbinary(max), or xml.
Error: 6623, Severity: 16, Column ‘%ls’ contains an invalid data type. Valid data types are char, varchar, nchar, and nvarchar.
Error: 6624, Severity: 16, XML document could not be created because server memory is low. Use sp_xml_removedocument to release XML documents.

Error: 6625, Severity: 16, Could not convert the value for OPENXML column ‘%ls’ to sql_variant data type. The value is too long. Change the data type of this column to text, ntext or image.
Error: 6626, Severity: 16, Unexpected end of data stream.
Error: 6627, Severity: 16, The size of the data chunk that was requested from the stream exceeds the allowed limit.
Error: 6628, Severity: 16, %.*ls can only process untyped XML. Cast the input value to XML or to a string type.
Error: 6629, Severity: 16, The result of the column expression for column “%ls” is not compatible with the requested type “XML”. The result must be an element, text node, comment node, processing instruction, or document node.
Error: 6630, Severity: 16, Element-centric mapping must be used with OPENXML when one of the columns is of type XML.
Error: 6631, Severity: 16, The requested OpenXML document is currently in use by another thread, and cannot be used.

Error: 6632, Severity: 16, Invalid data type for the column “%ls”. CLR types cannot be used in an OpenXML WITH clause.
Error: 6633, Severity: 16, The version of MSXMLSQL.DLL that was found is older than the minimum required version. Found version “%d.%d.%d”. Require version “%d.%d.%d”.
Error: 6634, Severity: 16, OpenXML cannot be used as the target of a DML or OUTPUT INTO operation.
Error: 6700, Severity: 16, XQuery: The ‘ %ls’ operation is not supported.
Error: 6701, Severity: 16, The version of the XML index that you are trying to use is not supported anymore. Please drop and recreate the XML index.
Error: 6716, Severity: 16, XML Node ID is invalid. Re-build the database if the problem persists.
Error: 6717, Severity: 16, XQuery: The document tree is too deep. If the problem persists you must simplify the XML hierarchy.

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 from Error: 5310 to Error: 5331

SQLServerF1

 

Error: 5310, Severity: 16, Aggregates are not allowed in the VALUES list of an INSERT statement.
Error: 5311, Severity: 16, Invalid quote character ‘%lc’. A remote server or user command used an invalid quote character.
Error: 5312, Severity: 16, The input to the function ‘ntile’ cannot be bound.
Error: 5313, Severity: 16, Synonym ‘%.*ls’ refers to an invalid object.
Error: 5315, Severity: 16, The target of a MERGE statement cannot be a remote table, a remote view, or a view over remote tables.
Error: 5316, Severity: 16, The target ‘%.*ls’ of the MERGE statement has an INSTEAD OF trigger on some, but not all, of the actions specified in the MERGE statement. In a MERGE statement, if any action has an enabled INSTEAD OF trigger on the target, then all actions must have enab

Error: 5317, Severity: 16, The target of a MERGE statement cannot be a partitioned view.
Error: 5318, Severity: 16, In a MERGE statement, the source and target cannot have the same name or alias. Use different aliases for the source and target to ensure that they have unique names in the MERGE statement.
Error: 5319, Severity: 16, Aggregates are not allowed in a WHEN clause of a MERGE statement.
Error: 5321, Severity: 16, The ‘%ls’ function is not allowed in the %S_MSG clause when the FROM clause contains a nested INSERT, UPDATE, DELETE, or MERGE statement.
Error: 5322, Severity: 16, An aggregate function is not allowed in the %S_MSG clause when the FROM clause contains a nested INSERT, UPDATE, DELETE, or MERGE statement.
Error: 5323, Severity: 15, Subqueries are not allowed in the %S_MSG clause when the FROM clause contains a nested INSERT, UPDATE, DELETE, or MERGE statement.

Error: 5324, Severity: 15, In a MERGE statement, a ‘%S_MSG’ clause with a search condition cannot appear after a ‘%S_MSG’ clause with no search condition.
Error: 5325, Severity: 15, The order of the data in the data file does not conform to the ORDER hint specified for the BULK rowset ‘%.*ls’. The order of the data must match the order specified in the ORDER hint for a BULK rowset. Update the ORDER hint to reflect the order in which
Error: 5326, Severity: 15, The data in the data file does not conform to the UNIQUE hint specified for the BULK rowset ‘%.*ls’. The data in the data file must be unique if the UNIQUE hint is specified for a BULK rowset. Remove the UNIQUE hint, or update the input data file to ensur
Error: 5327, Severity: 15, The column ‘%.*ls’ does not have a valid data type for the ORDER hint specified for data source ‘%.*ls’. The text, ntext, image, xml, varchar(max), nvarchar(max) and varbinary(max) data types cannot be used in the ORDER hint for a BULK rowset or CLR TVF.
Error: 5328, Severity: 15, Cannot insert explicit value for the identity column ‘%.*ls’ in the target table ‘%.*ls’ of the INSERT statement when the FROM clause contains a nested INSERT, UPDATE, DELETE, or MERGE statement.
Error: 5329, Severity: 15, Windowed functions are not allowed in the %S_MSG clause when the FROM clause contains a nested INSERT, UPDATE, DELETE, or MERGE statement.
Error: 5330, Severity: 16, Full-text predicates cannot appear in the OUTPUT clause.
Error: 5331, Severity: 16, Full-text predicates cannot appear in the %S_MSG clause when the FROM clause contains a nested INSERT, UPDATE, DELETE, or MERGE statement.

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.

 

SQL Server Errors or Failures Error: 1709 to Error: 1728

SQLServerF1

 

Error: 1709, Severity: 16,
Cannot use TEXTIMAGE_ON when a table has no text, ntext, image, varchar(max), nvarchar(max), non-FILESTREAM varbinary(max), xml or large CLR type columns.

Error: 1710, Severity: 10,
Cannot use alias type with rule or default bound to it as a column type in table variable or return table definition in table valued function. Type ‘%.*ls’ has a %S_MSG bound to it.

Error: 1711, Severity: 16,
Cannot define PRIMARY KEY constraint on column ‘%.*ls’ in table ‘%.*ls’. The computed column has to be persisted and not nullable.

Error: 1712, Severity: 16,
Online index operations can only be performed in Enterprise edition of SQL Server.

Error: 1713, Severity: 16,
Cannot execute %ls on/using table ‘%.*ls’ since the table is the target table or part of cascading actions of a currently executing trigger.

Error: 1714, Severity: 16,
Altr table failed because unique column IDs have been exhausted for table ‘%.*ls’.

Error: 1715, Severity: 16,
Foreign key ‘%.*ls’ creation failed. Only NO ACTION referential update action is allowed for referencing computed column ‘%.*ls’.

Error: 1716, Severity: 16,
FILESTREAM_ON cannot be specified when a table has no FILESTREAM columns. Remove the FILESTREAM_ON clause from the statement, or add a FILESTREAM column to the table.

Error: 1717, Severity: 16,
FILESTREAM_ON cannot be specified together with a partition scheme in the ON clause.

Error: 1718, Severity: 16,
Change tracking must be enabled on database ‘%.*ls’ before it can be enabled on table ‘%.*ls’.

Error: 1719, Severity: 16,
FILESTREAM data cannot be placed on an empty filegroup.

Error: 1720, Severity: 16,
Cannot drp FILESTREAM filegroup or partition scheme since table ‘%.*ls’ has FILESTREAM columns.

Error: 1721, Severity: 16,
Altering table ‘%.*ls’ failed because the row size using vardecimal storage format exceeds the maximum allowed table row size of %d bytes.

Error: 1722, Severity: 16,
Cannot %S_MSG %S_MSG ‘%.*ls’ since a partition scheme is not specified for FILESTREAM data.

Error: 1723, Severity: 16,
Cannot %S_MSG %S_MSG ‘%.*ls’ since a partition scheme was specified for FILESTREAM data but not for the table.

Error: 1724, Severity: 16,
Filegroup ‘%.*ls’ is not a FILESTREAM filegroup or partition scheme of FILESTREAM filegroups.

Error: 1725, Severity: 16,
Cannot add FILESTREAM column to %S_MSG ‘%.*ls’ because an INSTEAD OF trigger exists on the %S_MSG.

Error: 1726, Severity: 16,
Cannot add FILESTREAM filegroup or partition scheme since table ‘%.*ls’ has a FILESTREAM filegroup or partition scheme already.

Error: 1727, Severity: 16,
Cannot create non-clustered index ‘%.*ls’ on table ‘%.*ls’ with the FILESTREAM_ON clause.

Error: 1728, Severity: 16,
Cannot create index ‘%.*ls’ on table ‘%.*ls’ because the computed column ‘%.*ls’ uses a FILESTREAM column.

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.