[2017-06-14 18:10:17,731] ERROR in app: Exception on /cube/rhv_resthourdetail/me
mbers/rhv_vessel [GET]
Traceback (most recent call last):
File "C:\ProgramData\Anaconda3\lib\site-packages\sqlalchemy\engine\base.py", l
ine 1182, in _execute_context
context)
File "C:\ProgramData\Anaconda3\lib\site-packages\sqlalchemy\engine\default.py"
, line 470, in do_execute
cursor.execute(statement, parameters)
pyodbc.ProgrammingError: ('42S22', "[42S22] [Microsoft][SQL Server Native Client
11.0][SQL Server]Invalid column name 'rhv_vessel.vid'. (207) (SQLExecDirectW)")
The above exception was the direct cause of the following exception:
Traceback (most recent call last):
File "C:\ProgramData\Anaconda3\lib\site-packages\flask\app.py", line 1982, in
wsgi_app
response = self.full_dispatch_request()
File "C:\ProgramData\Anaconda3\lib\site-packages\flask\app.py", line 1614, in
full_dispatch_request
rv = self.handle_user_exception(e)
File "C:\ProgramData\Anaconda3\lib\site-packages\flask\app.py", line 1517, in
handle_user_exception
reraise(exc_type, exc_value, tb)
File "C:\ProgramData\Anaconda3\lib\site-packages\flask\_compat.py", line 33, i
n reraise
raise value
File "C:\ProgramData\Anaconda3\lib\site-packages\flask\app.py", line 1612, in
full_dispatch_request
rv = self.dispatch_request()
File "C:\ProgramData\Anaconda3\lib\site-packages\flask\app.py", line 1598, in
dispatch_request
return self.view_functions[rule.endpoint](**req.view_args)
File "C:\ProgramData\Anaconda3\lib\site-packages\cubes\server\decorators.py",
line 118, in wrapper
return f(*args, **kwargs)
File "C:\ProgramData\Anaconda3\lib\site-packages\cubes\server\decorators.py",
line 167, in wrapper
retval = f(*args, **kwargs)
File "C:\ProgramData\Anaconda3\lib\site-packages\cubes\server\blueprint.py", l
ine 474, in cube_members
page_size=g.page_size)
File "C:\ProgramData\Anaconda3\lib\site-packages\cubes\browser.py", line 371,
in members
**options)
File "C:\ProgramData\Anaconda3\lib\site-packages\cubes\sql\browser.py", line 3
10, in provide_members
result = self.execute(statement, "members")
File "C:\ProgramData\Anaconda3\lib\site-packages\cubes\sql\browser.py", line 3
49, in execute
return self.connectable.execute(statement)
File "C:\ProgramData\Anaconda3\lib\site-packages\sqlalchemy\engine\base.py", l
ine 2064, in execute
return connection.execute(statement, *multiparams, **params)
File "C:\ProgramData\Anaconda3\lib\site-packages\sqlalchemy\engine\base.py", l
ine 945, in execute
return meth(self, multiparams, params)
File "C:\ProgramData\Anaconda3\lib\site-packages\sqlalchemy\sql\elements.py",
line 263, in _execute_on_connection
return connection._execute_clauseelement(self, multiparams, params)
File "C:\ProgramData\Anaconda3\lib\site-packages\sqlalchemy\engine\base.py", l
ine 1053, in _execute_clauseelement
compiled_sql, distilled_params
File "C:\ProgramData\Anaconda3\lib\site-packages\sqlalchemy\engine\base.py", l
ine 1189, in _execute_context
context)
File "C:\ProgramData\Anaconda3\lib\site-packages\sqlalchemy\engine\base.py", l
ine 1402, in _handle_dbapi_exception
exc_info
File "C:\ProgramData\Anaconda3\lib\site-packages\sqlalchemy\util\compat.py", l
ine 203, in raise_from_cause
reraise(type(exception), exception, tb=exc_tb, cause=cause)
File "C:\ProgramData\Anaconda3\lib\site-packages\sqlalchemy\util\compat.py", l
ine 186, in reraise
raise value.with_traceback(tb)
File "C:\ProgramData\Anaconda3\lib\site-packages\sqlalchemy\engine\base.py", l
ine 1182, in _execute_context
context)
File "C:\ProgramData\Anaconda3\lib\site-packages\sqlalchemy\engine\default.py"
, line 470, in do_execute
cursor.execute(statement, parameters)
sqlalchemy.exc.ProgrammingError: (pyodbc.ProgrammingError) ('42S22', "[42S22] [M
icrosoft][SQL Server Native Client 11.0][SQL Server]Invalid column name 'rhv_ves
sel.vid'. (207) (SQLExecDirectW)") [SQL: 'SELECT rhv_vessel.vid AS [rhv_vessel.v
id] \nFROM rhv_resthourdetail JOIN rhv_vessel AS rhv_vessel ON rhv_resthourdetai
l.sourceid = rhv_vessel.vid GROUP BY [rhv_vessel.vid]']
127.0.0.1 - - [14/Jun/2017 18:10:17] "GET /cube/rhv_resthourdetail/members/rhv_v
essel?hierarchy=default&depth=1 HTTP/1.1" 500 -