MySQL Bugs: #105722: MS Access DB Migration fails with Record Count

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:	Windows
Assigned to:	MySQL Verification Team	CPU Architecture:	Any
Tags:	accdb, access, MDB, migration, reverse engineering

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

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

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".

Greetings

I am experiencing this same problem trying to import  access tables using  workbench  migration. I am using 8.0.28.It all works fine until  the  row  count step. It says it  is FINISHED but then takes this error: 
ERROR: Determine number of rows to copy: Error getting row count from source tables, wbcopytables exited with code 3221225477
Failed.

I am unble to resolve this. I would appreciate some  help. thanks

Kodi database for testing when importing

Attachment: MyVideos116.db (application/octet-stream, text), 540.00 KiB.

Same problem here. wbcopytables.exe counts all tables, but exits with same code.

Same issue with me, if any one got the solution

ERROR: Copy helper exited with an error: Worker exited with status 3221225477

Data copy results:
- `DrugsView`.`RxDrugs1` has FAILED (0 of 60000 rows copied)
- `DrugsView`.`RxDrugs2` has FAILED (0 of 60000 rows copied)
- `DrugsView`.`RxDrugs3` has FAILED (0 of 60000 rows copied)
- `DrugsView`.`RxDrugs4` has FAILED (0 of 40000 rows copied)
- `DrugsView`.`RxDrugs5` has FAILED (0 of 26902 rows copied)
- `DrugsView`.`NonRxDrugs1` has FAILED (0 of 60000 rows copied)
- `DrugsView`.`NonRxDrugs2` has FAILED (0 of 60000 rows copied)
- `DrugsView`.`NonRxDrugs3` has FAILED (0 of 22731 rows copied)
- `DrugsView`.`sysdiagrams` has FAILED (0 of 0 rows copied)
0 tables of 9 were fully copied
Click [Retry] to retry copying remaining data from tables
Copy data to target RDBMS finished
Tasks finished with warnings and/or errors; view the logs for details
Finished performing tasks.