MySQL Forums
Forum List  »  Oracle

Re: MySQL Workbench Migration Oracle Privileges
Posted by: Jerry Scott
Date: August 14, 2012 10:05AM

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

Options: ReplyQuote


Subject
Views
Written By
Posted
Re: MySQL Workbench Migration Oracle Privileges
351
August 14, 2012 10: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.