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!

_{^{(message by CodeOwnersMention)}}

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

Can you install the SQLite Web addon and run the following queries and post here their results:

SELECT * FROM statistics_meta WHERE source="opower";

should return something like:

Then run the following after replacing the ids with the ones from the previous query:

SELECT * FROM statistics WHERE metadata_id = 85 ORDER BY start_ts DESC LIMIT 10;

SELECT * FROM statistics WHERE metadata_id = 86 ORDER BY start_ts DESC LIMIT 10;

I use MariaDB so I had to use PHPMyAdmin, hope this text output is good enough...

|604|opower:ace_elec_4001842964_energy_cost|opower|NULL|0|1|Opower ace elec 4001842964 cost |605|opower:ace_elec_4001842964_energy_consumption|opower|kWh|0|1|Opower ace elec 4001842964 consumption

so 604 yields:

|668103|NULL|NULL|NULL|NULL|NULL|NULL|425.47|28915.129999999994|604|1696020848.368874|1693368000|NULL |579616|NULL|NULL|NULL|NULL|NULL|NULL|492.1|28489.659999999993|604|1693704225.9507341|1690516800|NULL |533758|NULL|NULL|NULL|NULL|NULL|NULL|430.09|27997.559999999994|604|1692397728.5801663|1687838400|NULL |533757|NULL|NULL|NULL|NULL|NULL|NULL|352.59|27567.469999999994|604|1692397728.5777245|1685073600|NULL |533756|NULL|NULL|NULL|NULL|NULL|NULL|246.42|27214.879999999994|604|1692397728.5752783|1682481600|NULL |533755|NULL|NULL|NULL|NULL|NULL|NULL|187.34|26968.459999999995|604|1692397728.5735028|1679976000|NULL |533754|NULL|NULL|NULL|NULL|NULL|NULL|239.17|26781.119999999995|604|1692397728.5717719|1677301200|NULL |533753|NULL|NULL|NULL|NULL|NULL|NULL|169.72|26541.949999999997|604|1692397728.5694172|1674795600|NULL |533752|NULL|NULL|NULL|NULL|NULL|NULL|195.27|26372.229999999996|604|1692397728.5669427|1672376400|NULL |533751|NULL|NULL|NULL|NULL|NULL|NULL|350.93|26176.959999999995|604|1692397728.5646255|1669784400|NULL

and 605 yields:

|668104|NULL|NULL|NULL|NULL|NULL|NULL|1865|149118|605|1696020848.3764186|1693368000|NULL |579617|NULL|NULL|NULL|NULL|NULL|NULL|2184|147253|605|1693704225.9606853|1690516800|NULL |533861|NULL|NULL|NULL|NULL|NULL|NULL|1912|145069|605|1692397728.7193213|1687838400|NULL |533860|NULL|NULL|NULL|NULL|NULL|NULL|1599|143157|605|1692397728.7181406|1685073600|NULL |533859|NULL|NULL|NULL|NULL|NULL|NULL|1184|141558|605|1692397728.7170343|1682481600|NULL |533858|NULL|NULL|NULL|NULL|NULL|NULL|898|140374|605|1692397728.7157485|1679976000|NULL |533857|NULL|NULL|NULL|NULL|NULL|NULL|1177|139476|605|1692397728.7144856|1677301200|NULL |533856|NULL|NULL|NULL|NULL|NULL|NULL|828|138299|605|1692397728.7130892|1674795600|NULL |533855|NULL|NULL|NULL|NULL|NULL|NULL|959|137471|605|1692397728.7120464|1672376400|NULL |533854|NULL|NULL|NULL|NULL|NULL|NULL|1742|136512|605|1692397728.711045|1669784400|NULL

It seems you only have monthly data up to Aug 29, 2023. In the energy dashboard if you change it to the year view you should see data. Not sure yet why it cannot pull more recent data. Can you click on the year view on your screenshot? Do you have bill and day view? Can you run the demo.py of the upstream library at https://github.com/tronikos/opower requesting dates after Aug 29 to try to debug on your own?

I believe my smart meter was installed in August of 2023. I can see day view starting with yesterday. I wonder why my monthly stopped, I’m assuming the integration needs monthly data? I’ve worked for ACE for 23 years, time to make some calls?

I’ll fiddle with demo.py.

Clicking around my account online, my monthly data appears it restarts on September 27th ‘23. So there is a gap, some days are missing and there is a bunch of estimated usage. I guess the first bit of missing data throws the error. What is the query range? 1 year? Thanks!

The integration doesn't need monthly data. It pulls at whatever resolution the utility supports. The supported ones are: hourly, daily, monthly.

If there is a gap that explains it. Would you mind temporarily changing the password and share with me your username and password to see how to best resolve this? You can privately reach me by gmail, discord, or home assistant community. My username is tronikos in all of them.

I DM'd you on Home Assistant community