KeyError: 'TABLE_NAME' on manage.py syncdb

[GoogleCodeExporter]

during python manage.py syncdb with this configuration on settings.py

DATABASES = {
    'default': {
        'ENGINE': 'ibm_db_django',
        'NAME': 'db2i',
        'USER': '*****', 
        'PASSWORD': '*****',
        'HOST': '*****',
        'PORT': '446',
    }
}

following error occurs:

Traceback (most recent call last):
  File "manage.py", line 9, in <module>
    execute_from_command_line(sys.argv)
  File "/ZDATA/zenv/extranet/lib64/python2.6/site-packages/django/core/management/__init__.py", line 443, in execute_from_command_line
    utility.execute()
  File "/ZDATA/zenv/extranet/lib64/python2.6/site-packages/django/core/management/__init__.py", line 382, in execute
    self.fetch_command(subcommand).run_from_argv(self.argv)
  File "/ZDATA/zenv/extranet/lib64/python2.6/site-packages/django/core/management/base.py", line 196, in run_from_argv
    self.execute(*args, **options.__dict__)
  File "/ZDATA/zenv/extranet/lib64/python2.6/site-packages/django/core/management/base.py", line 232, in execute
    output = self.handle(*args, **options)
  File "/ZDATA/zenv/extranet/lib64/python2.6/site-packages/django/core/management/base.py", line 371, in handle
    return self.handle_noargs(**options)
  File "/ZDATA/zenv/extranet/lib64/python2.6/site-packages/django/core/management/commands/syncdb.py", line 60, in handle_noargs
    tables = connection.introspection.table_names()
  File "/ZDATA/zenv/extranet/lib64/python2.6/site-packages/django/db/backends/__init__.py", line 896, in table_names
    return self.get_table_list(cursor)
  File "/ZDATA/zenv/extranet/lib/python2.6/site-packages/ibm_db_django/introspection.py", line 103, in get_table_list
    table_list.append( table['TABLE_NAME'].lower() )
KeyError: 'TABLE_NAME'

Database server is DB2 on system/z version 9.5

python version 2.6
Django version 1.4
ibm-db_django version 1.0.4a

Client is zLinux - Suse linux SLES 11 SP 2 

Original issue reported on code.google.com by gasp...@gmail.com on 12 Apr 2012 at 3:58

[GoogleCodeExporter]

The above error may came due to at server side your z/OS zparm DESCSTAT is not
set to YES. For more detail please go through 
https://www-304.ibm.com/support/docview.wss?uid=swg21157678.

After setting it to yes and if you are still having the problems, you may also 
have to rebind the packages for the metadata procedures. For more detail please 
go through 
http://publib.boulder.ibm.com/infocenter/dzichelp/v2r2/index.jsp?topic=/
com.ibm.db2.doc.inst/bjnniins1046825.htm.

Please let me know how it works for you.

Original comment by rahul.pr...@in.ibm.com on 13 Apr 2012 at 8:25

[GoogleCodeExporter]

well i did as you suggested and everything went well now it work.
DESCSTAT set to YES and rebind the storage procedure.
Thank you.
A.peta

Original comment by gasp...@gmail.com on 13 Apr 2012 at 2:23

[GoogleCodeExporter]

Original comment by rahul.pr...@in.ibm.com on 16 Apr 2012 at 8:27

• Changed state: Done