MySQL Bugs: #77933: Determine number of rows to copy: too many values to unpack Failed

Bug #77933	Determine number of rows to copy: too many values to unpack Failed
Submitted:	4 Aug 2015 13:37	Modified:	16 Apr 2018 22:36
Reporter:	Patrick Onokwai	Email Updates:
Status:	Closed	Impact on me:	None
Category:	MySQL Workbench: Migration	Severity:	S1 (Critical)
Version:	6.3.4.0/6.3.5	OS:	Windows (Windows 7)
Assigned to:		CPU Architecture:	Any
Tags:	Data Migration, Microsoft SQL Server 2012, ms sql, MySQL, MySQL Version 5.6.14.

Description:
Hi there 
I do need urgent help resolving a MS SQL to MySQL data migration error "ERROR: Determine number of rows to copy: too many values to unpack
Failed".

I am attempting to migrate data from Microsoft SQL Server 2012 (Server Name: (localdb)\v11.0) to MySQL Version 5.6.14 (User: root@localhost). Every step went well until I got to "DATA MIGRATION > Bulk Data Transfer" and I got the error message log: 

ERROR MESSAGE LOG
"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="DRIVER={SQL Server Native Client 11.0};SERVER=(localdb)\v11.0;DATABASE={};UID=" --table-file=c:\users\rickwa~1\appdata\local\temp\tmpw6iis9
14:33:00 [INF][      copytable]: --table [C:\WEBSITEPROJECTS\ASPNETWEBPROJECTS\PROJECTKARL\APP_DATA\CARSALES.MDF]	[dbo].[EngineSize]
14:33:00 [INF][      copytable]: --table [C:\WEBSITEPROJECTS\ASPNETWEBPROJECTS\PROJECTKARL\APP_DATA\CARSALES.MDF]	[dbo].[Roles]
14:33:00 [INF][      copytable]: --table [C:\WEBSITEPROJECTS\ASPNETWEBPROJECTS\PROJECTKARL\APP_DATA\CARSALES.MDF]	[dbo].[Transmission]
14:33:00 [INF][      copytable]: --table [C:\WEBSITEPROJECTS\ASPNETWEBPROJECTS\PROJECTKARL\APP_DATA\CARSALES.MDF]	[dbo].[Memberships]
14:33:00 [INF][      copytable]: --table [C:\WEBSITEPROJECTS\ASPNETWEBPROJECTS\PROJECTKARL\APP_DATA\CARSALES.MDF]	[dbo].[UsersInRoles]
14:33:00 [INF][      copytable]: --table [C:\WEBSITEPROJECTS\ASPNETWEBPROJECTS\PROJECTKARL\APP_DATA\CARSALES.MDF]	[dbo].[CarType]
14:33:00 [INF][      copytable]: --table [C:\WEBSITEPROJECTS\ASPNETWEBPROJECTS\PROJECTKARL\APP_DATA\CARSALES.MDF]	[dbo].[CarMake]
14:33:00 [INF][      copytable]: --table [C:\WEBSITEPROJECTS\ASPNETWEBPROJECTS\PROJECTKARL\APP_DATA\CARSALES.MDF]	[dbo].[Main]
14:33:00 [INF][      copytable]: --table [C:\WEBSITEPROJECTS\ASPNETWEBPROJECTS\PROJECTKARL\APP_DATA\CARSALES.MDF]	[dbo].[BodyType]
14:33:00 [INF][      copytable]: --table [C:\WEBSITEPROJECTS\ASPNETWEBPROJECTS\PROJECTKARL\APP_DATA\CARSALES.MDF]	[dbo].[Applications]
14:33:00 [INF][      copytable]: --table [C:\WEBSITEPROJECTS\ASPNETWEBPROJECTS\PROJECTKARL\APP_DATA\CARSALES.MDF]	[dbo].[Model]
14:33:00 [INF][      copytable]: --table [C:\WEBSITEPROJECTS\ASPNETWEBPROJECTS\PROJECTKARL\APP_DATA\CARSALES.MDF]	[dbo].[NoOfDoors]
14:33:00 [INF][      copytable]: --table [C:\WEBSITEPROJECTS\ASPNETWEBPROJECTS\PROJECTKARL\APP_DATA\CARSALES.MDF]	[dbo].[FuelType]
14:33:00 [INF][      copytable]: --table [C:\WEBSITEPROJECTS\ASPNETWEBPROJECTS\PROJECTKARL\APP_DATA\CARSALES.MDF]	[dbo].[Profiles]
14:33:00 [INF][      copytable]: --table [C:\WEBSITEPROJECTS\ASPNETWEBPROJECTS\PROJECTKARL\APP_DATA\CARSALES.MDF]	[dbo].[sysdiagrams]
14:33:00 [INF][      copytable]: --table [C:\WEBSITEPROJECTS\ASPNETWEBPROJECTS\PROJECTKARL\APP_DATA\CARSALES.MDF]	[dbo].[Users]
14:33:00 [INF][      copytable]: --table [C:\WEBSITEPROJECTS\ASPNETWEBPROJECTS\PROJECTKARL\APP_DATA\CARSALES.MDF]	[dbo].[Picture]
14:33:00 [INF][      copytable]: Opening ODBC connection to [unknown] 'DRIVER={SQL Server Native Client 11.0};SERVER=(localdb)\v11.0;DATABASE={};UID=;PWD=XXX'
14:33:00 [INF][      copytable]: ODBC connection to 'DRIVER={SQL Server Native Client 11.0};SERVER=(localdb)\v11.0;DATABASE={};UID=;PWD=' opened

ERROR: Determine number of rows to copy: too many values to unpack
Failed"

MySQL has the database and tables created but the rows are empty.
Note: both MS SQL and MySQL runs on development (localhost) servers)
I upgraded MySQL Workbench from 6.0 to 6.3 (the current version) but it still didn't resolve the problem

How to repeat:
Just follow the migration wizard steps 

Suggested fix:
I upgraded MySQL Workbench from 6.0 to 6.3 (the current version) but it still didnt resolve the problem
I have no idea how to fix

Hi Patrick Onokwai!
Thank you for your bug report. Can you attach your db to this report? You can make it private so noone will see it (except Oracle employees). That will help us reproduce issue and fix it.

Thank you for the feedback and test script. Verified with 6.3.5 version.

Hi, same problem with my migration. are there any tips for solving?

Hi, have you ever find solution to this?

Posted by developer:
 
Fixed as of the upcoming MySQL Workbench 8.0.11 release, and here's the changelog entry:

Table rows were not generated properly when a valid Microsoft SQL Server table was
migrated using the MySQL Migration wizard.

Thank you for the bug report.

same problem at the latest version 8.0.18
ERROR: Determine number of rows to copy: too many values to unpack