Oracle to Mysql migration
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