Something appears to be forcing some of your aggregates that should be
calculated on the daily summaries to be instead calculated on the archive.
is there any chance you have some future dated records in your archive? Try
the following to check:
1. open your database with sqlite3:
$ sqlite3 /var/lib/weewx/weewx.sdb
(if sqlite3 is not found you will need to install it using something like sudo
apt install sqlite3 and then try again)
2. obtain the timestamp of the last record in the archive in human readable
form:
sqlite> SELECT datetime(MAX(dateTime), 'unixepoch', 'localtime') FROM
archive;
This should display something like:
2023-06-05 03:05:00
3. exit sqlite3:
sqlite> .q
If the date at step 2 above is in the future you have some future dated
records in your archive. To remove these:
1. stop WeeWX
$ sudo systemctl stop weewx
2. make a backup of your WeeWX database:
$ cp /var/lib/weewx/weewx.sdb /var/lib/weewx/weewx_backup.sdb
3. open your database with sqlite3:
$ sqlite3 /var/lib/weewx/weewx.sdb
4. delete all future dated archive records:
sqlite> DELETE FROM archive WHERE dateTime>STRFTIME('%s');
5. check there are no more future dated records:
sqlite> SELECT datetime(MAX(dateTime), 'unixepoch', 'localtime') FROM
archive;
6. if there are no more future dated records exit sqlite3:
sqlite> .q
7. rebuild the daily summaries:
$ wee_database --rebuild-daily
8. restart WeeWX:
$ sudo systemctl restart WeeWX
Depending on your system some of the above linux commands may need to be
prefixed with sudo.
Gary
On Monday, 5 June 2023 at 18:59:05 UTC+2 mihec wrote:
> Hi,
> I'm having issues with NOAA report generation ever since I installed the
> station but never minded enough to fix it.
> I use Weatherflow Air & Sky, weewx version is 3.9.2.
>
> This is the error message in the /var/log/syslog:
>
> Jun 5 18:52:37 raspberrypi weewx[451]: cheetahgenerator: Generate failed
> with exception '<class 'weewx.ViolatedPrecondition'>'
> Jun 5 18:52:37 raspberrypi weewx[451]: cheetahgenerator: **** Ignoring
> template /etc/weewx/skins/neowx/NOAA/NOAA-YYYY.txt.tmpl
> Jun 5 18:52:37 raspberrypi weewx[451]: cheetahgenerator: **** Reason:
> Invalid aggregation type 'meanmax'
> Jun 5 18:52:37 raspberrypi weewx[451]: **** Traceback (most recent call
> last):
> Jun 5 18:52:37 raspberrypi weewx[451]: **** File
> "/usr/share/weewx/weewx/cheetahgenerator.py", line 332, in generate
> Jun 5 18:52:37 raspberrypi weewx[451]: ****
> fd.write(str(compiled_template))
> Jun 5 18:52:37 raspberrypi weewx[451]: **** File
> "/usr/lib/python2.7/dist-packages/Cheetah/Template.py", line 1005, in
> __str__
> Jun 5 18:52:37 raspberrypi weewx[451]: **** rc = getattr(self,
> mainMethName)()
> Jun 5 18:52:37 raspberrypi weewx[451]: **** File
> "_etc_weewx_skins_neowx_NOAA_NOAA_YYYY_txt_tmpl.py", line 741, in respond
> Jun 5 18:52:37 raspberrypi weewx[451]: **** File
> "_etc_weewx_skins_neowx_NOAA_NOAA_YYYY_txt_tmpl.py", line 315, in
> __errorCatcher28
> Jun 5 18:52:37 raspberrypi weewx[451]: **** File "<string>", line 1,
> in <module>
> Jun 5 18:52:37 raspberrypi weewx[451]: **** File
> "/usr/share/weewx/weewx/tags.py", line 329, in __getattr__
> Jun 5 18:52:37 raspberrypi weewx[451]: **** return
> self._do_query(aggregate_type)
> Jun 5 18:52:37 raspberrypi weewx[451]: **** File
> "/usr/share/weewx/weewx/tags.py", line 343, in _do_query
> Jun 5 18:52:37 raspberrypi weewx[451]: **** val=val,
> **self.option_dict)
> Jun 5 18:52:37 raspberrypi weewx[451]: **** File
> "/usr/share/weewx/weewx/wxmanager.py", line 60, in getAggregate
> Jun 5 18:52:37 raspberrypi weewx[451]: **** return
> weewx.manager.DaySummaryManager.getAggregate(self, timespan, obs_type,
> aggregateType, **option_dict)
> Jun 5 18:52:37 raspberrypi weewx[451]: **** File
> "/usr/share/weewx/weewx/manager.py", line 1268, in getAggregate
> Jun 5 18:52:37 raspberrypi weewx[451]: **** **option_dict)
> Jun 5 18:52:37 raspberrypi weewx[451]: **** File
> "/usr/share/weewx/weewx/manager.py", line 450, in getAggregate
> Jun 5 18:52:37 raspberrypi weewx[451]: **** raise
> weewx.ViolatedPrecondition("Invalid aggregation type '%s'" % aggregate_type)
> Jun 5 18:52:37 raspberrypi weewx[451]: **** ViolatedPrecondition:
> Invalid aggregation type 'meanmax'
> Jun 5 18:52:37 raspberrypi weewx[451]: cheetahgenerator: Generate failed
> with exception '<class 'weedb.NoColumnError'>'
> Jun 5 18:52:37 raspberrypi weewx[451]: cheetahgenerator: **** Ignoring
> template /etc/weewx/skins/neowx/NOAA/NOAA-YYYY-MM.txt.tmpl
> Jun 5 18:52:38 raspberrypi weewx[451]: cheetahgenerator: **** Reason: no
> such column: wind
> Jun 5 18:52:38 raspberrypi weewx[451]: **** Traceback (most recent call
> last):
> Jun 5 18:52:38 raspberrypi weewx[451]: **** File
> "/usr/share/weewx/weewx/cheetahgenerator.py", line 332, in generate
> Jun 5 18:52:38 raspberrypi weewx[451]: ****
> fd.write(str(compiled_template))
> Jun 5 18:52:38 raspberrypi weewx[451]: **** File
> "/usr/lib/python2.7/dist-packages/Cheetah/Template.py", line 1005, in
> __str__
> Jun 5 18:52:38 raspberrypi weewx[451]: **** rc = getattr(self,
> mainMethName)()
> Jun 5 18:52:38 raspberrypi weewx[451]: **** File
> "_etc_weewx_skins_neowx_NOAA_NOAA_YYYY_MM_txt_tmpl.py", line 496, in respond
> Jun 5 18:52:38 raspberrypi weewx[451]: **** File
> "_etc_weewx_skins_neowx_NOAA_NOAA_YYYY_MM_txt_tmpl.py", line 308, in
> __errorCatcher35
> Jun 5 18:52:38 raspberrypi weewx[451]: **** File "<string>", line 1,
> in <module>
> Jun 5 18:52:38 raspberrypi weewx[451]: **** File
> "/usr/share/weewx/weewx/tags.py", line 329, in __getattr__
> Jun 5 18:52:38 raspberrypi weewx[451]: **** return
> self._do_query(aggregate_type)
> Jun 5 18:52:38 raspberrypi weewx[451]: **** File
> "/usr/share/weewx/weewx/tags.py", line 343, in _do_query
> Jun 5 18:52:38 raspberrypi weewx[451]: **** val=val,
> **self.option_dict)
> Jun 5 18:52:38 raspberrypi weewx[451]: **** File
> "/usr/share/weewx/weewx/wxmanager.py", line 60, in getAggregate
> Jun 5 18:52:38 raspberrypi weewx[451]: **** return
> weewx.manager.DaySummaryManager.getAggregate(self, timespan, obs_type,
> aggregateType, **option_dict)
> Jun 5 18:52:38 raspberrypi weewx[451]: **** File
> "/usr/share/weewx/weewx/manager.py", line 1268, in getAggregate
> Jun 5 18:52:38 raspberrypi weewx[451]: **** **option_dict)
> Jun 5 18:52:38 raspberrypi weewx[451]: **** File
> "/usr/share/weewx/weewx/manager.py", line 459, in getAggregate
> Jun 5 18:52:38 raspberrypi weewx[451]: **** _row =
> self.getSql(select_stmt % interpolate_dict)
> Jun 5 18:52:38 raspberrypi weewx[451]: **** File
> "/usr/share/weewx/weewx/manager.py", line 395, in getSql
> Jun 5 18:52:38 raspberrypi weewx[451]: **** _cursor.execute(sql,
> sqlargs)
> Jun 5 18:52:38 raspberrypi weewx[451]: **** File
> "/usr/share/weewx/weedb/sqlite.py", line 41, in guarded_fn
> Jun 5 18:52:38 raspberrypi weewx[451]: **** raise
> weedb.NoColumnError(e)
> Jun 5 18:52:38 raspberrypi weewx[451]: **** NoColumnError: no such
> column: wind
>
> Is the problem related to the missing aggregation type or something else?
>
> Thanks.
>
--
You received this message because you are subscribed to the Google Groups
"weewx-user" group.
To unsubscribe from this group and stop receiving emails from it, send an email
to weewx-user+unsubscr...@googlegroups.com.
To view this discussion on the web visit
https://groups.google.com/d/msgid/weewx-user/89fe51a1-3eb1-490d-b6f5-9863c1c28591n%40googlegroups.com.
