Step 7 SalesOrderAggregatedCreated issue

Hello Team
On step 7 order migration is completed but after that SalesOrderAggregatedCreated items migration is started and its taking too much time as in 20 hours only 300 items SalesOrderAggregatedCreated happened. 
Please check this screen : https://prnt.sc/rnriv4
Can you please check this and let me know as we have huge amount of data.
Please help us as soon as possible. 
Thanks

9 answers

Profile photo of Mall Staff 184060.00 $tone March 28, 2020
Public

Hi there,

Please check this screen : https://prnt.sc/rnriv4

Please continue with the data migration in step #7 by running the CLI command:
php -f bin/ubdatamigration run --step=7

And let me know the details of error message if you see. I will help to check further and get back to you then.
 
Regards,
Mall.

#1
Profile photo of rufflebutts 1660.00 $tone March 28, 2020
Public

Hello Team, 

Its already processing from 2 days but still only 1000 SalesOrderAggregatedCreated items are performed. 

I just want to know that is it take time  ? or any trick to process this faster?  

#2
Profile photo of Mall Staff 184060.00 $tone March 30, 2020
Public

Hi there,
I am sorry for replying to you this late as we’ve just been back from our weekend. 

Its already processing from 2 days but still only 1000 SalesOrderAggregatedCreated items are performed. 

It seems that your M1 database has a big volume of data records in the  ‘sales_order_aggregated_created’ table. 

Please run the following SQL query in your M1 database, and let me know the screenshot of result that you see:

Select count(*) From sales_order_aggregated_created;

Besides, there might be some bad data records in that table. Did you see any error message in the log file of our module at pub/ub-tool/protected/runtime/ub_data_migration.log? 

For your information, all data in the tables which have the prefix “sales_order_aggregated…” is used for the sales report function in M2. If this data section is not important with your case,  you shouldn’t select that data objects to migrate in the setting of step #7 of our module (https://prnt.sc/rp4fus) to speed up the migration time. 

Regards,
Mall.

#3
Profile photo of rufflebutts 1660.00 $tone March 30, 2020
Public

Hello Team, 
There are two tables with prefix sales_order_aggregated 1. sales_order_aggregated_created and sales_order_aggregated_updated .

I have 26211 records in sales_order_aggregated_created table and 26809 records in sales_order_aggregated_updated table

#4
Profile photo of Mall Staff 184060.00 $tone March 30, 2020
Public

Hi there,

So the issue you mentioned is strange:

Its already processing from 2 days but still only 1000 SalesOrderAggregatedCreated items are performed. 

It seems that there are some issues with the bad data cases when migrating data from these tables:
sales_order_aggregated_created, sales_order_aggregated_updated
 
Did you see any error message in the log file of our module?
(you can check the log file at: pub/ub-tool/protected/runtime/ub_data_migration.log)

If you need further help, please provide me information of your instance:

  • Admin credentials of your M2 instance
  • SSH credentials of your M2 instance
  • Let me know the path to your M2 folder

I will help to check further and get back to you then.
PS. Please make sure you mark your reply private, or simply switch this ticket to the private mode, then it’s safe to share your site info here. Only you and our technical team can access it. 
Regards,
Mall.
 
 

#5
Profile photo of Mall Staff 184060.00 $tone March 30, 2020
Public

Hi there,

I did check log file but there is no error and i am working on local so cant share info. 

So, can you reset the step #7 and then uncheck the ‘SalesAggregated Data’ setting in step #7 of our module (https://prnt.sc/rp4fus)?  

Regards,
Mall.
 

#7
Profile photo of ubdev Staff 98150.00 $tone April 3, 2020
Public

Hi there, 
Please consider moving your instance to a staging server where we can provide you better help. We provide support via our helpdesk only though. 
Thanks for your understanding. 
Regards,
Ubertheme team

#9

Please login or Register to Submit Answer

Written By

Comments