National Grid (Upstate NY) is not retrieving any data

[fcastilloec]

The problem

I notice that I have no electricity data since December 25th. I know there are a couple of days of delay to show the data up, but it's been too long. In addition, some Opower sensors are now unavailable.
When debugging, there are no errors. The Opower integrations shows 200 status for fetching all the URLs, and tokens, even retrieves statistics, but none of them are shown.

What version of Home Assistant Core has the issue?

core-2025.1.0

What was the last working version of Home Assistant Core?

core-2024.11

What type of installation are you running?

Home Assistant Supervised

Integration causing the issue

Opower

Link to integration documentation on our website

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

Diagnostics information

No response

Example YAML snippet

No response

Anything in the logs that might be useful for us?

2025-01-06 15:27:52.852 DEBUG (MainThread) [opower.utilities.nationalgridnyupstate] Starting login process for National Grid
2025-01-06 15:27:52.901 DEBUG (MainThread) [opower.utilities.oidchelper] Generated PKCE code verifier and challenge
2025-01-06 15:27:52.902 DEBUG (MainThread) [opower.utilities.oidchelper] Fetching OAuth configuration from: https://login.nationalgrid.com/0e1366c5-731c-42b3-90d3-508039d9e70f/B2C_1A_UWP_NationalGrid_convert_merge_signin/v2.0/.well-known/openid-configuration
2025-01-06 15:27:52.902 DEBUG (MainThread) [opower.utilities.oidchelper] Fetching URL: https://login.nationalgrid.com/0e1366c5-731c-42b3-90d3-508039d9e70f/B2C_1A_UWP_NationalGrid_convert_merge_signin/v2.0/.well-known/openid-configuration, Method: GET
2025-01-06 15:27:53.413 DEBUG (MainThread) [opower.utilities.oidchelper] Fetch completed. Status: 200
2025-01-06 15:27:53.413 DEBUG (MainThread) [opower.utilities.oidchelper] Retrieved OAuth configuration
2025-01-06 15:27:53.413 DEBUG (MainThread) [opower.utilities.oidchelper] Requesting authorization code
2025-01-06 15:27:53.413 DEBUG (MainThread) [opower.utilities.oidchelper] Fetching URL: https://login.nationalgrid.com/0e1366c5-731c-42b3-90d3-508039d9e70f/b2c_1a_uwp_nationalgrid_convert_merge_signin/oauth2/v2.0/authorize, Method: GET
2025-01-06 15:27:54.003 DEBUG (MainThread) [opower.utilities.oidchelper] Fetch completed. Status: 200
2025-01-06 15:27:54.003 DEBUG (MainThread) [opower.utilities.oidchelper] Extracting settings from authorization content
2025-01-06 15:27:54.003 DEBUG (MainThread) [opower.utilities.oidchelper] Settings successfully extracted
2025-01-06 15:27:54.003 DEBUG (MainThread) [opower.utilities.oidchelper] Posting credentials
2025-01-06 15:27:54.003 DEBUG (MainThread) [opower.utilities.oidchelper] Posting credentials to https://login.nationalgrid.com/0e1366c5-731c-42b3-90d3-508039d9e70f
2025-01-06 15:27:54.004 DEBUG (MainThread) [opower.utilities.oidchelper] Fetching URL: https://login.nationalgrid.com/0e1366c5-731c-42b3-90d3-508039d9e70f/B2C_1A_UWP_NationalGrid_convert_merge_signin/SelfAsserted, Method: POST
2025-01-06 15:27:54.855 DEBUG (MainThread) [opower.utilities.oidchelper] Fetch completed. Status: 200
2025-01-06 15:27:54.857 DEBUG (MainThread) [opower.utilities.oidchelper] Credentials posted successfully
2025-01-06 15:27:54.857 DEBUG (MainThread) [opower.utilities.oidchelper] Confirming sign-in
2025-01-06 15:27:54.857 DEBUG (MainThread) [opower.utilities.oidchelper] Confirming sign-in at https://login.nationalgrid.com/0e1366c5-731c-42b3-90d3-508039d9e70f
2025-01-06 15:27:54.857 DEBUG (MainThread) [opower.utilities.oidchelper] Fetching URL: https://login.nationalgrid.com/0e1366c5-731c-42b3-90d3-508039d9e70f/B2C_1A_UWP_NationalGrid_convert_merge_signin/api/CombinedSigninAndSignup/confirmed, Method: GET
2025-01-06 15:27:55.345 DEBUG (MainThread) [opower.utilities.oidchelper] Fetch completed. Status: 200
2025-01-06 15:27:55.345 DEBUG (MainThread) [opower.utilities.oidchelper] Sign-in confirmed, authorization code obtained
2025-01-06 15:27:55.345 DEBUG (MainThread) [opower.utilities.oidchelper] Obtained authorization code
2025-01-06 15:27:55.345 DEBUG (MainThread) [opower.utilities.oidchelper] Requesting access token
2025-01-06 15:27:55.346 DEBUG (MainThread) [opower.utilities.oidchelper] Fetching URL: https://login.nationalgrid.com/0e1366c5-731c-42b3-90d3-508039d9e70f/b2c_1a_uwp_nationalgrid_convert_merge_signin/oauth2/v2.0/token, Method: POST
2025-01-06 15:27:55.435 DEBUG (MainThread) [opower.utilities.oidchelper] Fetch completed. Status: 200
2025-01-06 15:27:55.435 DEBUG (MainThread) [opower.utilities.oidchelper] Successfully obtained access token
2025-01-06 15:27:56.597 DEBUG (MainThread) [homeassistant.components.opower.coordinator] Updating sensor data with: []
2025-01-06 15:27:56.597 DEBUG (MainThread) [homeassistant.components.opower.coordinator] Updating Statistics for opower:ngny_elec_**********_e_energy_cost and opower:ngny_elec_**********_e_energy_consumption
2025-01-06 15:27:56.865 DEBUG (MainThread) [homeassistant.components.opower.coordinator] Getting monthly cost reads: 2024-11-25 23:00:00-05:00 - 2025-01-06 15:27:56.865205-05:00
2025-01-06 15:27:56.975 DEBUG (MainThread) [homeassistant.components.opower.coordinator] Got 1 monthly cost reads
2025-01-06 15:27:56.975 DEBUG (MainThread) [homeassistant.components.opower.coordinator] Getting daily cost reads: 2024-11-01 00:00:00-04:00 - 2025-01-06 15:27:56.865205-05:00
2025-01-06 15:27:57.425 DEBUG (MainThread) [homeassistant.components.opower.coordinator] Got 55 daily cost reads
2025-01-06 15:27:57.425 DEBUG (MainThread) [homeassistant.components.opower.coordinator] Getting hourly cost reads: 2024-11-07 15:27:56.865205-05:00 - 2025-01-06 15:27:56.865205-05:00
2025-01-06 15:27:58.218 DEBUG (MainThread) [homeassistant.components.opower.coordinator] Got 1176 hourly cost reads
2025-01-06 15:27:58.219 DEBUG (MainThread) [homeassistant.components.opower.coordinator] Got 1182 cost reads
2025-01-06 15:27:58.220 DEBUG (MainThread) [homeassistant.components.opower.coordinator] Getting statistics at: 2024-11-01 00:00:00-04:00
2025-01-06 15:27:58.298 DEBUG (MainThread) [homeassistant.components.opower.coordinator] Adding 1181 statistics for opower:ngny_elec_**********_e_energy_cost
2025-01-06 15:27:58.307 DEBUG (MainThread) [homeassistant.components.opower.coordinator] Adding 1181 statistics for opower:ngny_elec_**********_e_energy_consumption
2025-01-06 15:27:58.317 DEBUG (MainThread) [homeassistant.components.opower.coordinator] Updating Statistics for opower:ngny_gas_**********_g_energy_cost and opower:ngny_gas_**********_g_energy_consumption
2025-01-06 15:27:58.342 DEBUG (MainThread) [homeassistant.components.opower.coordinator] Getting monthly cost reads: 2024-10-03 00:00:00-04:00 - 2025-01-06 15:27:58.342001-05:00
2025-01-06 15:27:58.509 DEBUG (MainThread) [homeassistant.components.opower.coordinator] Got 2 monthly cost reads
2025-01-06 15:27:58.510 DEBUG (MainThread) [homeassistant.components.opower.coordinator] Getting statistics at: 2024-10-02 00:00:00-04:00
2025-01-06 15:27:58.519 DEBUG (MainThread) [homeassistant.components.opower.coordinator] Adding 1 statistics for opower:ngny_gas_**********_g_energy_cost
2025-01-06 15:27:58.519 DEBUG (MainThread) [homeassistant.components.opower.coordinator] Adding 1 statistics for opower:ngny_gas_**********_g_energy_consumption
2025-01-06 15:27:58.519 DEBUG (MainThread) [homeassistant.components.opower.coordinator] Finished fetching Opower data in 5.668 seconds (success: True)

