Knowledge

[Francisco_Fernandez]

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.

1. Once you were provided with the package (qvodbcconnectorpackage-enterprise-6.108.1-3+e368d0a.zip ), unzip it.
2. Go to C:\Program Files\Common Files\Qlik\Custom Data
3. Backup the older folder  "QvOdbcConnectorPackage outside of the original path.
4. 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?...