April 24, 2018 at 9:18 am
Hi.
I am getting the following errors in my CDC Capture job that is failing.
The Log-Scan Process failed to construct a replicated command from log sequence number (LSN) {00000783:0020e794:0052}. 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 'DB' failed. Look at previous errors for the cause of the failure. [SQLSTATE 42000] (Error 22864)
Entry Time 2018-04-19 10:15:47.087, Msg 22859, Level 16, State 2, 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. For more information, query the sys.dm_cdc_errors dynamic management view.
Entry Time 2018-04-19 10:15:47.087, Msg 18805, Level 16, State 1, The Log-Scan Process failed to construct a replicated command from log sequence number (LSN) {00000783:0020e794:0052}. Back up the publication database and contact Customer Support Services. For more information, query the sys.dm_cdc_errors dynamic management view.
Entry Time 2018-04-19 10:15:47.087, Msg 206, Level 16, State 2, Operand type clash: uniqueidentifier is incompatible with decimal For more information, query the sys.dm_cdc_errors dynamic management view.
Has anyone came across these problems?
April 24, 2018 at 9:28 am
Unless someone changed a datatype somewhere, it sounds like there might be corruption in the transaction log file. I''d look at running some DBCC commands to figure out what's going on. You'll need to Google search for which ones, but I'm pretty sure you need DBCC CHECKDB, but the parameters will need searching for...
Steve (aka sgmunson) 🙂 🙂 🙂
Rent Servers for Income (picks and shovels strategy)
April 24, 2018 at 11:05 am
Data type changes Steve noted really could be part of the problem. This bug wasn't addressed a few months ago - don't know the status now:
New Bug: Change Data Capture (CDC) Fails after ALTER COLUMN
Sue
April 28, 2018 at 10:50 am
juniorDBA13 - Tuesday, April 24, 2018 9:18 AMHi.I am getting the following errors in my CDC Capture job that is failing.
The Log-Scan Process failed to construct a replicated command from log sequence number (LSN) {00000783:0020e794:0052}. 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 'DB' failed. Look at previous errors for the cause of the failure. [SQLSTATE 42000] (Error 22864)
Entry Time 2018-04-19 10:15:47.087, Msg 22859, Level 16, State 2, 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. For more information, query the sys.dm_cdc_errors dynamic management view.
Entry Time 2018-04-19 10:15:47.087, Msg 18805, Level 16, State 1, The Log-Scan Process failed to construct a replicated command from log sequence number (LSN) {00000783:0020e794:0052}. Back up the publication database and contact Customer Support Services. For more information, query the sys.dm_cdc_errors dynamic management view.
Entry Time 2018-04-19 10:15:47.087, Msg 206, Level 16, State 2, Operand type clash: uniqueidentifier is incompatible with decimal For more information, query the sys.dm_cdc_errors dynamic management view.
Has anyone came across these problems?
Why can't you try this, Which was mentioned in error message ?
For more information, query the sys.dm_cdc_errors dynamic management view.
May 1, 2018 at 8:24 am
Because sys.dm_cdc_errors gives me the same information
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..
Operand type clash: uniqueidentifier is incompatible with decimal
The Log-Scan Process failed to construct a replicated command from log sequence number (LSN) {00000783:0020e794:0052}. Back up the publication database and contact Customer Support Services.
Viewing 5 posts - 1 through 4 (of 4 total)
You must be logged in to reply to this topic. Login to reply