topic Repl-cdc capture job for the database 'cdc.DB_capture' is not started ,source Microsoft Azure SQL MS CDC in Qlik Replicate

Repl-cdc capture job for the database 'cdc.DB_capture' is not started ,source Microsoft Azure SQL MS CDC

toni_lajsner — Mon, 18 Mar 2024 09:04:10 GMT

After an maintainance weekend we started to recive following massage :
Fitness check - failed: Repl-cdc capture job for the database 'cdc.DB_capture' is not started

I have looked at our source database and cdc is working :

tables are also tracked by cdc

Issue:

So it is saying that capture is ont started but i can see that cdc is enabled on database, do you have an idea what this can be ?

Re: Repl-cdc capture job for the database 'cdc.DB_capture' is not started ,source Microsoft Azure SQL MS CDC

Kent_Feng — Tue, 19 Mar 2024 23:45:09 GMT

Hi @toni_lajsner

You need to make sure the MS-CDC capture and cleanup jobs are running, following Preparing the database for CDC of the user's guide.

If you are sure everything is set properly and you still get the error, you can try skipping the fitness check by setting the internal parameter skipMscdcJobFitnessCheck to true at the source endpoint, referring to this article of our knowledge base: Qlik Replicate task message: Failed in MS-CDC fitness check

Hope the information is helpful to you.

Thanks

Kent