Error while Creating SuperUser : ORA-01400: cannot insert NULL into (""."AUTH_USER"."IS_STAFF")

akgc2 · January 22, 2024, 6:28am

Hi All
I am using following versions:

Python 3.12.1
Django 5.0.1
Oracle Database 19c

It seems to be a bug in new Django version mentioned above.

I am able to create a new project using django using below steps

Create a new Django Project
Django-admin startproject djan_prod_202401
Create a new sub app[Module] within main app
python manage.py startapp subapp_202401
Create a new Superuser using default sqllite db
python manage.py createsuperuser

User gets create successfully.

Issue starts when I change the default DB connection to my Oracle DB using in settings.py file

DATABASES = {
‘default’: {
‘ENGINE’: ‘django.db.backends.oracle’,
‘NAME’: ‘DB_NAME’,
‘USER’: ‘DB_USER’,
‘PASSWORD’: ‘DB_PASS’,
‘HOST’: ‘10.xxx.xxx.xxx’,
‘PORT’: ‘1522’,
}
}

After this change, I see that I am able to make DB connection successfully.

PS C:\Python_All\DJANGO_PROJECTS\djan_prod_202401> python manage.py dbshell

SQL*Plus: Release 12.1.0.2.0 Production on Sat Jan 20 14:50:04 2024

Last Successful login time: Tue Jan 16 2024 10:59:52 +05:30

Connected to:
Oracle Database 19c Enterprise Edition Release 19.0.0.0.0 - Production

After change in DB details make migrations to create tables in Oracle DB

PS C:\Python_All\DJANGO_PROJECTS\djan_prod_202401> python manage.py migrate
Operations to perform:
Apply all migrations: admin, auth, contenttypes, sessions
Running migrations:
Applying contenttypes.0001_initial… OK
Applying contenttypes.0002_remove_content_type_name… OK
Applying auth.0002_alter_permission_name_max_length… OK
Applying auth.0003_alter_user_email_max_length… OK
Applying auth.0004_alter_user_username_opts… OK
Applying auth.0005_alter_user_last_login_null… OK
Applying auth.0006_require_contenttypes_0002… OK
Applying auth.0007_alter_validators_add_error_messages… OK
Applying auth.0008_alter_user_username_max_length… OK
Applying auth.0009_alter_user_last_name_max_length… OK
Applying auth.0010_alter_group_name_max_length… OK
Applying auth.0011_update_proxy_permissions… OK
Applying auth.0012_alter_user_first_name_max_length… OK
Applying sessions.0001_initial… OK
PS C:\Python_All\DJANGO_PROJECTS\djan_prod_202401>

After this when I try to create superuser in Oracle DB I get below error.

Password:
Password (again):
Traceback (most recent call last):
File “C:\Users\my_user\AppData\Local\Programs\Python\Python312\Lib\site-packages\django\db\backends\utils.py”, line 105, in _execute
return self.cursor.execute(sql, params)
^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^
File “C:\Users\my_user\AppData\Local\Programs\Python\Python312\Lib\site-packages\django\db\backends\oracle\base.py”, line 571, in execute
return self.cursor.execute(query, self._param_generator(params))
^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^
File “C:\Users\my_user\AppData\Local\Programs\Python\Python312\Lib\site-packages\oracledb\cursor.py”, line 743, in execute
impl.execute(self)
File “src\oracledb\impl/thin/cursor.pyx”, line 173, in oracledb.thin_impl.ThinCursorImpl.execute
File “src\oracledb\impl/thin/protocol.pyx”, line 425, in oracledb.thin_impl.Protocol._process_single_message
File “src\oracledb\impl/thin/protocol.pyx”, line 426, in oracledb.thin_impl.Protocol._process_single_message
File “src\oracledb\impl/thin/protocol.pyx”, line 419, in oracledb.thin_impl.Protocol._process_message
oracledb.exceptions.IntegrityError: ORA-01400: cannot insert NULL into (“DB_USER”.“AUTH_USER”.“IS_STAFF”)
Help: https://docs.oracle.com/error-help/db/ora-01400/

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

Traceback (most recent call last):
File “C:\Python_All\DJANGO_PROJECTS\djan_prod_202401\manage.py”, line 22, in
main()
File “C:\Python_All\DJANGO_PROJECTS\djan_prod_202401\manage.py”, line 18, in main
execute_from_command_line(sys.argv)
File “C:\Users\my_user\AppData\Local\Programs\Python\Python312\Lib\site-packages\django\core\management_init_.py”, line 442, in execute_from_command_line
utility.execute()
File “C:\Users\my_user\AppData\Local\Programs\Python\Python312\Lib\site-packages\django\core\management_init_.py”, line 436, in execute
self.fetch_command(subcommand).run_from_argv(self.argv)
File “C:\Users\my_user\AppData\Local\Programs\Python\Python312\Lib\site-packages\django\core\management\base.py”, line 412, in run_from_argv
self.execute(*args, **cmd_options)
File “C:\Users\my_user\AppData\Local\Programs\Python\Python312\Lib\site-packages\django\contrib\auth\management\commands\createsuperuser.py”, line 88,
in execute
return super().execute(*args, **options)
^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^
File “C:\Users\my_user\AppData\Local\Programs\Python\Python312\Lib\site-packages\django\core\management\base.py”, line 458, in execute
output = self.handle(*args, **options)
^^^^^^^^^^^^^^^^^^^^^^^^^^^^^
File “C:\Users\my_user\AppData\Local\Programs\Python\Python312\Lib\site-packages\django\contrib\auth\management\commands\createsuperuser.py”, line 237, in handle
self.UserModel._default_manager.db_manager(database).create_superuser(
File “C:\Users\my_user\AppData\Local\Programs\Python\Python312\Lib\site-packages\django\contrib\auth\models.py”, line 172, in create_superuser
return self._create_user(username, email, password, **extra_fields)
^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^
File “C:\Users\my_user\AppData\Local\Programs\Python\Python312\Lib\site-packages\django\contrib\auth\models.py”, line 155, in _create_user
user.save(using=self._db)
File “C:\Users\my_user\AppData\Local\Programs\Python\Python312\Lib\site-packages\django\contrib\auth\base_user.py”, line 77, in save
super().save(*args, **kwargs)
File “C:\Users\my_user\AppData\Local\Programs\Python\Python312\Lib\site-packages\django\db\models\base.py”, line 822, in save
self.save_base(
File “C:\Users\my_user\AppData\Local\Programs\Python\Python312\Lib\site-packages\django\db\models\base.py”, line 909, in save_base
updated = self._save_table(
^^^^^^^^^^^^^^^^^
File “C:\Users\my_user\AppData\Local\Programs\Python\Python312\Lib\site-packages\django\db\models\base.py”, line 1067, in _save_table
results = self._do_insert(
^^^^^^^^^^^^^^^^
File “C:\Users\my_user\AppData\Local\Programs\Python\Python312\Lib\site-packages\django\db\models\base.py”, line 1108, in _do_insert
return manager._insert(
^^^^^^^^^^^^^^^^
File “C:\Users\my_user\AppData\Local\Programs\Python\Python312\Lib\site-packages\django\db\models\manager.py”, line 87, in manager_method
return getattr(self.get_queryset(), name)(*args, **kwargs)
^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^
File “C:\Users\my_user\AppData\Local\Programs\Python\Python312\Lib\site-packages\django\db\models\query.py”, line 1845, in _insert
return query.get_compiler(using=using).execute_sql(returning_fields)
^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^
File “C:\Users\my_user\AppData\Local\Programs\Python\Python312\Lib\site-packages\django\db\models\sql\compiler.py”, line 1823, in execute_sql
cursor.execute(sql, params)
File “C:\Users\my_user\AppData\Local\Programs\Python\Python312\Lib\site-packages\django\db\backends\utils.py”, line 122, in execute
return super().execute(sql, params)
^^^^^^^^^^^^^^^^^^^^^^^^^^^^
File “C:\Users\my_user\AppData\Local\Programs\Python\Python312\Lib\site-packages\django\db\backends\utils.py”, line 79, in execute
return self._execute_with_wrappers(
^^^^^^^^^^^^^^^^^^^^^^^^^^^^
File “C:\Users\my_user\AppData\Local\Programs\Python\Python312\Lib\site-packages\django\db\backends\utils.py”, line 92, in _execute_with_wrappers
return executor(sql, params, many, context)
^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^
File “C:\Users\my_user\AppData\Local\Programs\Python\Python312\Lib\site-packages\django\db\backends\utils.py”, line 100, in _execute
File “C:\Users\my_user\AppData\Local\Programs\Python\Python312\Lib\site-packages\django\db\backends\oracle\base.py”, line 571, in execute
return self.cursor.execute(query, self._param_generator(params))
^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^
File “C:\Users\my_user\AppData\Local\Programs\Python\Python312\Lib\site-packages\oracledb\cursor.py”, line 743, in execute
impl.execute(self)
File “src\oracledb\impl/thin/cursor.pyx”, line 173, in oracledb.thin_impl.ThinCursorImpl.execute
File “src\oracledb\impl/thin/protocol.pyx”, line 425, in oracledb.thin_impl.Protocol._process_single_message
File “src\oracledb\impl/thin/protocol.pyx”, line 426, in oracledb.thin_impl.Protocol._process_single_message
django.db.utils.IntegrityError: ORA-01400: cannot insert NULL into (“DB_USER”.“AUTH_USER”.“IS_STAFF”)
Help: ORA-01400 - Database Error Messages
PS C:\Python_All\DJANGO_PROJECTS\djan_prod_202401>

addwebsolution · January 22, 2024, 6:49am

Did you create a custom user model or using the default Django’s User model?

akgc2 · January 22, 2024, 6:54am

I am using default model, without any change in model.py file.

Below are the default lines of this file.

from django.db import models

Create your models here.

Regards
Arun

addwebsolution · January 22, 2024, 7:01am

Can you check and verify the structure of the AUTH_USER table in your Oracle database.

Also, re run these commands and try again.

python manage.py makemigrations
python manage.py migrate

akgc2 · January 22, 2024, 7:11am

auth_user structure

Name Null? Type

ID NOT NULL NUMBER(11)
PASSWORD NVARCHAR2(128)
LAST_LOGIN TIMESTAMP(6)
IS_SUPERUSER NOT NULL NUMBER(1)
USERNAME NVARCHAR2(150)
FIRST_NAME NVARCHAR2(150)
LAST_NAME NVARCHAR2(150)
EMAIL NVARCHAR2(254)
IS_STAFF NOT NULL NUMBER(1)
IS_ACTIVE NOT NULL NUMBER(1)
DATE_JOINED NOT NULL TIMESTAMP(6)

I tried the mentioned migration command but no change in error.

PS C:\Python_All\DJANGO_PROJECTS\djan_prod_202401> python manage.py makemigrations
No changes detected
PS C:\Python_All\DJANGO_PROJECTS\djan_prod_202401> python manage.py migrate
Operations to perform:
Apply all migrations: admin, auth, contenttypes, sessions
Running migrations:
No migrations to apply.
PS C:\Python_All\DJANGO_PROJECTS\djan_prod_202401>

Regards
Arun

rptmat57 · May 27, 2024, 1:09pm

Not sure why, but your auth structure in Oracle is missing the default values for IS_STAFF and IS_ACTIVE.
Also your migrate command isn’t running auth.0001 as if it was already run before. Did you manually fake it and create the structure in Oracle yourself?

Topic		Replies	Views
migrate admin, auth not working in oracle 12c Using Django	0	548	June 13, 2020
django server error create superuser Getting Started	13	4761	May 3, 2024
Django_admin_log not getting created and migrate error ora-00955 Using Django	2	2139	June 21, 2020
Newbie - Connecting to a Oracle 12c database Mystery Errors	3	1516	April 17, 2023
Create Super User issue Getting Started	1	234	May 12, 2024

Error while Creating SuperUser : ORA-01400: cannot insert NULL into (""."AUTH_USER"."IS_STAFF")

Create your models here.

Related topics