Migration Timeout Error

Answered

Public

amarkus asked May 27, 2016

I have 13000+ products to transfer. I am using UB Data Migration Pro. After 10 minutes I got a timeout error.
Fatal Error: Maximum execution time of 600 seconds exceeded in /html/pub/ub-tool/vii/db/CDbCommand.php on line 335
What do I need to do to avoid any errors transferring our products.
I am also getting an error with customers that says
Mage2CustomerAddressEntityText: Value cannot be blank.
It says customers were migrated but they are not showing up in Magento 2

Thanks
Anthony

UB Data Migration Pro

22 answers

Vote Up

Vote Down

Mall ⋅ Staff ⋅184060.00 $tone May 27, 2016

Public

Hi amarkus,

Fatal Error: Maximum execution time of 600 seconds exceeded in /html/pub/ub-tool/vii/db/CDbCommand.php on line 335
What do I need to do to avoid any errors transferring our products.

To solve this issue, let’s re-setting to up the the max_execution_time value in your php.ini.
Example setting to unlimitted: max_execution_time = -1

It says customers were migrated but they are not showing up in Magento 2

After migrated successfully, you have to make re-index the data migrated in your Magento 2 and then you will see your Customers in back-end of your Magento 2.
Regards,
Mall.

Vote Up

Vote Down

amarkus ⋅270.00 $tone May 27, 2016

Public

Thanks.
Will try to migrate again.
Did reindex and customers are there.
Can I run migration again if customers or products are added on old site after I migrated? If yes, does it just add new info or does it rewrite everything?
Thanks
Anthony

Vote Up

Vote Down

Mall ⋅ Staff ⋅184060.00 $tone May 27, 2016

Public

Hi amarkus,

Can I run migration again if customers or products are added on old site after I migrated? If yes, does it just add new info or does it rewrite everything?

No, you have to migrate data from your Magento 1 to a fresh Magento 2.
Regards,
Mall.

Vote Up

Vote Down

amarkus ⋅270.00 $tone May 27, 2016

Public

So after I transfer data I need about 2 weeks to get new site up and running. My old site will still be running while we build this out. What is best method to transfer any new customers and sales from old site in that 2-week period.
Thanks
Anthony

Vote Up

Vote Down

Admin ⋅ Staff ⋅-30640.00 $tone May 30, 2016

Public

You can proceed migration as normal. Then after two weeks, you click ‘Reset’ and re-migrate the Customers and Sales accordingly. The ‘reset’ option is available as seen in this post (step 6 & step 7): https://www.ubertheme.com/magento-news/magento-2-data-migration-pro-release/
Regards,
An Nguyen

Vote Up

Vote Down

amarkus ⋅270.00 $tone May 30, 2016

Public

Thanks for answering my questions.

I am getting a CDbExecution error on ‘Update System Increment IDs (EAV Entity Store)’ in the last step. Everything else seemed to migrate correctly. I can send you a screen shot if you want to see but don’t know where to send it to.

Thanks
Anthony

Vote Up

Vote Down

Mall ⋅ Staff ⋅184060.00 $tone May 31, 2016

Public

Hi amarkus,
Did you try reset and re-start migrate data on last step?
Also, you can use this tool to capture and sharing your screenshots: https://addons.mozilla.org/en-US/firefox/addon/lightshot/
Regards,
Mall.

Vote Up

Vote Down

amarkus ⋅270.00 $tone May 31, 2016

Public

I did re-start and still error. Please see screenshots. Great screen shot sharing tool you recommended, thanks.
http://prntscr.com/bam6sw
http://prntscr.com/bam76e
Anthony

Vote Up

Vote Down

Mall ⋅ Staff ⋅184060.00 $tone June 1, 2016

Public

Hi amarkus,
You have to make reset that step before you re-start data migration.
Regards,
Mall.

Vote Up

Vote Down

amarkus ⋅270.00 $tone June 1, 2016

Public

I keep reseting and this is the error I get.
http://prntscr.com/baydxr
http://prntscr.com/baye65
Thanks
Anthony

#10

Vote Up

Vote Down

Mall ⋅ Staff ⋅184060.00 $tone June 2, 2016

Public

Hi amarkus,
I need a closer look to detect the root of issues as you said. Let’s provide me the site URL and SSH credentials of your Magento 2 and connect information of your Magento 1 database.
I will check further and help you get out.
Regards,
Mall.

#11

Vote Up

Vote Down

amarkus ⋅270.00 $tone June 2, 2016

Public

Just emailed you information.
Thanks
Anthony

#12

Vote Up

Vote Down

Admin ⋅ Staff ⋅-30640.00 $tone June 3, 2016

Public

