cancel
Showing results for 
Search instead for 
Did you mean: 

Magento 2.1.7 reindex customer_grid returning No such entity

   Did you know you can see the translated content as per your choice?

Translation is in progress. Please check again after few minutes.

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.

 

 

11 REPLIES 11

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?

 

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

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 emptyad.jpg ad2.jpg ad3.jpg ad4.jpg

Re: Magento 2.1.7 reindex customer_grid returning No such entity

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.
If Issue Solved, Click Kudos/Accept As solutions. Get Magento insight from
Magento 2 Blogs/Tutorial

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.

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.

Re: Magento 2.1.7 reindex customer_grid returning No such entity

@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.

If Issue Solved, Click Kudos/Accept As solutions. Get Magento insight from
Magento 2 Blogs/Tutorial

Re: Magento 2.1.7 reindex customer_grid returning No such entity

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

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