topic Re: A new column was added to our source table in SQL Server which automatically added in Target ... in Qlik Replicate

A new column was added to our source table in SQL Server which automatically added in Target but no data is populated

pkagel — Tue, 29 Mar 2022 15:24:53 GMT

A new column was added to our source environment and it automatically was added to the target environment through replicate as I would expect. The issue is there is no data being populated. Is there a setting to have that data start flowing through? I would appreciate any help

Re: A new column was added to our source table in SQL Server which automatically added in Target but no data is populated

SwathiPulagam — Tue, 29 Mar 2022 15:30:10 GMT

Hi @pkagel ,

When the column is added the data transfer should start(when you enable the DDL capture). We need to analyze your scenario so please create a case.

Thanks,

Swathi

Re: A new column was added to our source table in SQL Server which automatically added in Target ...

lyka — Wed, 30 Mar 2022 16:08:21 GMT

Hello,

Can you check if articles were created for this new column that was added?

Thanks

Lyka

Re: A new column was added to our source table in SQL Server which automatically added in Target ...

lyka — Wed, 06 Apr 2022 14:18:50 GMT

Hi @pkagel,

Did any of the proposed solution helped?

Thanks

Lyka

Re: A new column was added to our source table in SQL Server which automatically added in Target ...

Bill_Steinagle — Fri, 29 Jul 2022 18:51:16 GMT

Hello,

Thank you for the post to the QDI forums. If the data is not being captured in the current Table with the added column you can have the Publication Dropped and stop and restart the Replicate Task as this will check and if the Publication is not defined it will create it and add the Articles/Tables which may help correct the condition. As noted by Swathi its dependent on your specific scenario. Hope this information is helpful.

Thanks!

Bill