Grid Status, Savings, Self-Powered, Solar Energy Year panels no longer work

[sassyass]

These were all working fine last year, but about a month ago (the week before Christmas maybe?) these panels stopped working and are now spitting out errors.

When I look at them they are all giving the same error: "Status: 500. Message: InfluxDB returned error: error parsing query: found \/, expected identifier, string, number, bool at line 1, char 149"

I took a peek with Chronograph, and it does look like values are still being populated into InfluxDB:

There was probably a pypowerwall update before this but not 100% sure; and I was waiting for more updates in case it would magically fix itself, but it's still persisted even after the latest updates.

Any help would be appreciated.

[jasonacox]

Hi @sassyass - did you import the latest dashboard.json and overwrite the existing one?

[sassyass]

I did import the latest dashboard.json, but it still gives the same errors.

[jasonacox]

Yikes. This seems more like a corruption in the influxdb. Can you try these:

# Check InfluxDB for errors
docker logs influxdb

# Run setup query to see if there are errors:
docker exec --tty influxdb sh -c "influx -import -path=/var/lib/influxdb/influxdb.sql"

[sassyass]

hmm I was fiddling around with the query, and it looks like it is the time range function.

I changed WHERE $timeFilter tz('$tz') to WHERE $timeFilter GROUP BY time($__interval) fill(null)

and that seems to mostly have fixed it; in the self-powered panel I just took out the tz('$tz')

[jasonacox]

Ah! Nice troubleshooting. I wonder if your timezone variable was missing. If you import the dashboard.json, the timezone should not be blank or have any spaces:

[sassyass]

Hm, no it is populated and looks exactly like that, America/Los_Angeles