Bug #106972 | ERROR: Determine number of rows to copy: Error with code 3221225477 | ||
---|---|---|---|
Submitted: | 9 Apr 2022 21:22 | Modified: | 19 Apr 2022 14:11 |
Reporter: | Stephen Yuenger | Email Updates: | |
Status: | Duplicate | Impact on me: | |
Category: | MySQL Workbench: Migration | Severity: | S1 (Critical) |
Version: | OS: | Windows (11 Pro) | |
Assigned to: | CPU Architecture: | x86 (I9) | |
Tags: | error |
[9 Apr 2022 21:22]
Stephen Yuenger
[11 Apr 2022 13:20]
MySQL Verification Team
Hello Stephen Yuenger, Thank you for the bug report. Could you please provide the error log? Regards, Ashwini Patil
[11 Apr 2022 16:59]
Stephen Yuenger
I was requested by Ashwini Patil to post the error log. I wish I had an error log. The problem is that this was discovered when I was analyzing the output and had major differences in the number of records attempted to write (based on recdNo) and the actual in the file. There were 10000s of records missing.
[11 Apr 2022 17:03]
Stephen Yuenger
Sorry posted that comment to wrong log.
[11 Apr 2022 17:20]
Stephen Yuenger
ERROR: Reverse engineer selected schemas: UnicodeDecodeError("'utf-16-le' codec can't decode bytes in position 50-51: illegal encoding"): error calling Python module function DbMsAccessRE.reverseEngineer Failed - Retrieving table 501c3OPA Expanded.Ntbl_ProgramType... - Retrieving table 501c3OPA Expanded.Switchboard Items... WARNING: Migration: reverseEngineerTablePK: column Switchboard Items.SwitchboardID was changed to NOT NULL because it's a Primary Key column WARNING: Migration: reverseEngineerTablePK: column Switchboard Items.ItemNumber was changed to NOT NULL because it's a Primary Key column - Retrieving table 501c3OPA Expanded.Ntbl_StaffPgmRole... - Retrieving table 501c3OPA Expanded.Dtbl_Memories_Mast... WARNING: Migration: reverseEngineerTable: Skipping index Dtbl_Memories_Mast.MM_MetaCodeNIK on a LONGCHAR column WARNING: Migration: reverseEngineerTable: Skipping index Dtbl_Memories_Mast.MM_PurposeNIK on a LONGCHAR column WARNING: Migration: reverseEngineerTable: Skipping index Dtbl_Memories_Mast.MM_PurposeNIK on a LONGCHAR column - Retrieving table 501c3OPA Expanded.Ntbl_AssetClass... - Retrieving table 501c3OPA Expanded.Tapi_Trans... - Retrieving table 501c3OPA Expanded.Ntbl_LicenseStatus... - Retrieving table 501c3OPA Expanded.Dtbl_Evaluations... - Retrieving table 501c3OPA Expanded.Dtbl_Exemplars_Mast... WARNING: Migration: reverseEngineerTable: Skipping index Dtbl_Exemplars_Mast.EX_Actions on a LONGCHAR column WARNING: Migration: reverseEngineerTable: Skipping index Dtbl_Exemplars_Mast.EX_AddFiles on a LONGCHAR column WARNING: Migration: reverseEngineerTable: Skipping index Dtbl_Exemplars_Mast.EX_By on a LONGCHAR column WARNING: Migration: reverseEngineerTable: Skipping index Dtbl_Exemplars_Mast.EX_Meta on a LONGCHAR column WARNING: Migration: reverseEngineerTable: Skipping index Dtbl_Exemplars_Mast.EX_Values on a LONGCHAR column - Retrieving table 501c3OPA Expanded.Tapi_TransApi... - Retrieving table 501c3OPA Expanded.Dtbl_Bios... - Retrieving table 501c3OPA Expanded.Tapi_Clarifai... - Retrieving table 501c3OPA Expanded.Tapi_SmartyStreets... - Retrieving table 501c3OPA Expanded.Dtb_lActionsTrace_Mast... WARNING: Migration: reverseEngineerTable: Skipping index Dtb_lActionsTrace_Mast.AT_Documentation on a LONGCHAR column WARNING: Migration: reverseEngineerTable: Skipping index Dtb_lActionsTrace_Mast.AT_ActionNIK on a LONGCHAR column - Retrieving table 501c3OPA Expanded.Dtbl_Donations_Mast... WARNING: Migration: reverseEngineerTable: Skipping index Dtbl_Donations_Mast.DO_ActionNIK on a LONGCHAR column - Retrieving table 501c3OPA Expanded.Copy Of Dtbl_County_Mast... - Retrieving table 501c3OPA Expanded.Dtbl_People... WARNING: Migration: reverseEngineerTable: Skipping index Dtbl_People.OrgNIK on a LONGCHAR column WARNING: Migration: reverseEngineerTable: Skipping index Dtbl_People.RoleNIK on a LONGCHAR column WARNING: Migration: reverseEngineerTable: Skipping index Dtbl_People.ContForOptIN on a LONGCHAR column WARNING: Migration: reverseEngineerTable: Skipping index Dtbl_People.OrgNIK on a LONGCHAR column WARNING: Migration: reverseEngineerTable: Skipping index Dtbl_People.RoleNIK on a LONGCHAR column - Retrieving table 501c3OPA Expanded.Dtbl_Staffing... WARNING: Migration: reverseEngineerTable: Skipping index Dtbl_Staffing.RoleNIK on a LONGCHAR column WARNING: Migration: reverseEngineerTable: Skipping index Dtbl_Staffing.StaffLicenseNIK on a LONGCHAR column WARNING: Migration: reverseEngineerTable: Skipping index Dtbl_Staffing.StaffQualfNIK on a LONGCHAR column WARNING: Migration: reverseEngineerTable: Skipping index Dtbl_Staffing.RoleNIK on a LONGCHAR column - Retrieving table 501c3OPA Expanded.Tapi_Outlook... - Retrieving table 501c3OPA Expanded.Tapi_Stamps... - Retrieving table 501c3OPA Expanded.Ntbl_ExActions... - Retrieving table 501c3OPA Expanded.Ntbl_OrgType... Traceback (most recent call last): File "C:\Program Files\MySQL\MySQL Workbench 8.0 CE\workbench\wizard_progress_page_widget.py", line 197, in thread_work self.func() File "C:\Program Files\MySQL\MySQL Workbench 8.0 CE\modules\migration_schema_selection.py", line 183, 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("'utf-16-le' codec can't decode bytes in position 50-51: illegal encoding"): error calling Python module function DbMsAccessRE.reverseEngineer ERROR: Reverse engineer selected schemas: UnicodeDecodeError("'utf-16-le' codec can't decode bytes in position 50-51: illegal encoding"): error calling Python module function DbMsAccessRE.reverseEngineer Failed
[19 Apr 2022 14:11]
MySQL Verification Team
Hello Stephen Yuenger, Thank you for the details. Imho this is duplicate of Bug #87647, please see Bug #87647. Regards, Ashwini Patil