No updates for several days about wienernetzesmartmeter HOT 8 CLOSED

Oh my, that sounds like a mess. 🫣

from wienernetzesmartmeter.

No, it isn't the API. They have a complete failure of the smart meter interface since Thursday. You can also see this, when you take a look at the smartmeter-web.wienernetze.at site.
I called them today and they confirmed this outage. They couldn't tell me - what a surprise - until when it will work again. ;-)
But in the evening hours I was able to discover some data from the end of last week in the web interface. So something is happening... albeit in small steps.

from wienernetzesmartmeter.

Thanks a lot @mundschenk-at for reporting
and @mr-p666 for investigating. That saves myself some time. Unfortunately the integration is, still, just reactive upon such incidents.

I'll have to invest some time to look at @reox PR regarding statistical measurements, which may compensate for such outages in some way.

Stay safe and thanks for the combined effort.

from wienernetzesmartmeter.

I can report that the API seems to be back again with data. However, I lost the 17th of March...
The problem with the current approach is, that as soon as data is imported from timepoint t, it seems to be impossible to add any data for x < t.
I.e., in the current case: The outage started on the 17th and was resolved on the 20th. However, for some reason data for the 18th appeared first and thus the 17th is now lost forever...
As far as I can tell, HA is not able to add stuff in between, because the overall sum has to match.
Or am I wrong about that? (Unfortunately, there is no documentation on the functions :( )

from wienernetzesmartmeter.

Even if there was no new data, rows were created in the statistics table over time.
Currently the only way to add the missing data is to manually update the corresponding lines in the DB. Basically, this is quite easy if you are familiar with SQL queries.

from wienernetzesmartmeter.

as far as I remember from the thread in the HA community forum, SQL is only half the way. That's why there is the statistics import in the first place. But also that one is limited in many regards... As far as I can tell, HA is not built to support that and thus there are now so many workarounds.

Or can you nowadays simply add the required data via SQL and all the statistics and so on will work correctly?

from wienernetzesmartmeter.

Basically you are not wrong.
In this case, however, it works because you're only updating rows from the middle of the table - let's say - you want to do a finer gradation of the existing statistics. The current values are retained as they are correct, so it's not a problem.
But keep in mind, do this only, if you know how it works. And it's always a good idea to create a backup before. ;-)

from wienernetzesmartmeter.

I see. Then the question is, if I should implement it :D I guess using the API with the known limitations is much safer, but knowing a workaround is also good!

from wienernetzesmartmeter.