Bug #93357 ERROR: Determine number of rows to copy: Error getting row count from source tab
Submitted: 27 Nov 2018 5:55 Modified: 27 Dec 2018 7:52
Reporter: Steele Dale Email Updates:
Status: No 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 2018 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 2018 7:52] MySQL Verification Team
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.
[28 Dec 2018 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".