Bug #75747 Not able to Migrate FileMaker's Database into MySQL
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
Portions of this website are copyright © 2001, 2002 The PHP Group
Page generated in 0.049 sec. using MySQL 8.4.7-u6-cloud
Timestamp references displayed by the system are UTC.
Content reproduced on this site is the property of the
respective copyright holders.
It is not reviewed in advance
by Oracle and does not necessarily represent the opinion of
Oracle or any other party.
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