Bug #75747 Not able to Migrate FileMaker's Database into MySQL

Submitted: 3 Feb 2015 13:06 Modified: 3 Feb 2015 15:45
Reporter: Chandni Gorajiya Email Updates:
Status: Unsupported Impact on me:
None 
Category:MySQL Workbench Severity:S3 (Non-critical)
Version:6.2.4.12437 build2426 OS:Windows
Assigned to: CPU Architecture:Any

[3 Feb 2015 13:06] Chandni Gorajiya
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
[3 Feb 2015 15:45] MySQL Verification Team
Thank you for the bug report. Such migration isn't supported you however could convert this bug report as feature request. Thanks.

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.