Description:
We are getting an error while migrating a schema from MS SQL Server to MySQL. We searched for this error and found related bugs, however they were closed because of missing updates from reporter.
There was some properties in table TableE (Name, Value) which we removed.
Reverse engineering 18 tables from test
- Retrieving table test.tableA...
- Retrieving table test.tableB...
- Retrieving table test.tableC...
- Retrieving table test.tableD...
- Retrieving table test.tableE...
Traceback (most recent call last):
File "C:\BO\modules\db_mssql_grt.py", line 391, in reverseEngineer
reverseEngineerTables(connection, schema)
File "C:\BO\modules\db_mssql_grt.py", line 563, in reverseEngineerTables
reverseEngineerTableColumns(connection, table)
File "C:\BO\modules\db_mssql_grt.py", line 623, in reverseEngineerTableColumns
for row in rows:
File "C:\BO\modules\db_mssql_grt.py", line 131, in <lambda>
con.add_output_converter(-150, lambda value: value if value is None else value.decode('utf-16'))
File "C:\BO\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 0x2e in position 50: truncated data
Traceback (most recent call last):
File "C:\BO\workbench\wizard_progress_page_widget.py", line 192, in thread_work
self.func()
File "C:\BO\modules\migration_schema_selection.py", line 175, in task_reveng
self.main.plan.migrationSource.reverseEngineer()
File "C:\BO\modules\migration.py", line 369, 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 0x2e in position 50: truncated data"): error calling Python module function DbMssqlRE.reverseEngineer
ERROR: Reverse engineer selected schemas: UnicodeDecodeError("'utf16' codec can't decode byte 0x2e in position 50: truncated data"): error calling Python module function DbMssqlRE.reverseEngineer
Failed
How to repeat:
Have a schema in SQL server with a table having properties and try to migrate the schema to mysql.