Created
December 11, 2018 22:00
-
-
Save JoeMurray/e27530b1635a105c670ceb6ae05e92d5 to your computer and use it in GitHub Desktop.
Workbench SQL Server migration error re 'utf16' codec can't decond byte
This file contains bidirectional Unicode text that may be interpreted or compiled differently than what appears below. To review, open the file in an editor that reveals hidden Unicode characters.
Learn more about bidirectional Unicode characters
| Starting... | |
| Connect to source DBMS... | |
| - Connecting... | |
| Connect to source DBMS done | |
| Reverse engineer selected schemas.... | |
| Reverse engineering dbo from RE7_39450 | |
| - Reverse engineering catalog information | |
| - Reverse engineering User Data Types... | |
| - Preparing... | |
| - Gathered stats for dbo | |
| Reverse engineering 266 tables from dbo | |
| Traceback (most recent call last): | |
| File "C:\Program Files\MySQL\MySQL Workbench 8.0 CE\modules\db_mssql_grt.py", line 395, in reverseEngineer | |
| reverseEngineerTables(connection, schema) | |
| File "C:\Program Files\MySQL\MySQL Workbench 8.0 CE\modules\db_mssql_grt.py", line 556, in reverseEngineerTables | |
| table_names = [(row[0], row[1]) for row in execute_query(connection, query % schema.name) ] | |
| File "C:\Program Files\MySQL\MySQL Workbench 8.0 CE\modules\db_mssql_grt.py", line 135, in <lambda> | |
| con.add_output_converter(-150, lambda value: value if value is None else value.decode('utf-16')) | |
| File "C:\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 byte 0x65 in position 22: truncated data | |
| Traceback (most recent call last): | |
| File "C:\Program Files\MySQL\MySQL Workbench 8.0 CE\workbench\wizard_progress_page_widget.py", line 196, in thread_work | |
| self.func() | |
| File "C:\Program Files\MySQL\MySQL Workbench 8.0 CE\modules\migration_schema_selection.py", line 179, in task_reveng | |
| self.main.plan.migrationSource.reverseEngineer() | |
| File "C:\Program Files\MySQL\MySQL Workbench 8.0 CE\modules\migration.py", line 364, in reverseEngineer | |
| self.state.sourceCatalog = self._rev_eng_module.reverseEngineer(self.connection, self.selectedCatalogName, self.selectedSchemataNames, self.state.applicationData) | |
| SystemError: UnicodeDecodeError("'utf16' codec can't decode byte 0x65 in position 22: truncated data"): error calling Python module function DbMssqlRE.reverseEngineer | |
| ERROR: Reverse engineer selected schemas: UnicodeDecodeError("'utf16' codec can't decode byte 0x65 in position 22: truncated data"): error calling Python module function DbMssqlRE.reverseEngineer | |
| Failed |
Sign up for free
to join this conversation on GitHub.
Already have an account?
Sign in to comment