Hi all, since upgrading to Qlik Sense Sep 2020, one application won't reload.
In fact, we have this error :
ERROR [HY000] [Qlik][OracleOCI] (3000) Oracle Caller Interface: ORA-24347: Warning of a NULL column in an aggregate function"
when testing, I found out the error is caused by 2 things :
1) MAX(TRUNC(pa.DATEFIELD)) when the datefield is empty/null
2) decode(.... null) : qlik won't accept the null part
ps1 : the query was working fine in Qlik before the upgrade to Sep 2020 (patch 3)
ps2 : the query still works fine in the database
Anyone would know why?
Hi Guys - has this been reported to Qlik?
You can follow steps here - if you do not have a Qlik Support contract: