Advertisement
Guest User

Untitled

a guest
Dec 22nd, 2014
149
0
Never
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
text 3.03 KB | None | 0 0
  1. Saved info to /opt/truecar/etc/app-info.json
  2. /opt/truecar/virtualenvs/survey_tool/lib/python2.7/site-packages/survey_tool-dev-py2.7.egg /
  3. Traceback (most recent call last):
  4. File "bin/migrate_data_from_r4.py", line 26, in <module>
  5. migrate_data()
  6. File "bin/migrate_data_from_r4.py", line 20, in migrate_data
  7. """.strip())
  8. 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
  9. y", line 150, in do
  10. return getattr(self.registry(), name)(*args, **kwargs)
  11. 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
  12. y", line 991, in execute
  13. bind, close_with_result=True).execute(clause, params or {})
  14. 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
  15. y", line 729, in execute
  16. return meth(self, multiparams, params)
  17. File "/opt/truecar/virtualenvs/survey_tool/lib/python2.7/site-packages/SQLAlchemy-0.9.7-py2.7-linux-x86_64.egg/sqlalchemy/sql/elements.
  18. py", line 321, in _execute_on_connection
  19. return connection._execute_clauseelement(self, multiparams, params)
  20. 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
  21. y", line 826, in _execute_clauseelement
  22. compiled_sql, distilled_params
  23. 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
  24. context)
  25. 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
  26. exc_info
  27. 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
  28. reraise(type(exception), exception, tb=exc_tb)
  29. 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
  30. context)
  31. 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
  32. cursor.execute(statement, parameters)
  33. 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' ()
  34. INFO [alembic.migration] Context impl MSSQLImpl.
  35. INFO [alembic.migration] Will assume transactional DDL.
  36. /
  37. Survey Sender script installed
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement