Advertisement
Not a member of Pastebin yet?
Sign Up,
it unlocks many cool features!
- Saved info to /opt/truecar/etc/app-info.json
- /opt/truecar/virtualenvs/survey_tool/lib/python2.7/site-packages/survey_tool-dev-py2.7.egg /
- Traceback (most recent call last):
- File "bin/migrate_data_from_r4.py", line 26, in <module>
- migrate_data()
- File "bin/migrate_data_from_r4.py", line 20, in migrate_data
- """.strip())
- File "/opt/truecar/virtualenvs/survey_tool/lib/python2.7/site-packages/SQLAlchemy-0.9.7-py2.7-linux-x86_64.egg/sqlalchemy/orm/scoping.p
- y", line 150, in do
- return getattr(self.registry(), name)(*args, **kwargs)
- File "/opt/truecar/virtualenvs/survey_tool/lib/python2.7/site-packages/SQLAlchemy-0.9.7-py2.7-linux-x86_64.egg/sqlalchemy/orm/session.p
- y", line 991, in execute
- bind, close_with_result=True).execute(clause, params or {})
- File "/opt/truecar/virtualenvs/survey_tool/lib/python2.7/site-packages/SQLAlchemy-0.9.7-py2.7-linux-x86_64.egg/sqlalchemy/engine/base.p
- y", line 729, in execute
- return meth(self, multiparams, params)
- File "/opt/truecar/virtualenvs/survey_tool/lib/python2.7/site-packages/SQLAlchemy-0.9.7-py2.7-linux-x86_64.egg/sqlalchemy/sql/elements.
- py", line 321, in _execute_on_connection
- return connection._execute_clauseelement(self, multiparams, params)
- File "/opt/truecar/virtualenvs/survey_tool/lib/python2.7/site-packages/SQLAlchemy-0.9.7-py2.7-linux-x86_64.egg/sqlalchemy/engine/base.p
- y", line 826, in _execute_clauseelement
- compiled_sql, distilled_params
- File "/opt/truecar/virtualenvs/survey_tool/lib/python2.7/site-packages/SQLAlchemy-0.9.7-py2.7-linux-x86_64.egg/sqlalchemy/engine/base.py", line 958, in _execute_context
- context)
- File "/opt/truecar/virtualenvs/survey_tool/lib/python2.7/site-packages/SQLAlchemy-0.9.7-py2.7-linux-x86_64.egg/sqlalchemy/engine/base.py", line 1160, in _handle_dbapi_exception
- exc_info
- File "/opt/truecar/virtualenvs/survey_tool/lib/python2.7/site-packages/SQLAlchemy-0.9.7-py2.7-linux-x86_64.egg/sqlalchemy/util/compat.py", line 199, in raise_from_cause
- reraise(type(exception), exception, tb=exc_tb)
- File "/opt/truecar/virtualenvs/survey_tool/lib/python2.7/site-packages/SQLAlchemy-0.9.7-py2.7-linux-x86_64.egg/sqlalchemy/engine/base.py", line 951, in _execute_context
- context)
- File "/opt/truecar/virtualenvs/survey_tool/lib/python2.7/site-packages/SQLAlchemy-0.9.7-py2.7-linux-x86_64.egg/sqlalchemy/engine/default.py", line 436, in do_execute
- cursor.execute(statement, parameters)
- sqlalchemy.exc.ProgrammingError: (ProgrammingError) ('42S22', "[42S22] [FreeTDS][SQL Server]Invalid column name 'response_id'. (207) (SQLExecDirectW)") 'WITH TableA_CTE (customer_id, question_id, customer_survey_id, RANKING)\nAS ( SELECT customer_id, question_id, customer_survey_id, RANKING = DENSE_RANK()\nOVER ( PARTITION BY customer_id, question_id, customer_survey_id ORDER BY response_id desc, NEWID() ASC )\nFROM dbo.response)\n--select*\ndelete FROM TableA_CTE WHERE RANKING > 1' ()
- INFO [alembic.migration] Context impl MSSQLImpl.
- INFO [alembic.migration] Will assume transactional DDL.
- /
- Survey Sender script installed
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement