Getting An unknown error occurred while rendering the preview. When rendering PDF preview

[c0fe]

Please verify that this bug has NOT been raised before.

• I checked and didn't find a similar issue

Describe the bug*

I am getting the following error when attempting to render a PDF preview in the template editing section of Inventree:

https://i.imgur.com/XFPETqY.png

Steps to Reproduce

1. Create Item
2. Create Vendor
3. Create Purchase Order
4. Go to Admin Center
5. Go to Report Template
6. Select InvenTree Purchase Order
7. Press Save & Reload Preview

Expected behaviour

Renders PDF preview

Deployment Method

Docker

Version Information

InvenTree-Version: 1.2.3
Django Version: 5.2.11
Commit Hash: 12da3b0
Commit Date: 2026-02-22
Commit Branch: null
Database: django.db.backends.postgresql
Debug-Mode: False
Deployed using Docker: True
Platform: Linux-6.12.57+deb13-amd64-x86_64-with-glibc2.41
Installer: DOC
Active plugins: [{"name":"InvenTreeBarcode","slug":"inventreebarcode","version":"2.1.0"},{"name":"BOM Exporter","slug":"bom-exporter","version":"1.1.0"},{"name":"InvenTree Exporter","slug":"inventree-exporter","version":"1.0.0"},{"name":"Part Parameter Exporter","slug":"parameter-exporter","version":"1.0.0"},{"name":"InvenTreeEmailNotifications","slug":"inventree-email-notification","version":"1.0.0"},{"name":"InvenTreeUINotifications","slug":"inventree-ui-notification","version":"1.0.0"},{"name":"InvenTreeCurrencyExchange","slug":"inventreecurrencyexchange","version":"1.0.0"},{"name":"InvenTreeMachines","slug":"inventree-machines","version":"1.0.0"},{"name":"InvenTreeLabel","slug":"inventreelabel","version":"1.1.0"},{"name":"InvenTreeLabelMachine","slug":"inventreelabelmachine","version":"1.0.0"}]

Try to reproduce on the demo site

I did not try to reproduce

Is the bug reproducible on the demo site?

Not reproducible

Relevant log output

Error in the worker container:

    raise ex.with_traceback(None)
psycopg.errors.UndefinedTable: relation "users_userprofile" does not exist
LINE 1: INSERT INTO "users_userprofile" ("metadata", "user_id", "lan...
                    ^

The above exception was the direct cause of the following exception:

Traceback (most recent call last):
  File "/home/inventree/src/backend/InvenTree/manage.py", line 25, in <module>
    main()
  File "/home/inventree/src/backend/InvenTree/manage.py", line 21, in main
    execute_from_command_line(sys.argv)
  File "/root/.local/lib/python3.11/site-packages/django/core/management/__init__.py", line 442, in execute_from_command_line
    utility.execute()
  File "/root/.local/lib/python3.11/site-packages/django/core/management/__init__.py", line 416, in execute
    django.setup()
  File "/root/.local/lib/python3.11/site-packages/django/__init__.py", line 24, in setup
    apps.populate(settings.INSTALLED_APPS)
  File "/root/.local/lib/python3.11/site-packages/django/apps/registry.py", line 124, in populate
    app_config.ready()
  File "/home/inventree/src/backend/InvenTree/InvenTree/apps.py", line 77, in ready
    self.add_user_on_startup()
  File "/home/inventree/src/backend/InvenTree/InvenTree/ready.py", line 199, in wrapper
    return func(*args, **kwargs)
           ^^^^^^^^^^^^^^^^^^^^^
  File "/home/inventree/src/backend/InvenTree/InvenTree/apps.py", line 275, in add_user_on_startup
    self._create_admin_user(add_user, add_email, add_password)
  File "/home/inventree/src/backend/InvenTree/InvenTree/apps.py", line 287, in _create_admin_user
    new_user = user.objects.create_superuser(
               ^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^
  File "/root/.local/lib/python3.11/site-packages/django/contrib/auth/models.py", line 195, in create_superuser
    return self._create_user(username, email, password, **extra_fields)
           ^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^
  File "/root/.local/lib/python3.11/site-packages/django/contrib/auth/models.py", line 163, in _create_user
    user.save(using=self._db)
  File "/root/.local/lib/python3.11/site-packages/django/contrib/auth/base_user.py", line 65, in save
    super().save(*args, **kwargs)
  File "/root/.local/lib/python3.11/site-packages/django/db/models/base.py", line 902, in save
    self.save_base(
  File "/root/.local/lib/python3.11/site-packages/django/db/models/base.py", line 1023, in save_base
    post_save.send(
  File "/root/.local/lib/python3.11/site-packages/django/dispatch/dispatcher.py", line 189, in send
    response = receiver(signal=self, sender=sender, **named)
               ^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^
  File "/home/inventree/src/backend/InvenTree/users/models.py", line 604, in create_or_update_user_profile
    UserProfile.objects.create(user=instance)
  File "/root/.local/lib/python3.11/site-packages/django/db/models/manager.py", line 87, in manager_method
    return getattr(self.get_queryset(), name)(*args, **kwargs)
           ^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^
  File "/root/.local/lib/python3.11/site-packages/django/db/models/query.py", line 665, in create
    obj.save(force_insert=True, using=self.db)
  File "/home/inventree/src/backend/InvenTree/users/models.py", line 596, in save
    super().save(*args, **kwargs)
  File "/home/inventree/src/backend/InvenTree/InvenTree/models.py", line 179, in save
    super().save(force_insert=force_insert, force_update=force_update, **kwargs)
  File "/root/.local/lib/python3.11/site-packages/django/db/models/base.py", line 902, in save
    self.save_base(
  File "/root/.local/lib/python3.11/site-packages/django/db/models/base.py", line 1008, in save_base
    updated = self._save_table(
              ^^^^^^^^^^^^^^^^^
  File "/root/.local/lib/python3.11/site-packages/django/db/models/base.py", line 1169, in _save_table
    results = self._do_insert(
              ^^^^^^^^^^^^^^^^
  File "/root/.local/lib/python3.11/site-packages/django/db/models/base.py", line 1210, in _do_insert
    return manager._insert(
           ^^^^^^^^^^^^^^^^
  File "/root/.local/lib/python3.11/site-packages/django/db/models/manager.py", line 87, in manager_method
    return getattr(self.get_queryset(), name)(*args, **kwargs)
           ^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^
  File "/root/.local/lib/python3.11/site-packages/django/db/models/query.py", line 1873, in _insert
    return query.get_compiler(using=using).execute_sql(returning_fields)
           ^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^
  File "/root/.local/lib/python3.11/site-packages/django/db/models/sql/compiler.py", line 1882, in execute_sql
    cursor.execute(sql, params)
  File "/root/.local/lib/python3.11/site-packages/django/db/backends/utils.py", line 79, in execute
    return self._execute_with_wrappers(
           ^^^^^^^^^^^^^^^^^^^^^^^^^^^^
  File "/root/.local/lib/python3.11/site-packages/django/db/backends/utils.py", line 92, in _execute_with_wrappers
    return executor(sql, params, many, context)
           ^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^
  File "/root/.local/lib/python3.11/site-packages/django/db/backends/utils.py", line 100, in _execute
    with self.db.wrap_database_errors:
  File "/root/.local/lib/python3.11/site-packages/django/db/utils.py", line 91, in __exit__
    raise dj_exc_value.with_traceback(traceback) from exc_value
  File "/root/.local/lib/python3.11/site-packages/django/db/backends/utils.py", line 105, in _execute
    return self.cursor.execute(sql, params)
           ^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^
  File "/root/.local/lib/python3.11/site-packages/psycopg/cursor.py", line 117, in execute
    raise ex.with_traceback(None)
django.db.utils.ProgrammingError: relation "users_userprofile" does not exist
LINE 1: INSERT INTO "users_userprofile" ("metadata", "user_id", "lan...
                    ^
ERROR: InvenTree command failed: 'python3 manage.py qcluster'
- Refer to the error messages in the log above for more information
Loading config file : /home/inventree/data/config.yaml
Waiting for database connection...
INVE-W3: Could not detect git information.
Waiting for database...
Database connection successful!
INVE-W3: Could not detect git information.

[c0fe]

Docker Compose File:

services:
    # redis acts as database cache manager
    inventree-cache:
        image: redis:7-alpine
        container_name: pos_acc_redis
        env_file:
            - .env
        networks:
            - pos_acc
        restart: always

    # InvenTree web server service
    # Uses gunicorn as the web server
    inventree-server:
        # If you wish to specify a particular InvenTree version, do so here
        image: inventree/inventree:${INVENTREE_TAG:-stable}
        container_name: pos_acc_main
        expose:
            - 8000
        networks:
            - pos_acc
        depends_on:
            - inventree-cache
        env_file:
            - .env
        volumes:
            # Data volume must map to /home/inventree/data
            - ${INVENTREE_EXT_VOLUME:?You must specify the 'INVENTREE_EXT_VOLUME' variable in the .env file!}:/home/inventree/data:z
            # Static and media files bind-mounted so OpenResty can serve them directly
            - /opt/1panel/apps/openresty/openresty/www/sites/inventree.mydomain.com/static:/home/inventree/data/static:z
            - /opt/1panel/apps/openresty/openresty/www/sites/inventree.mydomain.com/media:/home/inventree/data/media:z
        restart: unless-stopped

    # Background worker process handles long-running or periodic tasks
    inventree-worker:
        # If you wish to specify a particular InvenTree version, do so here
        image: inventree/inventree:${INVENTREE_TAG:-stable}
        container_name: pos_acc_worker
        command: invoke worker
        networks:
            - pos_acc
        depends_on:
            - inventree-server
        env_file:
            - .env
        volumes:
            # Data volume must map to /home/inventree/data
            - ${INVENTREE_EXT_VOLUME}:/home/inventree/data:z
            # Worker also needs access to media files
            - /opt/1panel/apps/openresty/openresty/www/sites/inventree.mydomain.com/static:/home/inventree/data/static:z
            - /opt/1panel/apps/openresty/openresty/www/sites/inventree.mydomain.com/media:/home/inventree/data/media:z
        restart: unless-stopped

networks:
    pos_acc:
        external: true

[c0fe]

env file:

# InvenTree environment variables for docker compose deployment
# For a full list of the available configuration options, refer to the InvenTree documentation:
# https://docs.inventree.org/en/stable/start/config/

# Specify the name of the docker-compose project
COMPOSE_PROJECT_NAME=inventree

# InvenTree version tag (e.g. 'stable' / 'latest' / 'x.x.x')
INVENTREE_TAG=stable

# InvenTree server URL - update this to match your server URL
INVENTREE_SITE_URL="[REDACTED]"
#INVENTREE_SITE_URL="https://inventree.my-domain.com"  # Or a public domain name (which you control)

# InvenTree proxy forwarding settings
INVENTREE_USE_X_FORWARDED_HOST=True
INVENTREE_USE_X_FORWARDED_PORT=True
INVENTREE_USE_X_FORWARDED_PROTO=True

# Specify the location of the external data volume
# By default, placed in local directory 'inventree-data'
INVENTREE_EXT_VOLUME=/media/cloud_drive/pos_acc

# Ensure debug is false for a production setup
INVENTREE_LOG_LEVEL=WARNING

# Enable custom plugins?
INVENTREE_PLUGINS_ENABLED=True

# Run database migrations automatically?
# Note: This does not negate the need to run "invoke update"
INVENTREE_AUTO_UPDATE=True

# Database configuration options
# DO NOT CHANGE THESE SETTINGS (unless you really know what you are doing)
INVENTREE_DB_ENGINE=postgresql
INVENTREE_DB_NAME=[REDACTED]
INVENTREE_DB_HOST=[REDACTED]
INVENTREE_DB_PORT=5432

# Database credentials - These should be changed from the default values!
# Note: These are *NOT* the InvenTree server login credentials,
#       they are the credentials for the PostgreSQL database
INVENTREE_DB_USER=[REDACTED]
INVENTREE_DB_PASSWORD=[REDACTED]

# Redis cache setup
# Refer to the documentation for other cache options
INVENTREE_CACHE_ENABLED=True
INVENTREE_CACHE_HOST=inventree-cache
INVENTREE_CACHE_PORT=6379

# Options for gunicorn server
INVENTREE_GUNICORN_TIMEOUT=90

# Admin User
INVENTREE_ADMIN_USER=[REDACTED]
INVENTREE_ADMIN_PASSWORD=[REDACTED]
INVENTREE_ADMIN_EMAIL=[REDACTED]

[c0fe]

Attempting to view the part gets me this error:

https://i.imgur.com/WWk4oJK.png

The console log:

https://pastebin.com/ykrXTdds

[c0fe]

After running docker compose run --rm inventree-server invoke update

I am getting this:

https://i.imgur.com/LX7S1QQ.png

[c0fe]

External database postgresql: 17.8

[SchrodingersGat]

Your last error (INVE-E1) is extremely strange to be seeing in the report generation context. That is only ever expected for a frontend rendering issue.

Can you please check in your web browser developer console, to see if there are any requests being made to the backend that are failing (e.g. for javascript files, etc)

[c0fe]

@SchrodingersGat here is the console log printed out in full: https://pastebin.com/6LZ3v9TV

I did this running on the same database (I first dropped the old database and created a new one prior) using the PKG/REPO installation method and on Incus container.

[c0fe]

@SchrodingersGat one more thing to add is that whenever you add images for parts, they do not load properly and instead show up as broken. I suspect that this is tied to using the database that is outside of the docker network that Inventree is on.

We have other software running in Docker containers and not experiencing this issue, But I think because of our setup, the bug appears.

[SchrodingersGat]

one more thing to add is that whenever you add images for parts, they do not load properly and instead show up as broken. I suspect that this is tied to using the database that is outside of the docker network that Inventree is on.

This sounds like there is an issue serving static files - your pastebin error above would indicate a similar problem.

Are you running on a different domain from your static files? Or something else that you have customized in your docker setup?

[c0fe]

@SchrodingersGat I have the PostgresSQL running in an Incus instance and I had Inventree running on Docker. The Incus instance basically made the PostgreSQL operate like Virtual Server.