Re: MySQL Workbench Migration Oracle Privileges

[Mark Davies]

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