search

frappe / insights

Open source analytics / business intelligence tool (BI)
https://frappe.io/insights
GNU Affero General Public License v3.0
406 stars 199 forks source link

Insights is connected to the DB but it not loading the UI #288

Open kitunzit opened 1 month ago

kitunzit commented 1 month ago

Good day. Insight app has connected to the MariaDB, on the second step/window showing " Help Us improve" i press skip & two messages are displayed " internal server error" & "Syncing Data source. This may take a while. Please wait....". See attached image. Am running ERPNext 15 hosted on cloud clusters. Any help will be appreciated. Thanks Image 31-07-2024 at 12 07 PM

nextchamp-saqib commented 1 month ago

Please share the traceback from the browser console. To do that open the browser console after you get "Internal Sever Error" and send the last error message

sunil-mel commented 1 week ago

I was also getting same error with postgresdb. Attached screenshot of the error message from the logs. I modified the code in the file insights_data_source_v3.py line 62 as below to make it work.

self.db_set("is_frappe_db", 0)

image

Next it was failing in the file ibis_utils.py line 388. I replaced with below code to make it work.

res = res.replace({pd.NaT: None, np.nan: None})