SQL Server Errors or Failures from Error: 22908 to Error: 22931

SQLServerF1

 

Error: 22908, Severity: 16, Could not create the Change Data Capture objects in database ‘%s’. Refer to previous errors in the current session to identify the cause and correct any associated problems.
Error: 22909, Severity: 16, Failed to cleanup the cdc.lsn_time_mapping table in database ‘%s’ when the last database table enabled for Change Data Capture was disabled. Refer to previous errors in the current session to identify the cause and correct any associated problems.
Error: 22910, Severity: 16, The cleanup request for database ‘%s’ failed. The database is not enabled for Change Data Capture.

Error: 22911, Severity: 16, The capture job cannot be used by Change Data Capture to extract changes from the log when transactional replication is also enabled on the same database. When Change Data Capture and transactional replication are both enabled on a database, use the logre
Error: 22913, Severity: 16, Could not drop the Change Data Capture objects in database ‘%s’. Refer to previous errors in the current session to identify the cause and correct any associated problems.
Error: 22914, Severity: 16, Only members of the sysadmin or db_owner or db_ddladmin roles can perform this operation when Change Data Capture is enabled for a database.

Error: 22916, Severity: 16, Could not grant SELECT permission for the change enumeration functions for capture instance ‘%s’ and source table ‘%s.%s’ for the specified role. Refer to previous errors in the current session to identify the cause and correct any associated problems.
Error: 22918, Severity: 16, One or more columns in the list of included columns was not a captured column of the change table %s.
Error: 22919, Severity: 16, One or more columns in the list of columns needing update flags was not a captured column of the change table %s.
Error: 22920, Severity: 16, The named capture instance %s does not exist for database %s.
Error: 22921, Severity: 16, Unable to generate scripts for all capture instances that the caller is authorized to access. To generate all such scripts, the parameters @column_list and @update_flag_list must both be null or empty.’
Error: 22923, Severity: 16, Could not compute the new low endpoint for database ‘%s’ from retention %d. Refer to previous errors in the current session to identify the cause and correct any associated problems.
Error: 22924, Severity: 16, Could not clean up change tables for database ‘%s’. A failure occurred when attempting to clean up the database change tables based upon the current retention time. Refer to previous errors in the current session to identify the cause and correct any asso
Error: 22925, Severity: 16, The number of columns captured by capture instance ‘%s’ exceeds the maximum allowed number: %d. Use the @captured_columns_list parameter to specify a subset of the columns less than or equal to the maximum allowed and resubmit the request.
Error: 22926, Severity: 16, Could not create a capture instance because the capture instance name ‘%s’ already exists in the current database. Specify an explicit unique name for the parameter @capture_instance.
Error: 22927, Severity: 16, Capture instance name ‘%s’ exceeds the length limit of 100 characters. Specify a name that satisfies the length constraint.
Error: 22928, Severity: 16, Index name ‘%s’ is not an index for table ‘%s.%s’. Specify a valid index name for the table.
Error: 22929, Severity: 16, Index ‘%s’ must be either a primary key or a unique index for table ‘%s.%s’. Specify an index that meets at least one of these requirements.
Error: 22930, Severity: 16, Could not locate ‘%s’ as a column of source table ‘%s.%s’. Specify a valid column name.
Error: 22931, Severity: 16, Source table ‘%s.%s’ does not exist in the current database. Ensure that the correct database context is set. Specify a valid schema and table name for the database.

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 *