UB Data Migration Pro – STEP 7 – Stuck on 86%

Hi michaelwest,
It seem your Magento1 database has some bad data in sales data section.
Let’s provide me the log file of our tool at pub/ub-tool/protected/runtime/ub_data_migration.log
I will check further and help you out.
Regards,
Mall.

Hi michaelwest,
I have checked the log files you shared. But i don’t see any errors.
Let’s continue with data migration in the step #7 with cli command:
php -f bin/ubdatamigration run --step=7
And tell me know how it goes.
Regards,
Mall.

Hi there,

1. Most of the products have .html twice or midway through the URL..

That is not issue of our tool. That is a issue of the Magento2 with your data migrated from Magento1.
You can see more about this at:
https://github.com/magento/magento2/issues/3726
http://magento.stackexchange.com/questions/135736/magento-2-1-product-urls-end-with-html-html-why
To solve that, you can do steps as bellow:
Step 1: Backup current your Magento2 database.
Step 2: Run bellow sql in your Magento2 database:
UPDATE url_rewrite SET request_path = REPLACE(request_path, ‘.html.html’, ‘.html’);
UPDATE url_rewrite SET request_path = REPLACE(request_path, ‘-html.html’, ‘.html’);
Step 3: Clear all cache of magento and your browser and access it

2. I think there’s an issue with the product pictures… the Main image is fine but the Alternative image isn’t the same as on our existing website. 

Let’s re-check your settings with product’s images.
And tell me know how it goes.
Regards,
Mall.

Hi there,

Something went wrong while generating the Sage Pay request: SQLSTATE[42000]: Syntax error or access violation: 1103 Incorrect table name ”, query was: INSERT INTO “ () VALUES ()
You will be redirected to the PayPal website.

To solve that, for each Store view migrated, let’s open it and click to save button in back-end of your site.
Regards,
Mall.

Hi there,
Here is root of issue with category urls as you mentioned:
http://i.prntscr.com/0eaf31aae22040e5be80d8bd6bac4300.png
and
http://i.prntscr.com/e223ac3f66bf4af2b0d415fe59ca9ebc.png
To solve that, you can do steps as bellow:
Step 1: Backup current database of your Magento2.
Step 2: Run bellow sql in your database:

UPDATE catalog_category_entity_varchar SET value = REPLACE(value, '.html', '') WHERE attribute_id = 114;
 UPDATE url_rewrite SET request_path = REPLACE(request_path, '.html/', '/');

Step 3: Clean the Magento2 cache.
And tell me know how it goes.
Regards,
Mall.

Hi there,

Paypal still not working

Here is root of issue:

Something went wrong while generating the Sage Pay request: SQLSTATE[42000]: Syntax error or access violation: 1103 Incorrect table name ”, query was: INSERT INTO “ () VALUES ()

That because you have missing open and re-save the Store view named English (en_migrated) in back-end of your site as my suggesting in first reply.
I have do it for you and now the issue with checkout function was solved.
Let’s have a look again.
Regards,
Mall.