Problem wtih Qlik Sense Sep 2020 - sql query error

[OmarBenSalem]

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?

@Michael_Tarallo maybe? 

Thanks !

[OmarBenSalem]

anyone? 

[mikhail_babkin]

Same problem. We' ve fixed this issue by replacing catalog with oracle drivers in qlik folder to catalog from previous version of Qlik Sense. 

[Popov_Pavel]

Same problem

[Michael_Tarallo]

Hi Guys - has this been reported to Qlik?

You can follow steps here - if you do not have a Qlik Support contract:

https://community.qlik.com/t5/Qlik-Fix/Qlik-Fix-How-to-Log-a-Case-as-a-Guest-in-the-Support-Portal/t...

[Michael_Tarallo]

I sent over to PM for quick review