MySQL Forums
Forum List  »  Oracle

Re: MySQL Workbench Migration Oracle Privileges
Posted by: Mark Davies
Date: July 27, 2012 03:40AM

Hi Sergio,

More than happy to dig into the code.

I applied the change you suggested, which worked and I now am able to select a schema from the "Schemata Selection" window and proceed to the "Reverse Engineer Source" window. Unfortunately I encounter an error during the reverse engineer process, the log is below.

Thanks,

Mark


Starting...
Connect to source DBMS...
- Connecting...
Connecting to ...
Opening ODBC connection to DSN=oracle odbc;PWD=XXXX...
Connected
Connect to source DBMS done
Reverse engineer selected schemata....
Connection to apparently lost, reconnecting...
Connecting to ...
Opening ODBC connection to DSN=oracle odbc;PWD=XXXX...
Connected
Reverse engineering CHEMBL_14 from None
- Reverse engineering catalog information
- Preparing...
- Gathered stats for CHEMBL_14
Reverse engineering tables from CHEMBL_14
- Retrieving table CHEMBL_14.COMPOUND_PROPERTIES...
Traceback (most recent call last):
File "/Applications/MySQLWorkbench.app/Contents/PlugIns/db_generic_re_grt.py", line 229, in reverseEngineer
reverseEngineerTables(connection, schema)
File "/Applications/MySQLWorkbench.app/Contents/PlugIns/db_generic_re_grt.py", line 359, in reverseEngineerTables
reverseEngineerTableColumns(connection, table)
File "/Applications/MySQLWorkbench.app/Contents/PlugIns/db_generic_re_grt.py", line 395, in reverseEngineerTableColumns
type_name = odbc_datatypes[column_info[4]].upper() # data_type
KeyError: 3

Traceback (most recent call last):
File "/Applications/MySQLWorkbench.app/Contents/Resources/libraries/workbench/wizard_progress_page_widget.py", line 191, in thread_work
self.func()
File "/Applications/MySQLWorkbench.app/Contents/PlugIns/migration_schema_selection.py", line 160, in task_reveng
self.main.plan.migrationSource.reverseEngineer()
File "/Applications/MySQLWorkbench.app/Contents/PlugIns/migration.py", line 329, in reverseEngineer
self.state.sourceCatalog = self._rev_eng_module.reverseEngineer(self.connection, self.selectedCatalogName, self.selectedSchemataNames, self.state.applicationData)
SystemError: KeyError("3"): error calling Python module function DbGenericRE.reverseEngineer
*** ERROR: Reverse engineer selected schemata: KeyError("3"): error calling Python module function DbGenericRE.reverseEngineer
Failed

Options: ReplyQuote


Subject
Views
Written By
Posted
Re: MySQL Workbench Migration Oracle Privileges
379
July 27, 2012 03:40AM


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.