MySQL Forums
Forum List  »  Oracle

Oracle to Mysql migration
Posted by: Douglas Campbell
Date: February 12, 2013 02:24PM

Hi, This problem has been reported numerous times and when asked if its a bug users have been ignored. When asked does the Migration tool support Oracle again no answer. The person who has dealt most with these problems is developer Sergio but I would like to know what the solution is to the problem below even if its a bug that will be fixed in the next release.




Starting...

Connect to source DBMS...

- Connecting...

Connecting to ...

Opening ODBC connection to DSN=C5LOCAL...

Connected

Connect to source DBMS done

Reverse engineer selected schemata....

Connection to apparently lost, reconnecting...

Connecting to ...

Opening ODBC connection to DSN=C5LOCAL...

Connected

Reverse engineering C5NW from None

- Reverse engineering catalog information

Traceback (most recent call last):

File "C:\Program Files (x86)\MySQL\MySQL Workbench CE 5.2.46\modules\db_generic_re_grt.py", line 683, in reverseEngineer

return GenericReverseEngineering.reverseEngineer(connection, catalog_name, schemata_list, context)

File "C:\Program Files (x86)\MySQL\MySQL Workbench CE 5.2.46\modules\db_generic_re_grt.py", line 207, in reverseEngineer

catalog = cls.reverseEngineerCatalog(connection, catalog_name)

File "C:\Program Files (x86)\MySQL\MySQL Workbench CE 5.2.46\modules\db_generic_re_grt.py", line 358, in reverseEngineerCatalog

cls.reverseEngineerUserDatatypes(connection, catalog)

File "C:\Program Files (x86)\MySQL\MySQL Workbench CE 5.2.46\modules\db_generic_re_grt.py", line 331, in reverseEngineerUserDatatypes

for type_row in cls.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 (x86)\MySQL\MySQL Workbench CE 5.2.46\workbench\wizard_progress_page_widget.py", line 192, in thread_work

self.func()

File "C:\Program Files (x86)\MySQL\MySQL Workbench CE 5.2.46\modules\migration_schema_selection.py", line 160, in task_reveng

self.main.plan.migrationSource.reverseEngineer()

File "C:\Program Files (x86)\MySQL\MySQL Workbench CE 5.2.46\modules\migration.py", line 332, 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
Oracle to Mysql migration
391
February 12, 2013 02:24PM
104
February 13, 2013 10:41AM


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.