How do i fix this error with migrating database

As said in the title im having some issues regarding the UB data migration lite. I am in the process of migrating a magento 1.9 database to magento 2 but when i reach the Migrate Attributes step i cannot get any further, this is because every time i press one of the buttons it gives me a error. At the end of this question ill post some pictures regarding the error screens so that maybe someone can help me figure out how to resolve this issue.
Thank you in advance.
Error Picture 1: http://prntscr.com/cklqwb
Error Picture 2: http://prntscr.com/cklra1
Error Picture 3: http://prntscr.com/cklrjm
 
There are a few more of those tabs but the amount of them would be a lot so if u need them let me know i can make more pictures if needed.
 
With kind regards,
 
Marco van Stiphout

13 answers

Profile photo of Marco van Stiphout 110.00 $tone September 22, 2016
Public

Hi mall, i watched a tutorial on youtube regarding the use of this tool. in this process i made sure my magento 2 installation was completely fresh with no data or anything, when i reached the point i described in my question it kept giving me the errors on the pictures. i hope u can help me figure this out because the sheer amount of products is way too much for me to just manually type in again.

#2
Profile photo of Admin Staff -30640.00 $tone September 23, 2016
Public

Hi Marco, 
It’s pity that our Lite version is available for Magento 2.0.7 only. Due to the time constraint, only UB Data Migration Pro is fully compatible with Magento 2.1.1. 
Thanks for your understanding. 
Regards,
An Nguyen

#5
Profile photo of Marco van Stiphout 110.00 $tone September 23, 2016
Public

Hi An Nguyen,
Thanks for the reply. Its a shame that i cannot use the lite version for 2.0.7.
So now im wondering if u could awnser a quick other question regarding this, i started making a theme on magento 2.1.1, do you think if i were to insert it into 2.0.7 that it would still look the same? if so i could just downgrade the magento version a bit.
I hope to hear from you soon.
Regards,
Marco van Stiphout

#6
Profile photo of Admin Staff -30640.00 $tone September 23, 2016
Public

Hi Marco, 
For the Lite version, you should make a test on a fresh Magento 2.0.7 instance to learn more if our tool can help. 
Our UB Data Migration tool (both Lite & Pro version) requires migration to be proceeded on a fresh Magento 2 instance to ensure the data integrity. Further, for any migration projects, it would be best to start the data migration task first. Once done, the extensions, theme integration or customization should follow then. This will help you have safe database in place in Magento 2.   
PS. Please note our migration tool is available for Magento CE only. 
Thanks, 
An Nguyen

#7
Profile photo of Marco van Stiphout 110.00 $tone September 26, 2016
Public

Hello An Nguyen,
Thank you for your response. As u said i installed a fresh version of magento 2.0.7 and tried again. I did nothing but install the magento version and add the ub data migration tool but when i used it this time, at the same step it gave me a bit of a different error(http://prntscr.com/cmgqln). i hope this one can be fixed cause the amount of data i need to migrate is way too much to migrate by hand.
I hope to hear from u soon.
With kind regards,
Marco van Stiphout

#8
Profile photo of Admin Staff -30640.00 $tone September 26, 2016
Public

Hi Marco, 
The screenshot you provides shows a strange issue that MySQL does not return the primary key automatically. May I know your MySQL version and Magento 1 version?
Could you try to test again on your old MySQL server that you did proceed in your first question?
Meanwhile, please take a look at this case as well -- https://www.ubertheme.com/question/magento2-upgradation/
If it still does not help, please do let us know.
Regards,
An Nguyen

#9
Profile photo of Admin Staff -30640.00 $tone September 26, 2016
Public

Hi Marco, 
We need to have a closer look into your case. Please help to provide via private message here or email info (at) ubertheme.com your SSH credentials and full access to both M1 and M2 database so that we could debug further. 
Regards,
An Nguyen

#11
Profile photo of Marco van Stiphout 110.00 $tone September 26, 2016
Public

Hi An Nguyen,
Currently i have my databases running on a local server using xampp. This is because i am working for my internship so i am not allowed to access the live database to prevent me making problems. My task is to make a updated version of their magento webshop and when i tried migrating it i ran into all the named issues. If its really gonna be hard getting the data converted using your tool i might have to look into a different option because i cant spend too much time on this.
Thank you for all the help and i hope u might still have a idea on what i could do.
With kind regards,
Marco van Stiphout

#12
Profile photo of Admin Staff -30640.00 $tone September 27, 2016
Public

Hi Marco,
It’s hard to provide you help when you set up in your localhost. Please consider to bring your site live where we can debug and help you out. 
Regards,
An Nguyen

#13

Please login or Register to Submit Answer

Written By

Comments