Error - Migrating from Oracle to MySql (Workbench 5.2)
Hi everyone,
I'm trying to migrate a very small database from oracle to MySQL, but I have got a error, something with reverseEngineer, please see log below.
Any Help? Thanks!
Starting...
Connect to source DBMS...
- Connecting...
Connecting to ...
Opening ODBC connection to DSN=Oracle_XE...
Connected
Connect to source DBMS done
Reverse engineer selected schemata....
Connection to apparently lost, reconnecting...
Connecting to ...
Opening ODBC connection to DSN=Oracle_XE...
Connected
Reverse engineering PREVISAO from None
- Reverse engineering catalog information
Traceback (most recent call last):
File "C:\Program Files (x86)\MySQL\MySQL Workbench CE 5.2.44\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.44\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.44\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.44\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.44\workbench\wizard_progress_page_widget.py", line 191, in thread_work
self.func()
File "C:\Program Files (x86)\MySQL\MySQL Workbench CE 5.2.44\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.44\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
Edited 1 time(s). Last edit at 12/22/2012 05:12PM by Nivaldo Ribeiro.