search

akeneo / transporteo

Migration Tool for Akeneo PIM from 1.7 to 2.0
Other
8 stars 7 forks source link

SQL FileNotFoundException while migrating via SSH #143

Closed marcusandre closed 6 years ago

marcusandre commented 6 years ago

Hello together,

we'd like to upgrade an already installed Akeneo 1.7.3 instance onto a different server. Akeneo 2.3 is installed on the new server; everything works fine.

To migrate the data from the old instance, we use transporteo via ssh. The connection works, but it halts at this step:

Destination PIM database initialization... Migrating files data...

It print's the following:

[Akeneo\PimMigration\Domain\FileNotFoundException]  
 The file /tmp/transporteo_akeneo_file_storage_file_info.sql does not exist

The user has all permissions to create any files at /tmp on the source server, as well as at the destination server.

Is there a step we missed before? Is there anything we'd have to do on the source pim? We use the API for our own purposes without any errors yet.

You can find the processing and stack trace here: https://gist.github.com/marcusandre/0332884a6a59d5c52d55ca0bc5a525fe#file-akeneo_error-txt

Source PIM specs: https://gist.github.com/marcusandre/0332884a6a59d5c52d55ca0bc5a525fe#file-source_pim_specs-txt

Destination PIM specs:https://gist.github.com/marcusandre/0332884a6a59d5c52d55ca0bc5a525fe#file-destination_pim_specs-txt

Do you have any idea what's going on? If you still need data, just let me know.

Thank you very much!

marcusandre commented 6 years ago

Hello,

since we couldn't wait any longer, we could help ourselves with sshfs.

Mount the source directory onto your new machine. Also export the source database and import it on the new machine as well. Start your synchronisation as a local procedure.

If someone has problems synchronizing a very large product catalog via SSH, this should also be considered. You should also allow some time, as the transfer of a large product catalog can easily take 2-3 hours.