When we are trying to execute a question, request is not going to the server. Not able to call DB.
Can anyone please help here?
Hi there,
difficult to help without more information.
Is your database up and running correctly?
Is your database correctly connected to Metabase?
Does any error message appear in the UI, or in the logs page?
Best
Hey Roberto
Thanks for the response.
Yes, my database is running fine.
We are facing an issue with one of our questions (metabase report), where we are using the Metabase UI to create a question with multiple custom columns.
Basically the page is not loading up and query is not going to the server from the browser and eventually page is getting stuck. That report is not even showing up in logs anywhere.
We have checked on different browsers on different systems, still issue is same. Not even able to see the editor for that report.
All other questions are working fine
Priya,
Can you share the diagnostic information for your Metabase instance? It's in Admin -> Troubleshooting -> Diagnostic Info.
If you open up the native SQL editor are you able to query these tables from Metabase?
Here is the Diagnostic Info :
{
"browser-info": {
"language": "en-GB",
"platform": "MacIntel",
"userAgent": "Mozilla/5.0 (Macintosh; Intel Mac OS X 10_15_7) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/126.0.0.0 Safari/537.36",
"vendor": "Google Inc."
},
"system-info": {
"file.encoding": "UTF-8",
"java.runtime.name": "OpenJDK Runtime Environment",
"java.runtime.version": "11.0.19+7-post-Ubuntu-0ubuntu118.04.1",
"java.vendor": "Ubuntu",
"java.vendor.url": "https://ubuntu.com/",
"java.version": "11.0.19",
"java.vm.name": "OpenJDK 64-Bit Server VM",
"java.vm.version": "11.0.19+7-post-Ubuntu-0ubuntu118.04.1",
"os.name": "Linux",
"os.version": "5.4.0-1103-aws",
"user.language": "en",
"user.timezone": "Etc/UTC"
},
"metabase-info": {
"databases": [
"databricks-sql",
"postgres",
"sparksql-databricks",
"snowflake"
],
"hosting-env": "unknown",
"application-database": "postgres",
"application-database-details": {
"database": {
"name": "PostgreSQL",
"version": "13.14"
},
"jdbc-driver": {
"name": "PostgreSQL JDBC Driver",
"version": "42.5.4"
}
},
"run-mode": "prod",
"version": {
"date": "2023-11-07",
"tag": "v0.47.7",
"branch": "?",
"hash": "dd51fd4"
},
"settings": {
"report-timezone": "Asia/Kolkata"
}
}
}
Yes, we are able to query these tables through SQL editor
Priya,
What visualization type is it? There were some problems with Pivot tables failing to load properly in the GUI that were patched in v48 and v49 - I'm wondering if that's what you're running into.
It is raw data, there is no visualisation.
Priya,
You mentioned that you cannot open a Metabase Question - if you have a Question saved then that question has a visualization type selected (table, line, bar, pivot etc). In your last message you said there is no visualization it's just raw data. I would like to help but I am a little bit confused about what path you are taking to get this error.
Do you mean that you cannot access the table at all through the data picker? For example, if you go to "Browse Data" then select the database does the table exist? If so, if you select the table are the fields in it listed?
Which database type is this table in? (Snowflake, Postgres, SQL Server, etc).
It has the table visualisation and we are using Databricks as database.
We are able to browse data and all other questions are also working fine, we are facing issues only with 1 question
Priya,
Is this a model (or built on a model)? Lately we have seen a few issue with losing metadata on models, like this one: Making a model with a native question that was "transformed" with "Explore results" will lead to model with no metadata · Issue #45146 · metabase/metabase · GitHub
If you recreate the question does it work? I am also curious about nay logs or errors you see in the network tab or console tab in dev tools when you navigate to the question. Do you see anything in the Metabase logs around the time you attempt to load the question?
No, it is not built on model. Question is directly created on a table.
We have tried to again re-create the question, new question is also not working.
On network tab, we are getting pending status and after some time throws error of no response. Also, that particular question is not showing up on metabase logs as well.