SQL Server Errors or Failures from Error: 22853 to Error: 22907

SQLServerF1

 

Error: 22853, Severity: 10, Could not delete obsolete entries in the cdc.lsn_time_mapping table for database %s. The failure occurred when executing the command ‘%s’. The error returned was %d: ‘%s’. Use the action and error to determine the cause of the failure and resubmit the req
Error: 22854, Severity: 16, Can not enable Change Data Capture on table ‘%s’ or add ColumnSet column to it because CDC does not support ColumnSet.
Error: 22855, Severity: 10, Warning: The @allow_partition_switch parameter is set to 1. Change data capture will not track changes introduced in the table resulting from a partition switch which will cause data inconsistency when changes are consumed. Refer to books online for more
Error: 22856, Severity: 10, Warning: The @allow_partition_switch parameter is set to 0.

ALTERR TABLE … SWITCH PARTITION statement will be disallowed on this partitioned table. Refer to books online for more information about partition switching behavior when using Change Data Captu
Error: 22857, Severity: 10, Warning: The @allow_partition_switch parameter must be 1 for tables that are not partitioned. The explicit setting of the parameter to 0 was ignored. Refer to books online for more information about partition switching behavior when using Change Data Capt
Error: 22858, Severity: 16, Unable to add entries to the Change Data Capture LSN time mapping table to reflect dml changes applied to the tracked tables. Refer to previous errors in the current session to identify the cause and correct any associated problems.

Error: 22859, Severity: 16, Log Scan process failed in processing log records. Refer to previous errors in the current session to identify the cause and correct any associated problems.
Error: 22860, Severity: 16, Log scan process failed in processing a ddl log record. Refer to previous errors in the current session to identify the cause and correct any associated problems.
Error: 22861, Severity: 10, Unable to upgrade database ‘%s’. Error ‘%d’ was raised: ‘%s’. Use the reported error to determine the cause of the failure and then execute sys.sp_cdc_vupgrade in the database context to rerun upgrade.
Error: 22862, Severity: 16, The database snapshot ‘%s’ does not exist. Correct the parameter value and resubmit the request.
Error: 22863, Severity: 16, Failed to insert rows into Change Data Capture change tables. Refer to previous errors in the current session to identify the cause and correct any associated problems.
Error: 22864, Severity: 16, The call to sp_MScdc_capture_job by the Capture Job for database ‘%s’ failed. Look at previous errors for the cause of the failure.
Error: 22865, Severity: 16, The number of columns in the index ‘%s’, used as the unique row identifier to support net changes for table ‘%s’.’%s’, exceeds the limit of 14 columns. Set the parameter @supports_net_changes to 0 or use the @index_name parameter to identify a unique inde
Error: 22901, Severity: 16, The database ‘%s’ is not enabled for Change Data Capture. Ensure that the correct database context is set and retry the operation. To report on the databases enabled for Change Data Capture, query the is_cdc_enabled column in the sys.databases catalog vie
Error: 22902, Severity: 16, Caller is not authorized to initiate the requested action. Sysadmin privileges are required.
Error: 22903, Severity: 16, Another connection is already running ‘sp_replcmds’ for Change Data Capture in the current database.
Error: 22904, Severity: 16, Caller is not authorized to initiate the requested action. DBO privileges are required.
Error: 22905, Severity: 10, Database ‘%s’ is already enabled for Change Data Capture. Ensure that the correct database context is set, and retry the operation. To report on the databases enabled for Change Data Capture, query the is_cdc_enabled column in the sys.databases catalog vi
Error: 22906, Severity: 16, The database ‘%s’ cannot be enabled for Change Data Capture because a database user named ‘cdc’ or a schema named ‘cdc’ already exists in the current database. These objects are required exclusively by Change Data Capture. Drop or rename the user or schem
Error: 22907, Severity: 16, Parameter @role_name cannot be empty. Specify a value for @role_name and retry the operation. Supply null as the value if no role is to be used to gate access to captured change data.

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 *