Replication when tables are suspended

[chandraprakash_j_volvo]

Source: Oracle

Target: Databricks Lakehouse

We are replicating 38 tables to the target. One table suspended  and we noticed 2 days later and unspended the table. When the tables are suspended will the Qlik replicate capture the changes from the source or it will lead to loss of data 

[chandraprakash_j_volvo]

If so , is there is a way to unsuspend without data loss?

[DesmondWOO · Accepted solution]

Hi @chandraprakash_j_volvo ,

Thank your for reaching out to the Qlik Community.

When a table is suspended, Replicate continues applying changes to other tables. As a result, the suspended table will miss the changes that occurred during the suspension period.

Without data loss, the best way is to reload the suspended  table only. Another way is to stop whole task and resume the task from the earlier timestamp or position. However, the captured changes will be applied again for other tables.

Regards,
Desmond