Qlik ODBC connector package reload issue using the bulk reader feature

Andreas_Giesbrecht — Tue, 29 Mar 2022 07:42:31 GMT

With the Qlik Sense August 2021 release, Qlik has introduced a bulk reader reload mode for the Qlik ODBC connector package connectors such as MS SQL, Oracle, PostgreSQL, Snowflake, etc...

The bulk reader can be enabled under the Reload Optimization section when creating a database connection.

For more information please check for example the following link: Create a Snowflake connection

In the mentioned Qlik Sense version you may encounter data reload issues such as additional truncated values after the reload via the bulk reader feature, as you can see in the following screenshot there are values like "Aust" and "Bra" which have been truncated from the original values "Austria" and "Brazil":

The expected result should be as the following screenshot:

Environment

Qlik Sense Enterprise August 2021
Qlik Sense Desktop August 2021
Qlik ODBC connector package August 2021

Resolution

The issue is related to a software defect and has been solved in the Qlik Sense November 2021 version. Please also note that the problem might happen with other connectors within the Qlik ODBC connector package.

Workaround:

In order to solve the problem you have the following options:

Upgrade Qlik Sense accordingly to version November 2021 or upwards
Just upgrade the Qlik ODBC connector package version to version November 2021 or upwards
Avoid the bulk reader mode

Fix Version:

Qlik Sense November 2021 and upwards

article Qlik ODBC connector package reload issue using the bulk reader feature in Official Support Articles

Qlik ODBC connector package reload issue using the bulk reader feature

Environment

Resolution

Workaround:

Fix Version: