Description:
I am trying to do a POC on migrating an ORACLE database to MySQL. I manage to do the setup for the Source and Destination but upon retrieval of schema non appears.
09:48:38 [INF][ grt]: Opening ODBC connection to DSN=ORACLE...
09:48:39 [ERR][ python]: error calling DbGenericRE.connect
Traceback:
File "C:\Program Files\MySQL\MySQL Workbench 8.0\modules\db_generic_re_grt.py", line 693, in connect
return GenericReverseEngineering.connect(connection, password)
File "C:\Program Files\MySQL\MySQL Workbench 8.0\modules\db_generic_re_grt.py", line 147, in connect
con = db_driver.connect(connection, password)
File "C:\Program Files\MySQL\MySQL Workbench 8.0\workbench\db_driver.py", line 95, in connect
connection = library.connect(connection_string, password=password)
NameError: ('28000', '[28000] [Oracle][ODBC][Ora]ORA-01005: null password given; logon denied\n (1005) (SQLDriverConnect); [28000] [Oracle][ODBC][Ora]ORA-01005: null password given; logon denied\n (1005)')
09:48:39 [ERR][ pymforms]: Unhandled exception in Python code:
Traceback (most recent call last):
File "C:\Program Files\MySQL\MySQL Workbench 8.0\modules\migration_source_selection.py", line 226, in test_connection
if not source.connect():
File "C:\Program Files\MySQL\MySQL Workbench 8.0\modules\migration.py", line 199, in connect
self._rev_eng_module.connect(self.connection, self.password or "")
SystemError: InterfaceError("('28000', '[28000] [Oracle][ODBC][Ora]ORA-01005: null password given; logon denied\n (1005) (SQLDriverConnect); [28000] [Oracle][ODBC][Ora]ORA-01005: null password given; logon denied\n (1005)')"): error calling Python module function DbGenericRE.connect
During handling of the above exception, another exception occurred:
Traceback (most recent call last):
File "C:\Program Files\MySQL\MySQL Workbench 8.0\modules\migration_source_selection.py", line 331, in go_advanced
self.test_connection(self.main.plan.migrationSource, "Source")
File "C:\Program Files\MySQL\MySQL Workbench 8.0\modules\migration_source_selection.py", line 256, in test_connection
username = source.connection.parameterValues.userName
KeyError: 'grt.Dict key must be a string'
09:49:35 [INF][ grt]: Connecting to generic@DRIVER=%driver%;SERVER=vmoracle.rx5ndv43tvbezjzonsygi5xach.dx.internal.cloudapp.net;PORT=1521...
09:49:35 [INF][ grt]: Opening ODBC connection to DRIVER=;SERVER=vmoracle.rx5ndv43tvbezjzonsygi5xach.dx.internal.cloudapp.net;PORT=1521;DATABASE=;UID=hr;PWD=XXXX;...
09:49:35 [ERR][ python]: error calling DbGenericRE.connect
Traceback:
File "C:\Program Files\MySQL\MySQL Workbench 8.0\modules\db_generic_re_grt.py", line 693, in connect
return GenericReverseEngineering.connect(connection, password)
File "C:\Program Files\MySQL\MySQL Workbench 8.0\modules\db_generic_re_grt.py", line 147, in connect
con = db_driver.connect(connection, password)
File "C:\Program Files\MySQL\MySQL Workbench 8.0\workbench\db_driver.py", line 95, in connect
connection = library.connect(connection_string, password=password)
NameError: ('IM002', '[IM002] [Microsoft][ODBC Driver Manager] Data source name not found and no default driver specified (0) (SQLDriverConnect)')
09:49:36 [INF][ grt]: Connecting to generic@DRIVER=%driver%;SERVER=vmoracle.rx5ndv43tvbezjzonsygi5xach.dx.internal.cloudapp.net;PORT=1521...
09:49:36 [INF][ grt]: Opening ODBC connection to DRIVER=;SERVER=vmoracle.rx5ndv43tvbezjzonsygi5xach.dx.internal.cloudapp.net;PORT=1521;DATABASE=;UID=hr;PWD=XXXX;...
09:49:36 [ERR][ python]: error calling DbGenericRE.connect
Traceback:
File "C:\Program Files\MySQL\MySQL Workbench 8.0\modules\db_generic_re_grt.py", line 693, in connect
return GenericReverseEngineering.connect(connection, password)
File "C:\Program Files\MySQL\MySQL Workbench 8.0\modules\db_generic_re_grt.py", line 147, in connect
con = db_driver.connect(connection, password)
File "C:\Program Files\MySQL\MySQL Workbench 8.0\workbench\db_driver.py", line 95, in connect
connection = library.connect(connection_string, password=password)
NameError: ('IM002', '[IM002] [Microsoft][ODBC Driver Manager] Data source name not found and no default driver specified (0) (SQLDriverConnect)')
09:49:42 [INF][ grt]: Connecting to ...
09:49:42 [INF][ grt]: Opening ODBC connection to DSN=UserOracle...
09:49:42 [INF][ grt]: Connected
09:49:45 [WRN][ mforms]: Resource file not found: migration_check_done_win.png
09:49:45 [WRN][ mforms]: Resource file not found: migration_check_current_win.png
09:49:48 [INF][ grt]: Connecting to Mysql@mysqlnightwatch.mysql.database.azure.com:3306...
09:49:48 [INF][ grt]: Connecting to Mysql@mysqlnightwatch.mysql.database.azure.com:3306...
09:49:48 [INF][ grt]: Connected
09:49:51 [WRN][ mforms]: Resource file not found: migration_check_done_win.png
09:49:51 [WRN][ mforms]: Resource file not found: migration_check_current_win.png
09:49:52 [INF][ Wizard]: Execute 'Connect to source DBMS'
09:49:52 [INF][ grt]: Connecting to ...
09:49:52 [INF][ grt]: Opening ODBC connection to DSN=UserOracle...
09:49:52 [INF][ grt]: Connected
09:49:52 [INF][ Wizard]: Execute 'Check target DBMS connection'
09:49:52 [INF][ grt]: Connecting to Mysql@mysqlnightwatch.mysql.database.azure.com:3306...
09:49:52 [INF][ grt]: Connecting to Mysql@mysqlnightwatch.mysql.database.azure.com:3306...
09:49:52 [INF][ grt]: Connected
09:49:52 [INF][ Wizard]: Starting thread for 'Retrieve schema list from source'
09:49:52 [INF][ grt]: Connection to apparently lost, reconnecting...
09:49:52 [INF][ grt]: Connecting to ...
09:49:52 [INF][ grt]: Opening ODBC connection to DSN=UserOracle...
09:49:52 [INF][ grt]: Connected
09:49:57 [WRN][ mforms]: Resource file not found: migration_check_done_win.png
09:49:57 [WRN][ mforms]: Resource file not found: migration_check_current_win.png
09:57:02 [WRN][ mforms]: Resource file not found: migration_check_current_win.png
09:57:06 [WRN][ mforms]: Resource file not found: migration_check_current_win.png
09:57:10 [WRN][ mforms]: Resource file not found: migration_check_current_win.png
How to repeat:
Database System: Generic RDBMS
Connection Method: ODBC Datasource
DSN: UserOracle (Oracle in instantclient_19_15)
Description: I am trying to do a POC on migrating an ORACLE database to MySQL. I manage to do the setup for the Source and Destination but upon retrieval of schema non appears. 09:48:38 [INF][ grt]: Opening ODBC connection to DSN=ORACLE... 09:48:39 [ERR][ python]: error calling DbGenericRE.connect Traceback: File "C:\Program Files\MySQL\MySQL Workbench 8.0\modules\db_generic_re_grt.py", line 693, in connect return GenericReverseEngineering.connect(connection, password) File "C:\Program Files\MySQL\MySQL Workbench 8.0\modules\db_generic_re_grt.py", line 147, in connect con = db_driver.connect(connection, password) File "C:\Program Files\MySQL\MySQL Workbench 8.0\workbench\db_driver.py", line 95, in connect connection = library.connect(connection_string, password=password) NameError: ('28000', '[28000] [Oracle][ODBC][Ora]ORA-01005: null password given; logon denied\n (1005) (SQLDriverConnect); [28000] [Oracle][ODBC][Ora]ORA-01005: null password given; logon denied\n (1005)') 09:48:39 [ERR][ pymforms]: Unhandled exception in Python code: Traceback (most recent call last): File "C:\Program Files\MySQL\MySQL Workbench 8.0\modules\migration_source_selection.py", line 226, in test_connection if not source.connect(): File "C:\Program Files\MySQL\MySQL Workbench 8.0\modules\migration.py", line 199, in connect self._rev_eng_module.connect(self.connection, self.password or "") SystemError: InterfaceError("('28000', '[28000] [Oracle][ODBC][Ora]ORA-01005: null password given; logon denied\n (1005) (SQLDriverConnect); [28000] [Oracle][ODBC][Ora]ORA-01005: null password given; logon denied\n (1005)')"): error calling Python module function DbGenericRE.connect During handling of the above exception, another exception occurred: Traceback (most recent call last): File "C:\Program Files\MySQL\MySQL Workbench 8.0\modules\migration_source_selection.py", line 331, in go_advanced self.test_connection(self.main.plan.migrationSource, "Source") File "C:\Program Files\MySQL\MySQL Workbench 8.0\modules\migration_source_selection.py", line 256, in test_connection username = source.connection.parameterValues.userName KeyError: 'grt.Dict key must be a string' 09:49:35 [INF][ grt]: Connecting to generic@DRIVER=%driver%;SERVER=vmoracle.rx5ndv43tvbezjzonsygi5xach.dx.internal.cloudapp.net;PORT=1521... 09:49:35 [INF][ grt]: Opening ODBC connection to DRIVER=;SERVER=vmoracle.rx5ndv43tvbezjzonsygi5xach.dx.internal.cloudapp.net;PORT=1521;DATABASE=;UID=hr;PWD=XXXX;... 09:49:35 [ERR][ python]: error calling DbGenericRE.connect Traceback: File "C:\Program Files\MySQL\MySQL Workbench 8.0\modules\db_generic_re_grt.py", line 693, in connect return GenericReverseEngineering.connect(connection, password) File "C:\Program Files\MySQL\MySQL Workbench 8.0\modules\db_generic_re_grt.py", line 147, in connect con = db_driver.connect(connection, password) File "C:\Program Files\MySQL\MySQL Workbench 8.0\workbench\db_driver.py", line 95, in connect connection = library.connect(connection_string, password=password) NameError: ('IM002', '[IM002] [Microsoft][ODBC Driver Manager] Data source name not found and no default driver specified (0) (SQLDriverConnect)') 09:49:36 [INF][ grt]: Connecting to generic@DRIVER=%driver%;SERVER=vmoracle.rx5ndv43tvbezjzonsygi5xach.dx.internal.cloudapp.net;PORT=1521... 09:49:36 [INF][ grt]: Opening ODBC connection to DRIVER=;SERVER=vmoracle.rx5ndv43tvbezjzonsygi5xach.dx.internal.cloudapp.net;PORT=1521;DATABASE=;UID=hr;PWD=XXXX;... 09:49:36 [ERR][ python]: error calling DbGenericRE.connect Traceback: File "C:\Program Files\MySQL\MySQL Workbench 8.0\modules\db_generic_re_grt.py", line 693, in connect return GenericReverseEngineering.connect(connection, password) File "C:\Program Files\MySQL\MySQL Workbench 8.0\modules\db_generic_re_grt.py", line 147, in connect con = db_driver.connect(connection, password) File "C:\Program Files\MySQL\MySQL Workbench 8.0\workbench\db_driver.py", line 95, in connect connection = library.connect(connection_string, password=password) NameError: ('IM002', '[IM002] [Microsoft][ODBC Driver Manager] Data source name not found and no default driver specified (0) (SQLDriverConnect)') 09:49:42 [INF][ grt]: Connecting to ... 09:49:42 [INF][ grt]: Opening ODBC connection to DSN=UserOracle... 09:49:42 [INF][ grt]: Connected 09:49:45 [WRN][ mforms]: Resource file not found: migration_check_done_win.png 09:49:45 [WRN][ mforms]: Resource file not found: migration_check_current_win.png 09:49:48 [INF][ grt]: Connecting to Mysql@mysqlnightwatch.mysql.database.azure.com:3306... 09:49:48 [INF][ grt]: Connecting to Mysql@mysqlnightwatch.mysql.database.azure.com:3306... 09:49:48 [INF][ grt]: Connected 09:49:51 [WRN][ mforms]: Resource file not found: migration_check_done_win.png 09:49:51 [WRN][ mforms]: Resource file not found: migration_check_current_win.png 09:49:52 [INF][ Wizard]: Execute 'Connect to source DBMS' 09:49:52 [INF][ grt]: Connecting to ... 09:49:52 [INF][ grt]: Opening ODBC connection to DSN=UserOracle... 09:49:52 [INF][ grt]: Connected 09:49:52 [INF][ Wizard]: Execute 'Check target DBMS connection' 09:49:52 [INF][ grt]: Connecting to Mysql@mysqlnightwatch.mysql.database.azure.com:3306... 09:49:52 [INF][ grt]: Connecting to Mysql@mysqlnightwatch.mysql.database.azure.com:3306... 09:49:52 [INF][ grt]: Connected 09:49:52 [INF][ Wizard]: Starting thread for 'Retrieve schema list from source' 09:49:52 [INF][ grt]: Connection to apparently lost, reconnecting... 09:49:52 [INF][ grt]: Connecting to ... 09:49:52 [INF][ grt]: Opening ODBC connection to DSN=UserOracle... 09:49:52 [INF][ grt]: Connected 09:49:57 [WRN][ mforms]: Resource file not found: migration_check_done_win.png 09:49:57 [WRN][ mforms]: Resource file not found: migration_check_current_win.png 09:57:02 [WRN][ mforms]: Resource file not found: migration_check_current_win.png 09:57:06 [WRN][ mforms]: Resource file not found: migration_check_current_win.png 09:57:10 [WRN][ mforms]: Resource file not found: migration_check_current_win.png How to repeat: Database System: Generic RDBMS Connection Method: ODBC Datasource DSN: UserOracle (Oracle in instantclient_19_15)