No such entity for customer grid magento2

Question

i face the issue in magento223 version after data migration for only customer data to magento223 setup migration was successfully completed.

but in admin login in all customer grid it shows like "No such entity." how to resolve this issue can any one help out for this ?

i also done with index:reindex command and cache:clean commange still not display.

Thanks

Answer 1

When you transfer the data the insert records on these specific records are automatically generated and tend to start at 1 and not 0.

I think this script work for you :-

SET FOREIGN_KEY_CHECKS=0;
UPDATE `store` SET store_id = 0 WHERE code='admin';
UPDATE `store_group` SET group_id = 0 WHERE name='Default';
UPDATE `store_website` SET website_id = 0 WHERE code='admin';
UPDATE `customer_group` SET customer_group_id = 0 WHERE customer_group_code='NOT LOGGED IN';
SET FOREIGN_KEY_CHECKS=1;

Answer 2

In database table 'customer_entity' confirm website id with existing website if not match then change it and run below commands.

php bin/magento indexer:reindex

php bin/magento cache:flush