MySQL Forums
Forum List  »  Microsoft Access

Reverse Engineer Access database in MySQL Workbench
Posted by: Arvind Bhuta
Date: January 08, 2015 01:37PM

I am trying to migrate a Microsoft Access database in MySQL Workbench in Windows 7. The problem is at Revers Engineer Source. I get a "A task has failed executing."

Here is the following message log (I'm new to MySQL, so I don't know what to do next, is there a tutorial out there or a message board I could go to for directions on what to do next?).

Starting...
Connect to source DBMS...
- Connecting...
Connecting to ...
Opening ODBC connection to DSN=OR_MIG...
Connected
Connect to source DBMS done
Reverse engineer selected schemas....
Reverse engineering OR from def
- Reverse engineering catalog information
- Preparing...
Traceback (most recent call last):
File "C:\Program Files (x86)\MySQL\MySQL Workbench 6.2 CE\modules\db_msaccess_re_grt.py", line 748, 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 265, in reverseEngineer
routine_count_per_schema[schema_name] = len(cls.getProcedureNames(connection, catalog_name, schema_name)) + len(cls.getFunctionNames(connection, catalog_name, schema_name)) if get_routines else 0
File "C:\Program Files (x86)\MySQL\MySQL Workbench 6.2 CE\modules\db_msaccess_re_grt.py", line 227, in getProcedureNames
cls.get_connection(connection).cursor().procedures() ))
pyodbc.ProgrammingError: ('42000', "[42000] [Microsoft][ODBC Microsoft Access Driver] Undefined function '|' in expression. (-3102) (SQLProcedures)")

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: ProgrammingError("('42000', "[42000] [Microsoft][ODBC Microsoft Access Driver] Undefined function '|' in expression. (-3102) (SQLProcedures)")"): error calling Python module function DbMsAccessRE.reverseEngineer
ERROR: Reverse engineer selected schemas: ProgrammingError("('42000', "[42000] [Microsoft][ODBC Microsoft Access Driver] Undefined function '|' in expression. (-3102) (SQLProcedures)")"): error calling Python module function DbMsAccessRE.reverseEngineer
Failed

Options: ReplyQuote


Subject
Views
Written By
Posted
Reverse Engineer Access database in MySQL Workbench
3882
January 08, 2015 01:37PM


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.