MySQL Forums
Forum List  »  Oracle

Re: MySQL Workbench Migration Oracle Privileges
Posted by: Mark Davies
Date: August 07, 2012 08:05AM

Hi Sergio,

Sorry it has taken me a while to reply. I made the suggested modifcations and now get the following error message:

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 402, in reverseEngineerTableColumns
datatype = simple_datatypes_list.index('VARCHAR')
ValueError: list.index(x): x not in list

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: ValueError("list.index(x): x not in list"): error calling Python module function DbGenericRE.reverseEngineer
*** ERROR: Reverse engineer selected schemata: ValueError("list.index(x): x not in list"): error calling Python module function DbGenericRE.reverseEngineer
Failed

Options: ReplyQuote


Subject
Views
Written By
Posted
Re: MySQL Workbench Migration Oracle Privileges
331
August 07, 2012 08:05AM


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.