CDC functionality may break after upgrading to the latest CU for SQL Server 2012, 2014 and 2016

Share this Post

This problem was brought to our attention recently by one of our customers.

CDC LogScan job fails, possible Error Message:

Log Scan process failed in processing log records.
Operand type clash: int is incompatible with uniqueidentifier
Operand type clash: int is incompatible with datetime
The Log-Scan Process failed to construct a replicated command from log sequence number

Procedure or function sp_batchinsert_<nnnn> has too many arguments specified.

Within hours our SQL Server product team tracked down the problem and released the following technical paper with a simple solution to get CDC back up and running.

Share this Post
Tags: ,

Leave a Reply

Your email address will not be published. Required fields are marked *

This site uses Akismet to reduce spam. Learn how your comment data is processed.