User gets list view blank

User would get list view as blank when a key on the keyboard has been typed multiple times while within a filter field, exceeding the number of keys to 4,000.

This creates a URI that is beyond allowed size of 4096 and the list view fails.

With help of @snv figured out that table __UserSettings gets populated.

1 Like

To resolve it followed the below:

Delete records from database:

bench mariadb

delete from __UserSettings where length(data) > 4000;

Sync user settings:

bench console

from frappe.model.utils.user_settings import sync_user_settings, get_user_settings

Check if it is cleared: e.g. For Sales Invoice list view for user

bench console

frappe.cache().hget('_user_settings', '"Sales Invoice"::""')