Show Users in Role giving error?

ERPNext Reports
1

In Setup->Role->Any Role-> Show Users. This error dialog is showing.
What can be the issue?

Traceback (most recent call last):
File “/Users/neha/Dev/frappe-bench/apps/frappe/frappe/app.py”, line 55, in application
response = frappe.handler.handle()
File “/Users/neha/Dev/frappe-bench/apps/frappe/frappe/handler.py”, line 19, in handle
execute_cmd(cmd)
File “/Users/neha/Dev/frappe-bench/apps/frappe/frappe/handler.py”, line 36, in execute_cmd
ret = frappe.call(method, **frappe.form_dict)
File “/Users/neha/Dev/frappe-bench/apps/frappe/frappe/init.py”, line 879, in call
return fn(*args, **newargs)
File “/Users/neha/Dev/frappe-bench/apps/frappe/frappe/desk/reportview.py”, line 16, in get
data = compress(execute(**args))
File “/Users/neha/Dev/frappe-bench/apps/frappe/frappe/desk/reportview.py”, line 21, in execute
return DatabaseQuery(doctype).execute(*args, **kwargs)
File “/Users/neha/Dev/frappe-bench/apps/frappe/frappe/model/db_query.py”, line 79, in execute
result = self.build_and_run()
File “/Users/neha/Dev/frappe-bench/apps/frappe/frappe/model/db_query.py”, line 103, in build_and_run
return frappe.db.sql(query, as_dict=not self.as_list, debug=self.debug, update=self.update)
File “/Users/neha/Dev/frappe-bench/apps/frappe/frappe/database.py”, line 148, in sql
self._cursor.execute(query)
File “/Users/neha/Dev/frappe-bench/env/lib/python2.7/site-packages/MySQLdb/cursors.py”, line 205, in execute
self.errorhandler(self, exc, value)
File “/Users/neha/Dev/frappe-bench/env/lib/python2.7/site-packages/MySQLdb/connections.py”, line 36, in defaulterrorhandler
raise errorclass, errorvalue
OperationalError: (1054, “Unknown column ‘tabUserRole.name as ‘UserRole:name’’ in ‘field list’”)

2

Working fine in my test account. Are you getting this error for custom Role?

@saurabh can you please check once?

3

No for Administrator. Issue is with columns. It is picking default columns and among them one column is invalid. Not able to figure out where these default columns for report present. For now solved it by removing that column.

4

Hello,

This is generally the case when Custom Field is selected in the report. And later Custom Field itself is deleted. Then it starts showing error in the report. For now, you have to remove that field as a Column from the Pick Column option.

Issue closed.