Opower not working for Seattle City Light

[alcooper91]

The problem

Starting around June 10 it looks like opower stopped populating data from Seattle City Light. I deleted and re-added my credentials and now my previous (6) sensors don't appear to have re-populated. I have since upgraded home assistant in hopes that maybe there was just some bug, but they haven't been restored either. I did not upgrade around the time that it broke.

What version of Home Assistant Core has the issue?

2024.06.4

What was the last working version of Home Assistant Core?

No response

What type of installation are you running?

Home Assistant OS

Integration causing the issue

opower

Link to integration documentation on our website

https://www.home-assistant.io/integrations/scl/

Diagnostics information

No response

Example YAML snippet

No response

Anything in the logs that might be useful for us?

Logs do not show any errors for opower, even when enabling debug logging:

2024-06-22 19:00:17.514 DEBUG (MainThread) [homeassistant.components.opower.coordinator] Updating sensor data with: []
2024-06-22 19:00:17.514 DEBUG (MainThread) [homeassistant.components.opower.coordinator] Updating Statistics for opower:scl_elec_<not_actually_my_account_#>_energy_cost and opower:scl_elec_<not_actually_my_account_#>_energy_consumption
2024-06-22 19:00:18.554 DEBUG (MainThread) [homeassistant.components.opower.coordinator] Finished fetching Opower data in 7.195 seconds (success: True)

Note that the two sensors it seems to query statistics for are configured in my energy setup.

Additional information

No response

[home-assistant[bot]]

scl documentation scl source

[alcooper91]

@tronikos since I see you are an Opower owner that has been tagged in a different bug? I think this fell through the cracks since I tagged it as a specific provider.

[tronikos]

When does your billing period start? For the first few days these sensors are often not available. You should be using the statistics, see https://www.home-assistant.io/integrations/opower#energy Are these available and up to date? (a couple of days delay is normal)

[alcooper91]

Looks like my last billing period was April 12-June 12. I thought the last day of data that I had before trying to recreate was June 10, which with the two day lag means that June 12 is likely when it stopped pulling data. When I just looked now though it looks like it’s populated data until June 17

The integration hasn’t provided any new entities since I tried to re set it up on I believe June 20. (E.g. previously on the integrations page it listed one service and six entities and now it lists just one service)

All of the existing opower entities on the statistics page have error messages like:

This entity has no state at the moment, if this is an orphaned entity, you may want to delete the long term statistics of it from your database.

Do you want to permanently delete the long term statistics of sensor.current_bill_electric_usage_to_date from your database?

[alcooper91]

Hmm, I actually do see non orphaned entities in the statistics panel for the consumption and cost (though cost has always reported as 0), but the data ends around June 17, the logs do show that they were updated. But there is no error message.

[alcooper91]

I’ll also note again (as I kind of buried it in the initial post) that the sensors it shows as getting data for are the ones it always has, but that the number string that should be the account number is not and has never been an account number I see in the UI when I log into the utility.

[jacobmovingfwd]

I've been seeing the same thing. I just deleted & recreated the Integration entry, and it has no devices or entities. Before, it had 1 device, but with no entities, and no info on the energy panel.

Yet, somehow even with no entity, there's still something on the Energy panel:

Could this be an old account maybe? Does Opower manage a user having old accounts properly?