Hi Team,
Error: ts=2019-09-06T08:45:00.215+02:00 lvl=error msg=“error evaluating expression” service=kapacitor task_master=main task=wincalculator node=influxdb_out16 err=“invalid math operator + for type missing”
ts=2019-09-06T08:45:00.215+02:00 lvl=error msg=“error evaluating expression” service=kapacitor task_master=main task=wincalculator node=influxdb_out16 err=“invalid math operator * for type missing”
dbrp "telegraf"."200_days"
var cpu_user = batch
|query('SELECT 100 - last(Percent_Idle_Time) FROM "telegraf"."200_days".win_cpu where bu=\'DGFF\' and instance=\'_Total\'')
.period(5m)
.every(5m)
.groupBy('solution','service','environment','host')
.align()
.fill(0.0)
|log()
|sideload()
.source('file:/appl/grafana/influx/kapacitor/conf/load/tasks/sideload')
.order('{{.host}}.yml')
.field('cpuval', 10.0)
var memusage = batch
|query(''' SELECT last(Committed_Bytes) as commitedbytes,last(Available_Bytes) as availablebytes FROM "telegraf"."200_days".win_mem where bu='DGFF' ''')
.period(5m)
.every(5m)
.groupBy('solution','service','environment','host')
.align()
.fill(0.0)
|log()
|sideload()
.source('file:/appl/grafana/influx/kapacitor/conf/load/tasks/sideload')
.order('{{.host}}.yml')
.field('memval', 10.0)
var swapusage = batch
|query('SELECT last(Percent_Usage) FROM "telegraf"."200_days".win_swap where bu=\'DGFF\'')
.period(5m)
.every(5m)
.groupBy('solution','service','environment','host')
.align()
.fill(0.0)
|log()
|sideload()
.source('file:/appl/grafana/influx/kapacitor/conf/load/tasks/sideload')
.order('{{.host}}.yml')
.field('swapval', 10.0)
var cpuUsage=cpu_user
var memUsage=memusage
var swapUsage=swapusage
var Health_Score = cpuUsage
|join(memUsage,swapUsage)
.as('cpuUsage','memUsage','swapUsage')
.fill(0.0)
|eval(lambda: ("memUsage.commitedbytes" / ("memUsage.availablebytes" + "memUsage.commitedbytes")) * 100.0).as('memHealth')
|eval(
lambda: (100.0-("cpuUsage.last" * "cpuUsage.cpuval")/10.0),
lambda: (100.0-("memHealth" * "memUsage.memval")/10.0),
lambda: (100.0-("swapUsage.last" * "swapUsage.swapval")/10.0)
).as('cpuHealth','memhealth','swaphealth')
|influxDBOut()
.cluster('name')
.create()
.database('testdb')
.retentionPolicy('myrp')
.measurement('measurement')
Need your assistance on this issue.