Qlik Community

Ask a Question

New to Qlik Sense

If you’re new to Qlik Sense, start with this Discussion Board and get up-to-speed quickly.

Announcements
Become an analytics expert with Qlik's new 15 week course: Applied Data Analytics using Qlik Sense. READ MORE
cancel
Showing results for 
Search instead for 
Did you mean: 
4Tsatos
Contributor
Contributor

Error loading Data from Oracle Query that previously was working

I'm getting this error on loading

ERROR [HY000] [Qlik][OracleOCI] (3000) Oracle Caller Interface: ORA-24347: Warning of a NULL column in an aggregate function

My SQL statement is working without any warning using other Oracle SQL clients

It's highly possible for this to happen after installing latest updates

Thank you

Labels (2)
5 Replies
dajjan81
Contributor II
Contributor II

Stefan_dT
Contributor III
Contributor III

This seems to be a bug in Oracle that comes and go.

Found an old entry from 2012 on stackOverflow that reads:  “…Looking around on the net I find this was reported as a bug at various times in Oracle versions 8 and 9 - perhaps it has crept back into 11.2”

See mentioned link to mentioned post:
https://stackoverflow.com/questions/11771462/ora-24347-warning-of-a-null-column-in-an-aggregate-func...

 

Stefan_dT
Contributor III
Contributor III

Also found an Oracle support entry for this from 19 Oct 2020 - no solution listed.

https://support.oracle.com/knowledge/Oracle%20Database%20Products/2430361_1.html#FIX 

4Tsatos
Contributor
Contributor
Author

Nope, just i'm trying to avoid sending complex ORACLE queries directly from QLIK. I realized that is better to build a warehouse database, so i made all queries tables. What it is for me still a question is why this started to happen last 2,3 months, propably after an update on QLik sense platform

Anna_Klimkova
Employee
Employee