<?xml version="1.0" encoding="UTF-8"?>
<rss xmlns:content="http://purl.org/rss/1.0/modules/content/" xmlns:dc="http://purl.org/dc/elements/1.1/" xmlns:rdf="http://www.w3.org/1999/02/22-rdf-syntax-ns#" xmlns:taxo="http://purl.org/rss/1.0/modules/taxonomy/" version="2.0">
  <channel>
    <title>topic Query on using Qlik task for store changes only in Qlik Replicate</title>
    <link>https://community.qlik.com/t5/Qlik-Replicate/Query-on-using-Qlik-task-for-store-changes-only/m-p/2541846#M15830</link>
    <description>&lt;P&gt;Hello Team,&lt;BR /&gt;&lt;BR /&gt;I created a qlik task (CDC_POC) for just capturing the changes(inserts/updates/deletes) from the table WIP_TRANSACTION_ACCOUNTS and store it in __ct table.&lt;BR /&gt;Hence I created the task CDC_POC with just store changes enabled. Its already been 15 mins since I started the task , however I don't see any changes being captured in the __ct table. The latency is keeping on increasing and its already 15 mins now.&amp;nbsp;&lt;BR /&gt;The source endpoint is Oracle and the target is Oracle.&lt;BR /&gt;However, I am using a standby DR (having "Use Archived Redo Logs only") as the source endpoint . Is this the reason why the changes are not being captured? Do we have to use live DB for CDC in store changes option?&lt;BR /&gt;I have attached the logs and screenshot of the task.&lt;BR /&gt;&lt;BR /&gt;Could anyone help me on this?&amp;nbsp;&lt;a href="https://community.qlik.com/t5/user/viewprofilepage/user-id/121014"&gt;@Dana_Baldwin&lt;/a&gt;&amp;nbsp;&lt;a href="https://community.qlik.com/t5/user/viewprofilepage/user-id/115309"&gt;@john_wang&lt;/a&gt;&amp;nbsp;&lt;/P&gt;</description>
    <pubDate>Wed, 28 Jan 2026 15:15:16 GMT</pubDate>
    <dc:creator>harikesh_1991</dc:creator>
    <dc:date>2026-01-28T15:15:16Z</dc:date>
    <item>
      <title>Query on using Qlik task for store changes only</title>
      <link>https://community.qlik.com/t5/Qlik-Replicate/Query-on-using-Qlik-task-for-store-changes-only/m-p/2541846#M15830</link>
      <description>&lt;P&gt;Hello Team,&lt;BR /&gt;&lt;BR /&gt;I created a qlik task (CDC_POC) for just capturing the changes(inserts/updates/deletes) from the table WIP_TRANSACTION_ACCOUNTS and store it in __ct table.&lt;BR /&gt;Hence I created the task CDC_POC with just store changes enabled. Its already been 15 mins since I started the task , however I don't see any changes being captured in the __ct table. The latency is keeping on increasing and its already 15 mins now.&amp;nbsp;&lt;BR /&gt;The source endpoint is Oracle and the target is Oracle.&lt;BR /&gt;However, I am using a standby DR (having "Use Archived Redo Logs only") as the source endpoint . Is this the reason why the changes are not being captured? Do we have to use live DB for CDC in store changes option?&lt;BR /&gt;I have attached the logs and screenshot of the task.&lt;BR /&gt;&lt;BR /&gt;Could anyone help me on this?&amp;nbsp;&lt;a href="https://community.qlik.com/t5/user/viewprofilepage/user-id/121014"&gt;@Dana_Baldwin&lt;/a&gt;&amp;nbsp;&lt;a href="https://community.qlik.com/t5/user/viewprofilepage/user-id/115309"&gt;@john_wang&lt;/a&gt;&amp;nbsp;&lt;/P&gt;</description>
      <pubDate>Wed, 28 Jan 2026 15:15:16 GMT</pubDate>
      <guid>https://community.qlik.com/t5/Qlik-Replicate/Query-on-using-Qlik-task-for-store-changes-only/m-p/2541846#M15830</guid>
      <dc:creator>harikesh_1991</dc:creator>
      <dc:date>2026-01-28T15:15:16Z</dc:date>
    </item>
    <item>
      <title>Re: Query on using Qlik task for store changes only</title>
      <link>https://community.qlik.com/t5/Qlik-Replicate/Query-on-using-Qlik-task-for-store-changes-only/m-p/2541854#M15832</link>
      <description>&lt;P&gt;Hello&amp;nbsp;&lt;a href="https://community.qlik.com/t5/user/viewprofilepage/user-id/347193"&gt;@harikesh_1991&lt;/a&gt;&amp;nbsp;,&lt;/P&gt;
