M1 EXPORTED/IMPORTED KWH resetting to zero periodically

[ministryofsillywalks]

I have an issue where my sensor.solaredge_m1_exported_kwh & sensor.solaredge_m1_imported_kwh are occasionally resetting "0"

This is somehow happening at pretty similar times:
20:22
06:22
20:15
06:15

It happens to both sensors however not to any other sensors from the modbus integration.
I have no idea whats going on. HA doesn't reboot at these times and also all other network activity seems normal.
These "0" values of course royally screw up my energy dashboard

Any idea whats going on?

[mpredfearn]

@ministryofsillywalks yeah sometimes we get bad data back from the inverter. #44 should fix it once upstream.

[nerfherder]

This should now be fixed

[ChristophCaina]

Hi, I've just noticed the same behave today - but not periodically...
Is there some way to detect, why the sensor was at zero?

[ChristophCaina]

ok, I have recalculated the stats in the Database and changed the SUM... for some time, the Dashboard showed the correct data... but then, suddenly, the issue came back, without another "dip" in the sensors log / history...

Import Sensor

Export Sensor

Stats from 07:00 to 09:30

the previous dip to 0 [the same than in the comment above]

How can I fix this in the table - and why did it come back, after recalculating the sum in the DB ?

[nerfherder]

A new release hasn't gone out yet but the code to fix the 0 values has been merged into master. Just double checking if you have got the latest code?

I'm not sure about the stats issues you are facing, I've been looking into this as well as I got some bad battery charged stats in my history which is impacting my long term stats as well. I believe you can delete the entity from the database and it will rebuild when new stars are added.

[ChristophCaina]

hm... I had some issues whenever I deleted somehting from the stats table...
I did this a few times, when I had bad readings from the default SolarEdge integration (API call)... and whenever I deleted something, the complete DB was rebuilt with empty stats.

The strange thing here is, that whenever I had this in the past, recalculating the SUM did work - and the graph was then OK (until the next bad reading / connection loss, or whatever)

Only this time, after recalculating the sum, the issue came back with the next calculation.
Not sure, if the integration does save the last Sum somewhere... or if this might be related to a change in the core?

[nerfherder]

I don't believe that issue would be coming from this integration from my understanding of the code. There might have been a change in the core.

[gmacioso]

@ChristophCaina
Appreciate, if you find solution how to correct the stats in DB, to share :)
I stucked with same issue...

[ChristophCaina]

only recalculating and editing manually... :-(
Unfortunately, this could cause some other side effects...

I did this right now - trying to fix the values, but since my solar installation did start to produce a small amount of energy, the dashboard graph is now showing some values in the wrong "direction" ...
:-(

honestly speaking:
I haven't seen such a "delicate" thing for a while now... within the last month, I had so many issues in this direction that I really considering to disable the energy dashboard... I can't see any benefit until these kind of issues are fixed... (either in the many integrations that could be related - or the core)

[nerfherder]

What are you editing the db with out of interest?

[ChristophCaina]

For editing the DB, I am using a Supervisor Addon called: SQLite Web
It is a simple SQLite Viewer / Editor...

after the recent change from above, I did refresh the site... now, it seems that the statistics have been summed up again:

• frustrated *

[mpredfearn]

honestly speaking:
I haven't seen such a "delicate" thing for a while now... within the last month, I had so many issues in this direction that I really > considering to disable the energy dashboard... I can't see any benefit until these kind of issues are fixed... (either in the many integrations that could be related - or the core)

Agreed - the energy dashboard is definitely pretty fragile at the moment - but it's still a young feature so some growing pains are kinda to be expected. These issues need to be reported against home assistant core though. I believe we've now solved the "zero problem" with the energy stats from this integration - zero is not tolerated as a valid value for either the inverter total generation nor the import / export meters. So as long as you have the latest version of this integration, any problems observed must be coming from the core.

[ChristophCaina]

So as long as you have the latest version of this integration, any problems observed must be coming from the core.

Currently, I am running Version 1.5.0 of this integration.
I guess, the fix will be in one of the next releases, right?

[WillCodeForCats]

Out of curiosity, what's your integration polling interval and how are you connecting to the inverter?