KwH feeds reset to zero after power failure

Emoncms
1

We had a power outage here a few weeks back that has a caused a glitch in the energydata calculated from the incoming power feeds. ie when I look at the incoming solar and import (grid) power feeds on that day (May 17) I can see a jump with no data from approx 9:00am when the power was cut through to approx 4:45pm when I fixed the date/time problem and it started recording correctly again. However, I have since noticed that there was a huge glitch in the energy feed graphs and now I have discovered that this has been caused by the import and solar energy feeds being reset to zero.
My system is a RPi3 with emontxv3 with directserial software.
Powered by OpenEnergyMonitor.org | low-write 9.7.9 | 2017.01.05
Local emoncms

Can I edit the data to re-instate the correct values?.

Date, Time, importkwH, SolarKwH
2017-05-17 08:45:00, 909.2, 869.6
2017-05-17 08:50:00, 909.3, 869.7
2017-05-17 08:55:00, 909.4, 869.8
2017-05-17 09:00:00, 909.4, 869.8
2017-05-17 09:05:00, 0.0, 0.0
2017-05-17 09:10:00, 0.2, 0.0
2017-05-17 09:15:00, 0.3, 0.0
2017-05-17 09:20:00, 0.4, 0.0
2017-05-17 09:25:00, 0.4, 0.0
2017-05-17 09:30:00, 0.4, 0.0
2017-05-17 09:35:00, 0.4, 0.0
2017-05-17 09:40:00, 0.4, 0.0
2017-05-17 09:45:00, 0.4, 0.0

energy feed corruption.jpg1288×685 111 KB
power and energy feeds.jpg1275×675 148 KB

2

So no-one has any ideas or pointers of where to start looking?

3

Allan - Look for EditRealTime

I’m not sure how well this will work. Sometimes it works for me and other times it seems to do nothing. Make sure you backup your data first!

Under the menu Extra > Visualisations look for 1) Select visualisation: and then select EditRealTime. Under 2) Set options: find the feed to be fixed.

Screen Shot 2017-06-06 at 8.47.32 PM.png2342×1480 360 KB

Click the data point you want to change. Then enter your new value.

I believe this feature was disabled on emoncms.org. I am not sure of its status on a RasPi or an emonPi.

4

Thanks Jon,
That certainly had an effect on the feeds that had reset themselves. The edit process seems a bit random though. I went back to the date that the reset had occurred and corrected the first incorrect log entry and nothing appeared to have happened, however upon monitoring the current output I noticed that it had jumped up to the value I had just entered.
ie I changed the entry for 17/05/17 9:05:00 to 909.4 as per the above table, but the only thing that changed was the current value for June 7th.
I tried a few times at various date/time points and sometimes they altered the value for that point and other times it changed the current value. Maybe it has something to do with when emoncms is updating a new value.
In the end I just added an offset to the current value equal to the point just before reset and left it to run. At least the future values will be correct.

5

I know im digging up an old thread but, I’ve just noticed this issue when I went to pull up my July solar stats.

we had a power blink on the 27th and all the kwh feeds has reset to 0. its now a couple of days later and looking for the best way to correct the data.

I am looking at the edit real time bit, And can see that i could multiply everything in a window by a float or a fraction. - Can a constant be added or am I missing a math trick that i could be using?

Or is there something in Post process that could be used?