Netbox: accounting report failure
Closed, ResolvedPublic

Description

sudo /srv/deployment/netbox/venv/bin/python /srv/deployment/netbox/deploy/src/netbox/manage.py runreport accounting.Accounting

Jun  7 06:14:13 netbox1002 python[277971]: [06:14:10] Running accounting.Accounting...
Jun  7 06:14:13 netbox1002 python[277971]: Traceback (most recent call last):
Jun  7 06:14:13 netbox1002 python[277971]:   File "/srv/deployment/netbox/deploy/src/netbox/manage.py", line 10, in <module>
Jun  7 06:14:13 netbox1002 python[277971]:     execute_from_command_line(sys.argv)
Jun  7 06:14:13 netbox1002 python[277971]:   File "/srv/deployment/netbox/venv/lib/python3.9/site-packages/django/core/management/__init__.py", line 446, in execute_from_command_line
Jun  7 06:14:13 netbox1002 python[277971]:     utility.execute()
Jun  7 06:14:13 netbox1002 python[277971]:   File "/srv/deployment/netbox/venv/lib/python3.9/site-packages/django/core/management/__init__.py", line 440, in execute
Jun  7 06:14:13 netbox1002 python[277971]:     self.fetch_command(subcommand).run_from_argv(self.argv)
Jun  7 06:14:13 netbox1002 python[277971]:   File "/srv/deployment/netbox/venv/lib/python3.9/site-packages/django/core/management/base.py", line 414, in run_from_argv
Jun  7 06:14:13 netbox1002 python[277971]:     self.execute(*args, **cmd_options)
Jun  7 06:14:13 netbox1002 python[277971]:   File "/srv/deployment/netbox/venv/lib/python3.9/site-packages/django/core/management/base.py", line 460, in execute
Jun  7 06:14:13 netbox1002 python[277971]:     output = self.handle(*args, **options)
Jun  7 06:14:13 netbox1002 python[277971]:   File "/srv/deployment/netbox/current/src/netbox/extras/management/commands/runreport.py", line 55, in handle
Jun  7 06:14:13 netbox1002 python[277971]:     for test_name, attrs in job_result.data.items():
Jun  7 06:14:13 netbox1002 python[277971]: AttributeError: 'NoneType' object has no attribute 'items'

Event Timeline

Restricted Application added a subscriber: Aklapper. · View Herald Transcript

Change #1039978 had a related patch set uploaded (by Ayounsi; author: Ayounsi):

[operations/puppet@production] Disable Accounting report alerting until bug is fixed

https://gerrit.wikimedia.org/r/1039978

Volans claimed this task.

The problem was that a device had been inserted with a numeric serial that the spreadsheet saved as integer. I've set the whole column in google drive as plain text.
We could also add a conversion to string to be safer in the report itself.

Change #1039978 abandoned by Volans:

[operations/puppet@production] Disable Accounting report alerting until bug is fixed

Reason:

Not needed anymore, issue solved

https://gerrit.wikimedia.org/r/1039978