Bug #105722 MS Access DB Migration fails with Record Count - Code: 3221225477
Submitted: 26 Nov 2021 16:55 Modified: 29 Dec 2021 12:48
Reporter: Stephen Brown Email Updates:
Status: No Feedback Impact on me:
None 
Category:MySQL Workbench: Migration Severity:S2 (Serious)
Version:8.0.27 OS:Microsoft Windows
Assigned to: MySQL Verification Team CPU Architecture:Any
Tags: accdb, access, MDB, migration, reverse engineering

[26 Nov 2021 16:55] Stephen Brown
Description:
Attempted migration of a MS Access 16 DB fails using MySQL Workbench 6.3.9's Migration Wizard.

Attempting to Migrate Access365 back end tables to Mysql Using MYSQL Workbench.
I am using the Migration Wizard on Workbench. I started with the ODBC 64bit to select the data source (MS-Access be 47 tables ) Then started with Migration. I get to the 'Create Schemas' part and here the first warnings appear.Like below:

Then get to the Bulk Transfer part and get the message below

Starting...
Prepare information for data copy...
Prepare information for data copy done
Determine number of rows to copy....
Counting number of rows in tables...
wbcopytables.exe --count-only --passwords-from-stdin --odbc-source="DSN=MediProsDB_2" --source-rdbms-type=MsAccess --source-timeout= --target-timeout=None --table-file=C:\Users\medic\AppData\Local\Temp\tmpxkpmzeup
--table 	"tbl_Option_MandateStatus"
16:49:20 [INF][      copytable]: --table 	"tbl_Option_ExpertTypeID"
16:49:20 [INF][      copytable]: --table 	"tbl_Option_RecordCount"
16:49:20 [INF][      copytable]: --table 	"tbl_Option_FOAReturnedID"
16:49:20 [INF][      copytable]: --table 	"tbl_Users"
16:49:20 [INF][      copytable]: --table 	"tbl_Option_ClientStatusID_Report"
16:49:20 [INF][      copytable]: --table 	"tbl_ExpertAddRec"
16:49:20 [INF][      copytable]: --table 	"tbl_Option_SolicitorsID"
16:49:20 [INF][      copytable]: --table 	"tbl_UserTypes"
16:49:20 [INF][      copytable]: --table 	"tbl_Diary_1"
16:49:20 [INF][      copytable]: --table 	"tbl_Option_ProviderType"
16:49:20 [INF][      copytable]: --table 	"tbl_ExpertAddRecSol"
16:49:20 [INF][      copytable]: --table 	"tbl_Option_ProductServiceList"
16:49:20 [INF][      copytable]: --table 	"tbl_Option_ClientStatusID_Records"
16:49:20 [INF][      copytable]: --table 	"tbl_GP_HospitalPractices_all"
16:49:20 [INF][      copytable]: --table 	"tbl_Solicitor_Emails"
16:49:20 [INF][      copytable]: --table 	"tbl_Option_RecordStatus"
16:49:20 [INF][      copytable]: --table 	"tbl_SolicitorsJFLaw"
16:49:20 [INF][      copytable]: --table 	"tbl_Option_RecordChased"
16:49:20 [INF][      copytable]: --table 	"tbl_Option_VideoTypeID"
16:49:20 [INF][      copytable]: --table 	"tbl_Option_FOARequiredID"
16:49:20 [INF][      copytable]: --table 	"tbl_OptionExpertContractStatusID"
16:49:20 [INF][      copytable]: --table 	"tbl_Option_ReportType"
16:49:20 [INF][      copytable]: --table 	"tbl_Option_DBProgress"
16:49:20 [INF][      copytable]: --table 	"tbl_Option_ClaimTypeID"
16:49:20 [INF][      copytable]: --table 	"tbl_ExpertRecRequest"
16:49:20 [INF][      copytable]: --table 	"tbl_Option_LOIReceived"
16:49:20 [INF][      copytable]: --table 	"tbl_MediprosID"
16:49:20 [INF][      copytable]: --table 	"tbl_Option_ClientStatusID"
16:49:20 [INF][      copytable]: --table 	"tbl_Option_MandateReceived"
16:49:20 [INF][      copytable]: Opening ODBC connection to [MsAccess] 'DSN=MediProsDB_2;PWD=XXX'
16:49:20 [INF][      copytable]: ODBC connection to 'DSN=MediProsDB_2;PWD=' opened

Loading table information from file C:\Users\medic\AppData\Local\Temp\tmpxkpmzeup
ROW_COUNT::"tbl_Option_MandateStatus": 2
ROW_COUNT::"tbl_Option_ExpertTypeID": 34
ROW_COUNT::"tbl_Option_RecordCount": 15
ROW_COUNT::"tbl_Option_FOAReturnedID": 2
ROW_COUNT::"tbl_Users": 11
ROW_COUNT::"tbl_Option_ClientStatusID_Report": 13
ROW_COUNT::"tbl_ExpertAddRec": 0
ROW_COUNT::"tbl_Option_SolicitorsID": 1
ROW_COUNT::"tbl_UserTypes": 2
ROW_COUNT::"tbl_Diary_1": 20
ROW_COUNT::"tbl_Option_ProviderType": 9
ROW_COUNT::"tbl_ExpertAddRecSol": 0
ROW_COUNT::"tbl_Option_ProductServiceList": 24
ROW_COUNT::"tbl_Option_ClientStatusID_Records": 2
ROW_COUNT::"tbl_GP_HospitalPractices_all": 3315
ROW_COUNT::"tbl_Solicitor_Emails": 43
ROW_COUNT::"tbl_Option_RecordStatus": 7
ROW_COUNT::"tbl_SolicitorsJFLaw": 43
ROW_COUNT::"tbl_Option_RecordChased": 6
ROW_COUNT::"tbl_Option_VideoTypeID": 6
ROW_COUNT::"tbl_Option_FOARequiredID": 3
ROW_COUNT::"tbl_OptionExpertContractStatusID": 6
ROW_COUNT::"tbl_Option_ReportType": 5
ROW_COUNT::"tbl_Option_DBProgress": 5
ROW_COUNT::"tbl_Option_ClaimTypeID": 8
ROW_COUNT::"tbl_ExpertRecRequest": 0
ROW_COUNT::"tbl_Option_LOIReceived": 4
ROW_COUNT::"tbl_MediprosID": 0
ROW_COUNT::"tbl_Option_ClientStatusID": 23
ROW_COUNT::"tbl_Option_MandateReceived": 2
FINISHED

ERROR: Determine number of rows to copy: Error getting row count from source tables, wbcopytables exited with code 3221225477
Failed

  

How to repeat:
To repeat: I go through the whole migration process with all the default settings, just press next at each stage. Until I get to the Bulk Transfer stage
[29 Nov 2021 12:48] MySQL Verification Team
Hello Stephen Brown,

Thank you for the bug report.
Could you please provide sample database to reproduce this issue at our end?

Regards,
Ashwini Patil
[30 Dec 2021 1:00] Bugs System
No feedback was provided for this bug for over a month, so it is
being suspended automatically. If you are able to provide the
information that was originally requested, please do so and change
the status of the bug back to "Open".