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.
Did you imported your customers? Or maybe you were changing your website/stores configuration in Magento?
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
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
@Rakesh Jesadiya Have you read my first message? Probably not exactly.
All reindexed succesfully, except indexes 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.
Try with below solutions:
Go to database,
Find table, indexer_state
now change customer_grid from row 2, status "working" from "invalid"
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.
I have tried the suggested steps, but i am getting the same result - empty customer grid with No such entity message