Skip to content

@crooksey /gist:2157378
Created

Embed URL

HTTPS clone URL

Subversion checkout URL

You can clone with
or
.
Download ZIP
Traceback from informixdb + sqlalchemy
Traceback (most recent call last):
File "/home/luke/virts/pyramid1.3b2/lib/python2.7/site-packages/pyramid_debugtoolbar-0.9.9.1-py2.7.egg/pyramid_debugtoolbar/panels/performance.py", line 55, in resource_timer_handler
result = handler(request)
File "/home/luke/virts/pyramid1.3b2/lib/python2.7/site-packages/pyramid-1.3b2-py2.7.egg/pyramid/tweens.py", line 20, in excview_tween
response = handler(request)
File "/home/luke/virts/pyramid1.3b2/lib/python2.7/site-packages/pyramid_tm-0.3-py2.7.egg/pyramid_tm/__init__.py", line 61, in tm_tween
response = handler(request)
File "/home/luke/virts/pyramid1.3b2/lib/python2.7/site-packages/pyramid-1.3b2-py2.7.egg/pyramid/router.py", line 164, in handle_request
response = view_callable(context, request)
File "/home/luke/virts/pyramid1.3b2/lib/python2.7/site-packages/pyramid-1.3b2-py2.7.egg/pyramid/config/views.py", line 331, in rendered_view
result = view(context, request)
File "/home/luke/virts/pyramid1.3b2/lib/python2.7/site-packages/pyramid-1.3b2-py2.7.egg/pyramid/config/views.py", line 462, in _requestonly_view
response = view(request)
File "/home/luke/pyramids/intranet/intranet/views.py", line 34, in view_customer
cust_slcustm = DBSessionRO.query(Slcustm).filter(Slcustm.customer == customer_no).first()
File "build/bdist.linux-i686/egg/sqlalchemy/orm/query.py", line 2024, in first
ret = list(self[0:1])
File "build/bdist.linux-i686/egg/sqlalchemy/orm/query.py", line 1918, in __getitem__
return list(res)
File "build/bdist.linux-i686/egg/sqlalchemy/orm/query.py", line 2093, in __iter__
return self._execute_and_instances(context)
File "build/bdist.linux-i686/egg/sqlalchemy/orm/query.py", line 2106, in _execute_and_instances
close_with_result=True)
File "build/bdist.linux-i686/egg/sqlalchemy/orm/query.py", line 2097, in _connection_from_session
**kw)
File "build/bdist.linux-i686/egg/sqlalchemy/orm/session.py", line 729, in connection
close_with_result=close_with_result)
File "build/bdist.linux-i686/egg/sqlalchemy/orm/session.py", line 733, in _connection_for_bind
return self.transaction._connection_for_bind(engine)
File "build/bdist.linux-i686/egg/sqlalchemy/orm/session.py", line 266, in _connection_for_bind
conn = bind.contextual_connect()
File "build/bdist.linux-i686/egg/sqlalchemy/engine/base.py", line 2340, in contextual_connect
self.pool.connect(),
File "build/bdist.linux-i686/egg/sqlalchemy/pool.py", line 210, in connect
return _ConnectionFairy(self).checkout()
File "build/bdist.linux-i686/egg/sqlalchemy/pool.py", line 371, in __init__
rec = self._connection_record = pool._do_get()
File "build/bdist.linux-i686/egg/sqlalchemy/pool.py", line 697, in _do_get
con = self._create_connection()
File "build/bdist.linux-i686/egg/sqlalchemy/pool.py", line 174, in _create_connection
return _ConnectionRecord(self)
File "build/bdist.linux-i686/egg/sqlalchemy/pool.py", line 259, in __init__
pool.dispatch.first_connect.exec_once(self.connection, self)
File "build/bdist.linux-i686/egg/sqlalchemy/event.py", line 265, in exec_once
self(*args, **kw)
File "build/bdist.linux-i686/egg/sqlalchemy/event.py", line 274, in __call__
fn(*args, **kw)
File "build/bdist.linux-i686/egg/sqlalchemy/engine/strategies.py", line 166, in first_connect
dialect.initialize(c)
File "build/bdist.linux-i686/egg/sqlalchemy/dialects/informix/base.py", line 357, in initialize
super(InformixDialect, self).initialize(connection)
File "build/bdist.linux-i686/egg/sqlalchemy/engine/default.py", line 175, in initialize
self._get_default_schema_name(connection)
File "build/bdist.linux-i686/egg/sqlalchemy/dialects/informix/base.py", line 593, in _get_default_schema_name
return connection.execute('select CURRENT_ROLE from systables').scalar()
File "build/bdist.linux-i686/egg/sqlalchemy/engine/base.py", line 1405, in execute
params)
File "build/bdist.linux-i686/egg/sqlalchemy/engine/base.py", line 1582, in _execute_text
statement, parameters
File "build/bdist.linux-i686/egg/sqlalchemy/engine/base.py", line 1646, in _execute_context
context)
File "build/bdist.linux-i686/egg/sqlalchemy/engine/base.py", line 1639, in _execute_context
context)
File "build/bdist.linux-i686/egg/sqlalchemy/engine/default.py", line 330, in do_execute
cursor.execute(statement, parameters)
DatabaseError: (DatabaseError) SQLCODE -217 in PREPARE:
IX000: Column (current_role) not found in any table in the query (or SLV is undefined).
'select CURRENT_ROLE from systables' ()
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment
Something went wrong with that request. Please try again.