New Pulse reports don't render

Folks, I’ve created several (8) new Pulse reports, but when I attach the question to the pulse details, I only see the spinning “please wait” icon. I’m running the v0.37.4 release of Metabase connecting with a mySQL database. I can go to the original report and display it’s results, but adding it into the Pulse doesn’t want to work. I have about 30 different reports that do work correctly as a pulse, just not these latest ones.

One final detail - all of these reports that fail to “resolve” in the pulse settings screen return just 1 line of information.

Is anyone else seeing this issue with Metabase?

Thanks, Bill

Hi @bill.valaski
Please post “Diagnostic Info” from Admin > Troubleshooting.
And check the log for more details - Admin > Troubleshooting > Logs.

Here’s the diagnostic info:

{
“browser-info”: {
“language”: “en-US”,
“platform”: “Linux x86_64”,
“userAgent”: “Mozilla/5.0 (X11; Linux x86_64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/89.0.4389.72 Safari/537.36”,
“vendor”: “Google Inc.”
},
“system-info”: {
“file.encoding”: “UTF-8”,
“java.runtime.name”: “OpenJDK Runtime Environment”,
“java.runtime.version”: “11.0.7+10”,
“java.vendor”: “AdoptOpenJDK”,
“java.vendor.url”: “https://adoptopenjdk.net/”,
“java.version”: “11.0.7”,
“java.vm.name”: “OpenJDK 64-Bit Server VM”,
“java.vm.version”: “11.0.7+10”,
“os.name”: “Linux”,
“os.version”: “4.18.0-240.1.1.el8_3.x86_64”,
“user.language”: “en”,
“user.timezone”: “GMT”
},
“metabase-info”: {
“databases”: [
“mysql”
],
“hosting-env”: “unknown”,
“application-database”: “postgres”,
“application-database-details”: {
“database”: {
“name”: “PostgreSQL”,
“version”: “10.14”
},
“jdbc-driver”: {
“name”: “PostgreSQL JDBC Driver”,
“version”: “42.2.8”
}
},
“run-mode”: “prod”,
“version”: {
“date”: “2020-12-17”,
“tag”: “v0.37.4”,
“branch”: “release-x.37.x”,
“hash”: “e0d5287”
},
“settings”: {
“report-timezone”: “US/Eastern”
}
}
}

I’m re-scheduling the pulse for the next hourly tick - I’ll look at the troubleshooting logs once that completes.

Bill

OK, here’s the error from the pulse:

[1ee42c50-e5f7-4a8d-8766-ca8979dd7597] 2021-03-05T16:00:00-05:00 ERROR metabase.task.send-pulses Error sending Pulse 21
com.fasterxml.jackson.core.JsonParseException: Unrecognized token ‘day’: was expecting (JSON String, Number, Array, Object or token ‘null’, ‘true’ or ‘false’)
at [Source: (StringReader); line: 1, column: 4]
at com.fasterxml.jackson.core.JsonParser.constructError(JsonParser.java:1840)
at com.fasterxml.jackson.core.base.ParserMinimalBase.reportError(ParserMinimalBase.java:722)
at com.fasterxml.jackson.core.json.ReaderBasedJsonParser.reportInvalidToken(ReaderBasedJsonParser.java:2868)
at com.fasterxml.jackson.core.json.ReaderBasedJsonParser.handleOddValue(ReaderBasedJsonParser.java:1914)
at com.fasterxml.jackson.core.json.ReaderBasedJsonParser.nextToken(ReaderBasedJsonParser.java:773)
at cheshire.parse$parse.invokeStatic(parse.clj:90)
at cheshire.parse$parse.invoke(parse.clj:88)
at cheshire.core$parse_string.invokeStatic(core.clj:208)
at cheshire.core$parse_string.invoke(core.clj:194)
at cheshire.core$parse_string.invokeStatic(core.clj:204)
at cheshire.core$parse_string.invoke(core.clj:194)
at clojure.core$comp$fn__5807.invoke(core.clj:2569)
at clojure.core$comp$fn__5807.invoke(core.clj:2569)
at medley.core$map_keys$fn__1769$fn__1770.invoke(core.cljc:103)
at clojure.lang.PersistentArrayMap.kvreduce(PersistentArrayMap.java:377)
at clojure.core$fn__8437.invokeStatic(core.clj:6845)
at clojure.core$fn__8437.invoke(core.clj:6830)
at clojure.core.protocols$fn__8167$G__8162__8176.invoke(protocols.clj:175)
at clojure.core$reduce_kv.invokeStatic(core.clj:6856)
at clojure.core$reduce_kv.invoke(core.clj:6847)
at medley.core$reduce_map.invokeStatic(core.cljc:84)
at medley.core$reduce_map.invoke(core.cljc:81)
at medley.core$map_keys.invokeStatic(core.cljc:103)
at medley.core$map_keys.invoke(core.cljc:100)
at metabase.pulse.render.body$column_name.invokeStatic(body.clj:71)
at metabase.pulse.render.body$column_name.invoke(body.clj:67)
at metabase.pulse.render.body$query_results__GT_header_row$iter__48448__48452$fn__48453.invoke(body.clj:86)
at clojure.lang.LazySeq.sval(LazySeq.java:42)
at clojure.lang.LazySeq.seq(LazySeq.java:51)
at clojure.lang.RT.seq(RT.java:535)
at clojure.core$seq__5402.invokeStatic(core.clj:137)
at clojure.core$seq__5402.invoke(core.clj:137)
at metabase.pulse.render.table$render_table_head$iter__48289__48293$fn__48294.invoke(table.clj:83)
at clojure.lang.LazySeq.sval(LazySeq.java:42)
at clojure.lang.LazySeq.seq(LazySeq.java:51)
at clojure.lang.RT.seq(RT.java:535)
at clojure.core$seq__5402.invokeStatic(core.clj:137)
at clojure.core$map$fn__5866.invoke(core.clj:2746)
at clojure.lang.LazySeq.sval(LazySeq.java:42)
at clojure.lang.LazySeq.seq(LazySeq.java:51)
at clojure.lang.RT.seq(RT.java:535)
at clojure.core$seq__5402.invokeStatic(core.clj:137)
at clojure.core$apply.invokeStatic(core.clj:660)
at clojure.core$apply.invoke(core.clj:660)
at hiccup.compiler$fn__47637.invokeStatic(compiler.clj:88)
at hiccup.compiler$fn__47637.invoke(compiler.clj:82)
at hiccup.compiler$fn__47620$G__47615__47625.invoke(compiler.clj:68)
at clojure.core$map$fn__5866.invoke(core.clj:2753)
at clojure.lang.LazySeq.sval(LazySeq.java:42)
at clojure.lang.LazySeq.seq(LazySeq.java:51)
at clojure.lang.RT.seq(RT.java:535)
at clojure.core$seq__5402.invokeStatic(core.clj:137)
at clojure.core$apply.invokeStatic(core.clj:660)
at clojure.core$apply.invoke(core.clj:660)
at hiccup.compiler$fn__47637.invokeStatic(compiler.clj:88)
at hiccup.compiler$fn__47637.invoke(compiler.clj:82)
at hiccup.compiler$fn__47620$G__47615__47625.invoke(compiler.clj:68)
at hiccup.compiler$render_element.invokeStatic(compiler.clj:78)
at hiccup.compiler$render_element.invoke(compiler.clj:72)
at hiccup.compiler$fn__47635.invokeStatic(compiler.clj:85)
at hiccup.compiler$fn__47635.invoke(compiler.clj:82)
at hiccup.compiler$fn__47620$G__47615__47625.invoke(compiler.clj:68)
at clojure.core$map$fn__5866.invoke(core.clj:2753)
at clojure.lang.LazySeq.sval(LazySeq.java:42)
at clojure.lang.LazySeq.seq(LazySeq.java:51)
at clojure.lang.RT.seq(RT.java:535)
at clojure.core$seq__5402.invokeStatic(core.clj:137)
at clojure.core$apply.invokeStatic(core.clj:660)
at clojure.core$apply.invoke(core.clj:660)
at hiccup.compiler$fn__47637.invokeStatic(compiler.clj:88)
at hiccup.compiler$fn__47637.invoke(compiler.clj:82)
at hiccup.compiler$fn__47620$G__47615__47625.invoke(compiler.clj:68)
at hiccup.compiler$render_element.invokeStatic(compiler.clj:78)
at hiccup.compiler$render_element.invoke(compiler.clj:72)
at hiccup.compiler$fn__47635.invokeStatic(compiler.clj:85)
at hiccup.compiler$fn__47635.invoke(compiler.clj:82)
at hiccup.compiler$fn__47620$G__47615__47625.invoke(compiler.clj:68)
at clojure.core$map$fn__5866.invoke(core.clj:2753)
at clojure.lang.LazySeq.sval(LazySeq.java:42)
at clojure.lang.LazySeq.seq(LazySeq.java:51)
at clojure.lang.RT.seq(RT.java:535)
at clojure.core$seq__5402.invokeStatic(core.clj:137)
at clojure.core$apply.invokeStatic(core.clj:660)
at clojure.core$apply.invoke(core.clj:660)
at hiccup.compiler$fn__47637.invokeStatic(compiler.clj:88)
at hiccup.compiler$fn__47637.invoke(compiler.clj:82)
at hiccup.compiler$fn__47620$G__47615__47625.invoke(compiler.clj:68)
at hiccup.compiler$render_element.invokeStatic(compiler.clj:78)
at hiccup.compiler$render_element.invoke(compiler.clj:72)
at hiccup.compiler$fn__47635.invokeStatic(compiler.clj:85)
at hiccup.compiler$fn__47635.invoke(compiler.clj:82)
at hiccup.compiler$fn__47620$G__47615__47625.invoke(compiler.clj:68)
at clojure.core$map$fn__5866.invoke(core.clj:2753)
at clojure.lang.LazySeq.sval(LazySeq.java:42)
at clojure.lang.LazySeq.seq(LazySeq.java:51)
at clojure.lang.RT.seq(RT.java:535)
at clojure.core$seq__5402.invokeStatic(core.clj:137)
at clojure.core$apply.invokeStatic(core.clj:660)
at clojure.core$apply.invoke(core.clj:660)
at hiccup.compiler$fn__47637.invokeStatic(compiler.clj:88)
at hiccup.compiler$fn__47637.invoke(compiler.clj:82)
at hiccup.compiler$fn__47620$G__47615__47625.invoke(compiler.clj:68)
at hiccup.compiler$render_element.invokeStatic(compiler.clj:78)
at hiccup.compiler$render_element.invoke(compiler.clj:72)
at hiccup.compiler$fn__47635.invokeStatic(compiler.clj:85)
at hiccup.compiler$fn__47635.invoke(compiler.clj:82)
at hiccup.compiler$fn__47620$G__47615__47625.invoke(compiler.clj:68)
at clojure.core$map$fn__5866.invoke(core.clj:2755)
at clojure.lang.LazySeq.sval(LazySeq.java:42)
at clojure.lang.LazySeq.seq(LazySeq.java:51)
at clojure.lang.Cons.next(Cons.java:39)
at clojure.lang.RT.boundedLength(RT.java:1792)
at clojure.lang.RestFn.applyTo(RestFn.java:130)
at clojure.core$apply.invokeStatic(core.clj:665)
at clojure.core$apply.invoke(core.clj:660)
at hiccup.compiler$fn__47637.invokeStatic(compiler.clj:88)
at hiccup.compiler$fn__47637.invoke(compiler.clj:82)
at hiccup.compiler$fn__47620$G__47615__47625.invoke(compiler.clj:68)
at clojure.core$map$fn__5866.invoke(core.clj:2753)
at clojure.lang.LazySeq.sval(LazySeq.java:42)
at clojure.lang.LazySeq.seq(LazySeq.java:51)
at clojure.lang.RT.seq(RT.java:535)
at clojure.core$seq__5402.invokeStatic(core.clj:137)
at clojure.core$apply.invokeStatic(core.clj:660)
at clojure.core$apply.invoke(core.clj:660)
at hiccup.compiler$fn__47637.invokeStatic(compiler.clj:88)
at hiccup.compiler$fn__47637.invoke(compiler.clj:82)
at hiccup.compiler$fn__47620$G__47615__47625.invoke(compiler.clj:68)
at hiccup.compiler$render_element.invokeStatic(compiler.clj:78)
at hiccup.compiler$render_element.invoke(compiler.clj:72)
at hiccup.compiler$fn__47635.invokeStatic(compiler.clj:85)
at hiccup.compiler$fn__47635.invoke(compiler.clj:82)
at hiccup.compiler$fn__47620$G__47615__47625.invoke(compiler.clj:68)
at clojure.core$map$fn__5866.invoke(core.clj:2753)
at clojure.lang.LazySeq.sval(LazySeq.java:42)
at clojure.lang.LazySeq.seq(LazySeq.java:51)
at clojure.lang.RT.seq(RT.java:535)
at clojure.core$seq__5402.invokeStatic(core.clj:137)
at clojure.core$apply.invokeStatic(core.clj:660)
at clojure.core$apply.invoke(core.clj:660)
at hiccup.compiler$fn__47637.invokeStatic(compiler.clj:88)
at hiccup.compiler$fn__47637.invoke(compiler.clj:82)
at hiccup.compiler$fn__47620$G__47615__47625.invoke(compiler.clj:68)
at hiccup.compiler$render_element.invokeStatic(compiler.clj:78)
at hiccup.compiler$render_element.invoke(compiler.clj:72)
at hiccup.compiler$fn__47635.invokeStatic(compiler.clj:85)
at hiccup.compiler$fn__47635.invoke(compiler.clj:82)
at hiccup.compiler$fn__47620$G__47615__47625.invoke(compiler.clj:68)
at clojure.core$map$fn__5866.invoke(core.clj:2753)
at clojure.lang.LazySeq.sval(LazySeq.java:42)
at clojure.lang.LazySeq.seq(LazySeq.java:51)
at clojure.lang.RT.seq(RT.java:535)
at clojure.core$seq__5402.invokeStatic(core.clj:137)
at clojure.core$apply.invokeStatic(core.clj:660)
at clojure.core$apply.invoke(core.clj:660)
at hiccup.compiler$fn__47637.invokeStatic(compiler.clj:88)
at hiccup.compiler$fn__47637.invoke(compiler.clj:82)
at hiccup.compiler$fn__47620$G__47615__47625.invoke(compiler.clj:68)
at hiccup.compiler$render_element.invokeStatic(compiler.clj:78)
at hiccup.compiler$render_element.invoke(compiler.clj:72)
at hiccup.compiler$fn__47635.invokeStatic(compiler.clj:85)
at hiccup.compiler$fn__47635.invoke(compiler.clj:82)
at hiccup.compiler$fn__47620$G__47615__47625.invoke(compiler.clj:68)
at clojure.lang.Var.invoke(Var.java:384)
at metabase.email.messages$render_message_body.invokeStatic(messages.clj:366)
at metabase.email.messages$render_message_body.invoke(messages.clj:362)
at metabase.email.messages$render_pulse_email.invokeStatic(messages.clj:380)
at metabase.email.messages$render_pulse_email.invoke(messages.clj:377)
at metabase.pulse$fn__69612.invokeStatic(pulse.clj:180)
at metabase.pulse$fn__69612.invoke(pulse.clj:170)
at clojure.lang.MultiFn.invoke(MultiFn.java:239)
at metabase.pulse$results__GT_notifications$iter__69644__69648$fn__69649.invoke(pulse.clj:224)
at clojure.lang.LazySeq.sval(LazySeq.java:42)
at clojure.lang.LazySeq.seq(LazySeq.java:51)
at clojure.lang.RT.seq(RT.java:535)
at clojure.core$seq__5402.invokeStatic(core.clj:137)
at clojure.core$seq__5402.invoke(core.clj:137)
at metabase.pulse$send_notifications_BANG
.invokeStatic(pulse.clj:262)
at metabase.pulse$send_notifications_BANG
.invoke(pulse.clj:261)
at metabase.pulse$send_pulse_BANG
.invokeStatic(pulse.clj:288)
at metabase.pulse$send_pulse_BANG
.doInvoke(pulse.clj:270)
at clojure.lang.RestFn.invoke(RestFn.java:439)
at metabase.task.send_pulses$fn__78696$send_pulses_BANG___78705$fn__78708$fn__78726$fn__78727.invoke(send_pulses.clj:59)
at metabase.models.task_history$fn__40573$do_with_task_history__40578$fn__40579.invoke(task_history.clj:77)
at metabase.models.task_history$fn__40573$do_with_task_history__40578.invoke(task_history.clj:72)
at metabase.task.send_pulses$fn__78696$send_pulses_BANG___78705$fn__78708$fn__78726.invoke(send_pulses.clj:56)
at metabase.task.send_pulses$fn__78696$send_pulses_BANG___78705$fn__78708.invoke(send_pulses.clj:55)
at metabase.task.send_pulses$fn__78696$send_pulses_BANG___78705.invoke(send_pulses.clj:42)
at metabase.task.send_pulses$fn__78696$send_pulses_BANG___78705$fn__78706.invoke(send_pulses.clj:49)
at metabase.task.send_pulses$fn__78696$send_pulses_BANG___78705.invoke(send_pulses.clj:42)
at metabase.task.send_pulses.SendPulses$fn__78762.invoke(send_pulses.clj:100)
at metabase.models.task_history$fn__40573$do_with_task_history__40578$fn__40579.invoke(task_history.clj:77)
at metabase.models.task_history$fn__40573$do_with_task_history__40578.invoke(task_history.clj:72)
at metabase.task.send_pulses.SendPulses.execute(send_pulses.clj:86)
at org.quartz.core.JobRunShell.run(JobRunShell.java:213)
at org.quartz.simpl.SimpleThreadPool$WorkerThread.run(SimpleThreadPool.java:557)
[1ee42c50-e5f7-4a8d-8766-ca8979dd7597] 2021-03-05T16:00:00-05:00 ERROR metabase.driver.sql-jdbc.execute Failed to set timezone ‘US/Eastern’ for :mysql database
java.sql.SQLTransientConnectionException: (conn=1275) Unknown or incorrect time zone: ‘US/Eastern’
at org.mariadb.jdbc.internal.util.exceptions.ExceptionFactory.createException(ExceptionFactory.java:79)
at org.mariadb.jdbc.internal.util.exceptions.ExceptionFactory.create(ExceptionFactory.java:153)
at org.mariadb.jdbc.MariaDbStatement.executeExceptionEpilogue(MariaDbStatement.java:274)
at org.mariadb.jdbc.MariaDbStatement.executeInternal(MariaDbStatement.java:363)
at org.mariadb.jdbc.MariaDbStatement.execute(MariaDbStatement.java:501)
at com.mchange.v2.c3p0.impl.NewProxyStatement.execute(NewProxyStatement.java:75)
at metabase.driver.sql_jdbc.execute$set_time_zone_if_supported_BANG_.invokeStatic(execute.clj:127)
at metabase.driver.sql_jdbc.execute$set_time_zone_if_supported_BANG_.invoke(execute.clj:112)
at metabase.driver.sql_jdbc.execute$fn__76510.invokeStatic(execute.clj:159)
at metabase.driver.sql_jdbc.execute$fn__76510.invoke(execute.clj:154)
at clojure.lang.MultiFn.invoke(MultiFn.java:239)
at metabase.driver.sql_jdbc.execute$execute_reducible_query.invokeStatic(execute.clj:388)
at metabase.driver.sql_jdbc.execute$execute_reducible_query.invoke(execute.clj:376)
at metabase.driver.sql_jdbc.execute$execute_reducible_query.invokeStatic(execute.clj:385)
at metabase.driver.sql_jdbc.execute$execute_reducible_query.invoke(execute.clj:376)
at metabase.driver.sql_jdbc$fn__78125.invokeStatic(sql_jdbc.clj:49)
at metabase.driver.sql_jdbc$fn__78125.invoke(sql_jdbc.clj:47)
at clojure.lang.MultiFn.invoke(MultiFn.java:244)
at metabase.query_processor.context$executef.invokeStatic(context.clj:59)
at metabase.query_processor.context$executef.invoke(context.clj:48)
at metabase.query_processor.context.default$default_runf.invokeStatic(default.clj:69)
at metabase.query_processor.context.default$default_runf.invoke(default.clj:67)
at metabase.query_processor.context$runf.invokeStatic(context.clj:45)
at metabase.query_processor.context$runf.invoke(context.clj:39)
at metabase.query_processor.reducible$pivot.invokeStatic(reducible.clj:34)
at metabase.query_processor.reducible$pivot.invoke(reducible.clj:31)
at metabase.query_processor.middleware.mbql_to_native$mbql__GT_native$fn__44124.invoke(mbql_to_native.clj:26)
at metabase.query_processor.middleware.check_features$check_features$fn__43400.invoke(check_features.clj:42)
at metabase.query_processor.middleware.optimize_datetime_filters$optimize_datetime_filters$fn__44289.invoke(optimize_datetime_filters.clj:133)
at metabase.query_processor.middleware.auto_parse_filter_values$auto_parse_filter_values$fn__42201.invoke(auto_parse_filter_values.clj:44)
at metabase.query_processor.middleware.wrap_value_literals$wrap_value_literals$fn__45855.invoke(wrap_value_literals.clj:149)
at metabase.query_processor.middleware.annotate$add_column_info$fn__41956.invoke(annotate.clj:575)
at metabase.query_processor.middleware.permissions$check_query_permissions$fn__43275.invoke(permissions.clj:70)
at metabase.query_processor.middleware.pre_alias_aggregations$pre_alias_aggregations$fn__44807.invoke(pre_alias_aggregations.clj:40)
at metabase.query_processor.middleware.cumulative_aggregations$handle_cumulative_aggregations$fn__43473.invoke(cumulative_aggregations.clj:61)
at metabase.query_processor.middleware.resolve_joined_fields$resolve_joined_fields$fn__45044.invoke(resolve_joined_fields.clj:36)
at metabase.query_processor.middleware.resolve_joins$resolve_joins$fn__45363.invoke(resolve_joins.clj:183)
at metabase.query_processor.middleware.add_implicit_joins$add_implicit_joins$fn__37681.invoke(add_implicit_joins.clj:254)
at metabase.query_processor.middleware.large_int_id$convert_id_to_string$fn__44085.invoke(large_int_id.clj:44)
at metabase.query_processor.middleware.limit$limit$fn__44110.invoke(limit.clj:38)
at metabase.query_processor.middleware.format_rows$format_rows$fn__44065.invoke(format_rows.clj:75)
at metabase.query_processor.middleware.desugar$desugar$fn__43539.invoke(desugar.clj:22)
at metabase.query_processor.middleware.binning$update_binning_strategy$fn__42560.invoke(binning.clj:229)
at metabase.query_processor.middleware.resolve_fields$resolve_fields$fn__43077.invoke(resolve_fields.clj:24)
at metabase.query_processor.middleware.add_dimension_projections$add_remapping$fn__37225.invoke(add_dimension_projections.clj:316)
at metabase.query_processor.middleware.add_implicit_clauses$add_implicit_clauses$fn__37432.invoke(add_implicit_clauses.clj:141)
at metabase.query_processor.middleware.add_source_metadata$add_source_metadata_for_source_queries$fn__37830.invoke(add_source_metadata.clj:105)
at metabase.query_processor.middleware.reconcile_breakout_and_order_by_bucketing$reconcile_breakout_and_order_by_bucketing$fn__45004.invoke(reconcile_breakout_and_order_by_bucketing.clj:98)
at metabase.query_processor.middleware.auto_bucket_datetimes$auto_bucket_datetimes$fn__42148.invoke(auto_bucket_datetimes.clj:140)
at metabase.query_processor.middleware.resolve_source_table$resolve_source_tables$fn__43124.invoke(resolve_source_table.clj:46)
at metabase.query_processor.middleware.parameters$substitute_parameters$fn__44789.invoke(parameters.clj:114)
at metabase.query_processor.middleware.resolve_referenced$resolve_referenced_card_resources$fn__43176.invoke(resolve_referenced.clj:80)
at metabase.query_processor.middleware.expand_macros$expand_macros$fn__43795.invoke(expand_macros.clj:158)
at metabase.query_processor.middleware.add_timezone_info$add_timezone_info$fn__37861.invoke(add_timezone_info.clj:15)
at metabase.query_processor.middleware.splice_params_in_response$splice_params_in_response$fn__45725.invoke(splice_params_in_response.clj:32)
at metabase.query_processor.middleware.resolve_database_and_driver$resolve_database_and_driver$fn__45015$fn__45019.invoke(resolve_database_and_driver.clj:33)
at metabase.driver$do_with_driver.invokeStatic(driver.clj:61)
at metabase.driver$do_with_driver.invoke(driver.clj:57)
at metabase.query_processor.middleware.resolve_database_and_driver$resolve_database_and_driver$fn__45015.invoke(resolve_database_and_driver.clj:27)
at metabase.query_processor.middleware.fetch_source_query$resolve_card_id_source_tables$fn__44013.invoke(fetch_source_query.clj:267)
at metabase.query_processor.middleware.store$initialize_store$fn__45734$fn__45735.invoke(store.clj:11)
at metabase.query_processor.store$do_with_store.invokeStatic(store.clj:46)
at metabase.query_processor.store$do_with_store.invoke(store.clj:40)
at metabase.query_processor.middleware.store$initialize_store$fn__45734.invoke(store.clj:10)
at metabase.query_processor.middleware.cache$maybe_return_cached_results$fn__43053.invoke(cache.clj:214)
at metabase.query_processor.middleware.validate$validate_query$fn__45743.invoke(validate.clj:10)
at metabase.query_processor.middleware.normalize_query$normalize$fn__44137.invoke(normalize_query.clj:22)
at metabase.query_processor.middleware.add_rows_truncated$add_rows_truncated$fn__37699.invoke(add_rows_truncated.clj:36)
at metabase.query_processor.middleware.results_metadata$record_and_return_metadata_BANG_$fn__45710.invoke(results_metadata.clj:147)
at metabase.query_processor.middleware.constraints$add_default_userland_constraints$fn__43416.invoke(constraints.clj:42)
at metabase.query_processor.middleware.process_userland_query$process_userland_query$fn__44878.invoke(process_userland_query.clj:136)
at metabase.query_processor.middleware.catch_exceptions$catch_exceptions$fn__43359.invoke(catch_exceptions.clj:174)
at metabase.query_processor.reducible$async_qp$qp_STAR___36488$thunk__36489.invoke(reducible.clj:103)
at metabase.query_processor.reducible$async_qp$qp_STAR___36488.invoke(reducible.clj:109)
at metabase.query_processor.reducible$async_qp$qp_STAR___36488.invoke(reducible.clj:96)
at metabase.query_processor.reducible$sync_qp$qp_STAR___36497$fn__36498.invoke(reducible.clj:131)
at metabase.query_processor.reducible$sync_qp$qp_STAR___36497.invoke(reducible.clj:130)
at clojure.lang.AFn.applyToHelper(AFn.java:154)
at clojure.lang.AFn.applyTo(AFn.java:144)
at clojure.core$apply.invokeStatic(core.clj:667)
at clojure.core$apply.invoke(core.clj:660)
at metabase.query_processor$process_userland_query.invokeStatic(query_processor.clj:237)
at metabase.query_processor$process_userland_query.doInvoke(query_processor.clj:233)
at clojure.lang.RestFn.invoke(RestFn.java:410)
at metabase.query_processor$fn__45901$process_query_and_save_execution_BANG___45910$fn__45911.invoke(query_processor.clj:246)
at metabase.query_processor$fn__45901$process_query_and_save_execution_BANG___45910.invoke(query_processor.clj:241)
at metabase.query_processor$fn__45945$process_query_and_save_with_max_results_constraints_BANG___45954$fn__45955.invoke(query_processor.clj:258)
at metabase.query_processor$fn__45945$process_query_and_save_with_max_results_constraints_BANG___45954.invoke(query_processor.clj:254)
at metabase.pulse$execute_card$process_query__69498.invoke(pulse.clj:41)
at metabase.pulse$execute_card$fn__69500.invoke(pulse.clj:50)
at metabase.middleware.session$do_with_current_user.invokeStatic(session.clj:260)
at metabase.middleware.session$do_with_current_user.invoke(session.clj:252)
at metabase.pulse$execute_card.invokeStatic(pulse.clj:49)
at metabase.pulse$execute_card.doInvoke(pulse.clj:30)
at clojure.lang.RestFn.invoke(RestFn.java:464)
at metabase.pulse$pulse__GT_notifications$iter__69662__69666$fn__69667.invoke(pulse.clj:231)
at clojure.lang.LazySeq.sval(LazySeq.java:42)
at clojure.lang.LazySeq.seq(LazySeq.java:51)
at clojure.lang.LazySeq.first(LazySeq.java:73)
at clojure.lang.RT.first(RT.java:692)
at clojure.core$first__5384.invokeStatic(core.clj:55)
at clojure.core$first__5384.invoke(core.clj:55)
at metabase.pulse$fn__69612.invokeStatic(pulse.clj:176)
at metabase.pulse$fn__69612.invoke(pulse.clj:170)
at clojure.lang.MultiFn.invoke(MultiFn.java:239)
at metabase.pulse$results__GT_notifications$iter__69644__69648$fn__69649.invoke(pulse.clj:224)
at clojure.lang.LazySeq.sval(LazySeq.java:42)
at clojure.lang.LazySeq.seq(LazySeq.java:51)
at clojure.lang.RT.seq(RT.java:535)
at clojure.core$seq__5402.invokeStatic(core.clj:137)
at clojure.core$seq__5402.invoke(core.clj:137)
at metabase.pulse$send_notifications_BANG_.invokeStatic(pulse.clj:262)
at metabase.pulse$send_notifications_BANG_.invoke(pulse.clj:261)
at metabase.pulse$send_pulse_BANG_.invokeStatic(pulse.clj:288)
at metabase.pulse$send_pulse_BANG_.doInvoke(pulse.clj:270)
at clojure.lang.RestFn.invoke(RestFn.java:439)
at metabase.task.send_pulses$fn__78696$send_pulses_BANG___78705$fn__78708$fn__78726$fn__78727.invoke(send_pulses.clj:59)
at metabase.models.task_history$fn__40573$do_with_task_history__40578$fn__40579.invoke(task_history.clj:77)
at metabase.models.task_history$fn__40573$do_with_task_history__40578.invoke(task_history.clj:72)
at metabase.task.send_pulses$fn__78696$send_pulses_BANG___78705$fn__78708$fn__78726.invoke(send_pulses.clj:56)
at metabase.task.send_pulses$fn__78696$send_pulses_BANG___78705$fn__78708.invoke(send_pulses.clj:55)
at metabase.task.send_pulses$fn__78696$send_pulses_BANG___78705.invoke(send_pulses.clj:42)
at metabase.task.send_pulses$fn__78696$send_pulses_BANG___78705$fn__78706.invoke(send_pulses.clj:49)
at metabase.task.send_pulses$fn__78696$send_pulses_BANG___78705.invoke(send_pulses.clj:42)
at metabase.task.send_pulses.SendPulses$fn__78762.invoke(send_pulses.clj:100)
at metabase.models.task_history$fn__40573$do_with_task_history__40578$fn__40579.invoke(task_history.clj:77)
at metabase.models.task_history$fn__40573$do_with_task_history__40578.invoke(task_history.clj:72)
at metabase.task.send_pulses.SendPulses.execute(send_pulses.clj:86)
at org.quartz.core.JobRunShell.run(JobRunShell.java:213)
at org.quartz.simpl.SimpleThreadPool$WorkerThread.run(SimpleThreadPool.java:557)
Caused by: org.mariadb.jdbc.internal.util.exceptions.MariaDbSqlException: Unknown or incorrect time zone: ‘US/Eastern’
at org.mariadb.jdbc.internal.util.exceptions.MariaDbSqlException.of(MariaDbSqlException.java:34)
at org.mariadb.jdbc.internal.protocol.AbstractQueryProtocol.exceptionWithQuery(AbstractQueryProtocol.java:194)
at org.mariadb.jdbc.internal.protocol.AbstractQueryProtocol.executeQuery(AbstractQueryProtocol.java:262)
at org.mariadb.jdbc.MariaDbStatement.executeInternal(MariaDbStatement.java:357)
… 126 more
Caused by: java.sql.SQLException: Unknown or incorrect time zone: ‘US/Eastern’
at org.mariadb.jdbc.internal.protocol.AbstractQueryProtocol.readErrorPacket(AbstractQueryProtocol.java:1688)
at org.mariadb.jdbc.internal.protocol.AbstractQueryProtocol.readPacket(AbstractQueryProtocol.java:1550)
at org.mariadb.jdbc.internal.protocol.AbstractQueryProtocol.getResult(AbstractQueryProtocol.java:1513)
at org.mariadb.jdbc.internal.protocol.AbstractQueryProtocol.executeQuery(AbstractQueryProtocol.java:256)

Hmmmm, the “day” token that’s causing my error is part of a where clause in the SQL:

where calevt.pc_eventDate between subdate(date(now()),day(now())-1) AND subdate(date(now()),1)

The “funny” thing is it works fine when running the question directly, just not in the pulse.

Bill

@bill.valaski
Which version of MySQL are you using?
And is pc_eventDate just a regular DATE column type?
Pulses are using it’s own rendering engine, so it’s not the same as just querying the question.
I doubt the problem is in your WHERE-clause, I’m sure it’s in the SELECT-clause or the actual column types returned.

@flamber
10.3.27-MariaDB MariaDB Server

calevt.pc_eventDate is a “date” value, not “datetime”

I’m open to any other suggestions for troubleshooting this query?
Thanks, Bill

@bill.valaski So do you return a column called day in your SELECT-clause?
Try creating a new question with exact same query and see if that works. I think there might be a problem with old column information causing a problem with the visualization_settings, but you would have to look in the application database (Postgres in your case) table report_card.visualization_settings and compare the new vs the broken question.

@flamber thanks for your suggestions. I determined that the where clause I was using was no longer valid - it was trying to apply “between” on the same date. The original query had the user manually select the starting and ending dates, but this “version” just returns the results from the records entered yesterday. By simplifying the query to

calevt.pc_eventDate = DATE_SUB(CURDATE(), INTERVAL 1 DAY)

I could then see the results displayed properly in the Pulse details rather than the spinning “calculating” pointer. Thanks for your help!

Bill