MySQL Forums
Forum List  »  Microsoft Access

Workbench Access to MySQL migration issue.
Posted by: David Plott
Date: October 09, 2014 01:03PM

MySQL Workbench version: 6.2.3.12312 Build 2280 32 Bit
Win 7 pro, latest patches.

I am trying to Reverse engineer a MS Access 2010 DB to a MySQL DB. I get to the reverse engineer part and it almost gets done and then throws the following error. I don't know where to go from here, the error doesn't provide me with any info to work with. Does anyone have any idea as to what my issue might be?

Thanks,

Traceback (most recent call last):
File "C:\Program Files (x86)\MySQL\MySQL Workbench 6.2 CE\modules\db_msaccess_re_grt.py", line 753, in reverseEngineer
return MsAccessReverseEngineering.reverseEngineer(connection, catalog_name, schemata_list, context)
File "C:\Program Files (x86)\MySQL\MySQL Workbench 6.2 CE\modules\db_msaccess_re_grt.py", line 351, in reverseEngineer
cls.reverseEngineerTables(connection, schema)
File "C:\Program Files (x86)\MySQL\MySQL Workbench 6.2 CE\modules\db_msaccess_re_grt.py", line 438, in reverseEngineerTables
cls.reverseEngineerTableFKs(connection, table)
File "C:\Program Files (x86)\MySQL\MySQL Workbench 6.2 CE\modules\db_msaccess_re_grt.py", line 632, in reverseEngineerTableFKs
process_fk(catalog, table, fk_name, fk_columns)
File "C:\Program Files (x86)\MySQL\MySQL Workbench 6.2 CE\modules\db_msaccess_re_grt.py", line 588, in process_fk
ref_column = find_object_with_name(foreign_key.referencedTable.columns, fk_row.szReferencedColumn)
AttributeError: 'NoneType' object has no attribute 'columns'

Traceback (most recent call last):
File "C:\Program Files (x86)\MySQL\MySQL Workbench 6.2 CE\workbench\wizard_progress_page_widget.py", line 192, in thread_work
self.func()
File "C:\Program Files (x86)\MySQL\MySQL Workbench 6.2 CE\modules\migration_schema_selection.py", line 175, in task_reveng
self.main.plan.migrationSource.reverseEngineer()
File "C:\Program Files (x86)\MySQL\MySQL Workbench 6.2 CE\modules\migration.py", line 356, in reverseEngineer
self.state.sourceCatalog = self._rev_eng_module.reverseEngineer(self.connection, self.selectedCatalogName, self.selectedSchemataNames, self.state.applicationData)
SystemError: AttributeError("'NoneType' object has no attribute 'columns'"): error calling Python module function DbMsAccessRE.reverseEngineer
ERROR: Reverse engineer selected schemas: AttributeError("'NoneType' object has no attribute 'columns'"): error calling Python module function DbMsAccessRE.reverseEngineer
Failed

Options: ReplyQuote


Subject
Views
Written By
Posted
Workbench Access to MySQL migration issue.
4147
October 09, 2014 01:03PM


Sorry, you can't reply to this topic. It has been closed.

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.