Support Forum
The Forums are a place to find answers on a range of Fortinet products from peers and product experts.
simosghi
New Contributor

Upgrade Firmware FAZ to 5.4.3 Custom Dataset stop working

Hi,

after a firmware upgrade, a custom dataset stop working:

 

select coalesce(nullifna(`user`),nullifna(`srcname`), ipstr(`srcip`)) as user_src,coalesce (nullifna(root_domain(hostname)),'other')as domain, sum($browse_time) as browsetime, sum(coalesce(sentbyte, 0)+coalesce(rcvdbyte, 0)) as bandwidth, sum(coalesce(rcvdbyte, 0)) as traffic_in, sum(coalesce(sentbyte, 0)) as traffic_out from $log where $filter and coalesce (nullifna(root_domain(hostname)),'other') is not null group by domain, user_src having sum($browse_time)>9 order by user_src asc, browsetime desc

 

The error is this:

ERROR:  function sum(int4range[]) does not exist
LINE 1: ...ullifna(root_domain(hostname)),'other')as domain, sum(ebtime...
^
HINT: No function matches the given name and argument types. You might need to add explicit type casts.

Can Anyone help me?

Thank's

0 REPLIES 0
Announcements

Select Forum Responses to become Knowledge Articles!

Select the “Nominate to Knowledge Base” button to recommend a forum post to become a knowledge article.

Labels
Top Kudoed Authors