https://community.qlik.com/t5/Official-Support-Articles/Qlik-Replicate-and-Snowflake-and-logstream-task-Data-is-missing/ta-p/2078004 <P><SPAN>Scenario:</SPAN></P> <UL class="lia-list-style-type-circle"> <LI><SPAN>An MSSQL to Snowflake via Logstream task</SPAN></LI> <LI><SPAN>Apply changes and store changes are both enabled</SPAN></LI> <LI><SPAN>Store before and after on update settings are used</SPAN></LI> </UL> <P><SPAN>Records are missing from the __CT table.</SPAN></P> <H3><FONT color="#339966"><STRONG>Resolution</STRONG></FONT></H3> <P>An enhancement was introduced in Qlik Replicate (version 2022.11), adding a feature which forces Qlik Replicate always to write the change table entry.&nbsp;</P> <P>Enable the feature in the task settings:</P> <OL> <LI>Open the<STRONG> task settings</STRONG></LI> <LI>Click&nbsp;<STRONG>More Options</STRONG></LI> <LI>Add the following feature flag:&nbsp;<FONT face="courier new,courier">writeEqualBeforeAndAfterImagesToChangeTable</FONT></LI> <LI>Set it to <STRONG>On</STRONG><BR /><BR /><span class="lia-inline-image-display-wrapper lia-image-align-inline" image-alt="MSSQLToMySQL Settings.png" style="width: 999px;"><img src="https://community.qlik.com/t5/image/serverpage/image-id/108896i5ED33D7649D1429C/image-size/large?v=v2&amp;px=999" role="button" title="MSSQLToMySQL Settings.png" alt="MSSQLToMySQL Settings.png" /></span></LI> </OL> <P>&nbsp;</P> <H4><FONT color="#339966"><STRONG>Environment</STRONG></FONT></H4> <P class="lia-indent-padding-left-30px"><LI-PRODUCT title="Qlik Replicate" id="qlikReplicate"></LI-PRODUCT>&nbsp;</P> <P>&nbsp;</P> Thu, 01 Jun 2023 10:19:28 GMT Dineshan 2023-06-01T10:19:28Z https://community.qlik.com/t5/Official-Support-Articles/Qlik-Replicate-and-Snowflake-and-logstream-task-Data-is-missing/ta-p/2078004 <P><SPAN>Scenario:</SPAN></P> <UL class="lia-list-style-type-circle"> <LI><SPAN>An MSSQL to Snowflake via Logstream task</SPAN></LI> <LI><SPAN>Apply changes and store changes are both enabled</SPAN></LI> <LI><SPAN>Store before and after on update settings are used</SPAN></LI> </UL> <P><SPAN>Records are missing from the __CT table.</SPAN></P> <H3><FONT color="#339966"><STRONG>Resolution</STRONG></FONT></H3> <P>An enhancement was introduced in Qlik Replicate (version 2022.11), adding a feature which forces Qlik Replicate always to write the change table entry.&nbsp;</P> <P>Enable the feature in the task settings:</P> <OL> <LI>Open the<STRONG> task settings</STRONG></LI> <LI>Click&nbsp;<STRONG>More Options</STRONG></LI> <LI>Add the following feature flag:&nbsp;<FONT face="courier new,courier">writeEqualBeforeAndAfterImagesToChangeTable</FONT></LI> <LI>Set it to <STRONG>On</STRONG><BR /><BR /><span class="lia-inline-image-display-wrapper lia-image-align-inline" image-alt="MSSQLToMySQL Settings.png" style="width: 999px;"><img src="https://community.qlik.com/t5/image/serverpage/image-id/108896i5ED33D7649D1429C/image-size/large?v=v2&amp;px=999" role="button" title="MSSQLToMySQL Settings.png" alt="MSSQLToMySQL Settings.png" /></span></LI> </OL> <P>&nbsp;</P> <H4><FONT color="#339966"><STRONG>Environment</STRONG></FONT></H4> <P class="lia-indent-padding-left-30px"><LI-PRODUCT title="Qlik Replicate" id="qlikReplicate"></LI-PRODUCT>&nbsp;</P> <P>&nbsp;</P> Thu, 01 Jun 2023 10:19:28 GMT https://community.qlik.com/t5/Official-Support-Articles/Qlik-Replicate-and-Snowflake-and-logstream-task-Data-is-missing/ta-p/2078004 Dineshan 2023-06-01T10:19:28Z