
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
ERROR [HY000] [Qlik][OracleOCI] (3000) Oracle Caller Interface: ORA-24347: Warning of a NULL column in an aggregate function
Hi all,
I'm having this error in an app that worked fine :

- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
One solution, at least until i find a better one, is to filter out the the rows which have only NULL-values within the grouping. This may help, if you dont need all of the data.
More complex, you create a second select for the grouping, using only rows without NULL-values, joining this to the base select (with grouping, but no aggregation) and fill the empty rows with some other value, if you dont want it to be NULL values. That was my choice, when i needed all data.
Looks like that:
select d.grp,case when d2.sum_sales is null then 0 else d2.sum_sales from dataset d group by d.grp
left join
(select grp, sum(sales) as sum_sales from dataset where sales is not null group by grp) d2
on d.grp = d2.grp;


- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
I have the same problem. Anyone have a solution?
It started after update the version to Fev 2021

- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
I got a similar problem.
"The following error occurred:
ERROR [HY000] [Qlik][OracleOCI] (3000) Oracle Caller Interface: ORA-00904: " ": invalid identifier.
Any idea on what to do?


- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
here is a knowledge article related to the same error ora-24347
If a post helps to resolve your issue, please accept it as a Solution.

- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
Hola, tengo el mismo problema, hay alguna solucion?
