Table being suspended during CDC

[guilherme-matte]

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 · Accepted solution]

@guilherme-matte 

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:

https://help.qlik.com/en-US/replicate/May2022/Content/Replicate/Main/MicrosoftSQLServer-MSCDC/Micros...

[guilherme-matte]

@shashi_holla  Thank you for the insight!

I will check it out and get back to you.

Cheers

[SushilKumar]

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