Migration issue generating a 500 error

[LaureBrosseau]

Error while migration data from EE 1.7 to EE 2.0, raised by a client:

Migrating files data...
Migrating structure data...
Migrating families data...
PHP Fatal error: Uncaught Error: Wrong parameters for Akeneo\PimMigration\Domain\DataMigration\QueryException([string $message [, long $code [, Throwable $previous = NULL]]]) in /home/akeneo/transporteo/src/Infrastructure/Cli/LocalMySqlQueryExecutor.php:30
Stack trace:
#0 /home/akeneo/transporteo/src/Infrastructure/Cli/LocalMySqlQueryExecutor.php(30): Exception->__construct('Query "ALTER TA...', '42S21', Object(PDOException))
#1 /home/akeneo/transporteo/src/Infrastructure/Cli/LocalConsole.php(48): Akeneo\PimMigration\Infrastructure\Cli\LocalMySqlQueryExecutor->execute('ALTER TABLE ake...', Object(Akeneo\PimMigration\Domain\Pim\DestinationPim))
#2 /home/akeneo/transporteo/src/Domain/Command/ChainedConsole.php(23): Akeneo\PimMigration\Infrastructure\Cli\LocalConsole->execute(Object(Akeneo\PimMigration\Domain\Command\MySqlExecuteCommand), Object(Akeneo\PimMigration\Domain\Pim\DestinationPim))
#3 /home/akeneo/transporteo/src/Domain/MigrationStep/s080_FamilyMigration/FamilyDataMigrator.php(56): Akeneo\PimMigration\Domain\Command\C in /home/akeneo/transporteo/src/Infrastructure/Cli/LocalMySqlQueryExecutor.php on line 30

During the migration process, a client identified a request from the ALTER TABLE that blocks Transporteo (here is the complete request: ALTER TABLE akeneo_pim.pim_catalog_family ADD COLUMN image_attribute_id INT(11) DEFAULT NULL AFTER label_attribute_id, ADD CONSTRAINT FK_90632072BC295696 FOREIGN KEY (image_attribute_id) REFERENCES pim_catalog_attribute (id) ON DELETE SET NULL, ADD KEY IDX_90632072BC295696 (image_attribute_id))

[LaurentPetard]

The query is valid. Maybe the migration the table pim_catalog_family failed, but it would threw an error.

We would need the SQL error to investigate.

[LaureBrosseau]

when we run this request manually in MySQL we do not get any error, it seems to be executed fine