MySQL Bugs: #103835: Determine number of rows to copy: Error getting row count from source tables, wb

Bug #103835	Determine number of rows to copy: Error getting row count from source tables, wb
Submitted:	28 May 2021 3:17	Modified:	28 May 2021 21:27
Reporter:	Jesse Lay	Email Updates:
Status:	Can't repeat	Impact on me:	None
Category:	MySQL Workbench: Migration	Severity:	S3 (Non-critical)
Version:	8	OS:	Windows
Assigned to:		CPU Architecture:	x86

Description:
While trying to transfer data I get a error connecting to the database. All connection up until this point work. I have tried to clear the the vault so it will prompt me fore the password, but it will not. I've tried 
Using DSN to MS SQL and left out the password. ODBC (native) and left out the password. No matter what it fails at this step

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=local;DATABASE=;UID=sa" --source-rdbms-type=Mssql --source-timeout= --target-timeout=None --table-file=C:\Users\Jesse\AppData\Local\Temp\tmp_9mxba9v
--table [Seismos]	[dbo].[WellBore]
22:09:53 [INF][      copytable]: --table [Seismos]	[dbo].[StageTracking]
22:09:53 [INF][      copytable]: --table [Seismos]	[dbo].[SeismosisKeyLookupDefaultValue]
22:09:53 [INF][      copytable]: --table [Seismos]	[dbo].[WellVolume]
22:09:53 [INF][      copytable]: --table [Seismos]	[dbo].[Clusters]
22:09:53 [INF][      copytable]: --table [Seismos]	[dbo].[WellBoreCylinder]
22:09:53 [INF][      copytable]: --table [Seismos]	[dbo].[ActiveData]
22:09:53 [INF][      copytable]: --table [Seismos]	[dbo].[PulseParams]
22:09:53 [INF][      copytable]: --table [Seismos]	[dbo].[PulsePeriod]
22:09:53 [INF][      copytable]: --table [Seismos]	[dbo].[Plug]
22:09:53 [INF][      copytable]: --table [Seismos]	[dbo].[PumpSchedule]
22:09:53 [INF][      copytable]: --table [Seismos]	[dbo].[Perforation]
22:09:53 [INF][      copytable]: --table [Seismos]	[dbo].[CylinderVolume]
22:09:53 [INF][      copytable]: --table [Seismos]	[dbo].[PumpScheduleStep]
22:09:53 [INF][      copytable]: --table [Seismos]	[dbo].[Fluid]
22:09:53 [INF][      copytable]: --table [Seismos]	[dbo].[Proppant]
22:09:53 [INF][      copytable]: --table [Seismos]	[dbo].[FarFieldCalculation]
22:09:53 [INF][      copytable]: --table [Seismos]	[dbo].[FarFieldParameter]
22:09:53 [INF][      copytable]: --table [Seismos]	[dbo].[FarFieldConfiguration]
22:09:53 [INF][      copytable]: --table [Seismos]	[dbo].[GraphPartitionType]
22:09:53 [INF][      copytable]: --table [Seismos]	[dbo].[GraphPartition]
22:09:53 [INF][      copytable]: --table [Seismos]	[dbo].[NFinvResult]
22:09:53 [INF][      copytable]: --table [Seismos]	[dbo].[NFinvResultPlot]
22:09:53 [INF][      copytable]: --table [Seismos]	[dbo].[PreviousConfigurations]
22:09:53 [INF][      copytable]: --table [Seismos]	[dbo].[ProppantLookup]
22:09:53 [INF][      copytable]: --table [Seismos]	[dbo].[Pad]
22:09:53 [INF][      copytable]: --table [Seismos]	[dbo].[DaqSensorGroup]
22:09:53 [INF][      copytable]: --table [Seismos]	[dbo].[WellPadRelation]
22:09:53 [INF][      copytable]: --table [Seismos]	[dbo].[DaqDataSample]
22:09:53 [INF][      copytable]: --table [Seismos]	[dbo].[CasingChartLookup]
22:09:53 [INF][      copytable]: --table [Seismos]	[dbo].[FfParameterSet]
22:09:53 [INF][      copytable]: --table [Seismos]	[dbo].[SeismosClient]
22:09:53 [INF][      copytable]: --table [Seismos]	[dbo].[NfParameterSet]
22:09:53 [INF][      copytable]: --table [Seismos]	[dbo].[FluidLookup]
22:09:53 [INF][      copytable]: --table [Seismos]	[dbo].[NfProcessingResult]
22:09:53 [INF][      copytable]: --table [Seismos]	[dbo].[AppLauncher]
22:09:53 [INF][      copytable]: --table [Seismos]	[dbo].[SavedState]
22:09:53 [INF][      copytable]: --table [Seismos]	[dbo].[FfProcessingResult]
22:09:53 [INF][      copytable]: --table [Seismos]	[dbo].[Validation]
22:09:53 [INF][      copytable]: --table [Seismos]	[dbo].[ValidationRange]
22:09:53 [INF][      copytable]: --table [Seismos]	[dbo].[ModelDataSample]
22:09:53 [INF][      copytable]: --table [Seismos]	[dbo].[SeismosisKeyValue]
22:09:53 [INF][      copytable]: --table [Seismos]	[dbo].[NoteRefType]
22:09:53 [INF][      copytable]: --table [Seismos]	[dbo].[NoteEvent]
22:09:53 [INF][      copytable]: --table [Seismos]	[dbo].[DaqSite]
22:09:53 [INF][      copytable]: --table [Seismos]	[dbo].[SeismosNote]
22:09:53 [INF][      copytable]: --table [Seismos]	[dbo].[MeasureUnit]
22:09:53 [INF][      copytable]: --table [Seismos]	[dbo].[DaqSensorChannel]
22:09:53 [INF][      copytable]: --table [Seismos]	[dbo].[SeismosProject]
22:09:53 [INF][      copytable]: --table [Seismos]	[dbo].[Well]
22:09:53 [INF][      copytable]: --table [Seismos]	[dbo].[MapWellSensor]
22:09:53 [INF][      copytable]: --table [Seismos]	[dbo].[OffsetShot]
22:09:53 [INF][      copytable]: --table [Seismos]	[dbo].[WellTracking]
22:09:53 [INF][      copytable]: --table [Seismos]	[dbo].[Stage]
22:09:53 [INF][      copytable]: --table [Seismos]	[dbo].[StageStatus]
22:09:53 [INF][      copytable]: --table [Seismos]	[dbo].[StageEventLookup]
22:09:53 [INF][      copytable]: --table [Seismos]	[dbo].[StageResultLookup]
22:09:53 [INF][      copytable]: --table [Seismos]	[dbo].[SeismosisKeyLookup]
22:09:53 [INF][      copytable]: Opening ODBC connection to [Mssql] 'DSN=local;DATABASE=;UID=sa;PWD=XXX'
22:10:02 [ERR][      copytable]: ODBC connection to 'DSN=local;DATABASE=;UID=sa;PWD=' failed
22:10:02 [ERR][      copytable]: Exception: SQLDriverConnect: IM008:10:[Microsoft][ODBC SQL Server Driver]Dialog failed

