Running all scripts fails after upgrade to 4.1.2

[bruma1972]

Hello,

after upgrading to Version 4.1.2 most scripts failes to run in gui. If i run the scripts in the cli it work perfectly. Also if i create a simple "Hello World" script it failes as well.
Is there a way to debug this in the gui?

This is the error message:

Server Error
There was a problem with your request. Please contact an administrator.

The complete exception is provided below:

<class 'AttributeError'>

'NoneType' object has no attribute 'available_columns'

Python version: 3.12.3
NetBox version: 4.1.2
Plugins:
netbox_bgp: 0.14.0

Any ideas?

Thx and BR Markus

[candlerb]

after upgrading to Version 4.1.2

from what version?

Also if i create a simple "Hello World" script it failes as well.

Can you show the exact script?

Is there a way to debug this in the gui?

Set DEBUG=True in configuration.py, and restart Netbox, and then the exception will show a full backtrace.

Also, I suggest you go to 4.1.5, to pick up the most recent bug fixes, although I'm not aware of a specific issue in 4.1.2-4.1.4

[bruma1972]

i have upgraded from 3.7.x

the script is:

from extras.scripts import Script
class Test(Script):
def run(self, data, commit):
self.log_info("Hello World")

i run the netbox in the latest docker environment (3.0.2)

here is the debug output

[candlerb]

the script is:

Adding the correct indentation, with Netbox 4.1.5 I get a different (known) error:

Exception Type: ValidationError at /extras/scripts/34/
Exception Value: {'name': ['This field cannot be blank.']}

See #17885. Fix here can be applied by hand if you can't wait for next release. EDIT: 4.1.6 with the fix is now out.

[wz4]

@candlerb I'm sorry to hijack this thread. Are you able to run custom scripts via the CLI or API in v4.1.6? I am still getting the error you referenced.

[candlerb]

Scripts and reports work fine for me in v4.1.6 in the GUI, but I had not tested CLI or API execution.

Running from CLI appears to be broken, AFAICS:

