Error Mage2SalesOrder on step 7

Hi there,
My data migration from 1.7.x  is chrashing on step 7 constantly, I’ve already reseted and tried to check different options in step 7 settings but it keeps saying:
2018/07/24 14:31:52 [error] [ub_data_migration] Mage2SalesOrder: Updated At cannot be blank.
Mage2SalesOrder: Updated At cannot be blank.
Mage2SalesOrder: Updated At cannot be blank.
Mage2SalesOrder: Updated At cannot be blank.
Mage2SalesOrder: Updated At cannot be blank.
Mage2SalesOrder: Updated At cannot be blank.
thanks in advance for your help
Regards
Lathion J.B 

4 answers

Profile photo of Mall Staff 184060.00 $tone July 25, 2018
Public

Hi Lathion J.B,

Mage2SalesShipmentGrid: Order Increment Id cannot be blank.

That is another bad data issue with some records in the table ‘sales_flat_shipment_grid’. Some records had missing required values on the filed named ‘order_increment_id’.
Thus, in order to continue data migration in the step #7, you should delete these records in the table ‘sales_flat_shipment_grid’ by running the below SQL statement:

Delete From sales_flat_shipment_grid Where order_increment_id IS NULL or order_increment_id = '';

Alternatively, if you want to keep these records in the table ‘sales_flat_shipment_grid’, you can try with these steps:

+ Open the php file at: pub/ub-tool/protected/controllers/Step7Controller.php
and find the line:

if (empty(trim($model2->customer_name))) {
$model2->customer_name = 'Unknown';
}

and replace it with:

if (empty(trim($model2->customer_name))) {
$model2->customer_name = 'Unknown';
}
if (empty(trim($model2->order_increment_id))) {
$model2->order_increment_id = 'Unknown';
}

+ Once done, you can continue with data migration in the step #7 of our tool.
Regards,
Mall.
 

#
Profile photo of Mall Staff 184060.00 $tone July 24, 2018
Public

Hi there,

Mage2SalesOrder: Updated At cannot be blank.

That issue because your M1 database has some records which has bad data in the value of the sales_flat_order.updated_at field in sales data section.
To handle for that case, you could try with steps below:
+ Open the php file at path: pub/ub-tool/protected/controllers/Step7Controller.php
and find to the code line:

if (!$salesOrder2->save()) {

and replace it by code lines:

if ($salesOrder2->updated_at === '0000-00-00 00:00:00' || empty($salesOrder2->updated_at)) {
$salesOrder2->updated_at = date("Y-m-d H:i:s");
}
if (!$salesOrder2->save()) {

+ And find to the code line:

if ($salesOrder2->update()) {

and replace it by code lines:

if ($salesOrder2->updated_at === '0000-00-00 00:00:00' || empty($salesOrder2->updated_at)) {
$salesOrder2->updated_at = date("Y-m-d H:i:s");
}
if ($salesOrder2->update()) {

+ Once done, you could continue with data migration in the step #7 of our tool.
Regards,
Mall.
 

#1
Profile photo of swiss.good 390.00 $tone July 25, 2018
Public

Hi there,
Thank you very much for the trick it worked. But now i’ve got a new error saying
Mage2SalesShipmentGrid: Order Increment Id cannot be blank.

Regards
Lathion J.B 

#2

This question is now closed

Written By

Comments