topic Re: Question regarding steps from article on solving issue with MS-CDC table structure changes in Qlik Replicate

Question regarding steps from article on solving issue with MS-CDC table structure changes

MoeE — Wed, 03 Jun 2026 00:35:57 GMT

Hi,

I was reading through this article as our client is experiencing the same issue. The client has changed the base table structure and they are using MS-CDC so I was reading the relevant section that addresses this specific scenario from the article:

These steps are a little vague. Especially step 3.

I believe step 3 means to truncate the MS-CDC table on the source and not the actual source table.

Then in step 4, I believe the steps are to truncate the table on the target platform and then reload the data via QR. Is this correct?

Assistance with this is appreciated.

Thank you,

Mohammed

Re: Question regarding steps from article on solving issue with MS-CDC table structure changes

john_wang — Thu, 04 Jun 2026 15:30:26 GMT

Hello Mohammed, @MoeE

The article appears to be accurate.

In Step 3, it refers to truncating the source table (EMPLOYEE2_table in the example), not the MS-CDC change table ([cdc].[dbo_EMPLOYEE2_table_CT]).

The CDC change table (__CT) will already have been dropped in Step 2.

Step 4 also appears to be correct.

Please feel free to let me know if I have overlooked anything.

thanks,
John.

Re: Question regarding steps from article on solving issue with MS-CDC table structure changes

DesmondWOO — Fri, 05 Jun 2026 02:47:18 GMT

Hi @MoeE ,

You cannot truncate a source table while CDC is enabled. Therefore, you must first disable CDC for the table (Step 2) before performing the truncation (Step 3).

Regards,
Desmond