Skip to main content
Announcements
Qlik Connect 2024! Seize endless possibilities! LEARN MORE

Qlik Replicate: Process to change the frequency of updates made to the attrep_status internal table

100% helpful (1/1)
cancel
Showing results for 
Search instead for 
Did you mean: 
SwathiPulagam
Support
Support

Qlik Replicate: Process to change the frequency of updates made to the attrep_status internal table

Last Update:

Jun 15, 2022 5:28:04 AM

Updated By:

Sonja_Bauernfeind

Created date:

Jun 15, 2022 5:28:04 AM

By default, the updates made to the attrep_status table is 1 minute.

We can change the frequency of updates made to the attrep_status table from 1 minute to X minutes by adding a field in the json under sorter settings as below:

 

"sorter_settings": {
"cdc_notification_period":         X, 
"local_transactions_storage": {
"memory_keep_time": 120

 

 

There is no option in the UI, so we must modify it in JSON.

 

Steps to modify from JSON:

  1. Export the task JSON
  2. By default, the parameters look as below under sorter_settings:

    SwathiPulagam_0-1655226393987.png

  3. Now I added "cdc_notification_period":    600 (which means I changed the frequency of updates made to the attrep_status table from default 1 minute to 10 minutes as below) in the task JSON:
    "sorter_settings":  {
     "cdc_notification_period":   600,
        "local_transactions_storage": {
                 "memory_keep_time":  120
                          }
                           },
  4. Save the task JSON.
  5. Import the task JSON and resume the task.

 

Before the change:

SwathiPulagam_1-1655226394032.jpeg

 

After changing i to 10 mins:

SwathiPulagam_2-1655226394083.jpeg

 

Environment:

Qlik Replicate 

Labels (1)
Version history
Last update:
‎2022-06-15 05:28 AM
Updated by: