Magento 2 Error: Something went wrong with processing the default view

In magento 2, “something went wrong with processing the default view and we have restored the filter to its original stateis an error you accidentally face when you are working in Magento 2 Back-end. You may see this error when visiting product or order listing. And a error says: something went wrong was displayed but never tells you what is “SOMETHING“. We are always nervous about this issue because it prevent us from continuing to edit a product or processing an order.

You tried multiple ways such as disabling all caches, logging out, logging in again, visiting the site in private mode. However, they did not help you solve this obstacle at all.

The root cause of this problem came from ui_bookmark feature of Magento 2 to store admin user’s state. It always has a current & default state for each view in magento back-end we are using.

To fix the problem and view the orders again, all you have to do is:

  1. Login phpmyadmin and select magento database
  2. Find ui_bookmark table
  3. Edit ui_bookmark (identifier: default)
    Paste this value in ‘config’ column:
    {“views”:{“default”:{“label”:”Default View”,”index”:”default”,”editable”:false,”data”:{“search”:{“value”:””},”filters”:{“applied”:{“placeholder”:true}},”paging”:{“pageSize”:20,”current”:1,”options”:{“20”:{“value”:20,”label”:20},”30″:{“value”:30,”label”:30},”50″:{“value”:50,”label”:50},”100″:{“value”:100,”label”:100},”200″:{“value”:200,”label”:200}},”value”:20},”columns”:{“increment_id”:{“visible”:true,”sorting”:”asc”},”order_increment_id”:{“visible”:true,”sorting”:false},”billing_name”:{“visible”:true,”sorting”:false},”base_grand_total”:{“visible”:true,”sorting”:false},”grand_total”:{“visible”:true,”sorting”:false},”store_id”:{“visible”:false,”sorting”:false},”billing_address”:{“visible”:false,”sorting”:false},”shipping_address”:{“visible”:false,”sorting”:false},”customer_name”:{“visible”:false,”sorting”:false},”customer_email”:{“visible”:false,”sorting”:false},”shipping_information”:{“visible”:false,”sorting”:false},”subtotal”:{“visible”:false,”sorting”:false},”shipping_and_handling”:{“visible”:false,”sorting”:false},”actions”:{“visible”:true,”sorting”:false},”ids”:{“visible”:true,”sorting”:false},”created_at”:{“visible”:true,”sorting”:false},”order_created_at”:{“visible”:true,”sorting”:false},”state”:{“visible”:true,”sorting”:false},”customer_group_id”:{“visible”:false,”sorting”:false},”payment_method”:{“visible”:false,”sorting”:false}},”displayMode”:”grid”,”positions”:{“ids”:0,”increment_id”:1,”created_at”:2,”order_increment_id”:3,”order_created_at”:4,”billing_name”:5,”state”:6,”base_grand_total”:7,”grand_total”:8,”store_id”:9,”billing_address”:10,”shipping_address”:11,”customer_name”:12,”customer_email”:13,”customer_group_id”:14,”payment_method”:15,”shipping_information”:16,”subtotal”:17,”shipping_and_handling”:18,”actions”:19}},”value”:”Default View”}}}
  4. Edit ui_bookmark (identifier: current)
    Paste this value in ‘config’ column:
    {“current”:{“search”:{“value”:””},”filters”:{“applied”:{“placeholder”:true}},”paging”:{“pageSize”:20,”current”:1,”options”:{“20”:{“value”:20,”label”:20},”30″:{“value”:30,”label”:30},”50″:{“value”:50,”label”:50},”100″:{“value”:100,”label”:100},”200″:{“value”:200,”label”:200}},”value”:20},”columns”:{“increment_id”:{“visible”:true,”sorting”:”asc”},”order_increment_id”:{“visible”:true,”sorting”:false},”billing_name”:{“visible”:true,”sorting”:false},”base_grand_total”:{“visible”:true,”sorting”:false},”grand_total”:{“visible”:true,”sorting”:false},”store_id”:{“visible”:false,”sorting”:false},”billing_address”:{“visible”:false,”sorting”:false},”shipping_address”:{“visible”:false,”sorting”:false},”customer_name”:{“visible”:false,”sorting”:false},”customer_email”:{“visible”:false,”sorting”:false},”shipping_information”:{“visible”:false,”sorting”:false},”subtotal”:{“visible”:false,”sorting”:false},”shipping_and_handling”:{“visible”:false,”sorting”:false},”actions”:{“visible”:true,”sorting”:false},”ids”:{“visible”:true,”sorting”:false},”created_at”:{“visible”:true,”sorting”:false},”order_created_at”:{“visible”:true,”sorting”:false},”state”:{“visible”:true,”sorting”:false},”customer_group_id”:{“visible”:false,”sorting”:false},”payment_method”:{“visible”:false,”sorting”:false},”shipping_name”:{“visible”:true,”sorting”:false},”total_refunded”:{“visible”:false,”sorting”:false},”payment_type”:{“visible”:false,”sorting”:false},”status”:{“visible”:true,”sorting”:false},”customer_group”:{“visible”:false,”sorting”:false},”signifyd_guarantee_status”:{“visible”:false,”sorting”:false}},”displayMode”:”grid”,”positions”:{“ids”:0,”increment_id”:1,”created_at”:2,”billing_name”:3,”base_grand_total”:4,”store_id”:5,”grand_total”:6,”billing_address”:7,”shipping_address”:8,”customer_email”:9,”customer_name”:10,”shipping_information”:11,”payment_method”:12,”shipping_name”:13,”subtotal”:14,”status”:15,”shipping_and_handling”:16,”actions”:17,”customer_group”:18,”total_refunded”:19,”signifyd_guarantee_status”:20,”payment_type”:21}}}
  5. Reload error page

I am pretty sure that you can work on the grid successfully again without any error message in magento 2; attention something went wrong.