since middle of January statistic entities are not working

[2023alpha2023]

hi again,
the new version 1.4.5 didn't solve the problem.
Until around 17.01.24 I got this data in the home assistent energy dashboard (I add two statistic entities)

Everything is fine, Verbrauch and Netzeinspeisung are working
Yellow bar: data from an solar inverter

since 18.01.24 both statistic entities are not working and I got unclear data e.g.:

Three bars for Verbrauch, rest is missing
Netzeinspeisung: no bar

Is there any idea or trick to solve the problem?
If I remember correctly version 1.4.0 or 1.4.1 was working. I tried a couple of things:

• delete the entities
• delete the folder in custom_components
• installed version 1.4.0 or 1.4.1
• installer the actual version

-> no impact, still unclear data

[manolitto]

have a similar problem:

• version 1.4.5
• completely uninstalled the integration and deleted all old data
• reinstalled and reconfigured everything a week ago (when 1.4.5 came out)
• historic data (statistics) loading worked ok (once after setup), but
• on the next day I had a huge negative "consumption"
• and from next day on I get no data any longer at all

[simmac]

Similar issue for me. Look into your logs to see whether you get the same message, this is what I see in my logs:

Unable to load consumption

Please file an issue with this error and (anonymized) payload in github {'hasSmartMeter': True, 'isDataDeleted': False, 'zaehlpunkt': 'AT0010000000000000001000000[redacted], 'type': 'TAGSTROM', 'address': '[redacted]', 'zip': '[redacted]'} {'consumptionYesterdayValue': 10569, 'consumptionYesterdayValidated': True, 'consumptionYesterdayTimestamp': '2024-01-28T23:00:00.000Z', 'consumptionDayBeforeYesterdayValue': 14475, 'consumptionDayBeforeYesterdayValidated': True, 'consumptionDayBeforeYesterdayTimestamp': '2024-01-27T23:00:00.000Z'} {} {'optIn': True, 'consumptionAverage': 0, 'consumptionMinimum': 0, 'consumptionMaximum': 0}

[tixoman]

had the same problem.
My solution: deleting the 0 entries in the recorder database every day.

DELETE
FROM statistics
WHERE metadata_id IN (
SELECT ID FROM statistics_meta WHERE statistic_id LIKE '%AT00%'
)
AND state = 0 AND SUM = 0 AND start_ts >= UNIX_TIMESTAMP( DATE_ADD( UTC_DATE(), INTERVAL -1 DAY) )

So i have no negative consumption and the import is also running correct every day.

[DarwinsBuddy]

Please upgrade to v1.4.6 and follow instructions in FAQs How can I start over with a fresh data import?

[manolitto]

Please upgrade to v1.4.6 and follow instructions in FAQs How can I start over with a fresh data import?

Hmm, I upgraded and followed the FAQ guide (btw. small typo there, guess it should be "Days to keep" instead of "Days to remove"?)
After a restart and the reinstall of the integration everything looked fine.
A little later after another restart (actually a reboot) the Energy Board again shows a huge negative consumption for today (!?).

Will report what happens tomorrow after the next data import run...

[lukas-berger]

Same here, followed the guide in the FAQ and seeing -1096.2 kWh consumption for today.

[stefanschramek]

I have the same issues, as mentioned here #219