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: