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:
None 
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
Description:
I am trying to migrate an Access database to MySQL using MySqlWorkbench.  keep getting this error on a table.  

How to repeat:
restart migration
[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