Impossible to load question in pulse

Hi,

I’m trying to add a question to a new pulse.
When I select the question, the loader starts but never ends even if the question only have one line and work perfectly when I open the question in another window.

I tried with other questions and some are working, but not every question loads in the pulse.

Thank you

Hi, does anybody have any info concerning this issue ?
Thank you.

Hi @alexkava85
Which version of Metabase? Please post “Diagnostic Info” from Admin > Troubleshooting.
Do you see any errors around the time of the failed loading? Admin > Troubleshooting > Logs

Hi @flamber, this is version 0.34.0
Here is the log file at the time of the loading
2020-02-11T15:47:38-05:00 ERROR metabase.middleware.log GET /api/pulse/preview_card_info/1896 500 2,0 s (18 DB calls) {:message "Unsupported field: MonthOfYear", :type java.time.temporal.UnsupportedTemporalTypeException, :stacktrace ("java.time.LocalTime.get0(LocalTime.java:679)" "java.time.LocalTime.getLong(LocalTime.java:656)" "java.time.OffsetTime.getLong(OffsetTime.java:534)" "java.time.format.DateTimePrintContext.getValue(DateTimePrintContext.java:298)" "java.time.format.DateTimeFormatterBuilder$TextPrinterParser.format(DateTimeFormatterBuilder.java:3092)" "java.time.format.DateTimeFormatterBuilder$CompositePrinterParser.format(DateTimeFormatterBuilder.java:2179)" "java.time.format.DateTimeFormatter.formatTo(DateTimeFormatter.java:1746)" "java.time.format.DateTimeFormatter.format(DateTimeFormatter.java:1720)" "java_time.format$format.invokeStatic(format.clj:50)" "java_time.format$format.invoke(format.clj:43)" "--> pulse.render.datetime$reformat_temporal_str.invokeStatic(datetime.clj:14)" "pulse.render.datetime$reformat_temporal_str.invoke(datetime.clj:13)" "pulse.render.datetime$format_temporal_str.invokeStatic(datetime.clj:33)" "pulse.render.datetime$format_temporal_str.invoke(datetime.clj:16)" "pulse.render.body$fn__32751$format_cell__32756$fn__32757.invoke(body.clj:46)" "pulse.render.body$fn__32751$format_cell__32756.invoke(body.clj:43)" "pulse.render.body$fn__32824$query_results__GT_row_seq__32829$fn__32830$iter__32831__32835$fn__32836$iter__32869__32873$fn__32874.invoke(body.clj:97)" "pulse.render.table$render_table_body$iter__32665__32669$fn__32670$iter__32703__32707$fn__32708.invoke(table.clj:75)" "api.pulse$fn__65440.invokeStatic(pulse.clj:166)" "api.pulse$fn__65440.invoke(pulse.clj:159)" "middleware.auth$enforce_authentication$fn__48819.invoke(auth.clj:14)" "routes$fn__67566$fn__67567.doInvoke(routes.clj:56)" "middleware.exceptions$catch_uncaught_exceptions$fn__48775.invoke(exceptions.clj:104)" "middleware.exceptions$catch_api_exceptions$fn__48772.invoke(exceptions.clj:92)" "middleware.log$log_api_call$fn__48685$fn__48686.invoke(log.clj:178)" "middleware.log$log_api_call$fn__48685.invoke(log.clj:172)" "middleware.security$add_security_headers$fn__48736.invoke(security.clj:121)" "middleware.json$wrap_json_body$fn__48904.invoke(json.clj:64)" "middleware.json$wrap_streamed_json_response$fn__48922.invoke(json.clj:100)" "middleware.session$bind_current_user$fn__47354$fn__47355.invoke(session.clj:209)" "middleware.session$do_with_current_user.invokeStatic(session.clj:184)" "middleware.session$do_with_current_user.invoke(session.clj:177)" "middleware.session$bind_current_user$fn__47354.invoke(session.clj:208)" "middleware.session$wrap_current_user_id$fn__47339.invoke(session.clj:161)" "middleware.session$wrap_session_id$fn__47283.invoke(session.clj:125)" "middleware.auth$wrap_api_key$fn__48827.invoke(auth.clj:27)" "middleware.misc$maybe_set_site_url$fn__48800.invoke(misc.clj:56)" "middleware.misc$bind_user_locale$fn__48803.invoke(misc.clj:72)" "middleware.misc$add_content_type$fn__48788.invoke(misc.clj:28)" "middleware.misc$disable_streaming_buffering$fn__48811.invoke(misc.clj:87)")}

Thank you

here the diagnostic info
{
“browser-info”: {
“language”: “fr-FR”,
“platform”: “MacIntel”,
“userAgent”: “Mozilla/5.0 (Macintosh; Intel Mac OS X 10_15_3) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/80.0.3987.87 Safari/537.36”,
“vendor”: “Google Inc.”
},
“system-info”: {
“java.runtime.name”: “Java™ SE Runtime Environment”,
“java.runtime.version”: “1.8.0_201-b09”,
“java.vendor”: “Oracle Corporation”,
“java.vendor.url”: “http://java.oracle.com/”,
“java.version”: “1.8.0_201”,
“java.vm.name”: “Java HotSpot™ 64-Bit Server VM”,
“java.vm.version”: “25.201-b09”,
“os.name”: “Linux”,
“os.version”: “4.15.0-72-generic”,
“user.language”: “en”,
“user.timezone”: “Etc/UTC”
},
“metabase-info”: {
“databases”: [
“sqlserver”,
“mysql”,
“h2”
],
“hosting-env”: “unknown”,
“application-database”: “h2”,
“run-mode”: “prod”,
“version”: {
“tag”: “v0.34.0”,
“date”: “2019-12-19”,
“branch”: “release-0.34.x”,
“hash”: “1335215”
},
“settings”: {
“report-timezone”: “Canada/Eastern”
}
}
}

@alexkava85
I would recommend that you upgrade to 0.34.2 - there’s several other issues fixed, not related to this.

Then you should migrate away from H2 as the application database:
https://www.metabase.com/docs/latest/operations-guide/migrating-from-h2.html

Which database are you querying in question ID 1896? And is it a Custom or Native question?
It gives the error Unsupported field: MonthOfYear, which I have never seen before, so do you know if there’s a column or variable/parameter in the question by that name?