# /opt/netbox/venv/bin/python /opt/netbox/netbox/manage.py runscript ip-check-prefix.CheckPrefixLength
...
  File "/opt/netbox/netbox/extras/management/commands/runscript.py", line 85, in handle
    job = ScriptJob.enqueue(
          ^^^^^^^^^^^^^^^^^^
  File "/opt/netbox/netbox/netbox/jobs.py", line 106, in enqueue
    return Job.enqueue(cls.handle, name=name, *args, **kwargs)
           ^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^
  File "/opt/netbox/netbox/core/models/jobs.py", line 236, in enqueue
    job.full_clean()
  File "/opt/netbox/venv/lib/python3.12/site-packages/django/db/models/base.py", line 1561, in full_clean
    raise ValidationError(errors)
django.core.exceptions.ValidationError: {'name': ['This field cannot be blank.']}

I suggest you raise a bug for this (preferably including a specific simple script you're trying to run, which works in GUI but not from CLI)

I have not tested API. Ditto.

[iamjpy]

I'm running v4.1.6 on k8s installed with netbox-community/netbox-chart

I have the same issue when executing any custom script

[candlerb]

Is it possible to get the full backtrace, not as a screenshot but as text copy-paste?

[iamjpy]

Here's the traceback:

netbox Internal Server Error: /extras/scripts/results/23/
netbox Traceback (most recent call last):
netbox   File "/opt/netbox/venv/lib/python3.12/site-packages/django/core/handlers/exception.py", line 55, in inner
netbox     response = get_response(request)
netbox                ^^^^^^^^^^^^^^^^^^^^^
netbox   File "/opt/netbox/venv/lib/python3.12/site-packages/django/core/handlers/base.py", line 197, in _get_response
netbox     response = wrapped_callback(request, *callback_args, **callback_kwargs)
netbox                ^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^
netbox   File "/opt/netbox/venv/lib/python3.12/site-packages/django/views/generic/base.py", line 104, in view
netbox     return self.dispatch(request, *args, **kwargs)
netbox            ^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^
netbox   File "/opt/netbox/netbox/netbox/views/generic/base.py", line 26, in dispatch
netbox     return super().dispatch(request, *args, **kwargs)
netbox            ^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^
netbox   File "/opt/netbox/netbox/utilities/views.py", line 125, in dispatch
netbox     return super().dispatch(request, *args, **kwargs)
netbox            ^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^
netbox   File "/opt/netbox/netbox/utilities/views.py", line 39, in dispatch
netbox     return super().dispatch(request, *args, **kwargs)
netbox            ^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^
netbox   File "/opt/netbox/venv/lib/python3.12/site-packages/django/views/generic/base.py", line 143, in dispatch
netbox     return handler(request, *args, **kwargs)
netbox            ^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^
netbox   File "/opt/netbox/netbox/extras/views.py", line 1337, in get
netbox     return render(request, 'extras/script_result.html', context)
netbox            ^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^
netbox   File "/opt/netbox/venv/lib/python3.12/site-packages/django/shortcuts.py", line 25, in render
netbox     content = loader.render_to_string(template_name, context, request, using=using)
netbox               ^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^
netbox   File "/opt/netbox/venv/lib/python3.12/site-packages/django/template/loader.py", line 62, in render_to_string
netbox     return template.render(context, request)
netbox            ^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^
netbox   File "/opt/netbox/venv/lib/python3.12/site-packages/django/template/backends/django.py", line 61, in render
netbox     return self.template.render(context)
netbox            ^^^^^^^^^^^^^^^^^^^^^^^^^^^^^
netbox   File "/opt/netbox/venv/lib/python3.12/site-packages/django/template/base.py", line 171, in render
netbox     return self._render(context)
netbox            ^^^^^^^^^^^^^^^^^^^^^
netbox   File "/opt/netbox/venv/lib/python3.12/site-packages/django/template/base.py", line 163, in _render
netbox     return self.nodelist.render(context)
netbox            ^^^^^^^^^^^^^^^^^^^^^^^^^^^^^
netbox   File "/opt/netbox/venv/lib/python3.12/site-packages/django/template/base.py", line 1000, in render
netbox     return SafeString("".join([node.render_annotated(context) for node in self]))
netbox                                ^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^
netbox   File "/opt/netbox/venv/lib/python3.12/site-packages/django/template/base.py", line 961, in render_annotated
netbox     return self.render(context)
netbox            ^^^^^^^^^^^^^^^^^^^^
netbox   File "/opt/netbox/venv/lib/python3.12/site-packages/django/template/loader_tags.py", line 159, in render
netbox     return compiled_parent._render(context)
netbox            ^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^
netbox   File "/opt/netbox/venv/lib/python3.12/site-packages/django/template/base.py", line 163, in _render
netbox     return self.nodelist.render(context)
netbox            ^^^^^^^^^^^^^^^^^^^^^^^^^^^^^
netbox   File "/opt/netbox/venv/lib/python3.12/site-packages/django/template/base.py", line 1000, in render
netbox     return SafeString("".join([node.render_annotated(context) for node in self]))
netbox                                ^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^
netbox   File "/opt/netbox/venv/lib/python3.12/site-packages/django/template/base.py", line 961, in render_annotated
netbox     return self.render(context)
netbox            ^^^^^^^^^^^^^^^^^^^^
netbox   File "/opt/netbox/venv/lib/python3.12/site-packages/django/template/loader_tags.py", line 159, in render
netbox     return compiled_parent._render(context)
netbox            ^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^
netbox   File "/opt/netbox/venv/lib/python3.12/site-packages/django/template/base.py", line 163, in _render
netbox     return self.nodelist.render(context)
netbox            ^^^^^^^^^^^^^^^^^^^^^^^^^^^^^
netbox   File "/opt/netbox/venv/lib/python3.12/site-packages/django/template/base.py", line 1000, in render
netbox     return SafeString("".join([node.render_annotated(context) for node in self]))
netbox                                ^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^
netbox   File "/opt/netbox/venv/lib/python3.12/site-packages/django/template/base.py", line 961, in render_annotated
netbox     return self.render(context)
netbox            ^^^^^^^^^^^^^^^^^^^^
netbox   File "/opt/netbox/venv/lib/python3.12/site-packages/django/template/loader_tags.py", line 159, in render
netbox     return compiled_parent._render(context)
netbox            ^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^
netbox   File "/opt/netbox/venv/lib/python3.12/site-packages/django/template/base.py", line 163, in _render
netbox     return self.nodelist.render(context)
netbox            ^^^^^^^^^^^^^^^^^^^^^^^^^^^^^
netbox   File "/opt/netbox/venv/lib/python3.12/site-packages/django/template/base.py", line 1000, in render
netbox     return SafeString("".join([node.render_annotated(context) for node in self]))
netbox                                ^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^
netbox   File "/opt/netbox/venv/lib/python3.12/site-packages/django/template/base.py", line 961, in render_annotated
netbox     return self.render(context)
netbox            ^^^^^^^^^^^^^^^^^^^^
netbox   File "/opt/netbox/venv/lib/python3.12/site-packages/django/template/loader_tags.py", line 65, in render
netbox     result = block.nodelist.render(context)
netbox              ^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^
netbox   File "/opt/netbox/venv/lib/python3.12/site-packages/django/template/base.py", line 1000, in render
netbox     return SafeString("".join([node.render_annotated(context) for node in self]))
netbox                                ^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^
netbox   File "/opt/netbox/venv/lib/python3.12/site-packages/django/template/base.py", line 961, in render_annotated
netbox     return self.render(context)
netbox            ^^^^^^^^^^^^^^^^^^^^
netbox   File "/opt/netbox/venv/lib/python3.12/site-packages/django/template/loader_tags.py", line 65, in render
netbox     result = block.nodelist.render(context)
netbox              ^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^
netbox   File "/opt/netbox/venv/lib/python3.12/site-packages/django/template/base.py", line 1000, in render
netbox     return SafeString("".join([node.render_annotated(context) for node in self]))
netbox                                ^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^
netbox   File "/opt/netbox/venv/lib/python3.12/site-packages/django/template/base.py", line 961, in render_annotated
netbox     return self.render(context)
netbox            ^^^^^^^^^^^^^^^^^^^^
netbox   File "/opt/netbox/venv/lib/python3.12/site-packages/django/template/defaulttags.py", line 326, in render
netbox     return nodelist.render(context)
netbox            ^^^^^^^^^^^^^^^^^^^^^^^^
netbox   File "/opt/netbox/venv/lib/python3.12/site-packages/django/template/base.py", line 1000, in render
netbox     return SafeString("".join([node.render_annotated(context) for node in self]))
netbox                                ^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^
netbox   File "/opt/netbox/venv/lib/python3.12/site-packages/django/template/base.py", line 961, in render_annotated
netbox     return self.render(context)
netbox            ^^^^^^^^^^^^^^^^^^^^
netbox   File "/opt/netbox/venv/lib/python3.12/site-packages/django/template/library.py", line 258, in render
netbox     _dict = self.func(*resolved_args, **resolved_kwargs)
netbox             ^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^
netbox   File "/opt/netbox/netbox/utilities/templatetags/helpers.py", line 263, in table_config_form
netbox     'form': TableConfigForm(table=table),
netbox             ^^^^^^^^^^^^^^^^^^^^^^^^^^^^
netbox   File "/opt/netbox/netbox/utilities/forms/forms.py", line 135, in __init__
netbox     self.fields['available_columns'].choices = table.available_columns
netbox                                                ^^^^^^^^^^^^^^^^^^^^^^^
netbox AttributeError: 'NoneType' object has no attribute 'available_columns'

Thanks

[candlerb]

AFAICS, this is generating the HTML for the "Configure Table" button in the scripts results page. I find it doesn't appear when I first run the script (since the job isn't completed at that time), but if I refresh the page /extras/scripts/results/NNN/ then it appears:

Of course, it works for me (v4.1.6). But I have seen cases reported where users' table configurations have gotten corrupted.

You could try deleting the stored table config for the currently logged-in user:

# sudo -u postgres psql netbox
select id,username from users_user;
select data from users_userconfig where user_id=NNN;    << NOTE
delete from users_userconfig where user_id=NNN;

and logout and in again (NOTE: was there any config for "ScriptResultsTable" or "ReportResultsTable" in here?)

But there's no guarantee this will fix things, as I don't understand how it could end up with table=None rather than table=some-actual-table-object.

Do you have the "experimental HTMX navigation" option turned on for the user? (username > Preferences) If so, try turning it off.

---

Aside: I found the following in netbox/extras/views.py

class ScriptResultView(BaseScriptView):
...
    def get(self, request, **kwargs):
        table = None      <<<<< NOTE!
        job = get_object_or_404(Job.objects.all(), pk=kwargs.get('job_pk'))

        if job.completed:
            table = self.get_table(job, request, bulk_actions=False)     <<<<< NOTE!!

        log_threshold = request.GET.get('log_threshold', LogLevelChoices.LOG_DEBUG)
        if log_threshold not in LOG_LEVEL_RANK:
            log_threshold = LogLevelChoices.LOG_DEBUG

        context = {
            'script': job.object,
            'job': job,
            'table': table,
            'log_levels': dict(LogLevelChoices),
            'log_threshold': log_threshold,
        }

...

        # If this is an HTMX request, return only the result HTML
        if htmx_partial(request):
            if request.GET.get('log'):
                # If log=True, render only the log table
                return render(request, 'htmx/table.html', context)
            response = render(request, 'extras/htmx/script_result.html', context)
            if job.completed or not job.started:
                response.status_code = 286
            return response

        return render(request, 'extras/script_result.html', context)

I can certainly see how you'd get table=None if the job is not completed (but then, the configuration table should not be included, since it's wrapped by {% if job.completed %}). I can also see that the function get_table can return None in certain circumstances (e.g. if job.data is empty); there is different logic for 'scripts' and legacy 'reports'

