Dismiss Notice

Register now to be one of the first members of this SharePoint Community! Click here it just takes seconds!

Dismiss Notice
Welcome Guest from Country Flag

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

Discussion in 'Official Microsoft News' started by Chris Skorlinski [MSFT], Apr 8, 2017.

Thread Status:
Not open for further replies.
  1. Chris Skorlinski [MSFT]

    Chris Skorlinski [MSFT] Guest

    Blog Posts:
    0
    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/sq...-latest-cu-for-sql-server-2012-2014-and-2016/

    Continue reading...
     
Thread Status:
Not open for further replies.

Share This Page

LiveZilla Live Chat Software