How To Sync New Column On Target

[AgusBudianto]

We have added a new column, 'DCFLAG', to the PRVDPF table at the source, and it has been successfully synchronized with the following Log Stream task

However, the column is missing in the CDC task. How can I sync 'DCFLAG'? To assist with your analysis

[DesmondWOO]

Hi @AgusBudianto ,

Since the DDL option is set to “ignore,” Qlik Replicate did not apply the new column to the target table. Please follow these steps to align the source and target:

1. Add the new column to the source table. This DDL change will be captured by the Logstream staging task (parent).
2. Stop the replicate task (child).
3. Manually add the new column to the target table and __ct table.
4. Open the transformation settings for the replication task and ensure the new column appears in both Input and Output.
5. Resume the task.

Important: Please test these steps in the UAT environment before applying them in production.

Regards,
Desmond

[AgusBudianto]

Hi @DesmondWOO 

I've done it, and as you can see for point 4 in the Input and Output, the new column doesn't appear.

Then we attempted to reload the Log Stream task, and the new column is now present. However, some tasks failed because the logs are unavailable. Is this approach sufficient? Also, will performing a reload cause data loss on the target table or within the Log Stream itself?

BTW, can I reload just one table in Log Stream? I've tried, but the reload button is greyed out.

Regards,

Anto

[DesmondWOO]

Hi @AgusBudianto ,

In my test environment, I used SQL Server as both source and target for a LogStream task. The newly added column was visible in the transformation page. Since I do not know the exact configuration and environment of your task, I recommend opening a support ticket to confirm the behavior in your setup.

Regarding “reload”:

• If you reload the staging task (parent), Qlik Replicate will capture changes starting from the current timestamp, and any previous changes will be skipped.
• If you reload the replication task (child), a full load will be performed. Changes won't be lost.

To reload a single table only:

1. In the Qlik Replicate console, open the Monitor page for your replication task (child).
2. Select the table you want to reload.
3. Click the reload icon above the table list.  This will trigger a full load for the selected table only.
   

Regards,
Desmond