Magento2 Migrating from M1 1.9.3.6 To M2 2.2.0 opensource to opensource

[AbdulKadir-Agoliya]

I am attempting to migrate from 1.9.3.6 to 2.2.0 Opensource to opensource using the data migration tool.
using command : php bin/magento migrate:setting /path-to/vendor/magento/data-migration-tool/etc/opensource-to-opensource/1.9.3.6/config.xml

start migration setting and there is one error source docuement is
Source fields are not mapped. Document: core_website. Fields: mf_guid,created_at,updated_at
i added ignore field statement

core_website.mf_guid
core_website.updated_at
core_website.created_at

in map-stores.xml

php bin/magento migrate:data -r /path-to/vendor/magento/data-migration-tool/etc/opensource-to-opensource/1.9.3.6/config.xml

Expected result

1.error should remove
2. migration process to next step or proceed further

Actual result

1 . [PDOException] SQLSTATE[42S22]: Column not found: 1054 Unknown column 'created_at' in 'field list'

Also when i tried it using - -vvv param
it give me

it give me this
Exception trace:
() at /home/mazelivingco/public_html/mag2/vendor/magento/data-migration-tool/src/Migration/ResourceModel/Adapter/Mysql.php:169
PDOStatement->execute() at /home/mazelivingco/public_html/mag2/vendor/magento/data-migration-tool/src/Migration/ResourceModel/Adapter/Mysql.php:169
Migration\ResourceModel\Adapter\Mysql->insertMultiple() at /home/mazelivingco/public_html/mag2/vendor/magento/data-migration-tool/src/Migration/ResourceModel/Adapter/Mysql.php:137
Migration\ResourceModel\Adapter\Mysql->insertRecords() at /home/mazelivingco/public_html/mag2/vendor/magento/data-migration-tool/src/Migration/ResourceModel/Destination.php:46
Migration\ResourceModel\Destination->saveRecords() at /home/mazelivingco/public_html/mag2/vendor/magento/data-migration-tool/src/Migration/Step/Settings/Data.php:137
Migration\Step\Settings\Data->perform() at /home/mazelivingco/public_html/mag2/vendor/magento/data-migration-tool/src/Migration/Mode/AbstractMode.php:73
Migration\Mode\AbstractMode->runStage() at /home/mazelivingco/public_html/mag2/vendor/magento/data-migration-tool/src/Migration/Mode/Settings.php:70
Migration\Mode\Settings->runData() at /home/mazelivingco/public_html/mag2/vendor/magento/data-migration-tool/src/Migration/Mode/Settings.php:34
Migration\Mode\Settings->run() at /home/mazelivingco/public_html/mag2/vendor/magento/data-migration-tool/src/Migration/Console/MigrateSettingsCommand.php:51
Migration\Console\MigrateSettingsCommand->execute() at /home/mazelivingco/public_html/mag2/vendor/symfony/console/Command/Command.php:266
Symfony\Component\Console\Command\Command->run() at /home/mazelivingco/public_html/mag2/vendor/symfony/console/Application.php:875
Symfony\Component\Console\Application->doRunCommand() at /home/mazelivingco/public_html/mag2/vendor/symfony/console/Application.php:204
Symfony\Component\Console\Application->doRun() at /home/mazelivingco/public_html/mag2/vendor/magento/framework/Console/Cli.php:104
Magento\Framework\Console\Cli->doRun() at /home/mazelivingco/public_html/mag2/vendor/symfony/console/Application.php:122
Symfony\Component\Console\Application->run() at /home/mazelivingco/public_html/mag2/bin/magento:23

migrate:settings [-r|--reset] [-a|--auto] [--]

Now Please Suggest what to do next?

[victor-v-rad]

The problem you have is in core_config_data table which has fields were created by some extension. As quick fix i would suggest adding this code

            unset($sourceRecord['mf_guid']);
            unset($sourceRecord['updated_at']);
            unset($sourceRecord['created_at']);

right after foreach line

[victor-v-rad]

Internal ticket MAGETWO-80933 to fix it

[AbdulKadir-Agoliya]

Thank you so much its work For me
issue Fixed

[victor-v-rad]

Great!

[AbdulKadir-Agoliya]

Can anyone help here Migrating from magento1.9.3.6 to magento2.2.0

I got this error

Array to string conversion in /var/www/html/magento220/vendor/magento/data-migration-tool/src/Migration/ResourceModel/Adapter/Mysql.php on line 169

[Exception]
Notice: Array to string conversion in /var/www/html/magento220/vendor/magento/data-migration-tool/src/Migration/ResourceModel/Adapter/Mysql.p
hp on line 169

I see that file on line 169 i see this statement $statement->execute($bind);

protected function insertMultiple($documentName, $records)
{
$bind = [];
$values = [];
$colNum = count($records[0]);
$fields = array_keys($records[0]);
foreach ($records as $record) {
foreach ($record as $value) {
$bind[] = $value;
}
$values[] = '(' . implode(',', array_fill(0, $colNum, '?')) . ')';
}
if ($values && $fields) {
$insertSql = sprintf(
'INSERT INTO %s (%s) VALUES %s',
$documentName,
sprintf('%s', implode(',', $fields)),
implode(',', $values)
);
$statement = $this->resourceAdapter->getConnection()->prepare($insertSql);
$statement->execute($bind);
}

But i dont know how it works

migrate:data [-r|--reset] [-a|--auto] [--]

Please help me here its urgent and i have to finish it today

[AbdulKadir-Agoliya]

I have removed one module's column from M1's customer_group table and now that error gone

and now same error comes from sales_flat_order_item

so i think when
migrate mode data , its not ignoring field

so please give me solution for that
error come on
data-migration-tool/src/Migration/ResourceModel/Adapter/Mysql.php on line 169 $statement->execute($bind);
function name insertMultiple($documentName, $records)

[keanass]

same issue here :
from ce-to-ce 1.8 to 2.2 gives :
vendor/magento/data-migration-tool/src/Migration/ResourceModel/Adapter/Mysql.php on line 169
must correct this please.