Bug #100153 Reverse engineer selected schemas: UnicodeDecodeError("'utf16' codec can't decod

• Submitted: 8 Jul 2020 9:02
• Modified: 15 Sep 2020 20:50
• Reporter: x x
• Status: Can't repeat
• Category: MySQL Workbench: Migration
• Severity: S7 (Test Cases)
• Version: 8.0.20
• OS: Windows (Microsoft Windows 10 Education)
• CPU Architecture: Any
• Tags: WBBugReporter

[8 Jul 2020 9:02] x x

Description:
----[For better reports, please attach the log file after submitting. You can find it in Z:\Users\Nenver001\AppData\Roaming\MySQL\Workbench\log\wb.log]

Traceback (most recent call last):
  File "Z:\Program Files\MySQL\MySQL Workbench 8.0 CE\modules\db_mssql_grt.py", line 407, in reverseEngineer
    reverseEngineerTables(connection, schema)
  File "Z:\Program Files\MySQL\MySQL Workbench 8.0 CE\modules\db_mssql_grt.py", line 570, in reverseEngineerTables
    table_names = [(row[0], row[1]) for row in execute_query(connection, query.decode(encoding='UTF-8',errors='strict')) ]
  File "Z:\Program Files\MySQL\MySQL Workbench 8.0 CE\modules\db_mssql_grt.py", line 141, in <lambda>
    con.add_output_converter(-150, lambda value: value if value is None else value.decode('utf-16'))
  File "Z:\Program Files\MySQL\MySQL Workbench 8.0 CE\Python\Lib\encodings\utf_16.py", line 16, in decode
    return codecs.utf_16_decode(input, errors, True)
UnicodeDecodeError: 'utf16' codec can't decode bytes in position 10-11: illegal UTF-16 surrogate

How to repeat:
Traceback (most recent call last):
  File "Z:\Program Files\MySQL\MySQL Workbench 8.0 CE\modules\db_mssql_grt.py", line 407, in reverseEngineer
    reverseEngineerTables(connection, schema)
  File "Z:\Program Files\MySQL\MySQL Workbench 8.0 CE\modules\db_mssql_grt.py", line 570, in reverseEngineerTables
    table_names = [(row[0], row[1]) for row in execute_query(connection, query.decode(encoding='UTF-8',errors='strict')) ]
  File "Z:\Program Files\MySQL\MySQL Workbench 8.0 CE\modules\db_mssql_grt.py", line 141, in <lambda>
    con.add_output_converter(-150, lambda value: value if value is None else value.decode('utf-16'))
  File "Z:\Program Files\MySQL\MySQL Workbench 8.0 CE\Python\Lib\encodings\utf_16.py", line 16, in decode
    return codecs.utf_16_decode(input, errors, True)
UnicodeDecodeError: 'utf16' codec can't decode bytes in position 10-11: illegal UTF-16 surrogate

[15 Sep 2020 20:50] MySQL Verification Team

Not enough information was provided for us to be able to handle this bug. Please re-read the instructions at http://bugs.mysql.com/how-to-report.php 

If you can provide more information, feel free to add it to this bug.

Thank you for your interest in MySQL.