Statistics clean-up after zero-data input by SMA integration

[marieper (Per Lundborg)]

Early this morning the SMA integaration and/or my solar inverter sent some bad data into the yield entity

but restored itself to the original value a couple of hours later. The consequence is that the Energy dashboard recorded this as a 141kWh entry at 06:00.

I have tried with updating the statistics SQL entries for the failing two hours, both the states field as well as correcting the following sum field, but the correction is not reflected in the entity history nor in the Energy dashboard.

update "statistics_short_term" set state=141.625 where  metadata_id=190 and state=0

and

update "statistics" set state=141.625 where  metadata_id=190 and state=0

Is there any additional table that needs to be updated in order to set things straight?

[tom_l]

How to fix statistics data (e.g. energy data)

Hey I have managed (I think) to solve the issue which was bothering me for a long time and I have decided to share the solution with you guys. I hope that someone finds it helpful. Problem I have OWL energy sensor which sends the data via RF433. The problem is that sometimes the received values are not correct. Pretty often I get “0” as the energy_total and once the value jumped significantly by 78M. [image] I don’t have the sensor data to investigate what has happened that day and what wer…

To prevent this happening again:

How To Prevent Entity From Resetting To 0?

I have a similar issue with my SMA solar inverter. Every week or so it goes offline momentarily in the middle of the night (no idea why - it has non persistent logs!) and this changes the kWh counter to a low value then 0, then back up to the normal > 4000kWh count when it comes back online. This introduces a massive spike in energy use in home assistant. I have created a filtered version of the raw sensor (sensor.total_yield) to fix the issue: template: - sensor: - name: "total_yield_f…

[marieper (Per Lundborg)]

Thank you.

I will (try) to revert the sum field, as it seems like, contrary to what to expect, the sum correction has to be to increase the preceding entries rather than decreasing the succeeding entries.

[marieper (Per Lundborg)]

Actually decressing worked as well, although the entity history graph is not corrected the Energy Dashboard display correct values.

I will look into the filtering option pending my update of HA and the correction of the integration