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

[_riccardo]

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]

Hello @_riccardo ,

Please check the article:  transactions apply mode is not supported.

Hope this helps.

John.

[_riccardo]

Hello @john_wang,

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 · Accepted solution]

Hello @_riccardo ,

Thanks for the update.

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

1. Set TARGET_APPLY to Verbose and reproduce the issue.

2. Download the Task Diagnostics Package and attach it to the support ticket.

3. 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.