Loading table information from file C:\Users\Jesse\AppData\Local\Temp\tmp_9mxba9v

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

How to repeat:
Input connection info in the migration tool. Bulk transfer fails with 
ODBC connection to 'DSN=local;DATABASE=;UID=sa;PWD=' failed

Suggested fix:
prompt for password on this setp

Thank you for the bug report. Your ODBC connection to 'DSN=local;DATABASE=;UID=sa;PWD=' failed - is wrong using local instead of localhost.

Can you please elaborate further. that is the the name of the preconfigure DSN I have setup.

DSN

Attachment: Screenshot_1.png (image/png, text), 10.30 KiB.

WorkBench 8.0.25 connected MSSQL Server with ODBC native

Attachment: bug103835.png (image/png, text), 128.51 KiB.

Same issue here. I have everything great in MSSQL. I have been trying to troubleshoot this all day and relying on ChatGPT to give me tips. The migration wizard looks like it "wants" to work. It just keeps complaining about trying to find triggers. I even tried creating a "dummy" trigger in SQL server just to see if that could get the migration wizard to stop complaining about not finding triggers. '
ERROR: Determine number of rows to copy: Error getting row count from source tables, wbcopytables exited with code 1
Failed' 
It would be wonderful if someone who knows what they are doing could trace this error and why in migration from MSSQL to MySQL - this error is prevalent?