J
JeffTavares
Guest
We are getting the below error on our cdc jobs. Any ideas would be helpful it appears to have happened after SQL2016CU was applied on 3/24/2019.
The server host version is:
Microsoft SQL Server 2014 (SP3-CU2) (KB4482960) - 12.0.6214.1 (X64) Feb 2 2019 01:10:18
Enterprise Edition: Core-based Licensing (64-bit) on Windows NT 6.3 <X64> (Build 9600: ) (Hypervisor)
Any assistance would be helpful.
Errors:
Date 3/24/2019 8:32:01 AM
Log Job History (cdc.Participant_capture)
Step ID 2
Server SQLP3PROD02-14
Job Name cdc.Participant_capture
Step Name Change Data Capture Collection Agent
Duration 00:21:54
Sql Severity 16
Sql Message ID 22864
Operator Emailed
Operator Net sent
Operator Paged
Retries Attempted 10
Message
Executed as user: NYLIMRPS\sqlagentstartup.
The Log-Scan Process failed to construct a replicated command from log sequence number (LSN) {0006cd25:00000108:0002}.
Back up the publication database and contact Customer Support Services. [SQLSTATE 42000] (Error 18805)
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. [SQLSTATE 42000] (Error 22859)
The statement has been terminated. [SQLSTATE 42000] (Error 3621)
The call to sp_MScdc_capture_job by the Capture Job for database 'Participant' failed.
Look at previous errors for the cause of the failure. [SQLSTATE 42000] (Error 22864).
NOTE: The step was retried the requested number of times (10) without succeeding. The step failed.
Message
Entry Time 2019-03-24 08:53:55.907, Msg 8144, Level 16, State 2,
Procedure or function sp_batchinsert_1524200480 has too many arguments specified.
For more information, query the sys.dm_cdc_errors dynamic management view.
Continue reading...
The server host version is:
Microsoft SQL Server 2014 (SP3-CU2) (KB4482960) - 12.0.6214.1 (X64) Feb 2 2019 01:10:18
Enterprise Edition: Core-based Licensing (64-bit) on Windows NT 6.3 <X64> (Build 9600: ) (Hypervisor)
Any assistance would be helpful.
Errors:
Date 3/24/2019 8:32:01 AM
Log Job History (cdc.Participant_capture)
Step ID 2
Server SQLP3PROD02-14
Job Name cdc.Participant_capture
Step Name Change Data Capture Collection Agent
Duration 00:21:54
Sql Severity 16
Sql Message ID 22864
Operator Emailed
Operator Net sent
Operator Paged
Retries Attempted 10
Message
Executed as user: NYLIMRPS\sqlagentstartup.
The Log-Scan Process failed to construct a replicated command from log sequence number (LSN) {0006cd25:00000108:0002}.
Back up the publication database and contact Customer Support Services. [SQLSTATE 42000] (Error 18805)
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. [SQLSTATE 42000] (Error 22859)
The statement has been terminated. [SQLSTATE 42000] (Error 3621)
The call to sp_MScdc_capture_job by the Capture Job for database 'Participant' failed.
Look at previous errors for the cause of the failure. [SQLSTATE 42000] (Error 22864).
NOTE: The step was retried the requested number of times (10) without succeeding. The step failed.
Message
Entry Time 2019-03-24 08:53:55.907, Msg 8144, Level 16, State 2,
Procedure or function sp_batchinsert_1524200480 has too many arguments specified.
For more information, query the sys.dm_cdc_errors dynamic management view.
Continue reading...