Skip to main content
Announcements
Qlik Connect 2024! Seize endless possibilities! LEARN MORE
cancel
Showing results for 
Search instead for 
Did you mean: 
jmlozano
Partner - Contributor II
Partner - Contributor II

Warning of a NULL column in an aggregate function

I'm getting this error loading data through my oracle connection.

"Se ha producido el siguiente error: ERROR [HY000] [Qlik][OracleOCI] (3000) Oracle Caller Interface: ORA-24347: Warning of a NULL column in an aggregate function"

The view is working perfectly in database. And the data load was working a few months ago. ¿Any idea what's happening?

 

Thanks in advance

Labels (1)
14 Replies
Ken_T
Specialist
Specialist

we also downgraded to 6.40.5 version on the our Nov 2020 P3 env to workaround this issue. we have a ticket open with Qlik Support on this issue, hopefully they can confirm this is a problem in the Nov 2020 odbc connector

alexander_nagler
Partner Ambassador
Partner Ambassador

@Ken_T : Hello Ken, thanks for this information and suggested workaround. Do already have some  update form the Qlik Support regarding this? We're facing the same problem.

BR 

Alexander

Ken_T
Specialist
Specialist

@Alex there is a bug for the issue, QB-3807, but they have not given any timeline for the potential fix yet.  I did ask that they update this thread once they have some more details on this. we have not seen any problems since moving to the older version of the package

stvegerton
Creator III
Creator III

Wonder if it's possible to ignore this warning with a variable in the connector. Anyone? 

Ken_T
Specialist
Specialist

Anyone heard any update on this bug?