Qlik Replicate: No Insert happening on Azure Synapse SQL Pool in Bulk Mode

[Alan_Wang]

Azure Synapse as the target may be affected by a defect that causes the endpoint to not correctly path the staging folder. Extra slashes (/) may be observed in file paths, leading to files not being loaded to the target correctly when Azure SQL copy commands are executed.

No errors are logged or displayed and the staging files remain available in the correct folder. The only symptom of this issue is data not being replicated to the base tables.

Resolution

Affected Versions

Qlik Replicate November 2024 SR1 (current) and all earlier versions.

Fix Version

A patch will be released in the future to address this issue. Early build 2024.11.444 is being actively developed and can be requested using a Support case. 

Workaround

To mitigate the issue, use ADLS Gen2 storage instead of BLOB storage. SUPPORT-1644 only impacts BLOB storage.

Cause

This is caused by SUPPORT-1644, which leads to incorrect file paths between the staging folder locations and the copy commands executed by the task. Qlik is actively working on resolving the issue. 

Internal Investigation ID(s)

SUPPORT-1644

Environment

• Qik Replicate