Server log sees data but graphic look fails.

5 years 5 months ago #3185 by SteveR
Hi:
New and looking for help.
My esp8266 sketch seems to work and the Easy_IOT server log shows
2016-04-06T10:33:01.5616061-04:00 INFO EasyIoTWebinterface EasyIoTControl Data Virtual /Api/EasyIoT/Control/Data/Virtual/N14S0/slr_test02.temp/Day/?_=1459953114462
2016-04-06T10:33:01.5736068-04:00 INFO EasyIoTWebinterface EasyIoTControl Data Virtual /Api/EasyIoT/Control/Data/Virtual/N14S0/sr.test02.temp/Day/?_=1459953114463
2016-04-06T10:33:10.4191127-04:00 INFO EasyIoTWebinterface EasyIoTControl Module Virtual /Api/EasyIoT/Control/Module/Virtual/N14S0/ControlLevel/78.24
2016-04-06T10:37:24.1796270-04:00 INFO EasyIoTWebinterface EasyIoTControl Module Virtual /Api/EasyIoT/Control/Module/Virtual/N14S0/ControlLevel/78.35
2016-04-06T10:39:25.8325852-04:00 INFO EasyIoTWebinterface EasyIoTControl Module Virtual /Api/EasyIoT/Control/Module/Virtual/N14S0/ControlLevel/78.46
2016-04-06T10:40:27.3661047-04:00 INFO EasyIoTWebinterface EasyIoTControl Module Virtual /Api/EasyIoT/Control/Module/Virtual/N14S0/ControlLevel/78.35
2016-04-06T10:43:29.1315011-04:00 INFO EasyIoTWebinterface EasyIoTControl Module Virtual /Api/EasyIoT/Control/Module/Virtual/N14S0/ControlLevel/78.46
but when I try to open my (Virtual__ Temperature node N14S0 to view the data what I get is shown in attached 'error messages.jpg'. The context is shown in the attached 'page control chart.jpg'.
Any help or suggestions would be much appreciated. Thanks in advance.
Attachments:

Please Log in or Create an account to join the conversation.

5 years 4 months ago #3258 by NightOne
Not sure if you have managed to fix this, but that error normally means that there is a nan value on the database....meaning the graph can not render... What you will need is to open the SQLite datafile with something like sqlitebrowser.org/ (sqlite browser)... Then browse at all the "raw_values" and look for nan values.....I know its not idea but the easiest way to fix is to select the nan values and simple delete them...as there is no way of knowing what the value should have been.

This has happened to me a few times when I have loaded a sketch onto a arduino with code that tries to read a sensor that is not connected and then tried to upload a weird value to EasyIOT....this produces the error.

Please Log in or Create an account to join the conversation.

Time to create page: 0.266 seconds