topic Re: Suspended Tables (Databricks Target) due to "Transactional apply" Errors in "Batch optimized" Task in Qlik Replicate

Suspended Tables (Databricks Target) due to "Transactional apply" Errors in "Batch optimized" Task

_riccardo — Wed, 30 Apr 2025 14:16:20 GMT

Hi everyone,

I have a task in Qlik Replicate with target Databricks Lakehouse (Delta). Recently, many tables have been suspended due to the following errors:

"Performing 'update' operations in "Transactional apply" mode is not supported by Databricks Delta"
"Performing 'insert' operations in "Transactional apply" mode is not supported by Databricks Delta"
"Performing 'delete' operations in "Transactional apply" mode is not supported by Databricks Delta"

The problem is that the task has always been set to "Batch optimized apply". Does anyone know why this is happening?

Thank you in advance for any insights!

john_wang — Wed, 30 Apr 2025 15:52:04 GMT

Hope this helps.

John.

_riccardo — Mon, 05 May 2025 07:16:54 GMT

Thanks for the suggestion! However, I've already verified that all the tables in this replication task have defined primary keys.

Any other thoughts on why this might be happening?

john_wang — Mon, 05 May 2025 13:36:30 GMT

Thanks for the update.

I'd recommend opening a support ticket with the following information:

Set TARGET_APPLY to Verbose and reproduce the issue.
Download the Task Diagnostics Package and attach it to the support ticket.
Decrypt the verbose task log files, compress them, and include them in the ticket as well.

Please note that our support team may request additional information during their investigation.

Regards,

John.