- Mark as New
- Bookmark
- Subscribe
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
Magento 2.1.7 reindex customer_grid returning No such entity
Hello everyone,
I have Magento 2.1.7 All is reindexed succesfully, except indexes customer_grid returning No such entity.
I'm not php and mysql expert but maybe someone can help me.
- Mark as New
- Bookmark
- Subscribe
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
Re: Magento 2.1.7 reindex customer_grid returning No such entity
Hi @luki76,
Did you imported your customers? Or maybe you were changing your website/stores configuration in Magento?
- Mark as New
- Bookmark
- Subscribe
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
Re: Magento 2.1.7 reindex customer_grid returning No such entity
Now reindex working fine but I have problem with custommer list still
1 step. In the admin panel I add a new client. I get information that the client has been saved.
2 steps. I check the customer list, the customer list is empty.
3 steps. I am trying to re-add a client. I get the message that this email address is already stored in the database. The customer list is still empty
- Mark as New
- Bookmark
- Subscribe
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
Re: Magento 2.1.7 reindex customer_grid returning No such entity
If I go to admin - customers - all customers - add customer - save - I get information that client has been saved but customers list is empty. (check screenshots)
Then I go to admin - dashboard - I see new customers (check screenshots)
Then admin - dasboard - search - put name of customer and system found it (check screenshots)
But if I back to admin - customers - all customers - customers list is empty
- Mark as New
- Bookmark
- Subscribe
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
Re: Magento 2.1.7 reindex customer_grid returning No such entity
php bin/magento indexer:reset
php bin/magento indexer:reindex
Clear browsers cache and check again.
Just update my answer:
First run reset command, then run indexer command.
php bin/magento indexer:reset
php bin/magento indexer:reindex
If issue solved, click kudos/accept as solutions.
Magento 2 Blogs/Tutorial
- Mark as New
- Bookmark
- Subscribe
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
Re: Magento 2.1.7 reindex customer_grid returning No such entity
@Rakesh Jesadiya Have you read my first message? Probably not exactly.
All reindexed succesfully, except indexes customer_grid returning No such entity.
- Mark as New
- Bookmark
- Subscribe
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
Re: Magento 2.1.7 reindex customer_grid returning No such entity
I have just migrated the data from Magento1 to Magento2, but in customers grid, it is showing "No such entity". I have reset and reindexed the indexes but still getitng the same issue. I can see the records in customer_entity table, but the customers grid is still empty.
Please help me in resolving this issue.
- Mark as New
- Bookmark
- Subscribe
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
Re: Magento 2.1.7 reindex customer_grid returning No such entity
Try with below solutions:
Go to database,
Find table, indexer_state
now change customer_grid from row 2, status "working" from "invalid"
Run indexer:command
php bin/magento indexer:reindex
if above solutions not working try with below command,
Empty Customer_visitor table from database,
Now run command,
php bin/magento indexer:reset php bin/magento indexer:reindex
if issue solved, Click Kudos/Accept as solutions.
Magento 2 Blogs/Tutorial
- Mark as New
- Bookmark
- Subscribe
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
Re: Magento 2.1.7 reindex customer_grid returning No such entity
Tried the steps suggested, by still getting the empty page and No such entity message.
- Mark as New
- Bookmark
- Subscribe
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
Re: Magento 2.1.7 reindex customer_grid returning No such entity
Hi,
I have tried the suggested steps, but i am getting the same result - empty customer grid with No such entity message