Error loading Data from Oracle Query that previously was working

[4Tsatos]

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

[dajjan81]

I have the same error. https://community.qlik.com/t5/New-to-Qlik-Sense/Warning-of-a-NULL-column-in-an-aggregate-function/td...

Did you find a solution?

regards David

[Stefan_dT]

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]

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]

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]

Please, check this post:

Qlik ODBC connector package "ORA-24347: Warning of... - Qlik Community - 1785108