topic Re: Table being suspended during CDC in Qlik Replicate

Table being suspended during CDC

guilherme-matte — Mon, 09 Oct 2023 22:04:49 GMT

Hello Team

I've been having the following issue with a table during CDC

This error suspends the whole task:

This error suspends just the table, but both references the same.

We are replicating using MS-CDC from an on premises database to an Azure SQL db

Would anyone know what could be any of the issues? Seems like something is going bad when converting the UI to int?

Cheers!

shashi_holla — Mon, 09 Oct 2023 22:23:23 GMT

Looks the target table was not created by Replicate, as by default uniqueidentifier data type maps to STRING in Replicate and INT is not correct.

Here is the user guide link:

guilherme-matte — Mon, 09 Oct 2023 22:36:44 GMT

@shashi_holla Thank you for the insight!

I will check it out and get back to you.

Cheers

SushilKumar — Tue, 10 Oct 2023 07:20:06 GMT

Hello team,

If our response has been helpful, please consider clicking "Accept as Solution". This will assist other users in easily finding the answer.

Regards,

Sushil Kumar