Qlik Replicate and Snowflake and logstream task: Data is missing in CDC table __CT

[Dineshan]

Scenario:

• An MSSQL to Snowflake via Logstream task
• Apply changes and store changes are both enabled
• Store before and after on update settings are used

Records are missing from the __CT table.

Resolution

An enhancement was introduced in Qlik Replicate (version 2022.11), adding a feature which forces Qlik Replicate always to write the change table entry. 

Enable the feature in the task settings:

1. Open the task settings
2. Click More Options
3. Add the following feature flag: writeEqualBeforeAndAfterImagesToChangeTable
4. Set it to On
   
   

Environment

Qlik Replicate