On a Dashboard, When we click the question title (left hand corner), the question cannot be shown to download detail data after input the filter value. We are using the latest version 34.3.
Remarks : the report is very large with over 100 columns.
Please help.
Hi @hilaryfu
What type of question is it? Native or Custom? If Custom, is it based on a Saved Question?
Do you see any errors either in the Metabase log (Admin > Troubleshooting > Logs) or browser developer console?
It is a Native Query Question(select from a complex view). There are no error shown on Metabase log. It is just like the clicking action have not been invoked.
Moreover, before input the filtering value (no record will be displayed or selected), it can shown the original question with empty result set.
@hilaryfu I cannot reproduce this.
How have you setup the filters? Which type of filters and do they have a default value?
Can you reproduce this with Sample Dataset? Can you provide steps-to-reproduce?
The filter is data field type without default value. Only one filter is text value with default values.
@flamber, is there limit of the length of the SQL statement? I have changed the SQL from [select columns list] (there are around 150 columns) to [Select * ] from a view. It have been solved. Please advise.
@hilaryfu There shouldn’t be any limitations on the amount of columns (besides the builtin of your database).
Please post “Diagnostic Info” from Admin > Troubleshooting.
And check for any errors, when you have 150 columns, in Admin > Troubleshooting > Logs, or your browser developer console.
I have post the last few minutes log for you. The question ID is 47 for my problem question
[301d2dc4-512a-469a-b668-f36e46e76388] 2020-03-02T21:40:51+08:00 DEBUG metabase.middleware.log GET /api/session/properties 200 2.8 ms (1 DB calls) Jetty threads: 4/50 (3 idle, 0 queued) (63 total active threads) Queries in flight: 0
[301d2dc4-512a-469a-b668-f36e46e76388] 2020-03-02T21:40:51+08:00 DEBUG metabase.middleware.log GET /api/setup/admin_checklist 200 9.1 ms (11 DB calls) Jetty threads: 4/50 (3 idle, 0 queued) (65 total active threads) Queries in flight: 0
[301d2dc4-512a-469a-b668-f36e46e76388] 2020-03-02T21:40:51+08:00 DEBUG metabase.middleware.log GET /api/setting 200 522.3 µs (0 DB calls) Jetty threads: 4/50 (3 idle, 0 queued) (65 total active threads) Queries in flight: 0
[301d2dc4-512a-469a-b668-f36e46e76388] 2020-03-02T21:40:55+08:00 DEBUG metabase.middleware.log GET /api/util/bug_report_details 200 2.0 ms (1 DB calls) Jetty threads: 4/50 (3 idle, 0 queued) (65 total active threads) Queries in flight: 0
[301d2dc4-512a-469a-b668-f36e46e76388] 2020-03-02T21:43:12+08:00 DEBUG metabase.middleware.log GET /api/collection/root/items 200 11.4 ms (6 DB calls) Jetty threads: 4/50 (3 idle, 0 queued) (65 total active threads) Queries in flight: 0
[301d2dc4-512a-469a-b668-f36e46e76388] 2020-03-02T21:43:12+08:00 DEBUG metabase.middleware.log GET /api/collection/root 200 4.2 ms (2 DB calls) Jetty threads: 4/50 (3 idle, 0 queued) (65 total active threads) Queries in flight: 0
[301d2dc4-512a-469a-b668-f36e46e76388] 2020-03-02T21:43:15+08:00 DEBUG metabase.middleware.log GET /api/collection/3 200 3.4 ms (3 DB calls) Jetty threads: 4/50 (3 idle, 0 queued) (65 total active threads) Queries in flight: 0
[301d2dc4-512a-469a-b668-f36e46e76388] 2020-03-02T21:43:15+08:00 DEBUG metabase.middleware.log GET /api/collection/3/items 200 7.3 ms (7 DB calls) Jetty threads: 4/50 (3 idle, 0 queued) (65 total active threads) Queries in flight: 0
[301d2dc4-512a-469a-b668-f36e46e76388] 2020-03-02T21:43:16+08:00 DEBUG metabase.middleware.log GET /api/collection/13 200 7.7 ms (4 DB calls) Jetty threads: 4/50 (3 idle, 0 queued) (65 total active threads) Queries in flight: 0
[301d2dc4-512a-469a-b668-f36e46e76388] 2020-03-02T21:43:21+08:00 DEBUG metabase.middleware.log GET /api/card/47 200 6.9 ms (6 DB calls) Jetty threads: 4/50 (3 idle, 0 queued) (65 total active threads) Queries in flight: 0
[301d2dc4-512a-469a-b668-f36e46e76388] 2020-03-02T21:43:24+08:00 DEBUG metabase.middleware.log GET /api/alert/question/47 200 1.3 ms (1 DB calls) Jetty threads: 4/50 (3 idle, 0 queued) (65 total active threads) Queries in flight: 0
[301d2dc4-512a-469a-b668-f36e46e76388] 2020-03-02T21:43:25+08:00 DEBUG metabase.middleware.log POST /api/card/47/query 200 [ASYNC: completed] 57.4 ms (16 DB calls) Jetty threads: 3/50 (3 idle, 0 queued) (65 total active threads) Queries in flight: 0
[301d2dc4-512a-469a-b668-f36e46e76388] 2020-03-02T21:43:38+08:00 DEBUG metabase.middleware.log GET /api/field/2704 200 6.6 ms (7 DB calls) Jetty threads: 5/50 (2 idle, 0 queued) (65 total active threads) Queries in flight: 0
[301d2dc4-512a-469a-b668-f36e46e76388] 2020-03-02T21:43:38+08:00 DEBUG metabase.middleware.log GET /api/table/98/query_metadata 200 21.6 ms (9 DB calls) Jetty threads: 6/50 (1 idle, 0 queued) (65 total active threads) Queries in flight: 0
[301d2dc4-512a-469a-b668-f36e46e76388] 2020-03-02T21:43:38+08:00 DEBUG metabase.middleware.log GET /api/field/2623 200 4.8 ms (6 DB calls) Jetty threads: 6/50 (1 idle, 0 queued) (65 total active threads) Queries in flight: 0
[301d2dc4-512a-469a-b668-f36e46e76388] 2020-03-02T21:43:38+08:00 DEBUG metabase.middleware.log GET /api/field/2651 200 7.4 ms (6 DB calls) Jetty threads: 6/50 (1 idle, 0 queued) (67 total active threads) Queries in flight: 0
[301d2dc4-512a-469a-b668-f36e46e76388] 2020-03-02T21:43:38+08:00 DEBUG metabase.middleware.log GET /api/field/2658 200 5.3 ms (6 DB calls) Jetty threads: 4/50 (2 idle, 0 queued) (68 total active threads) Queries in flight: 0
[301d2dc4-512a-469a-b668-f36e46e76388] 2020-03-02T21:44:00+08:00 INFO metabase.api.card Card results metadata passed in to API is VALID. Thanks!
[301d2dc4-512a-469a-b668-f36e46e76388] 2020-03-02T21:44:00+08:00 DEBUG metabase.async.util Running metabase.api.card$update_card_async_BANG_$fn__48002@341a1cb7 on separate thread…
[301d2dc4-512a-469a-b668-f36e46e76388] 2020-03-02T21:44:00+08:00 DEBUG metabase.middleware.log PUT /api/card/47 200 [ASYNC: completed] 44.3 ms (10 DB calls) Jetty threads: 3/50 (2 idle, 0 queued) (68 total active threads) Queries in flight: 1
[301d2dc4-512a-469a-b668-f36e46e76388] 2020-03-02T21:44:01+08:00 DEBUG metabase.middleware.log GET /api/alert/question/47 200 1.3 ms (1 DB calls) Jetty threads: 4/50 (2 idle, 0 queued) (68 total active threads) Queries in flight: 0
[301d2dc4-512a-469a-b668-f36e46e76388] 2020-03-02T21:44:12+08:00 DEBUG metabase.middleware.log GET /api/collection/13 200 4.1 ms (4 DB calls) Jetty threads: 4/50 (2 idle, 0 queued) (68 total active threads) Queries in flight: 0
[301d2dc4-512a-469a-b668-f36e46e76388] 2020-03-02T21:44:12+08:00 DEBUG metabase.middleware.log GET /api/collection/13/items 200 7.8 ms (8 DB calls) Jetty threads: 4/50 (2 idle, 0 queued) (68 total active threads) Queries in flight: 0
[301d2dc4-512a-469a-b668-f36e46e76388] 2020-03-02T21:44:19+08:00 DEBUG metabase.middleware.log GET /api/dashboard/12 200 17.6 ms (14 DB calls) Jetty threads: 4/50 (2 idle, 0 queued) (68 total active threads) Queries in flight: 0
[301d2dc4-512a-469a-b668-f36e46e76388] 2020-03-02T21:44:24+08:00 DEBUG metabase.middleware.log POST /api/card/8/query 200 [ASYNC: completed] 37.8 ms (11 DB calls) Jetty threads: 3/50 (2 idle, 0 queued) (68 total active threads) Queries in flight: 3
[301d2dc4-512a-469a-b668-f36e46e76388] 2020-03-02T21:44:24+08:00 DEBUG metabase.middleware.log POST /api/card/45/query 200 [ASYNC: completed] 40.7 ms (10 DB calls) Jetty threads: 3/50 (2 idle, 0 queued) (68 total active threads) Queries in flight: 2
[301d2dc4-512a-469a-b668-f36e46e76388] 2020-03-02T21:44:24+08:00 DEBUG metabase.middleware.log POST /api/card/46/query 200 [ASYNC: completed] 41.6 ms (14 DB calls) Jetty threads: 3/50 (2 idle, 0 queued) (68 total active threads) Queries in flight: 1
[301d2dc4-512a-469a-b668-f36e46e76388] 2020-03-02T21:44:24+08:00 DEBUG metabase.middleware.log POST /api/card/47/query 200 [ASYNC: completed] 60.1 ms (15 DB calls) Jetty threads: 3/50 (2 idle, 0 queued) (68 total active threads) Queries in flight: 0
[301d2dc4-512a-469a-b668-f36e46e76388] 2020-03-02T21:44:30+08:00 DEBUG metabase.middleware.log POST /api/card/8/query 200 [ASYNC: completed] 38.8 ms (10 DB calls) Jetty threads: 3/50 (2 idle, 0 queued) (68 total active threads) Queries in flight: 3
[301d2dc4-512a-469a-b668-f36e46e76388] 2020-03-02T21:44:30+08:00 DEBUG metabase.middleware.log POST /api/card/45/query 200 [ASYNC: completed] 39.8 ms (10 DB calls) Jetty threads: 3/50 (2 idle, 0 queued) (68 total active threads) Queries in flight: 2
[301d2dc4-512a-469a-b668-f36e46e76388] 2020-03-02T21:44:30+08:00 DEBUG metabase.middleware.log POST /api/card/46/query 200 [ASYNC: completed] 207.8 ms (15 DB calls) Jetty threads: 3/50 (2 idle, 0 queued) (68 total active threads) Queries in flight: 1
[301d2dc4-512a-469a-b668-f36e46e76388] 2020-03-02T21:44:36+08:00 DEBUG metabase.middleware.log POST /api/card/47/query 200 [ASYNC: completed] 6.2 s (15 DB calls) Jetty threads: 3/50 (2 idle, 0 queued) (68 total active threads) Queries in flight: 0
[301d2dc4-512a-469a-b668-f36e46e76388] 2020-03-02T21:44:55+08:00 DEBUG metabase.middleware.log GET /api/session/properties 200 3.2 ms (1 DB calls) Jetty threads: 5/50 (2 idle, 0 queued) (66 total active threads) Queries in flight: 0
[301d2dc4-512a-469a-b668-f36e46e76388] 2020-03-02T21:44:55+08:00 DEBUG metabase.middleware.log GET /api/setup/admin_checklist 200 10.5 ms (11 DB calls) Jetty threads: 4/50 (2 idle, 0 queued) (66 total active threads) Queries in flight: 0
[301d2dc4-512a-469a-b668-f36e46e76388] 2020-03-02T21:44:55+08:00 DEBUG metabase.middleware.log GET /api/setting 200 489.1 µs (0 DB calls) Jetty threads: 4/50 (2 idle, 0 queued) (66 total active threads) Queries in flight: 0
[301d2dc4-512a-469a-b668-f36e46e76388] 2020-03-02T21:44:57+08:00 DEBUG metabase.middleware.log GET /api/util/bug_report_details 200 1.9 ms (1 DB calls) Jetty threads: 4/50 (2 idle, 0 queued) (66 total active threads) Queries in flight: 0
@hilaryfu There’s no error in getting the question, but I don’t know if you have changed it to SELECT * already.
Please post “Diagnostic Info” from Admin > Troubleshooting.
And check you browser developer console for errors.
I have rollback and click again before posting log for you
{
“browser-info”: {
“language”: “en-US”,
“platform”: “Win32”,
“userAgent”: “Mozilla/5.0 (Windows NT 10.0; Win64; x64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/70.0.3538.102 Safari/537.36 Edge/18.18363”,
“vendor”: “”
},
“system-info”: {
“java.runtime.name”: “Java™ SE Runtime Environment”,
“java.runtime.version”: “1.8.0_231-b11”,
“java.vendor”: “Oracle Corporation”,
“java.vendor.url”: “http://java.oracle.com/”,
“java.version”: “1.8.0_231”,
“java.vm.name”: “Java HotSpot™ 64-Bit Server VM”,
“java.vm.version”: “25.231-b11”,
“os.name”: “Linux”,
“os.version”: “3.10.0-1062.4.3.el7.x86_64”,
“user.language”: “en”,
“user.timezone”: “Etc/GMT”
},
“metabase-info”: {
“databases”: [
“mysql”
],
“hosting-env”: “unknown”,
“application-database”: “mysql”,
“run-mode”: “prod”,
“version”: {
“tag”: “v0.33.6”,
“date”: “2019-11-19”,
“branch”: “release-0.33.x”,
“hash”: “be1e0e1”
},
“settings”: {
“report-timezone”: null
}
}
}
I have fallback to version 33.6 as well
@hilaryfu So you posted a log, when everything was working? Yeah, that’s not going to help figuring out what’s wrong. And check your browser developer console for errors too, if you don’t see any errors in the Metabase log.
I don’t understand what you mean by “I have fallback to version 33.6 as well” ?