Qlik Replicate to Databricks DL using DB Volumes as staging failing

MDAtl — Fri, 31 Jan 2025 15:30:53 GMT

We're trying to replicate to Databricks DL using Qlik Replicate. It connects fine and also build the target table successfully but when it tries to push the data, the PUT fails with SSL error (see below) - Any pointers/suggestions greatly appreciated.

00013632: 2025-01-31T10:07:03 [TARGET_LOAD ]E: Failed (retcode -1) to execute statement: PUT 'E:/Program Files/Attunity/Replicate/data/tasks/POC_MD_DBX_TEST/cloud/1/LOAD00000001.csv.gz' INTO '/Volumes/pri-dflt-ctlg-useast1-sbx-blue-datamodpoc/qlik_test/qlik_test_volume/qlik_test/94c36654-3826-0a4d-baa1-509fe2fb8b7c/1/LOAD00000001.csv.gz' OVERWRITE; [1022502] (ar_odbc_stmt.c:5082)

00013632: 2025-01-31T10:07:03 [TARGET_LOAD ]E: RetCode: SQL_ERROR SqlState: HY000 NativeError: 52

Message: [Simba][Hardy] (52) Error communicating with the service: SSL peer certificate or SSH remote key was not OK [1022502] (ar_odbc_stmt.c:5090)

Re: Qlik Replicate to Databricks DL using DB Volumes as staging failing

sureshkumar — Sat, 01 Feb 2025 11:06:46 GMT

Hello @MDAtl

Please check security firewall rule once and try adding the SSL certificates to ODBC driver.

Regards,

Suresh

topic Qlik Replicate to Databricks DL using DB Volumes as staging failing in Qlik Replicate

Qlik Replicate to Databricks DL using DB Volumes as staging failing

Re: Qlik Replicate to Databricks DL using DB Volumes as staging failing