topic Re: Change processing fails to capture the Update from source in Qlik Replicate

Change processing fails to capture the Update from source

chandraprakash_j_volvo — Tue, 05 Dec 2023 10:36:11 GMT

Source: Azure SQL

Target: Databricks Lakehouse(delta)

Error:

Table 'dbo'.'Location' (subtask 0 thread 1) is suspended. Performing 'update' operations in "Transactional apply" mode is not supported by Databricks Delta in qlik.

How to resolve this?

Re: Change processing fails to capture the Update from source

DesmondWOO — Tue, 05 Dec 2023 11:40:01 GMT

Hi @chandraprakash_j_volvo ,

As user guide states, the Transactional apply Change Processing mode is not supported.

In your task setting, please ensure "Change Processing Mode" is set to "Batch optimized apply".

Regards,
Desmond

Re: Change processing fails to capture the Update from source

chandraprakash_j_volvo — Tue, 05 Dec 2023 11:53:09 GMT

In my case "Change Processing Mode" is set to "Batch optimized apply" only. But I found some of the reasons behind it.

"The Apply Changes replication mode supports tables with a Primary Key/Unique Index only. Tables without Primary Keys/Unique Indexes will be suspended at the Change Processing stage" This is the reason my task failed seems. I have updated the primary key in the Source table. Now it is working fine

Thanks

Re: Change processing fails to capture the Update from source

john_wang — Tue, 05 Dec 2023 13:26:31 GMT

Hello @chandraprakash_j_volvo ,

Thanks for the feedback.

"Batch optimized apply" required the table has PK or Unique Index as Qlik Replicate utilizes the PK or Unique Index to merge the operation and get the optimized applying. Without PK/UI then Replicate has no way to know how to optimize the rows within the batch.

Regards,

John.