A Status: 500. Message: Post "http://XXXXXXXXX:8087/api/v2/query?org=XXXXX": EOF

No Data is retrieved when I execute this Influx FLux query

from(bucket: “general”)

|> range(start: -2d)

|> filter(fn: (r) => r[“_measurement”] == “mem”)

|> filter(fn: (r) => r[“_field”] == “device_temperature”)

|> group(columns: [“device_mac”])

|> map(fn: (r) => ({r with device_mac:

if r.device_mac == “” then “”

else if r.device_mac == “BC5729035296” then “CLD0229-5296”

else if r.device_mac == “BC572903525C” then “CLD2528-525C”

else if r.device_mac == “BC572902866A” then “CLD2529-866A”

else if r.device_mac == “BC572902A649” then “CLD2530-A649”

else if r.device_mac == “BC572902A646” then “CLD2531-A646”

else if r.device_mac == “BC5729035294” then “CLD2532-5294”

else if r.device_mac == “BC572902865F” then “CLD2533-865F”

else if r.device_mac == “BC572902A63A” then “CLD2534-A63A”

else if r.device_mac == “BC572903529A” then “CLD2535-529A”

else if r.device_mac == “BC572902865D” then “CLD2536-865D”

else if r.device_mac == “BC5729035282” then “CLD2537-5282”

else if r.device_mac == “BC572902A64E” then “CLD2538-A64E”

else if r.device_mac == “BC572903529F” then “CLD2539-529F”

else if r.device_mac == “BC572903524D” then “CLD2540-524D”

else if r.device_mac == “BC5729035280” then “CLD2541-5280”

else if r.device_mac == “BC5729028664” then “CLD2542-8664”

else if r.device_mac == “BC572902865C” then “CLD2543-865C”

else if r.device_mac == “BC5729035255” then “CLD2544-5255”

else if r.device_mac == “BC572902A632” then “CLD2546-A632”

else if r.device_mac == “BC572903524A” then “CLD2547-524A”

else if r.device_mac == “BC572903F23E” then “CLD7060-F23E”

else if r.device_mac == “BC572902A645” then “CLD7061-A645”

else if r.device_mac == “BC5729028658” then “CLD7062-8658”

else if r.device_mac == “BC572902A64C” then “CLD7063-A64C”

else if r.device_mac == “BC572903529E” then “CLD7064-529E”

else if r.device_mac == “BC572902865E” then “CLD7065-865E”

else if r.device_mac == “BC572903F2F5” then “CLD7066-F2F5”

else if r.device_mac == “BC572902A620” then “CLD7067-A620”

else if r.device_mac == “BC572903F218” then “CLD7068-F218”

else if r.device_mac == “BC572902A633” then “CLD7069-A633”

else if r.device_mac == “BC5729028665” then “CLD7070-8665”

else if r.device_mac == “BC572903F182” then “CLD7071-F182”

else if r.device_mac == “BC572902A639” then “CLD7072-A639”

else if r.device_mac == “BC572903F30E” then “CLD7073-F30E”

else if r.device_mac == “BC572903F1D7” then “CLD7074-F1D7”

else if r.device_mac == “BC572903F1B4” then “CLD7075-F1B4”

else if r.device_mac == “BC572903F1B1” then “CLD7076-F1B1”

else if r.device_mac == “BC572903F2D7” then “CLD7077-F2D7”

else if r.device_mac == “BC572902A650” then “CLD7078-A650”

else if r.device_mac == “BC5729035270” then “CLD7079-5270”

else if r.device_mac == “BC572903524E” then “CLD7080-524E”

else if r.device_mac == “BC572902A63E” then “CLD7081-A63E”

else if r.device_mac == “BC572902A64F” then “CLD7082-A64F”

else if r.device_mac == “BC572903F2C7” then “CLD7083-F2C7”

else if r.device_mac == “BC5729035262” then “CLD7084-5262”

else if r.device_mac == “BC5729028663” then “CLD7085-8663”

else if r.device_mac == “BC5729035285” then “CLD7086-5285”

else if r.device_mac == “BC572903F20B” then “CLD7087-F20B”

else if r.device_mac == “BC572902A636” then “CLD7088-A636”

else if r.device_mac == “BC572902865A” then “CLD7089-865A”

else if r.device_mac == “BC572902A641” then “CLD7090-A641”

else if r.device_mac == “BC5729035267” then “CLD7091-5267”

else if r.device_mac == “BC5729035276” then “CLD7092-5276”

else if r.device_mac == “BC5729028661” then “CLD7093-8661”

else if r.device_mac == “BC572903F206” then “CLD7094-F206”

else if r.device_mac == “BC5729035284” then “CLD7095-5284”

else if r.device_mac == “BC5729035279” then “CLD7096-5279”

else if r.device_mac == “BC572903F1C0” then “CLD7097-F1C0”

else if r.device_mac == “BC5729035253” then “CLD7098-5253”

else if r.device_mac == “BC572903F1DA” then “CLD7099-F1DA”

else if r.device_mac == “BC572903F17B” then “CLD7100-F17B”

else if r.device_mac == “BC572903F2F7” then “CLD7101-F2F7”

else if r.device_mac == “BC572903F1AF” then “CLD7102-F1AF”

else if r.device_mac == “BC572903F18A” then “CLD7103-F18A”

else if r.device_mac == “BC572903F186” then “CLD7104-F186”

else if r.device_mac == “BC5729035265” then “CLD7105-5265”

else if r.device_mac == “BC572903F254” then “CLD7106-F254”

else if r.device_mac == “BC572903F24B” then “CLD7107-F24B”

else if r.device_mac == “BC572903F251” then “CLD7108-F251”

else if r.device_mac == “BC572903F180” then “Taguard-F180”

else if r.device_mac == “BC572903F19F” then “Taguard-F19F”

else if r.device_mac == “BC572903F1A2” then “Taguard-F1A2”

else if r.device_mac == “BC572903F1A5” then “Taguard-F1A5”

else if r.device_mac == “BC572903F1A6” then “Taguard-F1A6”

else if r.device_mac == “BC572903F1BA” then “Taguard-F1BA”

else if r.device_mac == “BC572903F1BB” then “Taguard-F1BB”

else if r.device_mac == “BC572903F1D3” then “Taguard-F1D3”

else if r.device_mac == “BC572903F1E5” then “Taguard-F1E5”

else if r.device_mac == “BC572903F1EC” then “Taguard-F1EC”

else if r.device_mac == “BC572903F1FB” then “Taguard-F1FB”

else if r.device_mac == “BC572903F200” then “Taguard-F200”

else if r.device_mac == “BC572903F207” then “Taguard-F207”

else if r.device_mac == “BC572903F209” then “Taguard-F209”

else if r.device_mac == “BC572903F20C” then “Taguard-F20C”

else if r.device_mac == “BC572903F222” then “Taguard-F222”

else if r.device_mac == “BC572903F229” then “Taguard-F229”

else if r.device_mac == “BC572903F22D” then “Taguard-F22D”

else if r.device_mac == “BC572903F244” then “Taguard-F244”

else if r.device_mac == “BC572903F249” then “Taguard-F249”

else if r.device_mac == “BC572903F250” then “Taguard-F250”

else if r.device_mac == “BC572903F273” then “Taguard-F273”

else if r.device_mac == “BC572903F275” then “Taguard-F275”

else if r.device_mac == “BC572903F2A7” then “Taguard-F2A7”

else if r.device_mac == “BC572903F2B1” then “Taguard-F2B1”

else if r.device_mac == “BC572903F2D8” then “Taguard-F2D8”

else if r.device_mac == “BC572903F2E7” then “Taguard-F2E7”

else if r.device_mac == “BC572903F2FD” then “Taguard-F2FD”

else if r.device_mac == “BC572903F303” then “Taguard-F303”

else “”}))

|> drop(columns: [“_field”, “device_temperature”])

|> drop(columns: [“_field”, “host”])

|> drop(columns: [“_field”, “clockin”])

|> drop(columns: [“_field”, “gateway_insert”])

|> drop(columns: [“_field”, “location”])

|> drop(columns: [“_field”, “history”])

|> aggregateWindow(every: 5m, fn: mean, createEmpty: false)

|> yield(name: “mean”)