topic Re: Null issue with Delete Events in Qlik Replicate https://community.qlik.com/t5/Qlik-Replicate/Null-issue-with-Delete-Events/m-p/2464413#M11654 <P>Hello&nbsp;<a href="https://community.qlik.com/t5/user/viewprofilepage/user-id/213055">@haiderpasha</a>&nbsp;,</P> <P>Thanks for reaching out to Qlik Community!</P> <P>This is the expected behavior, please check the article:&nbsp;<A title="Only PK columns of PostgreSQL source table replicate to target side" href="https://community.qlik.com/t5/Official-Support-Articles/Qlik-Replicate-Only-PK-columns-of-PostgreSQL-source-table/ta-p/1838414" target="_blank" rel="noopener">Only PK columns of PostgreSQL source table replicate to target side</A>.</P> <P>And User Guide mentioned the limitation:</P> <UL> <LI><SPAN><A title="The default configuration of Replica identity is supported only" href="https://help.qlik.com/en-US/replicate/May2024/Content/Global_Common/Content/SharedReplicateHDD/PostgreSQL-Source/limitations_postgresql_source.htm#ar_postgresds_802412600_1652565:~:text=The%20default%20configuration,replication%2Dpublication.html" target="_blank" rel="noopener">The default configuration of Replica identity is supported only</A>.</SPAN></LI> </UL> <P>Hope this helps.</P> <P>John.</P> <P>&nbsp;</P> Fri, 21 Jun 2024 00:25:22 GMT john_wang 2024-06-21T00:25:22Z Null issue with Delete Events https://community.qlik.com/t5/Qlik-Replicate/Null-issue-with-Delete-Events/m-p/2464367#M11652 <P>Hello team</P> <P>&nbsp;</P> <P>&nbsp; &nbsp; &nbsp; &nbsp; &nbsp;We have Arora PostgreSQL as a source and S3 as the target. The Delete event values are coming as null and do not carry the deleted records value in the columns.</P> <P>&nbsp;</P> <P>May I know what could be the issue here?</P> <P>&nbsp;</P> <DIV id="tinyMceEditorhaiderpasha_0" class="mceNonEditable lia-copypaste-placeholder">&nbsp;</DIV> <TABLE width="2366"> <TBODY> <TR> <TD width="131">header__change_seq</TD> <TD width="137">header__change_oper</TD> <TD width="142">header__change_mask</TD> <TD width="282">header__stream_position</TD> <TD width="117">header__operation</TD> <TD width="249">header__transaction_id</TD> <TD width="190">header__timestamp</TD> <TD width="95">jrnl_timestamp</TD> <TD width="48">jrnl_jsn</TD> <TD width="97">jrnl_prog_name</TD> <TD width="64">jrnl_userid</TD> <TD width="87">p_k</TD> <TD width="120">nk_item_cust_spec</TD> <TD width="117">fk_item_cust_spec</TD> <TD width="103">code_ctgry_type</TD> <TD width="81">text_entry_id</TD> <TD width="100">desc_entry_text</TD> <TD width="89">order_number</TD> <TD width="117">order_number_line</TD> </TR> <TR> <TD>2.02406E+34</TD> <TD>D</TD> <TD>CAA=</TD> <TD>00000011/E094BCB0.5.00000011/E094D848</TD> <TD>DELETE</TD> <TD>D0D8A706000000000000000000000000</TD> <TD>2024-06-18T16:48:25.340556Z</TD> <TD>null</TD> <TD>null</TD> <TD>null</TD> <TD>null</TD> <TD>15373069037</TD> <TD>null</TD> <TD>null</TD> <TD>null</TD> <TD>null</TD> <TD>null</TD> <TD>0</TD> <TD>0</TD> </TR> <TR> <TD>2.02406E+34</TD> <TD>D</TD> <TD>CAA=</TD> <TD>00000011/E144F4E8.5.00000011/E144F920</TD> <TD>DELETE</TD> <TD>2FABA806000000000000000000000000</TD> <TD>2024-06-19T02:21:38.908689Z</TD> <TD>null</TD> <TD>null</TD> <TD>null</TD> <TD>null</TD> <TD>15373069037</TD> <TD>null</TD> <TD>null</TD> <TD>null</TD> <TD>null</TD> <TD>null</TD> <TD>0</TD> <TD>0</TD> </TR> <TR> <TD>2.02406E+34</TD> <TD>D</TD> <TD>CAA=</TD> <TD>00000011/E7ACC8C0.3.00000011/E7ACCA50</TD> <TD>DELETE</TD> <TD>55FCAB06000000000000000000000000</TD> <TD>2024-06-20T14:33:20.479278Z</TD> <TD>null</TD> <TD>null</TD> <TD>null</TD> <TD>null</TD> <TD>15524466004</TD> <TD>null</TD> <TD>null</TD> <TD>null</TD> <TD>null</TD> <TD>null</TD> <TD>0</TD> <TD>0</TD> </TR> </TBODY> </TABLE> <P>&nbsp;</P> Thu, 20 Jun 2024 19:25:40 GMT https://community.qlik.com/t5/Qlik-Replicate/Null-issue-with-Delete-Events/m-p/2464367#M11652 haiderpasha 2024-06-20T19:25:40Z Re: Null issue with Delete Events https://community.qlik.com/t5/Qlik-Replicate/Null-issue-with-Delete-Events/m-p/2464413#M11654 <P>Hello&nbsp;<a href="https://community.qlik.com/t5/user/viewprofilepage/user-id/213055">@haiderpasha</a>&nbsp;,</P> <P>Thanks for reaching out to Qlik Community!</P> <P>This is the expected behavior, please check the article:&nbsp;<A title="Only PK columns of PostgreSQL source table replicate to target side" href="https://community.qlik.com/t5/Official-Support-Articles/Qlik-Replicate-Only-PK-columns-of-PostgreSQL-source-table/ta-p/1838414" target="_blank" rel="noopener">Only PK columns of PostgreSQL source table replicate to target side</A>.</P> <P>And User Guide mentioned the limitation:</P> <UL> <LI><SPAN><A title="The default configuration of Replica identity is supported only" href="https://help.qlik.com/en-US/replicate/May2024/Content/Global_Common/Content/SharedReplicateHDD/PostgreSQL-Source/limitations_postgresql_source.htm#ar_postgresds_802412600_1652565:~:text=The%20default%20configuration,replication%2Dpublication.html" target="_blank" rel="noopener">The default configuration of Replica identity is supported only</A>.</SPAN></LI> </UL> <P>Hope this helps.</P> <P>John.</P> <P>&nbsp;</P> Fri, 21 Jun 2024 00:25:22 GMT https://community.qlik.com/t5/Qlik-Replicate/Null-issue-with-Delete-Events/m-p/2464413#M11654 john_wang 2024-06-21T00:25:22Z