Influx db string

Industrial
1

hello,

connecting influxdb with plc siemens en opcua if i try to send a string i receive this error

unsupported input type for mean aggregate: string

this is what i'm sending

28/4/2024 00:37:29node: debug 38
ns=4;i=8 : msg : Object
object
_msgid: "0501bfd033f6f0e2"
payload: "pluto"
topic: "ns=4;i=8"
datatype: "String"
browseName: "Productie"
statusCode: object
serverTimestamp: "2024-04-27T22:37:31.799Z"
sourceTimestamp: "2024-04-27T22:37:31.799Z"

thi is the query in influxdb

from(bucket: "Test")
  |> range(start: v.timeRangeStart, stop: v.timeRangeStop)
  |> filter(fn: (r) => r["_measurement"] == "prod")
  |> filter(fn: (r) => r["_field"] == "value")
  |> aggregateWindow(every: v.windowPeriod, fn: mean, createEmpty: false)
  |> yield(name: "mean")

image
image826×168 15.8 KB

can smeone help me please

2

Is the error appearing when you run the query to interrogate the database?

What are you expecting to be written to the database when you give it that data? If you read the help text for the influxdb out node you will see that that data will cause the string "pluto" to be written, which I suspect is not what you want.

3

hello Colin
i think this solved by taking away the last 2 rows of code in the query still testing i don't think i'm the one who can give solution here, maybe someone else with more skill can say if i did rght

4

I am trying to, but you have not answered the question

5

sorry i wantend to read a name of production in grafana dashboard that i'm receiving from plc

6

Ok, so for the example you were in fact attempting to write "pluto", in which case that is ok.

The error you were getting was telling you that you were trying to take the mean value of a set of strings (containing "pluto" for example) which obviously you can't do. For string type fields all you can do is read them as a set of records.

7

i'm electrician so i don't know so much abut coding i'm learning and sometimes i spend days to do something that other people do iin 1 second :slight_smile:

8

It takes me forever to wire up a plug :slight_smile:

9

Try excluding the |> aggregateWindow function in your Flux Query. Apparently the column of your value is not of type number (which can be aggregated) its rather of type string (which can't be aggregated).