Skip to main content Skip to complementary content

Upgrading Qlik Data Gateway - Direct Access

This section lists the new features for each Direct Access gateway version, and explains how to upgrade your installation.

Qlik Data Gateway - Direct Access version history

Version

Release date

Significant changes

End of support date

1.6.3 January 30, 2024

Direct Access gateway 1.6.3 includes the following enhancements and bug fixes:

  • Data loss prevention

    In previous versions, to prevent potential data loss, Direct Access gateway did not automatically reconnect to the data source during a reload. From this version, Direct Access gateway will now automatically reconnect to the data source as needed. To prevent data loss, the completed reload summary will be verified before reconnecting. If data loss is detected, the reload will fail.

  • Timeout for reload sessions

    In rare scenarios, the reload session would stay alive indefinitely. To prevent such occurrences, this version introduces a three-hour timeout for reload sessions.

  • Timeout extension for load requests

    Reloads would sometimes fail with the following errors:

    Connector error: The session does not exist (DirectAccess-1509)

    Connector error: The stream session expired for the load data request (DirectAccess-1012)

    To mitigate this issue, an EXTEND_FIRST_REQUEST_TIMEOUT parameter (for extending the load request timeout) was added to the configuration.properties file. The default is "0". Customers who frequently encounter these errors should try setting the timeout to 5-10 minutes.

  • Support for detailed connection error messages

    Added support for viewing detailed connection error messages when using ODBC-based via Direct Access gateway connectors. Customers can now set the ShowErrorDetailMessage parameter in the Advanced connector settings to "true" to see the full error returned by the ODBC driver. The detailed error message will be show in the Data load editor.

    Information noteThe error message is provided in its entirety by the data source you are using. Qlik does not append any additional information to the error message or edit it in any way.
  • Handling multiple reloads with the same reload ID

    From this version, the engine session ID will be used to distinguish between multiple reloads with the same reload ID. This will prevent potential conflicts, resulting in reloads failing with the following error:

    Connector error: data loading error (DirectAccess-4008

Determined when the next major version is released
1.6.2 January 9, 2024

Direct Access gateway 1.6.2 resolves an issue that would sometimes cause the Connector Agent to crash when working in process isolation mode.

Warning note Customers working with Direct Access gateway 1.6.1 in process isolation mode are strongly encouraged to upgrade to this version.
Determined when the next major version is released
1.6.1 December 12, 2023

Direct Access gateway 1.6.1 introduces several important features and enhancements, improving overall stability and performance.

  • Connector process isolation has been added to Direct Access gateway. This is an opt-in feature, meaning that it is off by default. Process isolation allows administrators with direct access to the gateway server operating system to control how many processes are available for reloads per connector type. Spreading reloads across multiple connector processes increases the level of isolation by reducing the number of reloads running concurrently on each connector process. This in turn can improve overall Direct Access gateway stability in cases where connector crashes have occurred.

    See also: Mitigating connector crashes during reload

  • This version introduces the BEX_ONE_CHUNK application parameter for the SAP BW (via Direct Access gateway) connector. When accessing SAP BW directly from Qlik Cloud (that is, not via Direct access gateway), to optimize performance, the result set is divided into chunks in the SAP backend and read as separate threads. However, when accessing SAP BW via Direct Access gateway, dividing the result set into chunks has no real advantage. On the contrary, it consumes more of the shared memory in SAP as it requires an additional temp table to be created for the duration of the data transfer. It's possible (though usually not required) to start chunking by setting BEX_ONE_CHUNK:false in the appsettings.json file, which is located in the SAP connector binaries folder.

  • For SAP BW (via Direct Access gateway) and SAP SQL (via Direct Access gateway) connector logs, a _port suffix was added before the log file name extension, and a ProcessID=### message was added to the connector's log files in order to distinguish between events from new instances of the connector listening on the same port.

  • The reconnection mechanism during reload has been improved so that Direct Access gateway no longer needs to connect to the pod that started the reload (as was previously the case). Now, instead of repeatedly trying to connect to the pod that started the reload (which often resulted in reload failures), it will connect to the first available pod.

Direct Access gateway 1.6.0 resolves the following issues:

  • When reloads were performed from different data sources, processes from one data source would erroneously appear in the logging of the other data source.

  • The configuration.properties file would not be copied during the Direct Access gateway installation.

  • Qlik Cloud resource scaling would sometimes result in a DirectAccess-1006 error. An enhancement was made to improve handling of certain Qlik Cloud resource scaling scenarios that occur during application reloads performed via Direct Access gateway.

  • Connecting to Snowflake via the ODBC (via Direct Access gateway) connector would fail.

  • Debugging application scripts in the Data Load Editor (DLE) with the Limit Results option enabled would sometimes fail with the following error:

    Connector error: Invalid load request (DirectAccess-1006).

Determined when the next major version is released
1.5.3 September 23, 2023
  • ODBC (via Direct Access gateway) connector: The connector would sometimes crash when canceling reloads of large tables. An improvement was made to help prevent this.
  • Microsoft SQL Server (via Direct Access gateway) connector: When attempting to establish a connection to a SQL Server hosted on older Windows Server versions, the connection would fail due to a TLS compatibility issue and the following error would be returned:

    Please check the values for Username‚ Password‚ Host and other properties. Description: Client unable to establish connection - ERROR [08001] [Qlik][SqlServer] Problem establishing connection to the server.

    The SQL Server driver has been updated to correct the problem.

  • SAP SQL (via Direct Access gateway) connector: When attempting to preview a table, the following error would sometimes occur:

    Exception of Type System.OutOfMemoryException

  • SAP SQL (via Direct Access gateway) connector: Attempting to preview a table would sometimes time out after a few minutes with the following error:

    Request could not be completed.

  • SAP SQL (via Direct Access gateway) and SAP BW (via Direct Access gateway) connectors: Added diagnostic information to the logs to assist in troubleshooting multiple concurrent requests.

June 12, 2024

1.5.2 September 19, 2023
  • Provides support for the new ODBC (via Direct Access gateway) connector.

  • The Version column in Management Console will now display the Direct Access gateway version instead of the RepAgent (one of its sub-components) version.
  • Upgrading Direct Access gateway would reset advanced ODBC Connector logging settings (such as log file retention and maximum size) to default.
  • In rare cases, the ODBC connector would crash and could not be restarted by the Direct Access gateway agent.
  • When a connection failed or the SQL query was not valid, a generic "Offset and length were out of bounds..." error would be returned instead of the actual error cause.
  • In rare scenarios, hub reloads would fail with a "DirectAccess-4008" error for apps larger than 3 GB that had extended delays or processing after the initial gateway query. Additional logging has been added to assist in identifying any related issues.

June 12, 2024

1.4.2 July 13, 2023

Resolved issues:

  • Changing the ODBC_LOG_LEVEL value in the C:\ProgramData\Qlik\Gateway\configuration.properties file would have no effect.

  • Reload would fail with the following error if an active Direct Access gateway connection was not used for several minutes:

    Connector error: Invalid load request (DirectAccess-1006)

    The issue was resolved by not timing out if the session is still alive.

  • Loading tables with numerous columns from MySQL and PostgreSQL would sometimes fail with the following error:

    System.InvalidOperationException: Failed to HPACK encode the headers

  • When users did not have privileges on a Managed Space containing the Direct Access gateway, the following unclear error would be shown:

    Requested endpoint could not be provisioned due to failure to acquire a load slot: Object reference not set to an instance of an object.

    The error message was improved with a more accurate description of the issue.

  • Multiple reload attempts would sometimes fail due to excessive memory consumption.

February 19, 2024
1.4.1 June 20, 2023

Features and enhancements:

Direct Access gateway checks its health periodically. Starting from this version, the health check will restart the Direct Access gateway service if it is unresponsive for five minutes.

Resolved issues:

  • When starting a reload with a query that returns metadata immediately but only returns the first data chunk several minutes later, the following error would sometimes occur:

    Connector error: data loading error (DirectAccess-4008)

  • In certain scenarios, Direct Access gateway would not reconnect to Qlik Cloud when a reload was interrupted.

  • In rare situations, the following error would be encountered during reloads:

    No connection could be made because the target machine actively refused it.

  • When connecting to SQL Server, special characters in passwords would not be encoded correctly, resulting in the following error:

    Command test connection returned non-success: Error message: Please check the values for Username‚ Password‚ Host and other properties. Description: Access credentials are not valid for this connection.

  • The ODBC connector would sometimes crash when aborting load activity from the user interface while the query was returning data.

  • In rare scenarios related to heavy loads, reloads would sometimes fail with the following error:

    Connector error: Unknown reason:. Index was outside the bounds of the array. (DirectAccess-1500)

February 19, 2024
1.4.0 June 15, 2023

Updated the CA certificates needed for authenticating the Qlik Cloud tenant.

February 19, 2024
1.3.2 May 30, 2023

This version resolves the following issue:

Qlik Data Gateway - Direct Access 1.3.1 is prone to excessive CPU utilization in certain scenarios. Version 1.3.2 resolves this issue and contains no other changes. To prevent CPU-related failures, we encourage all customers to upgrade to version 1.3.2 immediately.

September 15, 2023
1.3.1 May 9, 2023

This version includes the CA bundle for Qlik Cloud Government and resolves several issues.

The CA bundle authenticates the identity of the Qlik Cloud tenant, thereby ensuring a trusted connection.

In previous Direct Access gateway versions, the CA bundle file for Qlik Cloud Government customers was provided by Qlik as needed. From this version, the CA bundle file is included in the installation.

In a default setup, the CA bundle file is installed to the following location: C:\Program Files\Qlik\ConnectorAgent\caBundle]qcg_ca_bundle.pem

  • A security vulnerability was identified whereby the HTTP client used for proxy connectivity would follow a redirect.
  • The Direct Access gateway agent would sometimes crash with the following error:

    Unable to write data to the transport connection: An established connection was aborted by the software in your host machine

  • An exception would sometimes occur during log initialization, which would cause the Direct Access gateway to hang on restart.
  • Reload session handling was improved to prevent unnecessary timeouts.
  • The Direct Access gateway Version column in Management Console would indicate the wrong version.
  • The agent would continue to send data to the gateway after the user stopped the task or the quota limit was reached.
  • End-to-end encryption for Data Gateway would not be enabled by default and was controlled by runtime flags.