&lt;P data-start="79" data-end="110"&gt;Thank you for opening the post.&lt;/P&gt;
&lt;P data-start="112" data-end="206"&gt;We do see that &lt;STRONG data-start="127" data-end="192"&gt;Qlik Replicate has started processing archived redo log files&lt;/STRONG&gt;, for example:&lt;/P&gt;
&lt;P data-start="112" data-end="206"&gt;&lt;FONT face="courier new,courier"&gt;00289322: 2026-01-28T09:34:20 [SOURCE_CAPTURE ]I: Start processing archived Redo log sequence 16425 thread 1 name +RECOC2/WWOPRDCPP1/ARCHIVELOG/2026_01_28/thread_1_seq_16425.8126.1223717649 (oradcdc_redo.c:1034)&lt;/FONT&gt;&lt;/P&gt;
&lt;P data-start="430" data-end="610"&gt;However, since the task logging level is &lt;STRONG data-start="471" data-end="493"&gt;not set to Verbose&lt;/STRONG&gt;, it is difficult to determine additional details from the uploaded task log. To proceed, we recommend the following:&lt;/P&gt;
&lt;OL data-start="612" data-end="1074"&gt;
&lt;LI data-start="612" data-end="689"&gt;
&lt;P data-start="615" data-end="689"&gt;&lt;STRONG data-start="615" data-end="640"&gt;Open a support ticket&lt;/STRONG&gt; and include the relevant background information.&lt;/P&gt;
&lt;/LI&gt;
&lt;LI data-start="690" data-end="867"&gt;
&lt;P data-start="693" data-end="867"&gt;Set &lt;STRONG data-start="697" data-end="715"&gt;SOURCE_CAPTURE&lt;/STRONG&gt; and &lt;STRONG data-start="720" data-end="736"&gt;TARGET_APPLY&lt;/STRONG&gt; logging levels to &lt;STRONG data-start="755" data-end="766"&gt;Verbose&lt;/STRONG&gt;, rerun the task for approximately &lt;STRONG data-start="801" data-end="815"&gt;30 minutes&lt;/STRONG&gt;, and then collect the &lt;STRONG data-start="838" data-end="866"&gt;Task Diagnostics Package&lt;/STRONG&gt;.&lt;/P&gt;
&lt;/LI&gt;
&lt;LI data-start="868" data-end="978"&gt;
&lt;P data-start="871" data-end="978"&gt;Collect the &lt;STRONG data-start="883" data-end="909"&gt;complete task log file&lt;/STRONG&gt;, &lt;A href="https://community.qlik.com/t5/Knowledge/How-to-decrypt-Qlik-Replicate-verbose-task-log-files/ta-p/1862114" target="_blank" rel="noopener"&gt;decrypt it manually&lt;/A&gt;, and upload the &lt;STRONG data-start="947" data-end="969"&gt;decrypted task log&lt;/STRONG&gt; as well.&lt;/P&gt;
&lt;/LI&gt;
&lt;LI data-start="979" data-end="1074"&gt;
&lt;P data-start="982" data-end="1074"&gt;Please confirm that the source tables were updated by &lt;STRONG data-start="1036" data-end="1054"&gt;DML operations&lt;/STRONG&gt; during this period.&lt;/P&gt;
&lt;/LI&gt;
&lt;/OL&gt;
&lt;P data-start="1076" data-end="1249"&gt;Finally, please &lt;STRONG data-start="1092" data-end="1163"&gt;avoid attaching task log files in the community forum in the future&lt;/STRONG&gt;, as it is publicly accessible and task logs may contain &lt;STRONG data-start="1220" data-end="1248"&gt;confidential information&lt;/STRONG&gt;.&lt;/P&gt;
&lt;P data-start="1076" data-end="1249"&gt;CC&amp;nbsp;&lt;SPAN&gt;&amp;nbsp;&lt;/SPAN&gt;&lt;A href="https://community.qlik.com/t5/user/viewprofilepage/user-id/121014" target="_blank"&gt;@Dana_Baldwin&lt;/A&gt;&lt;/P&gt;
&lt;P data-start="1076" data-end="1249"&gt;Best Regards,&lt;/P&gt;
&lt;P data-start="1076" data-end="1249"&gt;John.&lt;/P&gt;</description>
      <pubDate>Wed, 28 Jan 2026 16:06:42 GMT</pubDate>
      <guid>https://community.qlik.com/t5/Qlik-Replicate/Query-on-using-Qlik-task-for-store-changes-only/m-p/2541854#M15832</guid>
      <dc:creator>john_wang</dc:creator>
      <dc:date>2026-01-28T16:06:42Z</dc:date>
    </item>
    <item>
      <title>Re: Query on using Qlik task for store changes only</title>
      <link>https://community.qlik.com/t5/Qlik-Replicate/Query-on-using-Qlik-task-for-store-changes-only/m-p/2541963#M15838</link>
      <description>&lt;P&gt;Hello&amp;nbsp;&lt;a href="https://community.qlik.com/t5/user/viewprofilepage/user-id/115309"&gt;@john_wang&lt;/a&gt;&amp;nbsp;,&lt;BR /&gt;Sorry I was a bit too quick to raise a query. The task indeed worked as expected.&lt;BR /&gt;Since it was set to "use archived redo logs only" at the source endpoint, there was a lag/delay for about 30 mins for the data to start getting picked up.&lt;BR /&gt;&lt;BR /&gt;Also noted, I will ensure that I won't attach the logs anymore.&lt;BR /&gt;&lt;BR /&gt;Regards,&lt;/P&gt;
&lt;P&gt;Harikesh OP&lt;/P&gt;</description>
      <pubDate>Thu, 29 Jan 2026 13:54:13 GMT</pubDate>
      <guid>https://community.qlik.com/t5/Qlik-Replicate/Query-on-using-Qlik-task-for-store-changes-only/m-p/2541963#M15838</guid>
      <dc:creator>harikesh_1991</dc:creator>
      <dc:date>2026-01-29T13:54:13Z</dc:date>
    </item>
    <item>
      <title>Re: Query on using Qlik task for store changes only</title>
      <link>https://community.qlik.com/t5/Qlik-Replicate/Query-on-using-Qlik-task-for-store-changes-only/m-p/2541976#M15839</link>
      <description>&lt;P&gt;Glad to hear it works for you! Thank you so much for your support&amp;nbsp;&lt;a href="https://community.qlik.com/t5/user/viewprofilepage/user-id/347193"&gt;@harikesh_1991&lt;/a&gt;&amp;nbsp;&lt;/P&gt;</description>
      <pubDate>Thu, 29 Jan 2026 15:28:47 GMT</pubDate>
      <guid>https://community.qlik.com/t5/Qlik-Replicate/Query-on-using-Qlik-task-for-store-changes-only/m-p/2541976#M15839</guid>
      <dc:creator>john_wang</dc:creator>
      <dc:date>2026-01-29T15:28:47Z</dc:date>
    </item>
  </channel>
</rss>

