Skip to main content

Qlik

cancel
Turn on suggestions
Auto-suggest helps you quickly narrow down your search results by suggesting possible matches as you type.
Showing results for 
Search instead for 
Did you mean: 
Announcements
Introducing Qlik Answers: A plug-and-play, Generative AI powered RAG solution. READ ALL ABOUT IT!
cancel
Turn on suggestions
Auto-suggest helps you quickly narrow down your search results by suggesting possible matches as you type.
Showing results for 
Search instead for 
Did you mean: 
haiderpasha
Contributor III
Contributor III
‎2024-06-20 03:25 PM

Null issue with Delete Events

Hello team

 

         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.

 

May I know what could be the issue here?

 

 
header__change_seq header__change_oper header__change_mask header__stream_position header__operation header__transaction_id header__timestamp jrnl_timestamp jrnl_jsn jrnl_prog_name jrnl_userid p_k nk_item_cust_spec fk_item_cust_spec code_ctgry_type text_entry_id desc_entry_text order_number order_number_line
2.02406E+34 D CAA= 00000011/E094BCB0.5.00000011/E094D848 DELETE D0D8A706000000000000000000000000 2024-06-18T16:48:25.340556Z null null null null 15373069037 null null null null null 0 0
2.02406E+34 D CAA= 00000011/E144F4E8.5.00000011/E144F920 DELETE 2FABA806000000000000000000000000 2024-06-19T02:21:38.908689Z null null null null 15373069037 null null null null null 0 0
2.02406E+34 D CAA= 00000011/E7ACC8C0.3.00000011/E7ACCA50 DELETE 55FCAB06000000000000000000000000 2024-06-20T14:33:20.479278Z null null null null 15524466004 null null null null null 0 0

 

Labels (2)
Labels
156 Views
1 Solution

Accepted Solutions
john_wang
Support
Support
‎2024-06-20 08:25 PM

Hello @haiderpasha ,

Thanks for reaching out to Qlik Community!

This is the expected behavior, please check the article: Only PK columns of PostgreSQL source table replicate to target side.

And User Guide mentioned the limitation:

Hope this helps.

John.

 

Help users find answers! Do not forget to mark a solution that worked for you! If already marked, give it a thumbs up!

View solution in original post

115 Views
1 Reply
john_wang
Support
Support
‎2024-06-20 08:25 PM

Hello @haiderpasha ,

Thanks for reaching out to Qlik Community!

This is the expected behavior, please check the article: Only PK columns of PostgreSQL source table replicate to target side.

And User Guide mentioned the limitation:

Hope this helps.

John.

 

Help users find answers! Do not forget to mark a solution that worked for you! If already marked, give it a thumbs up!
116 Views