django setup error using db2

[白夜]

tristan@NorthStar:~/Coding/NorthStar$ python3 manage.py runserver
Performing system checks...

System check identified no issues (0 silenced).
Unhandled exception in thread started by <function check_errors.<locals>.wrapper at 0x7fedf8b9c8c8>
Traceback (most recent call last):
  File "/usr/local/lib/python3.4/dist-packages/ibm_db_dbi.py", line 1237, in _execute_helper
    return_value = ibm_db.execute(self.stmt_handler, parameters)
Exception: Statement Execute Failed: [IBM][CLI Driver][DB2/LINUXX8664] SQL0574N  DEFAULT value or IDENTITY attribute value is not valid for column "APPLIED" in table "TRISTAN.DJANGO_MIGRATIONS".  Reason code: "1".  SQLSTATE=42894 SQLCODE=-574

During handling of the above exception, another exception occurred:

Traceback (most recent call last):
  File "/usr/local/lib/python3.4/dist-packages/ibm_db_django/pybase.py", line 160, in execute
    return super( DB2CursorWrapper, self ).execute( operation, parameters )
  File "/usr/local/lib/python3.4/dist-packages/ibm_db_dbi.py", line 1335, in execute
    self._execute_helper(parameters)
  File "/usr/local/lib/python3.4/dist-packages/ibm_db_dbi.py", line 1247, in _execute_helper
    raise self.messages[len(self.messages) - 1]
ibm_db_dbi.ProgrammingError: ibm_db_dbi::ProgrammingError: Statement Execute Failed: [IBM][CLI Driver][DB2/LINUXX8664] SQL0574N  DEFAULT value or IDENTITY attribute value is not valid for column "APPLIED" in table "TRISTAN.DJANGO_MIGRATIONS".  Reason code: "1".  SQLSTATE=42894 SQLCODE=-574

During handling of the above exception, another exception occurred:

Traceback (most recent call last):
  File "/usr/local/lib/python3.4/dist-packages/django/utils/autoreload.py", line 222, in wrapper
    fn(*args, **kwargs)
  File "/usr/local/lib/python3.4/dist-packages/django/core/management/commands/runserver.py", line 107, in inner_run
    self.check_migrations()
  File "/usr/local/lib/python3.4/dist-packages/django/core/management/commands/runserver.py", line 159, in check_migrations
    executor = MigrationExecutor(connections[DEFAULT_DB_ALIAS])
  File "/usr/local/lib/python3.4/dist-packages/django/db/migrations/executor.py", line 17, in __init__
    self.loader = MigrationLoader(self.connection)
  File "/usr/local/lib/python3.4/dist-packages/django/db/migrations/loader.py", line 48, in __init__
    self.build_graph()
  File "/usr/local/lib/python3.4/dist-packages/django/db/migrations/loader.py", line 179, in build_graph
    self.applied_migrations = recorder.applied_migrations()
  File "/usr/local/lib/python3.4/dist-packages/django/db/migrations/recorder.py", line 59, in applied_migrations
    self.ensure_schema()
  File "/usr/local/lib/python3.4/dist-packages/django/db/migrations/recorder.py", line 53, in ensure_schema
    editor.create_model(self.Migration)
  File "/usr/local/lib/python3.4/dist-packages/django/db/backends/schema.py", line 263, in create_model
    self.execute(sql, params)
  File "/usr/local/lib/python3.4/dist-packages/django/db/backends/schema.py", line 99, in execute
    cursor.execute(sql, params)
  File "/usr/local/lib/python3.4/dist-packages/django/db/backends/utils.py", line 81, in execute
    return super(CursorDebugWrapper, self).execute(sql, params)
  File "/usr/local/lib/python3.4/dist-packages/django/db/backends/utils.py", line 65, in execute
    return self.cursor.execute(sql, params)
  File "/usr/local/lib/python3.4/dist-packages/ibm_db_django/pybase.py", line 170, in execute
    six.reraise(utils.ProgrammingError, utils.ProgrammingError( *tuple( six.PY3 and e.args or ( e._message, ) ) ), sys.exc_info()[2])
  File "/usr/local/lib/python3.4/dist-packages/django/utils/six.py", line 549, in reraise
    raise value.with_traceback(tb)
  File "/usr/local/lib/python3.4/dist-packages/ibm_db_django/pybase.py", line 160, in execute
    return super( DB2CursorWrapper, self ).execute( operation, parameters )
  File "/usr/local/lib/python3.4/dist-packages/ibm_db_dbi.py", line 1335, in execute
    self._execute_helper(parameters)
  File "/usr/local/lib/python3.4/dist-packages/ibm_db_dbi.py", line 1247, in _execute_helper
    raise self.messages[len(self.messages) - 1]
django.db.utils.ProgrammingError: Statement Execute Failed: [IBM][CLI Driver][DB2/LINUXX8664] SQL0574N  DEFAULT value or IDENTITY attribute value is not valid for column "APPLIED" in table "TRISTAN.DJANGO_MIGRATIONS".  Reason code: "1".  SQLSTATE=42894 SQLCODE=-574


if there sql stmt column default error?

[Collin Anderson]

Hi,

I'd ask on the ibm-db list. http://groups.google.com/group/ibm_db

Collin