Qlik Community

Knowledge

Search or browse our knowledge base to find answers to your questions ranging from account questions to troubleshooting error messages. The content is curated and updated by our global Support team

Announcements
QlikWorld online is next week! REGISTER NOW

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

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"

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: