Uploaded image for project: 'Hue (READ ONLY)'
  1. Hue (READ ONLY)
  2. HUE-8371

Shrink char field max length for Oracle DB support

    Details

    • Type: Bug
    • Status: Closed
    • Priority: Major
    • Resolution: Incomplete
    • Affects Version/s: 4.2.0
    • Fix Version/s: 4.9.0
    • Component/s: core.api
    • Labels:
      None

      Description

      Shrink char field max length for ORACLE

      when running 

       

      + /opt/cloudera/parcels/CDH-6.0.x-1.cdh6.0.x.p0.414838/lib/hue/build/env/bin/hue migrate
      Traceback (most recent call last):
      File "/opt/cloudera/parcels/CDH-6.0.x-1.cdh6.0.x.p0.414838/lib/hue/build/env/bin/hue", line 14, in <module>
      load_entry_point('desktop', 'console_scripts', 'hue')()
      File "/opt/cloudera/parcels/CDH-6.0.x-1.cdh6.0.x.p0.414838/lib/hue/desktop/core/src/desktop/manage_entry.py", line 145, in entry
      execute_from_command_line(sys.argv)
      File "/opt/cloudera/parcels/CDH-6.0.x-1.cdh6.0.x.p0.414838/lib/hue/build/env/lib/python2.7/site-packages/Django-1.11-py2.7.egg/django/core/management/_init_.py", line 363, in execute_from_command_line
      utility.execute()
      File "/opt/cloudera/parcels/CDH-6.0.x-1.cdh6.0.x.p0.414838/lib/hue/build/env/lib/python2.7/site-packages/Django-1.11-py2.7.egg/django/core/management/_init_.py", line 355, in execute
      self.fetch_command(subcommand).run_from_argv(self.argv)
      File "/opt/cloudera/parcels/CDH-6.0.x-1.cdh6.0.x.p0.414838/lib/hue/build/env/lib/python2.7/site-packages/Django-1.11-py2.7.egg/django/core/management/base.py", line 283, in run_from_argv
      self.execute(*args, **cmd_options)
      File "/opt/cloudera/parcels/CDH-6.0.x-1.cdh6.0.x.p0.414838/lib/hue/build/env/lib/python2.7/site-packages/Django-1.11-py2.7.egg/django/core/management/base.py", line 330, in execute
      output = self.handle(*args, **options)
      File "/opt/cloudera/parcels/CDH-6.0.x-1.cdh6.0.x.p0.414838/lib/hue/build/env/lib/python2.7/site-packages/Django-1.11-py2.7.egg/django/core/management/commands/migrate.py", line 204, in handle
      fake_initial=fake_initial,
      File "/opt/cloudera/parcels/CDH-6.0.x-1.cdh6.0.x.p0.414838/lib/hue/build/env/lib/python2.7/site-packages/Django-1.11-py2.7.egg/django/db/migrations/executor.py", line 115, in migrate
      state = self._migrate_all_forwards(state, plan, full_plan, fake=fake, fake_initial=fake_initial)
      File "/opt/cloudera/parcels/CDH-6.0.x-1.cdh6.0.x.p0.414838/lib/hue/build/env/lib/python2.7/site-packages/Django-1.11-py2.7.egg/django/db/migrations/executor.py", line 145, in _migrate_all_forwards
      state = self.apply_migration(state, migration, fake=fake, fake_initial=fake_initial)
      File "/opt/cloudera/parcels/CDH-6.0.x-1.cdh6.0.x.p0.414838/lib/hue/build/env/lib/python2.7/site-packages/Django-1.11-py2.7.egg/django/db/migrations/executor.py", line 244, in apply_migration
      state = migration.apply(state, schema_editor)
      File "/opt/cloudera/parcels/CDH-6.0.x-1.cdh6.0.x.p0.414838/lib/hue/build/env/lib/python2.7/site-packages/Django-1.11-py2.7.egg/django/db/migrations/migration.py", line 129, in apply
      operation.database_forwards(self.app_label, schema_editor, old_state, project_state)
      File "/opt/cloudera/parcels/CDH-6.0.x-1.cdh6.0.x.p0.414838/lib/hue/build/env/lib/python2.7/site-packages/Django-1.11-py2.7.egg/django/db/migrations/operations/models.py", line 97, in database_forwards
      schema_editor.create_model(model)
      File "/opt/cloudera/parcels/CDH-6.0.x-1.cdh6.0.x.p0.414838/lib/hue/build/env/lib/python2.7/site-packages/Django-1.11-py2.7.egg/django/db/backends/base/schema.py", line 302, in create_model
      self.execute(sql, params or None)
      File "/opt/cloudera/parcels/CDH-6.0.x-1.cdh6.0.x.p0.414838/lib/hue/build/env/lib/python2.7/site-packages/Django-1.11-py2.7.egg/django/db/backends/base/schema.py", line 119, in execute
      cursor.execute(sql, params)
      File "/opt/cloudera/parcels/CDH-6.0.x-1.cdh6.0.x.p0.414838/lib/hue/build/env/lib/python2.7/site-packages/Django-1.11-py2.7.egg/django/db/backends/utils.py", line 65, in execute
      return self.cursor.execute(sql, params)
      File "/opt/cloudera/parcels/CDH-6.0.x-1.cdh6.0.x.p0.414838/lib/hue/build/env/lib/python2.7/site-packages/Django-1.11-py2.7.egg/django/db/utils.py", line 94, in _exit_
      six.reraise(dj_exc_type, dj_exc_value, traceback)
      File "/opt/cloudera/parcels/CDH-6.0.x-1.cdh6.0.x.p0.414838/lib/hue/build/env/lib/python2.7/site-packages/Django-1.11-py2.7.egg/django/db/backends/utils.py", line 63, in execute
      return self.cursor.execute(sql)
      File "/opt/cloudera/parcels/CDH-6.0.x-1.cdh6.0.x.p0.414838/lib/hue/build/env/lib/python2.7/site-packages/Django-1.11-py2.7.egg/django/db/backends/oracle/base.py", line 479, in execute
      return self.cursor.execute(query, self._param_generator(params))
      django.db.utils.DatabaseError: ORA-00910: specified length too long for its datatype

        Attachments

          Activity

            People

            • Assignee:
              Unassigned
              Reporter:
              ranade Prakash
            • Votes:
              0 Vote for this issue
              Watchers:
              2 Start watching this issue

              Dates

              • Created:
                Updated:
                Resolved: