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:Microsoft Windows (Windows 7)
Assigned to: CPU Architecture:Any
Tags: Data Migration, Microsoft SQL Server 2012, ms sql, MySQL, MySQL Version 5.6.14.

[4 Aug 2015 13:37] Patrick Onokwai
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
[2 Sep 2015 9:46] Milosz Bodzek
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.
[13 Nov 2015 1:51] Miguel Solorzano
Thank you for the feedback and test script. Verified with 6.3.5 version.
[4 May 2016 7:32] Robert Malinowski
Hi, same problem with my migration. are there any tips for solving?
[30 Dec 2016 1:28] Juan Tellez
Hi, have you ever find solution to this?
[16 Apr 2018 22:36] Christine Cole
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.
[29 Oct 17:02] Marko Zoranovich
same problem at the latest version 8.0.18
ERROR: Determine number of rows to copy: too many values to unpack