SQL Server Errors or Failures from Error: 35330 to Error: 35353

SQLServerF1

Error: 35330, Severity: 16, %S_MSG statement failed because data cannot be updated in a table with a columnstore index. Consider disabling the columnstore index before issuing the %S_MSG statement, then rebuilding the columnstore index after %S_MSG is complete.

Error: 35334, Severity: 15, DBCC DBREINDEX failed because specifying FILLFACTOR is not allowed when creating or rebuilding a columnstore index. Rebuild the columnstore index without specifying FILLFACTOR.
Error: 35336, Severity: 15, CREATE INDEX statement failed because specifying key list is missing when creating an index. Create the index with specifying key list .
Error: 35337, Severity: 16, UPDATE STATISTICS failed because statistics cannot be updated on a columnstore index. UPDATE STATISTICS is valid only when used with the STATS_STREAM option.

Error: 35338, Severity: 16, Clustered columnstore index is not supported.
Error: 35339, Severity: 16, Multiple nonclustered columnstore indexes are not supported.
Error: 35340, Severity: 16, Conversion between columnstore index and relational index is not supported.
Error: 35341, Severity: 16, CREATE INDEX statement failed. A columnstore index cannot include a decimal or numeric data type with a precision greater than 18. Reduce the precision of column ‘%.*ls’ to 18 or omit column ‘%.*ls’.
Error: 35342, Severity: 16, CREATE INDEX statement failed. A columnstore index cannot include a datetimeoffset data type with a precision greater than 2. Reduce the precision of column ‘%.*ls’ to 2 or omit column ‘%.*ls’.
Error: 35343, Severity: 15, CREATE INDEX statement failed. Column ‘%.*ls’has a data type that cannot participate in a columnstore index. Omit column ‘%.*ls’.

Error: 35344, Severity: 16, MERGE clause of ALTER PARTITION statement failed because two nonempty partitions containing a columnstore index cannot be merged. Consider disabling the columnstore index before issuing the ALTER PARTITION statement, then rebuilding the columnstore index
Error: 35345, Severity: 16, MERGE clause of ALTER PARTITION statement failed because two partitions on different filegroups cannot be merged if either partition contains columnstore index data. Consider disabling the columnstore index before issuing the ALTER PARTITION statement, th
Error: 35346, Severity: 16, SPLIT clause of ALTER PARTITION statement failed because the partition is not empty. Only empty partitions can be split in when a columnstore index exists on the table. Consider disabling the columnstore index before issuing the ALTER PARTITION statement
Error: 35347, Severity: 16, The stored procedure, sp_tableoption failed because a table with a nonclustered columnstore index cannot be altered to use vardecimal storage format. Consider dropping the columnstore index.
Error: 35348, Severity: 16, CREATE INDEX statement failed because table ‘%.*ls’ uses vardecimal storage format. A columnstore index cannot be created on a table using vardecimal storage. Consider rebuilding the table without vardecimal storage.
Error: 35349, Severity: 16, TRUNCATEE TABLE statement failed because table ‘%.*ls’ has a columnstore index on it. A table with a columnstore index cannot be truncated. Consider dropping the columnstore index then truncating the table.
Error: 35350, Severity: 16, CREATE INDEX statement failed because a columnstore index on a partitioned table must be partition-aligned with the base table. Consider dropping the columnstore index before creating a new clustered index.
Error: 35351, Severity: 16, DROP INDEX statement failed because a columnstore index on a partitioned table must be partition-aligned with the base table (heap). Consider dropping the columnstore index before dropping a clustered index.
Error: 35352, Severity: 16, %S_MSG statement failed because the operation cannot be performed online on a table with a columnstore index. Perform the operation without specifying the ONLINE option or drop (or disable) the columnstore index before performing the operation using the O
Error: 35353, Severity: 16, %s cannot be enabled on a table with a columnstore index. Consider dropping columnstore index ‘%s’ on table ‘%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.

 

Leave a Reply

Your email address will not be published. Required fields are marked *