Re: MySQL Workbench Migration Oracle Privileges

[Jerry Scott]

Hi Sergio. I have followed and made the changes in this topic. Below is my log after making the VARCHAR to VARCHAR2 change.

Thank you
Jerry Scott
Senior Database Administrator
Enterprise Holdings, Inc.

Starting...

Connect to source DBMS...

- Connecting...

Connecting to ...

Opening ODBC connection to DSN=Oracle_xxxxxxx-xxx-xxxxxxx;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_xxxxxxx-xxx-xxxxxxx;PWD=XXXX...

Connected

Reverse engineering CHECKIN from None

- Reverse engineering catalog information

Traceback (most recent call last):

File "C:\Program Files\MySQL\MySQL Workbench 5.2 CE\modules\db_generic_re_grt.py", line 182, in reverseEngineer

catalog = reverseEngineerCatalog(connection, catalog_name)

File "C:\Program Files\MySQL\MySQL Workbench 5.2 CE\modules\db_generic_re_grt.py", line 328, in reverseEngineerCatalog

reverseEngineerUserDatatypes(connection, catalog)

File "C:\Program Files\MySQL\MySQL Workbench 5.2 CE\modules\db_generic_re_grt.py", line 301, in reverseEngineerUserDatatypes

for type_row in get_connection(connection).cursor().getTypeInfo(catalog=catalog.name): # FIXME: there are duplicated names in this resultset

pyodbc.DataError: ('22003', '[22003] [Oracle][ODBC]Numeric value out of range. (0) (SQLGetData)')



Traceback (most recent call last):

File "C:\Program Files\MySQL\MySQL Workbench 5.2 CE\workbench\wizard_progress_page_widget.py", line 191, in thread_work

self.func()

File "C:\Program Files\MySQL\MySQL Workbench 5.2 CE\modules\migration_schema_selection.py", line 160, in task_reveng

self.main.plan.migrationSource.reverseEngineer()

File "C:\Program Files\MySQL\MySQL Workbench 5.2 CE\modules\migration.py", line 329, in reverseEngineer

self.state.sourceCatalog = self._rev_eng_module.reverseEngineer(self.connection, self.selectedCatalogName, self.selectedSchemataNames, self.state.applicationData)

SystemError: DataError("('22003', '[22003] [Oracle][ODBC]Numeric value out of range. (0) (SQLGetData)')"): error calling Python module function DbGenericRE.reverseEngineer

*** ERROR: Reverse engineer selected schemata: DataError("('22003', '[22003] [Oracle][ODBC]Numeric value out of range. (0) (SQLGetData)')"): error calling Python module function DbGenericRE.reverseEngineer

Failed