Resolve grid access errors in Adobe Commerce on Cloud Infrastructure
If you encounter errors when navigating grid-based pages in Adobe Commerce on Cloud Infrastructure, the issue might be related to stored filters. Clearing these filters from the database can restore functionality.
Description description
Environment
Adobe Commerce on Cloud Infrastructure (all versions)
Issue/Symptoms
An error, Something went wrong with processing the default view and we have restored the filter to its original state, occurs when navigating to pages containing grids in the Adobe Commerce on Cloud infrastructure admin panel.
The issue occurs immediately upon navigating to specific pages, such as:
- Catalog
>Products - Customers
>All Customers - Customers
>Companies
It is reproducible across multiple admin users with identical roles.
Resolution resolution
The most common cause is related to filters recently applied by a user, or keyword searches on that page, so attempt to clear these filters:
-
Clear the products grid filter stored in the database for that user:
DELETE FROM ui_bookmark WHERE namespace = ‘product_listing’ AND user_id = (SELECT user_id FROM admin_user WHERE email = $user_email);
-
Clear the customers grid filter stored in the database for that user:
DELETE FROM ui_bookmark WHERE namespace = ‘customer_listing’ AND user_id = (SELECT user_id FROM admin_user WHERE email = $user_email); -
Clear the companies grid filter stored in the database for that user:
DELETE FROM ui_bookmark WHERE namespace = ‘company_listing’ AND user_id = (SELECT user_id FROM admin_user WHERE email = $user_email);
Additional troubleshooting steps:
-
The above list is not exhaustive so if you want to check all available grid filters, execute:
SELECT DISTINCT namespace FROM ui_bookmark;
-
To clear all grid filters for a specific user:
DELETE FROM ui_bookmark WHERE user_id = (SELECT user_id FROM admin_user WHERE email = $user_email);
By performing these actions, you should be able to eliminate the error and restore functionality to the relevant section of your admin panel.
If the issue persists after clearing the filters, submit an Adobe Support ticket.