I think it would be necessary to add some debugging in that function to determine if it's returning None, and why, to get to the underlying problem. Sorry, I can't help you further, although a quick-and-dirty hack to make things work again might be:

--- a/netbox/templates/extras/script_result.html
+++ b/netbox/templates/extras/script_result.html
@@ -111,7 +111,7 @@
 {% endblock content %}

 {% block modals %}
-  {% if job.completed %}
+  {% if job.completed and table %}
   {% table_config_form table table_name="ObjectTable" %}
   {% endif %}
 {% endblock modals %}

[bruma1972]

Hi,

i have tried your fixes. If i delete the userconfig in the database i am not able to logon with this user again. Also the modification of the script _resuts.html has no impact for me.

Here is my traceback as you requested:

/opt/netbox/venv/lib/python3.12/site-packages/django/core/handlers/exception.py, line 55, in inner
response = get_response(request)
^^^^^^^^^^^^^^^^^^^^^ …
Local vars
/opt/netbox/venv/lib/python3.12/site-packages/django/core/handlers/base.py, line 197, in _get_response
response = wrapped_callback(request, *callback_args, **callback_kwargs)
^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^ …
Local vars
/opt/netbox/venv/lib/python3.12/site-packages/django/views/generic/base.py, line 104, in view
return self.dispatch(request, *args, **kwargs)
^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^ …
Local vars
/opt/netbox/netbox/netbox/views/generic/base.py, line 26, in dispatch
return super().dispatch(request, *args, **kwargs)
^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^ …
Local vars
/opt/netbox/netbox/utilities/views.py, line 125, in dispatch
return super().dispatch(request, *args, **kwargs)
^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^ …
Local vars
/opt/netbox/netbox/utilities/views.py, line 39, in dispatch
return super().dispatch(request, *args, **kwargs)
^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^ …
Local vars
/opt/netbox/venv/lib/python3.12/site-packages/django/views/generic/base.py, line 143, in dispatch
return handler(request, *args, **kwargs)
^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^ …
Local vars
/opt/netbox/netbox/extras/views.py, line 1337, in get
return render(request, 'extras/script_result.html', context)
^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^ …
Local vars
/opt/netbox/venv/lib/python3.12/site-packages/django/shortcuts.py, line 25, in render
content = loader.render_to_string(template_name, context, request, using=using)
^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^ …
Local vars
/opt/netbox/venv/lib/python3.12/site-packages/django/template/loader.py, line 62, in render_to_string
return template.render(context, request)
^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^ …
Local vars
/opt/netbox/venv/lib/python3.12/site-packages/django/template/backends/django.py, line 61, in render
return self.template.render(context)
^^^^^^^^^^^^^^^^^^^^^^^^^^^^^ …
Local vars
/opt/netbox/venv/lib/python3.12/site-packages/django/template/base.py, line 171, in render
return self._render(context)
^^^^^^^^^^^^^^^^^^^^^ …
Local vars
/opt/netbox/venv/lib/python3.12/site-packages/django/test/utils.py, line 111, in instrumented_test_render
return self.nodelist.render(context)
^^^^^^^^^^^^^^^^^^^^^^^^^^^^^ …
Local vars
/opt/netbox/venv/lib/python3.12/site-packages/django/template/base.py, line 1000, in render
return SafeString("".join([node.render_annotated(context) for node in self]))
^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^ …
Local vars
/opt/netbox/venv/lib/python3.12/site-packages/django/template/base.py, line 961, in render_annotated
return self.render(context)
^^^^^^^^^^^^^^^^^^^^ …
Local vars
/opt/netbox/venv/lib/python3.12/site-packages/django/template/loader_tags.py, line 159, in render
return compiled_parent._render(context)
^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^ …
Local vars
/opt/netbox/venv/lib/python3.12/site-packages/django/test/utils.py, line 111, in instrumented_test_render
return self.nodelist.render(context)
^^^^^^^^^^^^^^^^^^^^^^^^^^^^^ …
Local vars
/opt/netbox/venv/lib/python3.12/site-packages/django/template/base.py, line 1000, in render
return SafeString("".join([node.render_annotated(context) for node in self]))
^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^ …
Local vars
/opt/netbox/venv/lib/python3.12/site-packages/django/template/base.py, line 961, in render_annotated
return self.render(context)
^^^^^^^^^^^^^^^^^^^^ …
Local vars
/opt/netbox/venv/lib/python3.12/site-packages/django/template/loader_tags.py, line 159, in render
return compiled_parent._render(context)
^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^ …
Local vars
/opt/netbox/venv/lib/python3.12/site-packages/django/test/utils.py, line 111, in instrumented_test_render
return self.nodelist.render(context)
^^^^^^^^^^^^^^^^^^^^^^^^^^^^^ …
Local vars
/opt/netbox/venv/lib/python3.12/site-packages/django/template/base.py, line 1000, in render
return SafeString("".join([node.render_annotated(context) for node in self]))
^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^ …
Local vars
/opt/netbox/venv/lib/python3.12/site-packages/django/template/base.py, line 961, in render_annotated
return self.render(context)
^^^^^^^^^^^^^^^^^^^^ …
Local vars
/opt/netbox/venv/lib/python3.12/site-packages/django/template/loader_tags.py, line 159, in render
return compiled_parent._render(context)
^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^ …
Local vars
/opt/netbox/venv/lib/python3.12/site-packages/django/test/utils.py, line 111, in instrumented_test_render
return self.nodelist.render(context)
^^^^^^^^^^^^^^^^^^^^^^^^^^^^^ …
Local vars
/opt/netbox/venv/lib/python3.12/site-packages/django/template/base.py, line 1000, in render
return SafeString("".join([node.render_annotated(context) for node in self]))
^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^ …
Local vars
/opt/netbox/venv/lib/python3.12/site-packages/django/template/base.py, line 961, in render_annotated
return self.render(context)
^^^^^^^^^^^^^^^^^^^^ …
Local vars
/opt/netbox/venv/lib/python3.12/site-packages/django/template/loader_tags.py, line 65, in render
result = block.nodelist.render(context)
^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^ …
Local vars
/opt/netbox/venv/lib/python3.12/site-packages/django/template/base.py, line 1000, in render
return SafeString("".join([node.render_annotated(context) for node in self]))
^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^ …
Local vars
/opt/netbox/venv/lib/python3.12/site-packages/django/template/base.py, line 961, in render_annotated
return self.render(context)
^^^^^^^^^^^^^^^^^^^^ …
Local vars
/opt/netbox/venv/lib/python3.12/site-packages/django/template/loader_tags.py, line 65, in render
result = block.nodelist.render(context)
^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^ …
Local vars
/opt/netbox/venv/lib/python3.12/site-packages/django/template/base.py, line 1000, in render
return SafeString("".join([node.render_annotated(context) for node in self]))
^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^ …
Local vars
/opt/netbox/venv/lib/python3.12/site-packages/django/template/base.py, line 961, in render_annotated
return self.render(context)
^^^^^^^^^^^^^^^^^^^^ …
Local vars
/opt/netbox/venv/lib/python3.12/site-packages/django/template/defaulttags.py, line 326, in render
return nodelist.render(context)
^^^^^^^^^^^^^^^^^^^^^^^^ …
Local vars
/opt/netbox/venv/lib/python3.12/site-packages/django/template/base.py, line 1000, in render
return SafeString("".join([node.render_annotated(context) for node in self]))
^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^ …
Local vars
/opt/netbox/venv/lib/python3.12/site-packages/django/template/base.py, line 961, in render_annotated
return self.render(context)
^^^^^^^^^^^^^^^^^^^^ …
Local vars
/opt/netbox/venv/lib/python3.12/site-packages/django/template/library.py, line 258, in render
_dict = self.func(*resolved_args, **resolved_kwargs)
^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^ …
Local vars
/opt/netbox/netbox/utilities/templatetags/helpers.py, line 263, in table_config_form
'form': TableConfigForm(table=table),
^^^^^^^^^^^^^^^^^^^^^^^^^^^^ …
Local vars
/opt/netbox/netbox/utilities/forms/forms.py, line 135, in init
self.fields['available_columns'].choices = table.available_columns
^^^^^^^^^^^^^^^^^^^^^^^ …

