Kapacitor returning NULL values

InfluxDB 1 Kapacitor
1

Hi All,

facing bit wired issue with this simple stream script.

  1. It is returning ‘duplicate’ data with duplicate row having all NULLs for FIELD Values for each correct row.

  2. output is missing two field tags ‘UPTIME’ and ‘UPTIME_FORMAT’

so far I had triple verified data in database, dropped measurement SYSTEM and re-created, but it is not helping here.

Script ::

var data = stream
|from()
.measurement(‘system’)
|window()
.period(6m)
.every(3s)

|httpOut('all_rec')
2

This has been resolved by using isPresent before aggregation.