Bug #93357 ERROR: Determine number of rows to copy: Error getting row count from source tab
Submitted: 27 Nov 5:55 Modified: 27 Nov 7:52
Reporter: Steele Dale Email Updates:
Status: Need Feedback Impact on me:
None 
Category:MySQL Workbench: Migration Severity:S2 (Serious)
Version:8.0.13 OS:Ubuntu (18.04)
Assigned to: CPU Architecture:Any

[27 Nov 5:55] Steele Dale
Description:
Attempting to migrate tables from MS SQL Server to MySQL using the MySQL Workbench Migration Tool on Windows 10 workstation supplies the following error message upon Bulk Data Transfer. I have noted issue occuring with prior versions of Workbench.

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=SQL Server;DATABASE=;UID=INTOV8\steele.dale" --source-rdbms-type=Mssql --source-timeout= --target-timeout=None --table-file=c:\users\steele~1.dal\appdata\local\temp\tmpfuk0je
--table [Corvus]	[ampla].[classifications]
15:44:48 [INF][      copytable]: --table [DB_Name]	[Table_Name]
15:44:48 [INF][      copytable]: --table [DB_Name]	[Table_Name]
15:44:48 [INF][      copytable]: --table [DB_Name]	[Table_Name]
15:44:48 [INF][      copytable]: --table [DB_Name]	[Table_Name]
15:44:48 [INF][      copytable]: --table [DB_Name]	[Table_Name]
15:44:48 [INF][      copytable]: --table [DB_Name]	[Table_Name]
15:44:48 [INF][      copytable]: --table [DB_Name]	[Table_Name]
15:44:48 [INF][      copytable]: Opening ODBC connection to [Mssql] 'DSN=SQL Server;DATABASE=;UID=[User_Name];PWD=XXX'
15:44:49 [INF][      copytable]: ODBC connection to 'DSN=SQL Server;DATABASE=;UID=[User_Name];PWD=' opened
15:44:53 [ERR][      copytable]: Exception: SQLExecDirect(SELECT count_big(*) FROM [DB_NAME].[Table_Name]): 42000:1924:[Microsoft][ODBC SQL Server Driver][SQL Server]Database 'DB_Name' is already open and can only have one user at a time.

Loading table information from file c:\users\[User_Name]\appdata\local\temp\tmpfuk0je

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

Resuming...
Failed

Resuming...
Failed

How to repeat:
I have repeated this no matter how many tables are selected to migrate.
[27 Nov 7:52] Miguel Solorzano
Thank you for the bug report. Are you able to attach a ziped database file with minimal table and data but enough to repeat the issue so we could attach it? (use Files tab private if you wish). Thanks.