Skip to main content

Official Support Articles

Search or browse our knowledge base to find answers to your questions ranging from account questions to troubleshooting error messages. The content is curated and updated by our global Support team

Announcements
New navigation header in progress. Thank you for your patience: READ DETAILS

How to refresh full compose tables without a drop and recreate

cancel
Showing results for 
Search instead for 
Did you mean: 
Nanda_Ravindra
Support
Support

How to refresh full compose tables without a drop and recreate

The information in this article is provided as-is and to be used at your discretion. So, please implement and test this in your testing environment before applying this to production.

  1. Stop the Qlik Replicate task that you want to reload all the tables.
  2. On the Compose server:
    1. Run the CDC for the task in question. (This will   get any current __ct records processed)
    2. Under ‘Manage task’, duplicate the Full load task.
    3. Enable the ‘handle duplicate’ check box for the newly created Ful load.
    4. Generate instructions for the newly created task.
  3. On the Qlik Replicate server:
    1. Reload all the tables for the task that you want to reprocess in Qlik Compose.
      Note: use DROP and recreate the target table option in ask settings under store change processing.
  4. On the Compose server:
    1. Run the newly created Full load task <-- This is a one-time activity.
    2. Resume the original CDC task – This will continue to capture the changes while the newly created Full load task is running.
    3. Verify the data from the newly created Full load task.
    4. Remove the newly created Full load tasks.

                

Environment

Qlik Compose 
Qlik Compose for Data Warehouses 7.x

Labels (2)
Version history
Last update:
‎2022-06-08 02:27 AM
Updated by: