cx_Oracle.DatabaseError: ORA-00910: specified length too long for its datatype

[Irving Safetywebs]

Hi Django-ites,

I am trying to install Django CMS on my Ubuntu installation running on the Linux subsystem for Windows 10 using Python 3.6 and connect it to an Oracle 12 c DB. Everytime I try to migrate the site to the DB like so: 

python poc/manage.py migrate

I get this error: 

  Applying cms.0008_auto_20150208_2149...Traceback (most recent call last):

  File "/mnt/c/Users/kz6lkb/Documents/django-cms-site/lib/python3.6/site-packages/django/db/backends/utils.py", line 86, in _execute

    return self.cursor.execute(sql, params)

  File "/mnt/c/Users/kz6lkb/Documents/django-cms-site/lib/python3.6/site-packages/django/db/backends/oracle/base.py", line 517, in execute

    return self.cursor.execute(query, self._param_generator(params))

cx_Oracle.DatabaseError: ORA-00910: specified length too long for its datatype

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

Traceback (most recent call last):

  File "poc/manage.py", line 21, in <module>

    main()

  File "poc/manage.py", line 17, in main

    execute_from_command_line(sys.argv)

  File "/mnt/c/Users/kz6lkb/Documents/django-cms-site/lib/python3.6/site-packages/django/core/management/__init__.py", line 401, in execute_from_command_line

    utility.execute()

  File "/mnt/c/Users/kz6lkb/Documents/django-cms-site/lib/python3.6/site-packages/django/core/management/__init__.py", line 395, in execute

    self.fetch_command(subcommand).run_from_argv(self.argv)

  File "/mnt/c/Users/kz6lkb/Documents/django-cms-site/lib/python3.6/site-packages/django/core/management/base.py", line 328, in run_from_argv

    self.execute(*args, **cmd_options)

  File "/mnt/c/Users/kz6lkb/Documents/django-cms-site/lib/python3.6/site-packages/django/core/management/base.py", line 369, in execute

    output = self.handle(*args, **options)

  File "/mnt/c/Users/kz6lkb/Documents/django-cms-site/lib/python3.6/site-packages/django/core/management/base.py", line 83, in wrapped

    res = handle_func(*args, **kwargs)

  File "/mnt/c/Users/kz6lkb/Documents/django-cms-site/lib/python3.6/site-packages/django/core/management/commands/migrate.py", line 233, in handle

    fake_initial=fake_initial,

  File "/mnt/c/Users/kz6lkb/Documents/django-cms-site/lib/python3.6/site-packages/django/db/migrations/executor.py", line 117, in migrate

    state = self._migrate_all_forwards(state, plan, full_plan, fake=fake, fake_initial=fake_initial)

  File "/mnt/c/Users/kz6lkb/Documents/django-cms-site/lib/python3.6/site-packages/django/db/migrations/executor.py", line 147, in _migrate_all_forwards

    state = self.apply_migration(state, migration, fake=fake, fake_initial=fake_initial)

  File "/mnt/c/Users/kz6lkb/Documents/django-cms-site/lib/python3.6/site-packages/django/db/migrations/executor.py", line 245, in apply_migration

    state = migration.apply(state, schema_editor)

  File "/mnt/c/Users/kz6lkb/Documents/django-cms-site/lib/python3.6/site-packages/django/db/migrations/migration.py", line 124, in apply

    operation.database_forwards(self.app_label, schema_editor, old_state, project_state)

  File "/mnt/c/Users/kz6lkb/Documents/django-cms-site/lib/python3.6/site-packages/django/db/migrations/operations/fields.py", line 249, in database_forwards

    schema_editor.alter_field(from_model, from_field, to_field)

  File "/mnt/c/Users/kz6lkb/Documents/django-cms-site/lib/python3.6/site-packages/django/db/backends/oracle/schema.py", line 59, in alter_field

    super().alter_field(model, old_field, new_field, strict)

  File "/mnt/c/Users/kz6lkb/Documents/django-cms-site/lib/python3.6/site-packages/django/db/backends/base/schema.py", line 565, in alter_field

    old_db_params, new_db_params, strict)

  File "/mnt/c/Users/kz6lkb/Documents/django-cms-site/lib/python3.6/site-packages/django/db/backends/base/schema.py", line 715, in _alter_field

    params,

  File "/mnt/c/Users/kz6lkb/Documents/django-cms-site/lib/python3.6/site-packages/django/db/backends/base/schema.py", line 142, in execute

    cursor.execute(sql, params)

  File "/mnt/c/Users/kz6lkb/Documents/django-cms-site/lib/python3.6/site-packages/django/db/backends/utils.py", line 100, in execute

    return super().execute(sql, params)

  File "/mnt/c/Users/kz6lkb/Documents/django-cms-site/lib/python3.6/site-packages/django/db/backends/utils.py", line 68, in execute

    return self._execute_with_wrappers(sql, params, many=False, executor=self._execute)

  File "/mnt/c/Users/kz6lkb/Documents/django-cms-site/lib/python3.6/site-packages/django/db/backends/utils.py", line 77, in _execute_with_wrappers

    return executor(sql, params, many, context)

  File "/mnt/c/Users/kz6lkb/Documents/django-cms-site/lib/python3.6/site-packages/django/db/backends/utils.py", line 86, in _execute

    return self.cursor.execute(sql, params)

  File "/mnt/c/Users/kz6lkb/Documents/django-cms-site/lib/python3.6/site-packages/django/db/utils.py", line 90, in __exit__

    raise dj_exc_value.with_traceback(traceback) from exc_value

  File "/mnt/c/Users/kz6lkb/Documents/django-cms-site/lib/python3.6/site-packages/django/db/backends/utils.py", line 86, in _execute

    return self.cursor.execute(sql, params)

  File "/mnt/c/Users/kz6lkb/Documents/django-cms-site/lib/python3.6/site-packages/django/db/backends/oracle/base.py", line 517, in execute

    return self.cursor.execute(query, self._param_generator(params))

django.db.utils.DatabaseError: ORA-00910: specified length too long for its datatype

I'm brand new to Django, so I really haven't varied at all from the installation documentation. Does anyone know how to move passed this error?

[Tim Graham]

The relevant migration is:

https://github.com/divio/django-cms/blob/d6cabc49f016dd9a16f91440da9fb6790d27c2ae/cms/migrations/0008_auto_20150208_2149.py

It increases the length of a CharField to 2048 characters which seems to be longer than Oracle supports.

As far as I know, Django CMS isn't tested with Oracle. Perhaps they would consider a fix but there may be other issues.