One wrong value every night

Energy
#1

For the last couple of weeks I am having the issue that the energy dashboard shows ONE totally off value between 4 and 5 am which destroys the whole dashboard and statistics:

Bildschirm­foto 2023-03-04 um 09.24.41
Bildschirm­foto 2023-03-04 um 09.24.412816×1856 419 KB

I can manually correct it hen everything is fine

But it happens every night between 4 and 5 am - does anyone have an idea what that could be - I have prepared a cron-job deleting negative values between that timeframe and started testing it but would like to actually solve the root cause of it…

#2

What is odd that both your production as well as consumption show a peak, seems to be a correction.
Are you calculating one value using the other?

#3

Share your sensor configurations. Also share the energy history graphs for the sensors around the time this happens.

#4

Is this sensor a total consumption-sensor or one that resets every day? If it is the latter, than that is probably the reason.

#5

Is there a trick - it says I can only add one screenshot - should I post 6 replies now or create a PDF ?

#6

Try posting the images now.

#7

Alright - this is my current dashboard:

grafik
grafik1412×812 35.6 KB

Grid Import Sensor History looks good:

grafik
grafik1417×656 28.7 KB

Grid Export:

grafik
grafik1401×617 26.6 KB

Solar Production:

grafik
grafik1410×627 28 KB

Watermeter:

grafik
grafik1393×604 26.1 KB

All sensors are MQTT sensors configured as Total Increasing

Only Grid Import and Export are coming from the powermeter over modbus but also configured as Total Increasing.

modbus:

  • name: hub1
    type: serial
    baudrate: 9600
    bytesize: 8
    method: rtu
    parity: E
    port: /dev/ttyUSB0
    stopbits: 1
    sensors:
    • name: sdm630_total_power_import
      slave: 11
      address: 72
      input_type: input
      count: 2
      precision: 2
      data_type: float32
      unit_of_measurement: kWh
      device_class: energy
      state_class: total_increasing
      scan_interval: 1800
    • name: sdm630_total_power_export
      slave: 11
      address: 74
      input_type: input
      count: 2
      precision: 2
      data_type: float32
      unit_of_measurement: kWh
      device_class: energy
      state_class: total_increasing
      scan_interval: 1800

So I double checked again - the history graphs of all sensors are correct - only in the dashbboard it shows wrong - I think there the statistic values are used - they are wrong - why I do not know:

So here for examle - Grid Import - all of the sudden at 4:10 am - the import was minus 64,34 - so a negative value…

grafik
grafik474×685 22.6 KB

Also the solar production (the PV is offline during night) the statistic shows at the same time a negative production:

grafik
grafik513×589 23.1 KB

#8

Show the configuration for sensor.fritz_dect_210_total_energy and format it properly.

#9

Can you pls help me where I find it ? I have not added this sensor manually as it was auto discovered:

grafik
grafik549×545 12.9 KB

grafik
grafik543×569 17.7 KB

#10

Never mind. What does its history look like?

#11

grafik
grafik1407×601 32 KB

Last night only:

grafik
grafik1384×605 26.2 KB

The History Graphs all look perfectly fine- only increasing- no negative values or peaks…

#12

Any idea what that coule be ?
It happens almost every day but not all days…

Is there a way to delete maybe ALL statistics if that is causing the issue but not the histories ? The histories all are fine…

#13

What I also found out in the DB at that time - the sum of changes to 0 and seems to restart to count from there…

grafik
grafik1367×268 44.7 KB

#14

Then I can’t explain it. Statistics are generated from this state.

#15

It is very very strange but I am not alone → Statistics reset to zero every now and then - #9 by PaStaDA
@sedael has the very same issue obviously :frowning: