Databricks Endpoint Connection Error after upgrading Qlik Replicate: SSL_connect: certificate verify failed.

[Nanda_Ravindra]

Following an upgrade of Qlik Replicate from version 2023.05 to 2024.05 and an upgrade of the Databricks ODBC drivers from version 2.6.22 to 2.8.2, the following error is encountered when configuring and testing the Databricks endpoint:

SYS-E-HTTPFAIL, Failed prepare Cloud component. SYS,GENERAL_EXCEPTION,Failed prepare Cloud component,Cannot connect to Cloud server RetCode: SQL_ERROR SqlState: HY000 NativeError: 14 Message: [Simba][ThriftExtension] (14) Unexpected response from server during a HTTP connection: SSL_connect: certificate verify failed. Failed to find field. Field named at object

Resolution

If you are using your organization's root certificates with the ODBC driver 2.8.2, then you should add the root certificates to the cacerts.pem file, which is located in the ODBC driver directory.

For more information, see: Magnitude Simba Apache Spark ODBC Data Connector (.pdf download).

If this option is not set, the connector defaults to using the trusted CA certificates .pem file installed by the connector. To use the trusted CA certificates in the .pem file, set the UseSystemTrustStore property to 0 or clear the Use System Trust Store check box in the SSL Options dialog.

Cause

• In version 2.6.22 of the ODBC driver, the default setting for UseSystemTrustStore was 1, meaning the driver checked the SSL certificate in the Windows trust store.
• In version 2.8.2, the default setting for UseSystemTrustStore was changed to 0, so the driver now uses the trusted CA certificates in the .pem file rather than referencing the Windows trust store.

Environment

• Qlik Replicate