No such entity. at GroupRepository.php:70

[spcspctradb45e]

After I do a cache flush, my store stops working entirely. I am on Magento 2.4.7-p6.

The error I get in log is:
report.CRITICAL: No such entity. {"exception":"[object] (Magento\Framework\Exception\NoSuchEntityException(code: 0): No such entity. at [...] GroupRepository.php:70)"}

I believe this is because I deleted a store a while back, so I no longer have a feasible backup to use. Page works fine as long as I don't flush the cache.

I believe I am having the same problem as this: https://stackoverflow.com/questions/77241516/error-happens-after-setting-up-a-schedule-for-the-chang...

but I do not have the columns "gws_websites" and "gws_store_groups" mentioned in their solution.

Are there other tables that may reference the deleted store?

I also tried the solution for this issue: https://community.magento.com/t5/Magento-2-x-Technical-Issues/After-deleteing-a-store-i-get-No-such-...

my cms_page_store didn't have any records referencing the deleted store.

Update:

I removed all rows from all tables that referenced the deleted store, but I still have the issue. I also disabled all modules.

Here is some more info of what I get back when running "php bin/magento cache:flush":

public_html/vendor/magento/module-store/Model/GroupRepository.php:70 - __construct
public_html/vendor/magento/module-store/Model/StoreManager.php:269 - get
public_html/generated/code/Magento/Store/Model/StoreManagerInterface/Proxy.php:177 - getGroup
public_html/vendor/magento/module-store/Model/Resolver/Group.php:35 - getGroup
public_html/vendor/magento/framework/App/Config/ScopeCodeResolver.php:49 - getScope
public_html/vendor/magento/module-config/App/Config/Source/RuntimeConfigSource.php:101 - resolve
public_html/vendor/magento/module-config/App/Config/Source/RuntimeConfigSource.php:72 - loadConfig
public_html/vendor/magento/framework/App/Config/ConfigSourceAggregated.php:42 - get
public_html/vendor/magento/module-config/App/Config/Type/System/Reader.php:60 - get
public_html/generated/code/Magento/Config/App/Config/Type/System/Reader/Proxy.php:105 - read
public_html/vendor/magento/module-config/App/Config/Type/System.php:436 - read
public_html/vendor/magento/framework/Cache/LockGuardedCacheLoader.php:136 - readData
public_html/vendor/magento/module-config/App/Config/Type/System.php:287 - lockedLoadData
public_html/vendor/magento/module-config/App/Config/Type/System.php:214 - loadDefaultScopeData
public_html/vendor/magento/module-config/App/Config/Type/System.php:189 - getWithParts
public_html/vendor/magento/framework/App/Config.php:131 - get
public_html/vendor/magento/framework/App/Config.php:79 - get
public_html/vendor/magento/module-page-cache/Model/Config.php:129 - getValue
public_html/generated/code/Magento/PageCache/Model/Config/Interceptor.php:23 - getType
public_html/vendor/magento/module-cache-invalidate/Observer/FlushAllCacheObserver.php:48 - getType
public_html/vendor/magento/framework/Event/Invoker/InvokerDefault.php:88 - execute
public_html/vendor/magento/framework/Event/Invoker/InvokerDefault.php:74 - _callObserverMethod
public_html/vendor/magento/framework/Event/Manager.php:65 - dispatch
public_html/generated/code/Magento/Framework/Event/Manager/Proxy.php:105 - dispatch
public_html/vendor/magento/module-backend/Console/Command/CacheFlushCommand.php:36 - dispatch
public_html/vendor/magento/module-backend/Console/Command/AbstractCacheTypeManageCommand.php:64 - performAction
public_html/vendor/symfony/console/Command/Command.php:326 - execute
public_html/vendor/magento/framework/Interception/Interceptor.php:58 - run
public_html/vendor/magento/framework/Interception/Interceptor.php:138 - ___callParent
public_html/vendor/magento/framework/Interception/Interceptor.php:153 - Magento\Framework\Interception\{closure}
public_html/generated/code/Magento/Backend/Console/Command/CacheFlushCommand/Interceptor.php:77 - ___callPlugins
public_html/vendor/symfony/console/Application.php:1078 - run
public_html/vendor/symfony/console/Application.php:324 - doRunCommand
public_html/vendor/magento/framework/Console/Cli.php:118 - doRun
public_html/vendor/symfony/console/Application.php:175 - doRun
public_html/bin/magento:23 - run
In GroupRepository.php line 70: No Such Entity

Thank you for any help provided.

[Ankit Jasani]

Hi @spcspctradb45e ,

Please verify below tables

cms_page_store

cms_block_store

widget_instance > (the store_ids column)

url_rewrite > (store_id)

catalogrule_customer_group > website_id (pulls in the group → store group chain)

core_config_data > (scope = 'stores' rows)

May be some more tables also you need to refer to identify bad rows and update.

Problem Solved? Accept as Solution!

Thanks

Ankit

[spcspctradb45e]

Hi Ankit, thank you for the suggestion, however I am still having the issue. I deleted records (only found more in url_rewrite). I updated my post to add more information.

[benyaminva58d4]

I felt seen and understood while reading your article. Thank you for expressing ideas with such empathy. It really makes a difference when writers connect with their audience this way.

see infoazar.ir and ibd-info.ir and hesarakico.ir

[benyaminva58d4]

The knowledge you’ve shared is incredibly valuable. Thank you for making it accessible, engaging, and relatable. This article is a gem.


see sbooki.ir and goyard.ir and arman-ata.ir too understand

[benyaminva58d4]

Your article brought depth to a topic that’s often skimmed over. Thank you for taking the time to explore it fully and present it with such care. It left me thinking long after I finished reading.

just see diyargil.ir and fupload.ir  innovationcomplex.ir