Magento 2.1.7 reindex customer_grid returning No such entity

[luki76]

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.

[Damian Culotta]

Hi @luki76,

Did you imported your customers? Or maybe you were changing your website/stores configuration in Magento?

[luki76]

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

[luki76]

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]

You have to again run indexer command,
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.

[luki76]

@Rakesh Jesadiya Have you read my first message? Probably not exactly.

All reindexed succesfully, except indexes customer_grid returning No such entity.

[Amit_DS]

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.

[Rakesh Jesadiya]

@luki76 @Amit_DS

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.

[Amit_DS]

Hi,
Tried the steps suggested, by still getting the empty page and No such entity message.

[Amit_DS]

Hi,

I have tried the suggested steps, but i am getting the same result - empty customer grid with No such entity message