Qlik Community

New to Qlik Sense

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

Announcements
QlikWorld 2022, LIVE in Denver CO., May 16-19, 2022. REGISTER NOW TO RECEIVE EARLY BIRD PRICING
cancel
Showing results for 
Search instead for 
Did you mean: 
OmarBenSalem
Partner
Partner

Problem wtih Qlik Sense Sep 2020 - sql query error

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 !

 
5 Replies
OmarBenSalem
Partner
Partner
Author

anyone? 

mikhail_babkin
Contributor
Contributor

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
Contributor
Contributor

Same problem

Michael_Tarallo
Employee
Employee

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...

Regards,
Mike Tarallo
Qlik
Michael_Tarallo
Employee
Employee

I sent over to PM for quick review

Regards,
Mike Tarallo
Qlik