SQL Server Errors or Failures from Error: 22978 to Error: 22997

SQLServerF1

 

Error: 22978, Severity: 16, Could not update the cdc.captured_columns entry for column ‘%s’ of change table ‘%s’ to reflect a data type change in the corresponding column of the source table ‘%s’. Change Data Capture column meta data for table ‘%s’ no longer accurately reflects the
Error: 22979, Severity: 16, The unique index ‘%s’ on table ‘%s’ is used by Change Data Capture. The constraint using this index cannot be dropped or disabled.
Error: 22980, Severity: 16, The unique index ‘%s’ on table ‘%s.%s’ is disabled and cannot be used as a unique index by Change Data Capture. Enable the index.
Error: 22981, Severity: 16, Object does not exist or access is denied.

Error: 22982, Severity: 16, Could not create internal stored procedures used to populate the change table for capture instance ‘%s’ and source table ‘%s.%s’. Refer to previous errors in the current session to identify the cause and correct any associated problems.
Error: 22983, Severity: 16, The unique index ‘%s’ on source table ‘%s’ is used by Change Data Capture. To alter or drop the index, you must first disable Change Data Capture on the table.

Error: 22984, Severity: 16, An error occurred while waiting on the log reader history cache event. This error is reported by the internal task scheduling and might be transient. Retry the operation.
Error: 22985, Severity: 16, Change data capture has not been enabled for source table ‘%s.%s’. Specify the name of a table enabled for Change Data Capture. To report on the tables enabled for Change Data Capture, query the is_tracked_by_cdc column in the sys.tables catalog view.
Error: 22986, Severity: 16, Could not allocate memory for Change Data Capture population. Verify that SQL Server has sufficient memory for all operations. Check the physical and virtual memory settings on the server and examine memory usage to see if another application is consuming
Error: 22987, Severity: 16, Change Data Capture population failed writing blob data for one or more large object columns. Verify that SQL Server has sufficient memory for all operations. Check the physical and virtual memory settings on the server and examine memory usage to see if
Error: 22988, Severity: 16, This instance of SQL Server is the %s. Change data capture is only available in the Enterprise, Developer, and Enterprise Evaluation editions.
Error: 22989, Severity: 16, Could not enable Change Data Capture for database ‘%s’. Change data capture is not supported on system databases, or on a distribution database.
Error: 22990, Severity: 16, The value specified for the parameter @pollinginterval cannot exceed 24 hours or be less than 0. Specify a polling interval (in seconds) that is less than or equal to 24 hours (86,400 seconds).
Error: 22991, Severity: 16, The value specified for the parameter @maxtrans must be greater than 0.
Error: 22992, Severity: 16, The specified @job_type, %s, is not supported. The value specified for the parameter @job_type must be N’capture’ to indicate a capture job, or N’cleanup’ to indicate a cleanup job.
Error: 22993, Severity: 16, The Change Data Capture job table containing job information for database ‘%s’ cannot be found in the msdb system database. Run the stored procedure ‘sys.sp_cdc_add_job’ to create the appropriate CDC capture or cleanup job. The stored procedure will creat
Error: 22994, Severity: 16, The retention value specified for the Change Data Capture cleanup process must be greater than 0 and less than or equal to 52594800. When creating or modifying the cleanup job, specify a retention value (in minutes) that is within that range. If this erro
Error: 22995, Severity: 16, A value for the parameter @retention cannot be specified when the job type is ‘capture’. Specify NULL for the parameter, or omit the parameter from the statement.
Error: 22996, Severity: 16, When adding or modifying the CDC cleanup job, @pollinginterval, @maxtrans, @maxscans, and @continuous may not be assigned non-null values.
Error: 22997, Severity: 16, The Change Data Capture ‘%s’ job does not exist in the system table ‘msdb.dbo.cdc_jobs’. Use the stored procedure ‘sys.sp_cdc_add_job’ to add the Change Data Capture job.

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 *