Description:
I am trying to migrate Filemaker's ODBC datasource into Mysql using Workbench.I tested connection and its successful.But on Fetch onlist -Migration Wizard its giving error.
Error Log
Starting...
Connect to source DBMS...
- Connecting to source...
Connecting to sql92@DRIVER=FileMaker ODBC;SERVER=127.0.0.1;PORT=5003...
Opening ODBC connection to DRIVER=FileMaker ODBC;SERVER=127.0.0.1;PORT=5003;DATABASE=cognito;UID=administrator;PWD=XXXX;...
Connected
Connect to source DBMS done
Check target DBMS connection...
- Connecting to target...
Connecting to Mysql@localhost:3306...
Connected
Check target DBMS connection done
Retrieve schema list from source....
- Checking connection...
Connection to sql92@DRIVER=FileMaker ODBC;SERVER=127.0.0.1;PORT=5003 apparently lost, reconnecting...
Connecting to sql92@DRIVER=FileMaker ODBC;SERVER=127.0.0.1;PORT=5003...
Opening ODBC connection to DRIVER=FileMaker ODBC;SERVER=127.0.0.1;PORT=5003;DATABASE=cognito;UID=administrator;PWD=XXXX;...
Connected
- Fetching catalog names...
Traceback (most recent call last):
File "C:\Program Files\MySQL\MySQL Workbench 6.2 CE\modules\db_sql92_re_grt.py", line 364, in getCatalogNames
return Sql92ReverseEngineering.getCatalogNames(connection)
File "C:\Program Files\MySQL\MySQL Workbench 6.2 CE\modules\db_sql92_re_grt.py", line 39, in getCatalogNames
return sorted(list(set(row[0] for row in cls.execute_query(connection, 'SELECT TABLE_CATALOG FROM INFORMATION_SCHEMA.TABLES'))) )
File "C:\Program Files\MySQL\MySQL Workbench 6.2 CE\modules\db_generic_re_grt.py", line 76, in execute_query
return cls.get_connection(connection_object).cursor().execute(query, *args, **kwargs)
pyodbc.Error: ('HY000', '[HY000] [FileMaker][FileMaker] FQL0002/(1:45): The table named "TABLES" does not exist. (8309) (SQLExecDirectW)')
Traceback (most recent call last):
File "C:\Program Files\MySQL\MySQL Workbench 6.2 CE\workbench\wizard_progress_page_widget.py", line 192, in thread_work
self.func()
File "C:\Program Files\MySQL\MySQL Workbench 6.2 CE\modules\migration_source_selection.py", line 456, in task_fetch_schemata
self.main.plan.migrationSource.doFetchSchemaNames(only_these_catalogs)
File "C:\Program Files\MySQL\MySQL Workbench 6.2 CE\modules\migration.py", line 241, in doFetchSchemaNames
catalog_names = self.getCatalogNames()
File "C:\Program Files\MySQL\MySQL Workbench 6.2 CE\modules\migration.py", line 205, in getCatalogNames
return self._rev_eng_module.getCatalogNames(self.connection)
SystemError: Error("('HY000', '[HY000] [FileMaker][FileMaker] FQL0002/(1:45): The table named "TABLES" does not exist. (8309) (SQLExecDirectW)')"): error calling Python module function DbSql92RE.getCatalogNames
ERROR: Retrieve schema list from source: Error("('HY000', '[HY000] [FileMaker][FileMaker] FQL0002/(1:45): The table named "TABLES" does not exist. (8309) (SQLExecDirectW)')"): error calling Python module function DbSql92RE.getCatalogNames
Failed
How to repeat:
I am not able to migrate from Filemaker ODBC data source
Description: I am trying to migrate Filemaker's ODBC datasource into Mysql using Workbench.I tested connection and its successful.But on Fetch onlist -Migration Wizard its giving error. Error Log Starting... Connect to source DBMS... - Connecting to source... Connecting to sql92@DRIVER=FileMaker ODBC;SERVER=127.0.0.1;PORT=5003... Opening ODBC connection to DRIVER=FileMaker ODBC;SERVER=127.0.0.1;PORT=5003;DATABASE=cognito;UID=administrator;PWD=XXXX;... Connected Connect to source DBMS done Check target DBMS connection... - Connecting to target... Connecting to Mysql@localhost:3306... Connected Check target DBMS connection done Retrieve schema list from source.... - Checking connection... Connection to sql92@DRIVER=FileMaker ODBC;SERVER=127.0.0.1;PORT=5003 apparently lost, reconnecting... Connecting to sql92@DRIVER=FileMaker ODBC;SERVER=127.0.0.1;PORT=5003... Opening ODBC connection to DRIVER=FileMaker ODBC;SERVER=127.0.0.1;PORT=5003;DATABASE=cognito;UID=administrator;PWD=XXXX;... Connected - Fetching catalog names... Traceback (most recent call last): File "C:\Program Files\MySQL\MySQL Workbench 6.2 CE\modules\db_sql92_re_grt.py", line 364, in getCatalogNames return Sql92ReverseEngineering.getCatalogNames(connection) File "C:\Program Files\MySQL\MySQL Workbench 6.2 CE\modules\db_sql92_re_grt.py", line 39, in getCatalogNames return sorted(list(set(row[0] for row in cls.execute_query(connection, 'SELECT TABLE_CATALOG FROM INFORMATION_SCHEMA.TABLES'))) ) File "C:\Program Files\MySQL\MySQL Workbench 6.2 CE\modules\db_generic_re_grt.py", line 76, in execute_query return cls.get_connection(connection_object).cursor().execute(query, *args, **kwargs) pyodbc.Error: ('HY000', '[HY000] [FileMaker][FileMaker] FQL0002/(1:45): The table named "TABLES" does not exist. (8309) (SQLExecDirectW)') Traceback (most recent call last): File "C:\Program Files\MySQL\MySQL Workbench 6.2 CE\workbench\wizard_progress_page_widget.py", line 192, in thread_work self.func() File "C:\Program Files\MySQL\MySQL Workbench 6.2 CE\modules\migration_source_selection.py", line 456, in task_fetch_schemata self.main.plan.migrationSource.doFetchSchemaNames(only_these_catalogs) File "C:\Program Files\MySQL\MySQL Workbench 6.2 CE\modules\migration.py", line 241, in doFetchSchemaNames catalog_names = self.getCatalogNames() File "C:\Program Files\MySQL\MySQL Workbench 6.2 CE\modules\migration.py", line 205, in getCatalogNames return self._rev_eng_module.getCatalogNames(self.connection) SystemError: Error("('HY000', '[HY000] [FileMaker][FileMaker] FQL0002/(1:45): The table named "TABLES" does not exist. (8309) (SQLExecDirectW)')"): error calling Python module function DbSql92RE.getCatalogNames ERROR: Retrieve schema list from source: Error("('HY000', '[HY000] [FileMaker][FileMaker] FQL0002/(1:45): The table named "TABLES" does not exist. (8309) (SQLExecDirectW)')"): error calling Python module function DbSql92RE.getCatalogNames Failed How to repeat: I am not able to migrate from Filemaker ODBC data source