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 for database 'XXXX' failed.
SQL Server Log File Viewer:
Process 151 generated fatal exception c000000d EXCEPTION_INVALID_CRT_PARAMETER. SQL Server is terminating this process.
SQLSERVER @@version:
Microsoft SQL Server 2019 (RTM-GDR) (KB4517790) - 15.0.2070.41 (X64) Oct 28 2019 19: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
