Qlik ODBC connector package ERROR : "ORA-24347: Warning of a NULL column in an aggregate function"

Francisco_Fernandez — Wed, 14 Jul 2021 14:58:46 GMT

Qlik Sense fails to load data from Oracle Database with the following ERROR message: "ERROR [HY000] [Qlik][OracleOCI] (3000) Oracle Caller Interface: ORA-24347: Warning of a NULL column in an aggregate function" .

This issue occurs due to a Simba Driver Bug on this version: 1.04.03.1003. The workaround is to replace the new Qlik ODBC connector package.

Environment :

Affected versions:

Qlik Sense September 2020
Qlik Sense November 2020
Qlik Sense February 2021

Workaround :

A new ODBC connector package is required. The package can be obtained from Qlik Support. Please contact us and reference this article.

Once you were provided with the package (qvodbcconnectorpackage-enterprise-6.108.1-3+e368d0a.zip ), unzip it.
Go to C:\Program Files\Common Files\Qlik\Custom Data
Backup the older folder "QvOdbcConnectorPackage outside of the original path.
COPY/REPLACE the new folder QvOdbcConnectorPackage in the zip attached under the path C:\Program Files\Common Files\Qlik\Custom Data

Please note that any change made has to be done with the services stopped.

Cause

Product Defect ID: QB-3179

Alternatively, you can download the package here:

https://www.dropbox.com/s/x6gtktj53uop0l0/qvodbcconnectorpackage-enterprise-6.108.1-3%2Be368d0a.zip?dl=0

article Qlik ODBC connector package ERROR : "ORA-24347: Warning of a NULL column in an aggregate function" in Official Support Articles

Qlik ODBC connector package ERROR : "ORA-24347: Warning of a NULL column in an aggregate function"

Environment :

Workaround :

Cause