I cannot make CDC on SQLSERVER 2019 to work and facing follow error:
Job Log File Viewer:
The call to sp_MScdc_capture_job by the Capture Job fordatabase'XXXX' failed.
SQL Server Log File Viewer:
Process 151 generated fatal exception c000000d EXCEPTION_INVALID_CRT_PARAMETER. SQL Server is terminating this process.
Microsoft SQL Server 2019(RTM-GDR)(KB4517790)-15.0.2070.41(X64) Oct 28201919:56:59 Copyright (C)2019 Microsoft Corporation Enterprise Edition (64-bit)on Windows Server 2019 Standard 10.0<X64>(Build 17763:)(Hypervisor)
I've tried Google the error and it seem to be a bug from 2016 version and prior which already fixed
Did anybody face that issue? I think that might be something related to a bug which prevent my CDC to start.
P/s: I also attached an image of Log File Viewer which execute the CDC stored Procedure and exception