Migration from 1.9.3.6 to 2.3.4

[foysal]

I am getting below error while I am migrating from 1.9.3.6 to 2.3.4. Please help me.

Sorry for previous wrong post.

[Nishu Jindal]

Hi,

This issue is occurring because of some duplicate entry in log tables.

Generally we dont need this data in magento 2. If your requirement is same, please truncate all magento 1 log table entries and run the migration process again.

Hope this helps you.

Problem Solved? Click Kudos & Accept as Solution!

[foysal]

Thanks @Nishu Jindal . How to truncate all magento 1 log table entries ?

[Nishu Jindal · Accepted solution]

Hi @foysal,

These are the log tables which need to be truncated.

log_customer
log_summary
log_summary_type
log_url
log_url_info
log_visitor
log_visitor_info 

On Magento 1 database, run.below command  for all tables one by one like

Truncate  `log_url`;

Hope this helps you.

Problem Solved! Click Kudos & Accept as Solution!

[foysal]

Thanks @Nishu Jindal . Your solution is working. How did you know the solution ?

Thanks.

[Nishu Jindal]

Hi @foysal ,

I am glad the solution worked for you. I have worked on 3-4 sites migration till now.

From past experiences, I have learnt these things.

Thanks!

Problem Solved! Click Kudos & Accept as Solution!

[foysal]

Thanks @Nishu Jindal. Could you please help me to learn debugging  these issues ? Thanks.