Qlik Sense SAAS Apache Spark connector "Unexpected response from server during a HTTP connection: SSL_CTX_load_verify_locations..."

Andreas_Giesbrecht — Tue, 10 May 2022 19:15:54 GMT

Issue description

You might receive the following error "ERROR [HY000] [Qlik][ThriftExtension] (14) Unexpected response from server during a HTTP connection: SSL_CTX_load_verify_locations: No such file or directory; no such file; system lib." when trying to connect using the Qlik Sense SAAS Apache Spark connector with SSL enabled:

At the same time the connection from on-premise (Qlik Sense Enterprise on Windows) seems to work successfully (enabling SSL and "Use System Trust Store"):

Environment

Qlik Sense SAAS

Resolution

Please note that in the Qlik SAAS Apache Spark connector you have to use a trusted certificate if you enable the SSL option:

Note: The certificate is not provided by Qlik, please contact your internal team to obtain the certificate.

Cause

In the Qlik SAAS Apache Spark connector there is no option "Use System Trust Store" available in comparison to Windows where those according root certificates are stored by default and can be used automatically.

article Qlik Sense SAAS Apache Spark connector "Unexpected response from server during a HTTP connection: SSL_CTX_load_verify_locations..." in Official Support Articles

Qlik Sense SAAS Apache Spark connector "Unexpected response from server during a HTTP connection: SSL_CTX_load_verify_locations..."

Issue description

Environment

Resolution

Cause