504 Gateway Time-out in report view for particular user

ERPNext
,
1

One particular user selected all the columns in pick columns ( report View). The Post request api/method/frappe.desk.reportview.get response is 504 Gateway Time-out and also makes the server busy. My server load average is greater than 7 during this time. I tried to edit pick columns but it throws the error

Uncaught TypeError: Cannot read properties of undefined (reading '__unsaved')
    at frappe.get_indicator (indicator.js:27:10)

Also I noticed that one filter is enabled automatically when am restarting the server.
There is no issues for other users. is there any alternative ways to edit pick columns for the particular user.

2

I changed data value manually in __UserSettings table(Mariadb). I think this is not the right way to do. I used the old data value from the previous backup. Problem solved but don’t know

  1. Why Pick columns in report view raised error?
  2. Why 504 gateway time out error?

Hope any one from the frappe community can answer.

Version:

ERPNext: v14.30.3 (main)
Frappe Framework: v14.60.0 (version-14)

UPDATE `__UserSettings`
SET `data` = '*******'
WHERE `user` = 'username' AND `doctype` = 'doctypename';