The metabase is not able to process a report and gets timed out after 20mins , The same query when executed in ssms takes 1 min.
The same query works for some other filter. however it would slightly take more time around 18mins to fetch the results in metabase, but executes in ssms within 1 min.
So would like to know why is it taking so much of time to publish the results in metabase?
Is there any configurations needs to be done for the same.
I get below error from the network browser response log
"via": [
{
"type": "clojure.lang.ExceptionInfo",
"message": "Timed out after 20.0 mins.",
"data": {
"status": "timed-out",
"type": "timed-out"
},
"at": [
"metabase.query_processor.context.default$default_timeoutf",
"invokeStatic",
"default.clj",
90
]
}
The below were the 2 errors in the console after 20min
react-dom.production.min.js:209 TypeError: Cannot read properties of undefined (reading 'map')
at C (index.js:115:26)
at index.js:93:21
at Array.map (<anonymous>)
at _ (index.js:91:21)
at a.value (Visualization.jsx:141:37)
at a.value (Visualization.jsx:82:10)
at So (react-dom.production.min.js:137:128)
at Ua (react-dom.production.min.js:176:159)
at xs (react-dom.production.min.js:263:490)
at Sc (react-dom.production.min.js:246:265)
index.js:115 Uncaught (in promise) TypeError: Cannot read properties of undefined (reading 'map')
at C (index.js:115:26)
at index.js:93:21
at Array.map (<anonymous>)
at _ (index.js:91:21)
at a.value (Visualization.jsx:141:37)
at a.value (Visualization.jsx:82:10)
at So (react-dom.production.min.js:137:128)
at Ua (react-dom.production.min.js:176:159)
at xs (react-dom.production.min.js:263:490)
at Sc (react-dom.production.min.js:246:265)
Please find the Diagonistic info
{
"browser-info": {
"language": "en-US",
"platform": "Win32",
"userAgent": "Mozilla/5.0 (Windows NT 10.0; Win64; x64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/122.0.0.0 Safari/537.36",
"vendor": "Google Inc."
},
"system-info": {
"file.encoding": "UTF-8",
"java.runtime.name": "Java(TM) SE Runtime Environment",
"java.runtime.version": "11.0.22+9-LTS-219",
"java.vendor": "Oracle Corporation",
"java.vendor.url": "https://openjdk.java.net/",
"java.version": "11.0.22",
"java.vm.name": "Java HotSpot(TM) 64-Bit Server VM",
"java.vm.version": "11.0.22+9-LTS-219",
"os.name": "Linux",
"os.version": "3.10.0-1062.9.1.el7.x86_64",
"user.language": "en",
"user.timezone": "Asia/Kolkata"
},
"metabase-info": {
"databases": [
"sqlserver",
"postgres"
],
"hosting-env": "unknown",
"application-database": "postgres",
"application-database-details": {
"database": {
"name": "PostgreSQL",
"version": "11.8"
},
"jdbc-driver": {
"name": "PostgreSQL JDBC Driver",
"version": "42.5.4"
}
},
"run-mode": "prod",
"version": {
"date": "2023-09-07",
"tag": "v0.47.1",
"branch": "release-x.47.x",
"hash": "bd278b9"
},
"settings": {
"report-timezone": "Asia/Calcutta"
}
}