September 15, 2023
1.3.0 February 16th, 2023

This version resolves the following issues:

  • Version 1.2 of Qlik Data Gateway – Direct Access might be prevented from installing due to an issue with its digital signature.
  • Configuration files would be overwritten during upgrade, resulting in changes being lost
September 15, 2023
1.2.0 January 24, 2023

Features and enhancements:

  • Added support for SAP BW and SAP SQL sources. For information on setting up connectivity to these sources, see SAP NetWeaver.

Resolved issues:

  • Improved stability and recoverability of the Qlik Data Gateway - Direct Access service, eliminating the need to manually restart the service
  • Support for overwriting the default Direct Access gateway installation and configuration parameters
May 16th, 2023.
1.1.1 November 15, 2022

Features and enhancements:

  • Added Windows Server 2022 support

Resolved issues:

  • Resolved a potential stability issue related to choosing a custom path during setup
April 24, 2023

1.1.0

October 18, 2022

Features and enhancements:

  • Support for Oracle Wallets
  • Support for Google BigQuery
  • Improved error messages

Resolved issues:

  • Improved system recoverability after driver crashes
  • The Qlik Data Gateway - Direct Access service would sometimes stop unexpectedly

April 24, 2023

1.0.0

August 23, 2022

Initial release

April 24, 2023

The upgrade procedure

To upgrade Direct Access gateway, simply download the setup file again, and then run the setup on the Direct Access gateway machine.

You can determine the installed Qlik Data Gateway - Direct Access version using the following methods:

  • Got to Data gateways in the Management Console and check the Version column.
  • Go to the Apps & features page in Windows Settings on the computer where it is installed.

     

    Version number of Qlik Data Gateway - Direct Access

Did this page help you?

If you find any issues with this page or its content – a typo, a missing step, or a technical error – let us know how we can improve!