Migration Timeout Error

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
 
 

22 answers

Profile photo of 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.

#1
Profile photo of 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

#2
Profile photo of 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.

#3
Profile photo of 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

#4
Profile photo of Admin Staff -30590.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

#5
Profile photo of 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

#6
Profile photo of 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.

#7
Profile photo of 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
Profile photo of Admin Staff -30590.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
Profile photo of 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
Profile photo of Mall Staff 184060.00 $tone June 6, 2016
Public

Hi 

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
Profile photo of 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
Profile photo of 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
Profile photo of 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
Profile photo of 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
Profile photo of 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
Profile photo of 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

Please login or Register to Submit Answer

Written By

Comments