Migration hangs on Customers after 10*100 Customer

Hi there,
My migration hangs after 10 batches of 100 customers imported successfully according to the Migration Log:
 
2017/07/19 14:49:01 -- Step #5 was finished.
2017/07/19 14:49:01 -- ——————--
2017/07/19 14:49:30 -- Start running step #6
2017/07/19 14:49:30 -- Migrated data in step #6 ok with 5 Customer Groups.
2017/07/19 14:49:30 -- Continue running step #6
2017/07/19 14:49:33 -- (Continued) migrated data in step #6 ok with 100 Customers.
2017/07/19 14:49:33 -- Continue running step #6
2017/07/19 14:49:35 -- (Continued) migrated data in step #6 ok with 100 Customers.
2017/07/19 14:49:35 -- Continue running step #6
2017/07/19 14:49:38 -- (Continued) migrated data in step #6 ok with 100 Customers.
2017/07/19 14:49:38 -- Continue running step #6
2017/07/19 14:49:40 -- (Continued) migrated data in step #6 ok with 100 Customers.
2017/07/19 14:49:40 -- Continue running step #6
2017/07/19 14:49:42 -- (Continued) migrated data in step #6 ok with 100 Customers.
2017/07/19 14:49:42 -- Continue running step #6
2017/07/19 14:49:45 -- (Continued) migrated data in step #6 ok with 100 Customers.
2017/07/19 14:49:45 -- Continue running step #6
2017/07/19 14:49:47 -- (Continued) migrated data in step #6 ok with 100 Customers.
2017/07/19 14:49:47 -- Continue running step #6
2017/07/19 14:49:49 -- (Continued) migrated data in step #6 ok with 100 Customers.
2017/07/19 14:49:50 -- Continue running step #6
2017/07/19 14:49:52 -- (Continued) migrated data in step #6 ok with 100 Customers.
2017/07/19 14:49:52 -- Continue running step #6
2017/07/19 14:49:56 -- (Continued) migrated data in step #6 ok with 100 Customers.
2017/07/19 14:49:56 -- Continue running step #6
2017/07/20 08:30:31 -- Start resetting data migration in step #6…
 
Note that the reset at bottom is following morning. I tried again but it hangs at the exact same place.
 
What steps do I need to take to identify the problem and proceed?
 
Thanks
Matt

  1. Profile photo of floorsavefloorsave 150.00 $tone July 20, 2017
    Hi there,Thanks, found some NULL in store_idNow looking for similar problems in sales importWill get back if further issuesThanksMatt
  2. Profile photo of floorsavefloorsave 150.00 $tone July 20, 2017
    Hell Again,So it appears to have imported all sales orders but doesn't say finished but still says processingLast couple of lines of migration log:2017/07/20 09:53:03 - (Continued) migrated data in step #7 ok with 100 Sales Orders.2017/07/20 09:53:03 - Continue running step #72017/07/20 09:53:29 - (Continued) migrated data in step #7 ok with 63 Sales Orders.Then the steps says13 Sales Orders 6863And in my databaseSELECT count(*) FROM sales_flat_orderreturns 6863Any clues as to how to think it's finished?ThanksMatt
  3. Profile photo of floorsavefloorsave 150.00 $tone July 20, 2017
    oh,and although I've uncommented out the lines for debugging, I'm not actually seeing any errors.The last line in migration log simply says:2017/07/20 09:53:29 - (Continued) migrated data in step #7 ok with 63 Sales Orders.

4 answers

Profile photo of Mall Staff 184060.00 $tone July 20, 2017
Public

Hi there,

What steps do I need to take to identify the problem and proceed?

It seem your database has some records with bad data in the customers data section. Kindly enable the debug mode of our tool by steps as indicated in the Readme.html (included file in your downloaded package)
Once done, let’s rerun the data migration in the step #6 and provide me the details of errors message you got. I will check further and help you out.
Regards,
Mall.

#1
Profile photo of Mall Staff 184060.00 $tone July 20, 2017
Public

Hi there,

oh,and although I’ve uncommented out the lines for debugging, I’m not actually seeing any errors.The last line in migration log simply says:2017/07/20 09:53:29 -- (Continued) migrated data in step #7 ok with 63 Sales Orders.

So, let’s continue with data migration in the step #6 with cli command:
php -f bin/ubdatamigration run --step=6
And tell me know how it goes.
Regards,
Mall.

#2

This question is now closed

Written By

Comments