Additional information

The logs show that daily cost, hourly cost, and other statistics have been downloaded without issues. I've also checked the National Grid website, and there's data for every day, including today. I'm guessing the issue is with Home Assistant itself, not even the Opower python module, but I'm happy to provide any additional logs or test things to help fix this issue

[home-assistant]

Hey there @tronikos, mind taking a look at this issue as it has been labeled with an integration (opower) you are listed as a code owner for? Thanks!

Code owner commands

Code owners of opower can trigger bot actions by commenting:

• @home-assistant close Closes the issue.
• @home-assistant rename Awesome new title Renames the issue.
• @home-assistant reopen Reopen the issue.
• @home-assistant unassign opower Removes the current integration label and assignees on the issue, add the integration domain after the command.
• @home-assistant add-label needs-more-information Add a label (needs-more-information, problem in dependency, problem in custom component) to the issue.
• @home-assistant remove-label needs-more-information Remove a label (needs-more-information, problem in dependency, problem in custom component) on the issue.

_{^{(message by CodeOwnersMention)}}

---

opower documentation
opower source
_{^{(message by IssueLinks)}}

[ZackWilson90]

I also have the same issue and conditions. The only difference is I show data up until the 25th.

[fcastilloec]

I see I'm not alone. I'm glad you mentioned the 25th because it madee double check and indeed I have data up to the 25th and nothing afterwards. I've edited my original post. Thanks!

[schmosby]

Same issue here... but I also noticed this is the most recent data available directly from national grid so it might be on their end...

I logged into https://myaccount.nationalgrid.com/energy-usage and viewed Usage Data Breakdown -> Energy Usage -> View by Day, December 25th is the most recent date I can view. :(

[fcastilloec]

@schmosby I saw the same after I downloaded my data for the current billing period. Indeed, the last available data is December 25th.