Hi Anthony,
Our team is checking your site now. Meanwhile, please do not do any re-migration at your end to avoid possible conflict.
We will keep you updated on the status soon.
Regards,
An Nguyen

#13

Vote Up

Vote Down

amarkus ⋅270.00 $tone June 3, 2016

Public

Looks good. Your extension made migrated easy and painless, thanks. Now please just find a way to get the group pricing carried over and everything will be perfect.
Thanks
Anthony

#15

Vote Up

Vote Down

Mall ⋅ Staff ⋅184060.00 $tone June 6, 2016

Public

Now please just find a way to get the group pricing carried over and everything will be perfect.

Yes, we need more time to get a good solution for this case and will reply you soon.
Regards,
Mall.

#16

Vote Up

Vote Down

hvohra ⋅50.00 $tone July 9, 2016

Public

HI, I purchased the pro version but getting issue migrating the customers. I have over 10K customer and while it says the data has been migrated but I am getting the following error also. I did the change for max_execution_time = -1 in php but still same issue.

Mage2CustomerAddressEntityText: Value cannot be blank.

After migration if I try to reindex I get another error in magento2 logs. Please help

ndexer process unknown error:
SQLSTATE[42S22]: Column not found: 1054 Unknown column ‘e.lock_expires’ in ‘field list’, query was: SELECT e., e.entity_id, TRIM(CONCAT_WS(‘ ‘, IF(e.prefix <> ”, e.prefix, NULL), IF(e.firstname <> ”, e.firstname, NULL), IF(e.middlename <> ”, e.middlename, NULL),

#17

Vote Up

Vote Down

Mall ⋅ Staff ⋅184060.00 $tone July 11, 2016

Public

Hi hvohra,

Mage2CustomerAddressEntityText: Value cannot be blank.

That issue because the table ‘customer_address_entity_text’ in database of your Magento 1 have one item missing the value of value field and this field is required in Magento2.

SQLSTATE[42S22]: Column not found: 1054 Unknown column ‘e.lock_expires’ in ‘field list’, query was: SELECT e., e.entity_id, TRIM(CONCAT_WS(‘ ‘, IF(e.prefix <> ”, e.prefix, NULL), IF(e.firstname <> ”, e.firstname, NULL), IF(e.middlename <> ”, e.middlename, NULL),

Seem you are using Magento 2.1.0 and you have re-set the step 6 at least once?
Please follow the solution to solve that in reply #12 at here: https://www.ubertheme.com/question/404-page/
and then open the table named `customer_entity` in your Magento2’s database and add more some fields as bellow:

`failures_num` smallint(6) DEFAULT '0' COMMENT 'Failure Number',
`first_failure` timestamp NULL DEFAULT NULL COMMENT 'First Failure',
`lock_expires` timestamp NULL DEFAULT NULL COMMENT 'Lock Expiration Date',

and then, you can make re-index your data in Magento 2.
and contact me if you need further assistance!
Regards,
Mall.

#18

Vote Up

Vote Down

hvohra ⋅50.00 $tone July 14, 2016

Public

Mall,
You mentioned in your reply:

Please follow the solution to solve that in reply #12 at here: https://www.ubertheme.com/question/404-page/

I am not able to find this page.

#19

Vote Up

Vote Down

Mall ⋅ Staff ⋅184060.00 $tone July 14, 2016

Public

Hi hvohra,
You don’t need focus it now. Let’s download and install update the latest version of this tool v2.0.5 to solve issues as you post.
Regard,
Mall.

#20

Vote Up

Vote Down

hvohra ⋅50.00 $tone July 14, 2016

Public

HI,
This is really upsetting. I have upgraded to v2.0.5 and now my entire site is down. I am not able to get to my categories or products from either front-end or the back-end. It keeps on giving me the following error. This is really a crappy $400 tool that does not work. I have spend several days try to get my data migration from magento 1.7 and still so many issue. Let me know if you can help otherwise I would like a refund

1 exception(s):
Exception #0 (ReflectionException): Class Magento\Catalog\Model\Category\Attribute\Backend\
Sortby does not exist
Exception #0 (ReflectionException): Class Magento\Catalog\Model\Category\Attribute\Backend\
Sortby does not exist
#0 /var/www/devmagento2/magento2/vendor/magento/framework/Code/Reader/ClassReader.php(19): ReflectionClass->__construct(‘Magento\\Catalog…’)
#1 /var/www/devmagento2/magento2/vendor/magento/framework/ObjectManager/Definition/Runtime.php(44): Magento\Framework\Code\Reader\ClassReader->getConstructor(‘Magento\\Catalog…’)
#2 /var/www/devmagento2/magento2/vendor/magento/framework/ObjectManager/Factory/Dynamic/Developer.php(71): Magento\Framework\ObjectManager\Definition\Runtime->getParameters(‘Magento\\Catalog…’)
#3 /var/www/devmagento2/magento2/vendor/magento/framework/ObjectManager/ObjectManager.php(57): Magento\Framework\ObjectManager\Factory\Dynamic\Developer->create(‘Magento\\Catalog…’, Array)
#4 /var/www/devmagento2/magento2/vendor/magento/framework/Validator/UniversalFactory.php(36): Magento\Framework\ObjectManager\ObjectManager->create(‘Magento\\Catalog…’, Array)
#5 /var/www/devmagento2/magento2/vendor/magento/module-eav/Model/Entity/Attribute/AbstractAttribute.php(498): Magento\Framework\Validator\UniversalFactory->create(‘Magento\\Catalog…’)
#6 /var/www/devmagento2/magento2/var/generation/Magento/Catalog/Model/ResourceModel/Eav/Attribute/Interceptor.php(1103): Magento\Eav\Model\Entity\Attribute\AbstractAttribute->getBackend()
#7 /var/www/devmagento2/magento2/vendor/magento/module-eav/Model/ResourceModel/ReadHandler.php(139): Magento\Catalog\Model\ResourceModel\Eav\Attribute\Interceptor->getBackend()
#8 /var/www/devmagento2/magento2/vendor/magento/framework/EntityManager/Operation/Read/ReadAttributes.php(59): Magento\Eav\Model\ResourceModel\ReadHandler->execute(‘Magento\\Catalog…’, Array, Array)
#9 /var/www/devmagento2/magento2/vendor/magento/framework/EntityManager/Operation/Read.php(116): Magento\Framework\EntityManager\Operation\Read\ReadAttributes->execute(Object(Magento\Catalog\Model\Category\Interceptor), Array)
#10 /var/www/devmagento2/magento2/vendor/magento/framework/EntityManager/EntityManager.php(61): Magento\Framework\EntityManager\Operation\Read->execute(Object(Magento\Catalog\Model\Category\Interceptor), 3, Array)
#11 /var/www/devmagento2/magento2/vendor/magento/module-catalog/Model/ResourceModel/Category.php(996): Magento\Framework\EntityManager\EntityManager->load(Object(Magento\Catalog\Model\Category\Interceptor), 3)
#12 /var/www/devmagento2/magento2/var/generation/Magento/Catalog/Model/ResourceModel/Category/Interceptor.php(336): Magento\Catalog\Model\ResourceModel\Category->load(Object(Magento\Catalog\Model\Category\Interceptor), 3, NULL)
#13 /var/www/devmagento2/magento2/vendor/magento/framework/Model/AbstractModel.php(531): Magento\Catalog\Model\ResourceModel\Category\Interceptor->load(Object(Magento\Catalog\Model\Category\Interceptor), 3, NULL)
#14 /var/www/devmagento2/magento2/var/generation/Magento/Catalog/Model/Category/Interceptor.php(1480): Magento\Framework\Model\AbstractModel->load(3, NULL)
#15 /var/www/devmagento2/magento2/vendor/magento/module-catalog/Controller/Adminhtml/Category.php(40): Magento\Catalog\Model\Category\Interceptor->load(3)
#16 /var/www/devmagento2/magento2/vendor/magento/module-catalog/Controller/Adminhtml/Category/Edit.php(75): Magento\Catalog\Controller\Adminhtml\Category->_initCategory(true)
#17 /var/www/devmagento2/magento2/var/generation/Magento/Catalog/Controller/Adminhtml/Category/Edit/Interceptor.php(24): Magento\Catalog\Controller\Adminhtml\Category\Edit->execute()
#18 /var/www/devmagento2/magento2/vendor/magento/framework/App/Action/Action.php(102): Magento\Catalog\Controller\Adminhtml\Category\Edit\Interceptor->execute()
#19 /var/www/devmagento2/magento2/vendor/magento/module-backend/App/AbstractAction.php(226): Magento\Framework\App\Action\Action->dispatch(Object(Magento\Framework\App\Request\Http))
#20 /var/www/devmagento2/magento2/vendor/magento/framework/Interception/Interceptor.php(74): Magento\Backend\App\AbstractAction->dispatch(Object(Magento\Framework\App\Request\Http))
#21 /var/www/devmagento2/magento2/vendor/magento/framework/Interception/Chain/Chain.php(70): Magento\Catalog\Controller\Adminhtml\Category\Edit\Interceptor->___callParent(‘dispatch’, Array)
#22 /var/www/devmagento2/magento2/vendor/magento/framework/Interception/Chain/Chain.php(63): Magento\Framework\Interception\Chain\Chain->invokeNext(‘Magento\\Catalog…’, ‘dispatch’, Object(Magento\Catalog\Controller\Adminhtml\Category\Edit\Interceptor), Array, ‘adminAuthentica…’)
#23 /var/www/devmagento2/magento2/vendor/magento/module-backend/App/Action/Plugin/Authentication.php(143): Magento\Framework\Interception\Chain\Chain->Magento\Framework\Interception\Chain\{closure}(Object(Magento\Framework\App\Request\Http))
#24 /var/www/devmagento2/magento2/vendor/magento/framework/Interception/Chain/Chain.php(67): Magento\Backend\App\Action\Plugin\Authentication->aroundDispatch(Object(Magento\Catalog\Controller\Adminhtml\Category\Edit\Interceptor), Object(Closure), Object(Magento\Framework\App\Request\Http))
#25 /var/www/devmagento2/magento2/vendor/magento/framework/Interception/Interceptor.php(138): Magento\Framework\Interception\Chain\Chain->invokeNext(‘Magento\\Catalog…’, ‘dispatch’, Object(Magento\Catalog\Controller\Adminhtml\Category\Edit\Interceptor), Array, ‘adminMassaction…’)
#26 /var/www/devmagento2/magento2/vendor/magento/module-backend/App/Action/Plugin/MassactionKey.php(33): Magento\Catalog\Controller\Adminhtml\Category\Edit\Interceptor->Magento\Framework\Interception\{closure}(Object(Magento\Framework\App\Request\Http))
#27 /var/www/devmagento2/magento2/vendor/magento/framework/Interception/Interceptor.php(142): Magento\Backend\App\Action\Plugin\MassactionKey->aroundDispatch(Object(Magento\Catalog\Controller\Adminhtml\Category\Edit\Interceptor), Object(Closure), Object(Magento\Framework\App\Request\Http))
#28 /var/www/devmagento2/magento2/var/generation/Magento/Catalog/Controller/Adminhtml/Category/Edit/Interceptor.php(39): Magento\Catalog\Controller\Adminhtml\Category\Edit\Interceptor->___callPlugins(‘dispatch’, Array, Array)
#29 /var/www/devmagento2/magento2/vendor/magento/framework/App/FrontController.php(55): Magento\Catalog\Controller\Adminhtml\Category\Edit\Interceptor->dispatch(Object(Magento\Framework\App\Request\Http))
#30 /var/www/devmagento2/magento2/vendor/magento/framework/Interception/Interceptor.php(74): Magento\Framework\App\FrontController->dispatch(Object(Magento\Framework\App\Request\Http))
#31 /var/www/devmagento2/magento2/vendor/magento/framework/Interception/Chain/Chain.php(70): Magento\Framework\App\FrontController\Interceptor->___callParent(‘dispatch’, Array)
#32 /var/www/devmagento2/magento2/vendor/magento/framework/Interception/Interceptor.php(138): Magento\Framework\Interception\Chain\Chain->invokeNext(‘Magento\\Framewo…’, ‘dispatch’, Object(Magento\Framework\App\FrontController\Interceptor), Array, ‘install’)
#33 /var/www/devmagento2/magento2/vendor/magento/framework/Module/Plugin/DbStatusValidator.php(69): Magento\Framework\App\FrontController\Interceptor->Magento\Framework\Interception\{closure}(Object(Magento\Framework\App\Request\Http))
#34 /var/www/devmagento2/magento2/vendor/magento/framework/Interception/Interceptor.php(142): Magento\Framework\Module\Plugin\DbStatusValidator->aroundDispatch(Object(Magento\Framework\App\FrontController\Interceptor), Object(Closure), Object(Magento\Framework\App\Request\Http))
#35 /var/www/devmagento2/magento2/var/generation/Magento/Framework/App/FrontController/Interceptor.php(26): Magento\Framework\App\FrontController\Interceptor->___callPlugins(‘dispatch’, Array, Array)
#36 /var/www/devmagento2/magento2/vendor/magento/framework/App/Http.php(135): Magento\Framework\App\FrontController\Interceptor->dispatch(Object(Magento\Framework\App\Request\Http))
#37 /var/www/devmagento2/magento2/vendor/magento/framework/App/Bootstrap.php(258): Magento\Framework\App\Http->launch()
#38 /var/www/devmagento2/magento2/index.php(39): Magento\Framework\App\Bootstrap->run(Object(Magento\Framework\App\Http))
#39 {main}

#21

Vote Up

Vote Down

Mall ⋅ Staff ⋅184060.00 $tone July 15, 2016

Public

Hi hvohra,
From the error messages you mentioned, it appears that the issue does not relate to our migration tool. Seem there’s something wrong when you upgraded your system.
I need a closer look to detect the root of issue, please provide me admin and ssh credentials of your Magento 2 site.
I will check further and help you get out.
Regards,
Mall.

#22