Bug #99056 Workbench Migration tool Crash - Sybase to MySQL
Submitted: 24 Mar 2020 13:19 Modified: 22 May 2020 12:08
Reporter: Rick Eisch Email Updates:
Status: Duplicate Impact on me:
None 
Category:MySQL Workbench: Migration Severity:S1 (Critical)
Version:8.0.19 OS:Windows (Microsoft Windows 10 Enterprise)
Assigned to: CPU Architecture:Any
Tags: WBBugReporter

[24 Mar 2020 13:19] Rick Eisch 
Description:
MIgration tool is not crrect parsing the Sybase ASE version number and as a result is failing.  Here is the log information:

08:02:30 [INF][            grt]: Connecting to Sybase@Sybase DEV...	
08:02:30 [INF][            grt]: Opening ODBC connection to DSN=Sybase DEV;DATABASE=accurint;UID=sa;PWD=XXXX...	
08:02:31 [ERR][         python]: error calling DbSybaseRE.connectTraceback (most recent call last):
08:02:31 [ERR][         python]:   File "C:\MySQLWorkbench\MySQL\MySQL Workbench 8.0 CE\modules\db_sybase_re_grt.py", line 226, in connect
08:02:31 [ERR][         python]:     _connections[connection.__id__]["version"] = getServerVersion(connection)
08:02:31 [ERR][         python]:   File "C:\MySQLWorkbench\MySQL\MySQL Workbench 8.0 CE\modules\db_sybase_re_grt.py", line 259, in getServerVersion
08:02:31 [ERR][         python]:     ver_parts = [ int(part) for part in ver_string.split('.') ] + 4*[ 0 ]
08:02:31 [ERR][         python]: ValueError: invalid literal for int() with base 10: '0 SP03 PL07'
08:02:43 [WRN][         mforms]: Resource file not found: migration_check_done_win.png
08:02:43 [WRN][         mforms]: Resource file not found: migration_check_current_win.png
08:02:52 [WRN][         mforms]: Resource file not found: migration_check_done_win.png
08:02:52 [WRN][         mforms]: Resource file not found: migration_check_current_win.png
08:02:52 [INF][         Wizard]: Execute 'Connect to source DBMS'
08:02:52 [INF][            grt]: Connecting to Sybase@Sybase DEV...	
08:02:52 [INF][            grt]: Opening ODBC connection to DSN=Sybase DEV;DATABASE=accurint;UID=sa;PWD=XXXX...	
08:02:53 [ERR][         python]: error calling DbSybaseRE.connectTraceback (most recent call last):
08:02:53 [ERR][         python]:   File "C:\MySQLWorkbench\MySQL\MySQL Workbench 8.0 CE\modules\db_sybase_re_grt.py", line 226, in connect
08:02:53 [ERR][         python]:     _connections[connection.__id__]["version"] = getServerVersion(connection)
08:02:53 [ERR][         python]:   File "C:\MySQLWorkbench\MySQL\MySQL Workbench 8.0 CE\modules\db_sybase_re_grt.py", line 259, in getServerVersion
08:02:53 [ERR][         python]:     ver_parts = [ int(part) for part in ver_string.split('.') ] + 4*[ 0 ]
08:02:53 [ERR][         python]: ValueError: invalid literal for int() with base 10: '0 SP03 PL07'
08:02:53 [ERR][         python]: error calling DbSybaseRE.getServerVersionTraceback (most recent call last):
08:02:53 [ERR][         python]:   File "C:\MySQLWorkbench\MySQL\MySQL Workbench 8.0 CE\modules\db_sybase_re_grt.py", line 259, in getServerVersion
08:02:53 [ERR][         python]:     ver_parts = [ int(part) for part in ver_string.split('.') ] + 4*[ 0 ]
08:02:53 [ERR][         python]: ValueError: invalid literal for int() with base 10: '0 SP03 PL07'

How to repeat:
Define a migration source "Sybase ASE 16" using ODBC to MySQL 8.0 as the target.  Click next.  the tools fails during the "fetch schema list" operation
[24 Mar 2020 13:26] Rick Eisch 
Advertised functionality not available
[6 Apr 2020 15:21] hero cypher 
The error about of python split function
Change: 
ver_string = ver_string.split('/', 2)[1]

with:
ver_string = ver_string.split('/')[1][:2]

in db_sybase_re_grt.py file in modules folder. But there are a lot of bug about Windows version of Workbench CE.
[22 May 2020 12:08] MySQL Verification Team 
Hello Rick Eisch,

Thank you for the bug report.
Imho this is duplicate of Bug #81546, please see Bug #81546.
Even if you feel that your issue is somewhat different, the resolution is likely to be the same. Because of this, we hope you add your comments to the original bug instead.

Regards,
Ashwini Patil