Skip to main content

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

No ratings
cancel
Showing results for 
Search instead for 
Did you mean: 
Francisco_Fernandez

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

Last Update:

Jul 14, 2021 10:58:46 AM

Updated By:

Patricia_Silva

Created date:

Feb 23, 2021 4:47:18 AM

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: 

 

Labels (1)
Version history
Last update:
‎2021-07-14 10:58 AM
Updated by: