topic azure_sql EXCEPTION IN Server.Run(): Invalid connector configuration file in Integration, Extension & APIs

azure_sql EXCEPTION IN Server.Run(): Invalid connector configuration file

mikedeee — Mon, 25 Mar 2024 14:27:52 GMT

Hi, Could use some help targeting a solution for an odbc azure error when running jobs in the QMC.

The full error is:

C:\ProgramData\Qlik\Custom Data\QvOdbcConnectorPackage\Log

azure_sql EXCEPTION IN Server.Run(): Invalid connector configuration file - can not find azure_sql-reading-strategy key

This occurred after a QS upgrade from a 2022 version to November 2023 Patch 3.

2 servers were upgraded with only one having the issue with jobs running in the QMC.

In that troubled server, the Azure connections in Qlik Sense will alloy selection of data (connection is apparently fine) but changes to the connection can not be made.

Re: azure_sql EXCEPTION IN Server.Run(): Invalid connector configuration file

mikedeee — Thu, 28 Mar 2024 12:25:03 GMT

Hoping someone on the Qlik support side can point towards a solution for this issue, I've scoured various Qlik documents and forum posts. This doesn't seem to point towards either an ODBC issue during the Qlik Sense upgrade, nor a certificate issue.

Could more detail and pointers be supplied about the connector configuration please?

Re: azure_sql EXCEPTION IN Server.Run(): Invalid connector configuration file

mikedeee — Tue, 02 Apr 2024 12:23:26 GMT

Would it be possible for a Qlik representative to comment on this with some direction towards a solution please?

Our upgrade path included the Qlik Sense built in ODBC install so as to qualify for support.