05-04-2020 11:12 AM
I am not able to run the Firepower MIgration tool 2.1.X on my windows 10 machine, I get the following error and the tool just exits.
1.3 seems to work fine on the same platform
Any help much appreciated.
Thnx
File "C:\Jenkins\Build_virtualenv\penv\lib\site-packages\sqlalchemy\engine\default.py", line 552, in do_execute
sqlalchemy.exc.OperationalError: (sqlite3.OperationalError) no such column: sessions.acl_prefilter_policy_name
[SQL: SELECT count(*) AS count_1
FROM (SELECT sessions.id AS sessions_id, sessions.migration_start_time AS sessions_migration_start_time, sessions.migration_end_time AS sessions_migration_end_time, sessions.parsing_start_time AS sessions_parsing_start_time, sessions.parsing_end_time AS sessions_parsing_end_time, sessions.sync_downstream_start_time AS sessions_sync_downstream_start_time, sessions.sync_downstream_end_time AS sessions_sync_downstream_end_time, sessions.sync_upstream_start_time AS sessions_sync_upstream_start_time, sessions.sync_upstream_end_time AS sessions_sync_upstream_end_time, sessions.config_name AS sessions_config_name, sessions.context_info AS sessions_context_info, sessions.telemetry_config_info AS sessions_telemetry_config_info, sessions.source_config_parse_summary AS sessions_source_config_parse_summary, sessions.acl_policy_name AS sessions_acl_policy_name, sessions.acl_prefilter_policy_name AS sessions_acl_prefilter_policy_name, sessions.nat_policy_name AS sessions_nat_policy_name, sessions.policy_selection_info AS sessions_policy_selection_info, sessions.server_id AS sessions_server_id, sessions.sync_status AS sessions_sync_status, sessions.system_info AS sessions_system_info, sessions.error_info AS sessions_error_info
FROM sessions) AS anon_1]
(Background on this error at: http://sqlalche.me/e/e3q8)
Solved! Go to Solution.
05-18-2020 03:41 PM - last edited on 03-09-2022 11:08 PM by smallbusiness
05-18-2020 03:41 PM - last edited on 03-09-2022 11:08 PM by smallbusiness
05-19-2020 07:59 AM
Hello:
Indeed, I just tried with a new directory and it works like a charm.
Thank you so much
Discover and save your favorite ideas. Come back to expert answers, step-by-step guides, recent topics, and more.
New here? Get started with these tips. How to use Community New member guide