Validation Error While Selecting Table to Create Query in Workbook

[Kathir-1995]

I have my own EC2 instance running Frappe version 15.47.2 and Insights version 3.0.6. Yesterday, I created some queries, charts, and dashboards. However, today I am encountering a validation error when trying to open an existing dashboard, and I am unable to create new queries. Below is the error I faced on the following API,

API: api/method/insights.api.workbooks.fetch_query_results

Error:

Traceback (most recent call last):
File "/home/ubuntu/frappe-bench/apps/insights/insights/insights/doctype/insights_data_source_v3/ibis_utils.py", line 34, in build
self.query = self.perform_operation(operation)
File "/home/ubuntu/frappe-bench/apps/insights/insights/insights/doctype/insights_data_source_v3/ibis_utils.py", line 44, in perform_operation
return self.apply_source(operation)
File "/home/ubuntu/frappe-bench/apps/insights/insights/insights/doctype/insights_data_source_v3/ibis_utils.py", line 104, in apply_source
return self.get_table_or_query(source_args.table)
File "/home/ubuntu/frappe-bench/apps/insights/insights/insights/doctype/insights_data_source_v3/ibis_utils.py", line 79, in get_table_or_query
_table = InsightsTablev3.get_ibis_table(
File "/home/ubuntu/frappe-bench/apps/insights/insights/insights/doctype/insights_table_v3/insights_table_v3.py", line 60, in get_ibis_table
t = ds.get_ibis_table(table_name)
File "/home/ubuntu/frappe-bench/apps/insights/insights/insights/doctype/insights_data_source_v3/insights_data_source_v3.py", line 280, in get_ibis_table
remote_db = self._get_ibis_backend()
File "/home/ubuntu/frappe-bench/apps/insights/insights/insights/doctype/insights_data_source_v3/insights_data_source_v3.py", line 179, in _get_ibis_backend
print(f"Connected to {self.name} ({self.title})")
BrokenPipeError: [Errno 32] Broken pipe

During handling of the above exception, another exception occurred:

Traceback (most recent call last):
File "/home/ubuntu/frappe-bench/apps/frappe/frappe/app.py", line 114, in application
response = frappe.api.handle(request)
File "/home/ubuntu/frappe-bench/apps/frappe/frappe/api/init.py", line 49, in handle
data = endpoint(**arguments)
File "/home/ubuntu/frappe-bench/apps/frappe/frappe/api/v1.py", line 36, in handle_rpc_call
return frappe.handler.handle()
File "/home/ubuntu/frappe-bench/apps/frappe/frappe/handler.py", line 49, in handle
data = execute_cmd(cmd)
File "/home/ubuntu/frappe-bench/apps/frappe/frappe/handler.py", line 85, in execute_cmd
return frappe.call(method, **frappe.form_dict)
File "/home/ubuntu/frappe-bench/apps/frappe/frappe/init.py", line 1781, in call
return fn(*args, **newargs)
File "/home/ubuntu/frappe-bench/apps/frappe/frappe/utils/typing_validations.py", line 31, in wrapper
return func(*args, **kwargs)
File "/home/ubuntu/frappe-bench/apps/insights/insights/decorators.py", line 18, in wrapper
return function(*args, **kwargs)
File "/home/ubuntu/frappe-bench/apps/insights/insights/decorators.py", line 167, in wrapper
return function(*args, **kwargs)
File "/home/ubuntu/frappe-bench/apps/insights/insights/api/workbooks.py", line 17, in fetch_query_results
ibis_query = IbisQueryBuilder().build(operations, use_live_connection)
File "/home/ubuntu/frappe-bench/apps/insights/insights/insights/doctype/insights_data_source_v3/ibis_utils.py", line 37, in build
frappe.throw(
File "/home/ubuntu/frappe-bench/apps/frappe/frappe/init.py", line 658, in throw
msgprint(
File "/home/ubuntu/frappe-bench/apps/frappe/frappe/init.py", line 623, in msgprint
_raise_exception()
File "/home/ubuntu/frappe-bench/apps/frappe/frappe/init.py", line 574, in _raise_exception
raise exc
frappe.exceptions.ValidationError: Invalid Source Operation at position 1: [Errno 32] Broken pipe

During handling of the above exception, another exception occurred:

Traceback (most recent call last):
File "/home/ubuntu/frappe-bench/apps/frappe/frappe/middlewares.py", line 16, in call
return super().call(environ, start_response)
File "/home/ubuntu/frappe-bench/env/lib/python3.10/site-packages/werkzeug/middleware/shared_data.py", line 250, in call
return self.app(environ, start_response)
File "/home/ubuntu/frappe-bench/env/lib/python3.10/site-packages/werkzeug/middleware/shared_data.py", line 250, in call
return self.app(environ, start_response)
File "/home/ubuntu/frappe-bench/apps/frappe/frappe/app.py", line 79, in application
app(environ, start_response),
File "/home/ubuntu/frappe-bench/env/lib/python3.10/site-packages/werkzeug/wrappers/request.py", line 190, in application
resp = f(*args[:-2] + (request,))
File "/home/ubuntu/frappe-bench/apps/frappe/frappe/app.py", line 132, in application
response = handle_exception(e)
File "/home/ubuntu/frappe-bench/apps/frappe/frappe/app.py", line 334, in handle_exception
response = frappe.utils.response.report_error(http_status_code)
File "/home/ubuntu/frappe-bench/apps/frappe/frappe/utils/response.py", line 48, in report_error
frappe.errprint(traceback)
File "/home/ubuntu/frappe-bench/apps/frappe/frappe/init.py", line 506, in errprint
print(msg)
BrokenPipeError: [Errno 32] Broken pipe

Screenshot:

[nextchamp-saqib]

It could be a problem with your database connection. Can you check if the data source status is "active"?

[Kathir-1995]

Data source status is Active only. I need another one clarification. Do i need to use main branch as version or shall i use version 3 branch?

[nextchamp-saqib]

Use the version-3 branch. The main branch only gets fixes and no new features.

Regarding the error, can you try connecting another data source and check? Or there should be a default data source for the site database (the database where your site points to) Can you try creating a query on this data source and check if the error persists?