Thx a lot.

BR Markus

[bruma1972]

Hi,
i have upgraded to version 4.1.6 but there is no change.
Any help appreciated.
Thx.
Markus

[davama]

Hello,

Anyone have an update?

Running v4.1.6 with below script which works perfectly fine on the UI but not on the CLI

from extras.scripts import Script
class Test(Script):
    def run(self, data, commit):
        self.log_info("Hello World")

unit@netbox-container:/opt/netbox/netbox$ ./manage.py runscript --traceback --loglevel debug test.Test 
🧬 loaded config '/etc/netbox/config/configuration.py'
🧬 loaded config '/etc/netbox/config/extra.py'
🧬 loaded config '/etc/netbox/config/logging.py'
🧬 loaded config '/etc/netbox/config/plugins.py'
Traceback (most recent call last):
  File "/opt/netbox/netbox/./manage.py", line 10, in <module>
    execute_from_command_line(sys.argv)
  File "/opt/netbox/venv/lib/python3.12/site-packages/django/core/management/__init__.py", line 442, in execute_from_command_line
    utility.execute()
  File "/opt/netbox/venv/lib/python3.12/site-packages/django/core/management/__init__.py", line 436, in execute
    self.fetch_command(subcommand).run_from_argv(self.argv)
  File "/opt/netbox/venv/lib/python3.12/site-packages/django/core/management/base.py", line 413, in run_from_argv
    self.execute(*args, **cmd_options)
  File "/opt/netbox/venv/lib/python3.12/site-packages/django/core/management/base.py", line 459, in execute
    output = self.handle(*args, **options)
             ^^^^^^^^^^^^^^^^^^^^^^^^^^^^^
  File "/opt/netbox/netbox/extras/management/commands/runscript.py", line 85, in handle
    job = ScriptJob.enqueue(
          ^^^^^^^^^^^^^^^^^^
  File "/opt/netbox/netbox/netbox/jobs.py", line 106, in enqueue
    return Job.enqueue(cls.handle, name=name, *args, **kwargs)
           ^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^
  File "/opt/netbox/netbox/core/models/jobs.py", line 236, in enqueue
    job.full_clean()
  File "/opt/netbox/venv/lib/python3.12/site-packages/django/db/models/base.py", line 1561, in full_clean
    raise ValidationError(errors)
django.core.exceptions.ValidationError: {'name': ['This field cannot be blank.']}

[candlerb]

As I said before, I think someone needs to raise this as a bug report (i.e. not being able to run scripts from the CLI because "name" isn't set when then job is created)

[wz4]

I did open a bug report. There is a fix pending.

#17923

[bokkepoot]

After an update from 4.1.4->4.1.11 , using a tarball, i have a similar issue as OP :

scripts won't run from the UI , userconfig.data={}

Environment:


Request Method: GET
Request URL: https://netbox.procolix.net/extras/scripts/results/394/

Django Version: 5.0.10
Python Version: 3.11.2
Installed Applications:
['django.contrib.auth',
 'django.contrib.contenttypes',
 'django.contrib.sessions',
 'django.contrib.messages',
 'django.contrib.staticfiles',
 'django.contrib.humanize',
 'django.forms',
 'corsheaders',
 'debug_toolbar',
 'django_filters',
 'django_htmx',
 'django_tables2',
 'django_prometheus',
 'strawberry_django',
 'mptt',
 'rest_framework',
 'social_django',
 'taggit',
 'timezone_field',
 'core',
 'account',
 'circuits',
 'dcim',
 'ipam',
 'extras',
 'tenancy',
 'users',
 'utilities',
 'virtualization',
 'vpn',
 'wireless',
 'django_rq',
 'drf_spectacular',
 'drf_spectacular_sidecar']
Installed Middleware:
['strawberry_django.middlewares.debug_toolbar.DebugToolbarMiddleware',
 'corsheaders.middleware.CorsMiddleware',
 'django.contrib.sessions.middleware.SessionMiddleware',
 'django.middleware.locale.LocaleMiddleware',
 'django.middleware.common.CommonMiddleware',
 'django.middleware.csrf.CsrfViewMiddleware',
 'django.contrib.auth.middleware.AuthenticationMiddleware',
 'django.contrib.messages.middleware.MessageMiddleware',
 'django.middleware.clickjacking.XFrameOptionsMiddleware',
 'django.middleware.security.SecurityMiddleware',
 'django_htmx.middleware.HtmxMiddleware',
 'netbox.middleware.RemoteUserMiddleware',
 'netbox.middleware.CoreMiddleware',
 'netbox.middleware.MaintenanceModeMiddleware']


Template error:
In template /opt/netbox/netbox/templates/extras/script_result.html, error at line 115
   'NoneType' object has no attribute 'available_columns'
   105 : 
   106 :         </div>
   107 :       </form>
   108 :     </div>
   109 :     {# /Object list tab #}
   110 : 
   111 : {% endblock content %}
   112 : 
   113 : {% block modals %}
   114 :   {% if job.completed %}
   115 :    {% table_config_form table table_name="ObjectTable" %} 
   116 :   {% endif %}
   117 : {% endblock modals %}
   118 : 

Traceback (most recent call last):
  File "/opt/netbox-4.1.11/venv/lib/python3.11/site-packages/django/core/handlers/exception.py", line 55, in inner
    response = get_response(request)
               ^^^^^^^^^^^^^^^^^^^^^
  File "/opt/netbox-4.1.11/venv/lib/python3.11/site-packages/django/core/handlers/base.py", line 197, in _get_response
    response = wrapped_callback(request, *callback_args, **callback_kwargs)
               ^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^
  File "/opt/netbox-4.1.11/venv/lib/python3.11/site-packages/django/views/generic/base.py", line 104, in view
    return self.dispatch(request, *args, **kwargs)
           ^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^
  File "/opt/netbox/netbox/netbox/views/generic/base.py", line 26, in dispatch
    return super().dispatch(request, *args, **kwargs)
           ^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^
  File "/opt/netbox/netbox/utilities/views.py", line 125, in dispatch
    return super().dispatch(request, *args, **kwargs)
           ^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^
  File "/opt/netbox/netbox/utilities/views.py", line 39, in dispatch
    return super().dispatch(request, *args, **kwargs)
           ^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^
  File "/opt/netbox-4.1.11/venv/lib/python3.11/site-packages/django/views/generic/base.py", line 143, in dispatch
    return handler(request, *args, **kwargs)
           ^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^
  File "/opt/netbox/netbox/extras/views.py", line 1340, in get
    return render(request, 'extras/script_result.html', context)
           ^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^
  File "/opt/netbox-4.1.11/venv/lib/python3.11/site-packages/django/shortcuts.py", line 25, in render
    content = loader.render_to_string(template_name, context, request, using=using)
              ^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^
  File "/opt/netbox-4.1.11/venv/lib/python3.11/site-packages/django/template/loader.py", line 62, in render_to_string
    return template.render(context, request)
           ^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^
  File "/opt/netbox-4.1.11/venv/lib/python3.11/site-packages/django/template/backends/django.py", line 61, in render
    return self.template.render(context)
           ^^^^^^^^^^^^^^^^^^^^^^^^^^^^^
  File "/opt/netbox-4.1.11/venv/lib/python3.11/site-packages/django/template/base.py", line 171, in render
    return self._render(context)
           ^^^^^^^^^^^^^^^^^^^^^
  File "/opt/netbox-4.1.11/venv/lib/python3.11/site-packages/django/test/utils.py", line 111, in instrumented_test_render
    return self.nodelist.render(context)
           ^^^^^^^^^^^^^^^^^^^^^^^^^^^^^
  File "/opt/netbox-4.1.11/venv/lib/python3.11/site-packages/django/template/base.py", line 1000, in render
    return SafeString("".join([node.render_annotated(context) for node in self]))
                              ^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^
  File "/opt/netbox-4.1.11/venv/lib/python3.11/site-packages/django/template/base.py", line 1000, in <listcomp>
    return SafeString("".join([node.render_annotated(context) for node in self]))
                               ^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^
  File "/opt/netbox-4.1.11/venv/lib/python3.11/site-packages/django/template/base.py", line 961, in render_annotated
    return self.render(context)
           ^^^^^^^^^^^^^^^^^^^^
  File "/opt/netbox-4.1.11/venv/lib/python3.11/site-packages/django/template/loader_tags.py", line 159, in render
    return compiled_parent._render(context)
           ^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^
  File "/opt/netbox-4.1.11/venv/lib/python3.11/site-packages/django/test/utils.py", line 111, in instrumented_test_render
    return self.nodelist.render(context)
           ^^^^^^^^^^^^^^^^^^^^^^^^^^^^^
  File "/opt/netbox-4.1.11/venv/lib/python3.11/site-packages/django/template/base.py", line 1000, in render
    return SafeString("".join([node.render_annotated(context) for node in self]))
                              ^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^
  File "/opt/netbox-4.1.11/venv/lib/python3.11/site-packages/django/template/base.py", line 1000, in <listcomp>
    return SafeString("".join([node.render_annotated(context) for node in self]))
                               ^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^
  File "/opt/netbox-4.1.11/venv/lib/python3.11/site-packages/django/template/base.py", line 961, in render_annotated
    return self.render(context)
           ^^^^^^^^^^^^^^^^^^^^
  File "/opt/netbox-4.1.11/venv/lib/python3.11/site-packages/django/template/loader_tags.py", line 159, in render
    return compiled_parent._render(context)
           ^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^
  File "/opt/netbox-4.1.11/venv/lib/python3.11/site-packages/django/test/utils.py", line 111, in instrumented_test_render
    return self.nodelist.render(context)
           ^^^^^^^^^^^^^^^^^^^^^^^^^^^^^
  File "/opt/netbox-4.1.11/venv/lib/python3.11/site-packages/django/template/base.py", line 1000, in render
    return SafeString("".join([node.render_annotated(context) for node in self]))
                              ^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^
  File "/opt/netbox-4.1.11/venv/lib/python3.11/site-packages/django/template/base.py", line 1000, in <listcomp>
    return SafeString("".join([node.render_annotated(context) for node in self]))
                               ^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^
  File "/opt/netbox-4.1.11/venv/lib/python3.11/site-packages/django/template/base.py", line 961, in render_annotated
    return self.render(context)
           ^^^^^^^^^^^^^^^^^^^^
  File "/opt/netbox-4.1.11/venv/lib/python3.11/site-packages/django/template/loader_tags.py", line 159, in render
    return compiled_parent._render(context)
           ^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^
  File "/opt/netbox-4.1.11/venv/lib/python3.11/site-packages/django/test/utils.py", line 111, in instrumented_test_render
    return self.nodelist.render(context)
           ^^^^^^^^^^^^^^^^^^^^^^^^^^^^^
  File "/opt/netbox-4.1.11/venv/lib/python3.11/site-packages/django/template/base.py", line 1000, in render
    return SafeString("".join([node.render_annotated(context) for node in self]))
                              ^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^
  File "/opt/netbox-4.1.11/venv/lib/python3.11/site-packages/django/template/base.py", line 1000, in <listcomp>
    return SafeString("".join([node.render_annotated(context) for node in self]))
                               ^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^
  File "/opt/netbox-4.1.11/venv/lib/python3.11/site-packages/django/template/base.py", line 961, in render_annotated
    return self.render(context)
           ^^^^^^^^^^^^^^^^^^^^
  File "/opt/netbox-4.1.11/venv/lib/python3.11/site-packages/django/template/loader_tags.py", line 65, in render
    result = block.nodelist.render(context)
             ^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^
  File "/opt/netbox-4.1.11/venv/lib/python3.11/site-packages/django/template/base.py", line 1000, in render
    return SafeString("".join([node.render_annotated(context) for node in self]))
                              ^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^
  File "/opt/netbox-4.1.11/venv/lib/python3.11/site-packages/django/template/base.py", line 1000, in <listcomp>
    return SafeString("".join([node.render_annotated(context) for node in self]))
                               ^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^
  File "/opt/netbox-4.1.11/venv/lib/python3.11/site-packages/django/template/base.py", line 961, in render_annotated
    return self.render(context)
           ^^^^^^^^^^^^^^^^^^^^
  File "/opt/netbox-4.1.11/venv/lib/python3.11/site-packages/django/template/loader_tags.py", line 65, in render
    result = block.nodelist.render(context)
             ^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^
  File "/opt/netbox-4.1.11/venv/lib/python3.11/site-packages/django/template/base.py", line 1000, in render
    return SafeString("".join([node.render_annotated(context) for node in self]))
                              ^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^
  File "/opt/netbox-4.1.11/venv/lib/python3.11/site-packages/django/template/base.py", line 1000, in <listcomp>
    return SafeString("".join([node.render_annotated(context) for node in self]))
                               ^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^
  File "/opt/netbox-4.1.11/venv/lib/python3.11/site-packages/django/template/base.py", line 961, in render_annotated
    return self.render(context)
           ^^^^^^^^^^^^^^^^^^^^
  File "/opt/netbox-4.1.11/venv/lib/python3.11/site-packages/django/template/defaulttags.py", line 326, in render
    return nodelist.render(context)
           ^^^^^^^^^^^^^^^^^^^^^^^^
  File "/opt/netbox-4.1.11/venv/lib/python3.11/site-packages/django/template/base.py", line 1000, in render
    return SafeString("".join([node.render_annotated(context) for node in self]))
                              ^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^
  File "/opt/netbox-4.1.11/venv/lib/python3.11/site-packages/django/template/base.py", line 1000, in <listcomp>
    return SafeString("".join([node.render_annotated(context) for node in self]))
                               ^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^
  File "/opt/netbox-4.1.11/venv/lib/python3.11/site-packages/django/template/base.py", line 961, in render_annotated
    return self.render(context)
           ^^^^^^^^^^^^^^^^^^^^
  File "/opt/netbox-4.1.11/venv/lib/python3.11/site-packages/django/template/library.py", line 258, in render
    _dict = self.func(*resolved_args, **resolved_kwargs)
            ^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^
  File "/opt/netbox/netbox/utilities/templatetags/helpers.py", line 263, in table_config_form
    'form': TableConfigForm(table=table),
            ^^^^^^^^^^^^^^^^^^^^^^^^^^^^
  File "/opt/netbox/netbox/utilities/forms/forms.py", line 135, in __init__
    self.fields['available_columns'].choices = table.available_columns
                                               ^^^^^^^^^^^^^^^^^^^^^^^

Exception Type: AttributeError at /extras/scripts/results/394/
Exception Value: 'NoneType' object has no attribute 'available_columns'