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


Chris Skorlinski
SQL Server Escalation Services

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.

https://blogs.msdn.microsoft.com/sql_server_team/cdc-functionality-may-break-after-upgrading-to-the-latest-cu-for-sql-server-2012-2014-and-2016/

 

 


Comments (0)

Skip to main content