SQL Server Errors or Failures from Error: 22827 to Error: 22852

Error: 22827, Severity: 16, Peer-to-peer conflict detection alert
Error: 22828, Severity: 16, The publication ‘%s’ was already %s for peer-to-peer conflict detection.
Error: 22829, Severity: 16, The command %s failed. The values specified for the @ins_cmd, @del_cmd or @upd_cmd cannot be appended with schema name %s within the size limit %d.
Error: 22830, Severity: 16, Could not update the metadata that indicates database %s is enabled for Change Data Capture. 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
Error: 22831, Severity: 16, Could not update the metadata that indicates database %s is not enabled for Change Data Capture. 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 resu
Error: 22832, Severity: 16, Could not update the metadata that indicates table %s is enabled for Change Data Capture. 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 th
Error: 22833, Severity: 16, Could not update the metadata that indicates table %s is not
enabled for Change Data Capture. 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 resubmi
Error: 22834, Severity: 16, Could not modify the the verbose logging status for table %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 request.
Error: 22835, Severity: 16, Could not update the metadata for database %s to indicate that a Change Data Capture job has been dropped. 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 failur
Error: 22836, Severity: 16, Could not update the metadata for database %s to indicate that a Change Data Capture job has been added. 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
Error: 22837, Severity: 16, Could not delete table entries or drop objects associated with capture instance ‘%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 re
Error: 22838, Severity: 16, All columns of a CDC unique index must be defined as NOT NULL. Index ‘%s’ selected as the CDC unique index for source table ‘%s.%s’ does not meet this requirement. Define all columns of the selected index as NOT NULL or select another unique index as the
Error: 22840, Severity: 16, The application lock request ‘%s’ needed to modify Change Data Capture metadata was not granted. The value returned from the request was %d: -1 = timeout; -2 = canceled; -3 = deadlock victim; -999 validation or other call error. Examine the error cause an
Error: 22841, Severity: 16, Could not upgrade the metadata for database ‘%s’ that is enabled for Change Data Capture. The failure occurred when executing the action ‘%s’. The error returned was %d: ‘%s’. Use the action and error to determine the cause of the failure and resubmit the
Error: 22842, Severity: 16, ALTERR TABLE SWITCH statement failed because the partitioned destination table is enabled for Change Data Capture and does not have @allow_partition_switch set to 1.
Error: 22843, Severity: 16, ALTERR TABLE SWITCH statement failed because the partitioned source table is enabled for Change Data Capture and does not have @allow_partition_switch set to 1.
Error: 22844, Severity: 16, The ‘%s’ option must be either 1 or 0.
Error: 22850, Severity: 16, The threshold value specified for the Change Data Capture cleanup process must be greater than 0. When creating or modifying the cleanup job, specify a positive threshold value. If this error is encountered when executing the sys.sp_cdc_cleanup_change_tab
Error: 22851, Severity: 16, Could not update cdc.change_tables to indicate a change in the low water mark for database %s.
Error: 22852, Severity: 10, Could not delete change table entries made obsolete by a change in one or more low water marks for capture instances of database %s. The failure occurred when executing the command ‘%s’. The error returned was %d: ‘%s’. Use the action and error to determi
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.