Delta Migration Error: Deltalog for customer_entity

[ghost]

Ready to go live with m2 on a staging server after successfully migrating a few weeks ago from 1.7.0.2.

Trying to update with new customers and recent orders in the past few weeks since migration.

After trying the migrate:delta command, I'm getting the Error: Deltalog for customer_entity is not installed.

The source mysql db, the destination db, and the delta db are all providing user with complete privileges.

I understand this has previously been brought up as an issue but none of the responses had a clear solution to this issue.

[victor-v-rad]

Hi @joshuacalebm

Can you find m2_cl_* tables in your Magento 1 DB? Does m2_cl_customer_entity table exists?

[ghost]

Hi. @victor-v-rad thanks for the reply. No the tables don't exist in the original m1 db I used for migration, but I'm actually trying to use a newer version of the original db I imported into the staging server since the hosting co won't allow remote db access. I read somewhere one would have to create these tables?

[victor-v-rad]

Hi @joshuacalebm

The tool creates these tables when php bin/magento migrate:data is run. It is used in 'delta mode' when you run php bin/magento migrate:delta. I believe the tool should notify a user that it could not create delta tables. Internal ticket MAGETWO-67773 to implement it if possible

[webkulabhi]

Hi @victor-v-rad
In which case tool did not create m2_cl_* tables in magento1 database? both database assigned to same user.

[victor-v-rad]

@webkulabhi
No privileges can be the cause. Check for errors in logs. Connect with this user to the MySQL and try to create some table manually.

[webkulabhi]

@victor-v-rad
user have already permission for create table.
may be some issues with 2.1.5 version. I tried with 2.1.6 and its working perfectly.
Thanks for your response.

[victor-v-rad]

Fixed

[MohanaKrishnan7]

@victor-v-rad It is not fixed !. @webkulabhi saying that "It is not working in 2.1.5." and I'm also facing the same error "Deltalog for customer_entity is not installed" in 2.2.4.

[Rudoslav]

I am migrating from 1.9.1.0 to 2.2.1. The problem still exists.
When I run:

php bin/magento migrate:delta vendor/magento/data-migration-tool/etc/opensource-to-opensource/1.9.1.0/config.xml

The error comes up:

[ERROR]: Deltalog for customer_entity is not installed
[Migration\Exception] Delta delivering failed

There are no errors in the nginx, or magento logs (in /var/log and var/log/).

[Rudoslav]

So I found out what was the issue.

When you try to run migrate:delta without running migrate:data before basically. The problem is that those delta log tables (m2_cl_*) are missing in the source database (magento 1).

[sohrobdevise]

@MohanaKrishnan7 @Rudoslav
Have you been able to find a solution for this? I am on version 2.2.5 and cannot find a solution.
Anything would be appreciated!

[Rudoslav]

@sohrobdevise

See my last comment above.
Check if your source (Magento 1) database does have delta/change list tables created.
Delta tables should have names starting with m2_cl_*.

[MohanaKrishnan7]

@MohanaKrishnan7 @Rudoslav
Have you been able to find a solution for this? I am on version 2.2.5 and cannot find a solution.
Anything would be appreciated!

@sohrobdevise

As @Rudoslav said, check whether you have m2_cl_* tables in your Magento 1 database in which you are running the DELTA migration.

If you don't find the tables. then you are running the DELTA migration in a different Magento 1 database and you have run the DATA migration in another Magento 1 database. Find the database in which you run the DATA migration and run the DELTA migration again.

If you are getting any other issues, take a fresh copy of your Magento 1 database and delete all the m2_cl_* tables. Install a fresh Magento 2 and try all the migration steps.

Thanks and Regards
MohanaKrishnan.