cancel
Showing results for 
Search instead for 
Did you mean: 

Magento 2.1.7 reindex customer_grid returning No such entity

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.

 

 

Tags (1)
10 REPLIES

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?

 

--
If you've found one of my answers useful, please give "Kudos" or "Accept as Solution"

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.jpgad2.jpgad3.jpgad4.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.

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.

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