Pulse fails with: Unsupported field: MonthOfYear

Nishya · June 22, 2021, 12:08pm

Hi @flamber,
I am getting the below error while sending email. But I couldn't find any problem with the date field as such. Can you please help me here?

cause "Unsupported field: MonthOfYear",
 :message "Unsupported field: MonthOfYear"

flamber · June 22, 2021, 12:18pm

Hi @Nishya
You were seeing a different problem.

Post "Diagnostic Info" from Admin > Troubleshooting.
Post the full stacktrace from Admin > Troubleshooting > Logs.
How is the question constructed - GUI, SQL or combination of both? Can you post the query.

Nishya · June 22, 2021, 12:23pm

Here the log,
unfortunately I couldn't share the GUI or SQL coz it contains PII.

[39c4e81e-5c01-4cbf-980b-cfbf5621ed8b] 2021-06-22T14:21:03+02:00 ERROR metabase.server.middleware.log POST /api/pulse/test 500 113.9 ms (14 DB calls)
{:via
[{:type java.time.temporal.UnsupportedTemporalTypeException,
:message "Unsupported field: MonthOfYear",
:at [java.time.LocalTime get0 nil -1]}],
:trace
[[java.time.LocalTime get0 nil -1]
[java.time.LocalTime getLong nil -1]
[java.time.OffsetTime getLong nil -1]
[java.time.format.DateTimePrintContext getValue nil -1]
[java.time.format.DateTimeFormatterBuilder$TextPrinterParser format nil -1]
[java.time.format.DateTimeFormatterBuilder$CompositePrinterParser format nil -1]
[java.time.format.DateTimeFormatter formatTo nil -1]
[java.time.format.DateTimeFormatter format nil -1]
[java_time.format$format invokeStatic "format.clj" 51]
[java_time.format$format invoke "format.clj" 44]
[metabase.pulse.render.datetime$reformat_temporal_str invokeStatic "datetime.clj" 14]
[metabase.pulse.render.datetime$reformat_temporal_str invoke "datetime.clj" 13]
[metabase.pulse.render.datetime$format_temporal_str invokeStatic "datetime.clj" 35]
[metabase.pulse.render.datetime$format_temporal_str invoke "datetime.clj" 16]
[metabase.pulse.render.body$fn__49992$format_cell__49997$fn__49998 invoke "body.clj" 47]
[metabase.pulse.render.body$fn__49992$format_cell__49997 invoke "body.clj" 44]
[metabase.pulse.render.body$fn__50072$query_results__GT_row_seq__50077$fn__50081$iter__50083__50087$fn__50088$iter__50122__50126$fn__50127
invoke
"body.clj"
117]
[clojure.lang.LazySeq sval "LazySeq.java" 42]
[clojure.lang.LazySeq seq "LazySeq.java" 51]
[clojure.lang.RT seq "RT.java" 535]
[clojure.core$seq__5402 invokeStatic "core.clj" 137]
[clojure.core$map_indexed$mapi__8548$fn__8549 invoke "core.clj" 7301]
[clojure.lang.LazySeq sval "LazySeq.java" 42]
[clojure.lang.LazySeq seq "LazySeq.java" 51]
[clojure.lang.RT seq "RT.java" 535]
[clojure.core$seq__5402 invokeStatic "core.clj" 137]
[clojure.core$seq__5402 invoke "core.clj" 137]
[metabase.pulse.render.table$render_table_body$iter__49900__49904$fn__49905$iter__49939__49943$fn__49944
invoke
"table.clj"
115]
[clojure.lang.LazySeq sval "LazySeq.java" 42]
[clojure.lang.LazySeq seq "LazySeq.java" 51]
[clojure.lang.RT seq "RT.java" 535]
[clojure.core$seq__5402 invokeStatic "core.clj" 137]
[clojure.core$map$fn__5866 invoke "core.clj" 2746]
[clojure.lang.LazySeq sval "LazySeq.java" 42]
[clojure.lang.LazySeq seq "LazySeq.java" 51]
[clojure.lang.Cons next "Cons.java" 39]
[clojure.lang.RT next "RT.java" 713]
[clojure.core$next__5386 invokeStatic "core.clj" 64]
[clojure.core$str$fn__5466 invoke "core.clj" 557]
[clojure.core$str invokeStatic "core.clj" 555]
[clojure.core$str doInvoke "core.clj" 544]
[clojure.lang.RestFn applyTo "RestFn.java" 139]
[clojure.core$apply invokeStatic "core.clj" 665]
[clojure.core$apply invoke "core.clj" 660]
[hiccup.compiler$fn__49232 invokeStatic "compiler.clj" 88]
[hiccup.compiler$fn__49232 invoke "compiler.clj" 82]
[hiccup.compiler$fn__49215$G__49210__49220 invoke "compiler.clj" 68]
[clojure.core$map$fn__5866 invoke "core.clj" 2753]
[clojure.lang.LazySeq sval "LazySeq.java" 42]
[clojure.lang.LazySeq seq "LazySeq.java" 51]
[clojure.lang.RT seq "RT.java" 535]
[clojure.core$seq__5402 invokeStatic "core.clj" 137]
[clojure.core$apply invokeStatic "core.clj" 660]
[clojure.core$apply invoke "core.clj" 660]
[hiccup.compiler$fn__49232 invokeStatic "compiler.clj" 88]
[hiccup.compiler$fn__49232 invoke "compiler.clj" 82]
[hiccup.compiler$fn__49215$G__49210__49220 invoke "compiler.clj" 68]
[hiccup.compiler$render_element invokeStatic "compiler.clj" 78]
[hiccup.compiler$render_element invoke "compiler.clj" 72]
[hiccup.compiler$fn__49230 invokeStatic "compiler.clj" 85]
[hiccup.compiler$fn__49230 invoke "compiler.clj" 82]
[hiccup.compiler$fn__49215$G__49210__49220 invoke "compiler.clj" 68]
[clojure.core$map$fn__5866 invoke "core.clj" 2755]
[clojure.lang.LazySeq sval "LazySeq.java" 42]
[clojure.lang.LazySeq seq "LazySeq.java" 51]
[clojure.lang.RT seq "RT.java" 535]
[clojure.core$seq__5402 invokeStatic "core.clj" 137]
[clojure.core$apply invokeStatic "core.clj" 660]
[clojure.core$apply invoke "core.clj" 660]
[hiccup.compiler$fn__49232 invokeStatic "compiler.clj" 88]
[hiccup.compiler$fn__49232 invoke "compiler.clj" 82]
[hiccup.compiler$fn__49215$G__49210__49220 invoke "compiler.clj" 68]
[clojure.core$map$fn__5866 invoke "core.clj" 2753]
[clojure.lang.LazySeq sval "LazySeq.java" 42]
[clojure.lang.LazySeq seq "LazySeq.java" 51]
[clojure.lang.RT seq "RT.java" 535]
[clojure.core$seq__5402 invokeStatic "core.clj" 137]
[clojure.core$apply invokeStatic "core.clj" 660]
[clojure.core$apply invoke "core.clj" 660]
[hiccup.compiler$fn__49232 invokeStatic "compiler.clj" 88]
[hiccup.compiler$fn__49232 invoke "compiler.clj" 82]
[hiccup.compiler$fn__49215$G__49210__49220 invoke "compiler.clj" 68]
[hiccup.compiler$render_element invokeStatic "compiler.clj" 78]
[hiccup.compiler$render_element invoke "compiler.clj" 72]
[hiccup.compiler$fn__49230 invokeStatic "compiler.clj" 85]
[hiccup.compiler$fn__49230 invoke "compiler.clj" 82]
[hiccup.compiler$fn__49215$G__49210__49220 invoke "compiler.clj" 68]
[clojure.core$map$fn__5866 invoke "core.clj" 2753]
[clojure.lang.LazySeq sval "LazySeq.java" 42]
[clojure.lang.LazySeq seq "LazySeq.java" 51]
[clojure.lang.RT seq "RT.java" 535]
[clojure.core$seq__5402 invokeStatic "core.clj" 137]
[clojure.core$apply invokeStatic "core.clj" 660]
[clojure.core$apply invoke "core.clj" 660]
[hiccup.compiler$fn__49232 invokeStatic "compiler.clj" 88]
[hiccup.compiler$fn__49232 invoke "compiler.clj" 82]
[hiccup.compiler$fn__49215$G__49210__49220 invoke "compiler.clj" 68]
[hiccup.compiler$render_element invokeStatic "compiler.clj" 78]
[hiccup.compiler$render_element invoke "compiler.clj" 72]
[hiccup.compiler$fn__49230 invokeStatic "compiler.clj" 85]
[hiccup.compiler$fn__49230 invoke "compiler.clj" 82]
[hiccup.compiler$fn__49215$G__49210__49220 invoke "compiler.clj" 68]
[clojure.core$map$fn__5866 invoke "core.clj" 2753]
[clojure.lang.LazySeq sval "LazySeq.java" 42]
[clojure.lang.LazySeq seq "LazySeq.java" 51]
[clojure.lang.RT seq "RT.java" 535]
[clojure.core$seq__5402 invokeStatic "core.clj" 137]
[clojure.core$apply invokeStatic "core.clj" 660]
[clojure.core$apply invoke "core.clj" 660]
[hiccup.compiler$fn__49232 invokeStatic "compiler.clj" 88]
[hiccup.compiler$fn__49232 invoke "compiler.clj" 82]
[hiccup.compiler$fn__49215$G__49210__49220 invoke "compiler.clj" 68]
[hiccup.compiler$render_element invokeStatic "compiler.clj" 78]
[hiccup.compiler$render_element invoke "compiler.clj" 72]
[hiccup.compiler$fn__49230 invokeStatic "compiler.clj" 85]
[hiccup.compiler$fn__49230 invoke "compiler.clj" 82]
[hiccup.compiler$fn__49215$G__49210__49220 invoke "compiler.clj" 68]
[clojure.core$map$fn__5866 invoke "core.clj" 2755]
[clojure.lang.LazySeq sval "LazySeq.java" 42]
[clojure.lang.LazySeq seq "LazySeq.java" 51]
[clojure.lang.Cons next "Cons.java" 39]
[clojure.lang.RT boundedLength "RT.java" 1792]
[clojure.lang.RestFn applyTo "RestFn.java" 130]
[clojure.core$apply invokeStatic "core.clj" 665]
[clojure.core$apply invoke "core.clj" 660]
[hiccup.compiler$fn__49232 invokeStatic "compiler.clj" 88]
[hiccup.compiler$fn__49232 invoke "compiler.clj" 82]
[hiccup.compiler$fn__49215$G__49210__49220 invoke "compiler.clj" 68]
[clojure.core$map$fn__5866 invoke "core.clj" 2753]
[clojure.lang.LazySeq sval "LazySeq.java" 42]
[clojure.lang.LazySeq seq "LazySeq.java" 51]
[clojure.lang.RT seq "RT.java" 535]
[clojure.core$seq__5402 invokeStatic "core.clj" 137]
[clojure.core$apply invokeStatic "core.clj" 660]
[clojure.core$apply invoke "core.clj" 660]
[hiccup.compiler$fn__49232 invokeStatic "compiler.clj" 88]
[hiccup.compiler$fn__49232 invoke "compiler.clj" 82]
[hiccup.compiler$fn__49215$G__49210__49220 invoke "compiler.clj" 68]
[hiccup.compiler$render_element invokeStatic "compiler.clj" 78]
[hiccup.compiler$render_element invoke "compiler.clj" 72]
[hiccup.compiler$fn__49230 invokeStatic "compiler.clj" 85]
[hiccup.compiler$fn__49230 invoke "compiler.clj" 82]
[hiccup.compiler$fn__49215$G__49210__49220 invoke "compiler.clj" 68]
[clojure.core$map$fn__5866 invoke "core.clj" 2753]
[clojure.lang.LazySeq sval "LazySeq.java" 42]
[clojure.lang.LazySeq seq "LazySeq.java" 51]
[clojure.lang.RT seq "RT.java" 535]
[clojure.core$seq__5402 invokeStatic "core.clj" 137]
[clojure.core$apply invokeStatic "core.clj" 660]
[clojure.core$apply invoke "core.clj" 660]
[hiccup.compiler$fn__49232 invokeStatic "compiler.clj" 88]
[hiccup.compiler$fn__49232 invoke "compiler.clj" 82]
[hiccup.compiler$fn__49215$G__49210__49220 invoke "compiler.clj" 68]
[hiccup.compiler$render_element invokeStatic "compiler.clj" 78]
[hiccup.compiler$render_element invoke "compiler.clj" 72]
[hiccup.compiler$fn__49230 invokeStatic "compiler.clj" 85]
[hiccup.compiler$fn__49230 invoke "compiler.clj" 82]
[hiccup.compiler$fn__49215$G__49210__49220 invoke "compiler.clj" 68]
[clojure.core$map$fn__5866 invoke "core.clj" 2753]
[clojure.lang.LazySeq sval "LazySeq.java" 42]
[clojure.lang.LazySeq seq "LazySeq.java" 51]
[clojure.lang.RT seq "RT.java" 535]
[clojure.core$seq__5402 invokeStatic "core.clj" 137]
[clojure.core$apply invokeStatic "core.clj" 660]
[clojure.core$apply invoke "core.clj" 660]
[hiccup.compiler$fn__49232 invokeStatic "compiler.clj" 88]
[hiccup.compiler$fn__49232 invoke "compiler.clj" 82]
[hiccup.compiler$fn__49215$G__49210__49220 invoke "compiler.clj" 68]
[hiccup.compiler$render_element invokeStatic "compiler.clj" 78]
[hiccup.compiler$render_element invoke "compiler.clj" 72]
[hiccup.compiler$fn__49230 invokeStatic "compiler.clj" 85]
[hiccup.compiler$fn__49230 invoke "compiler.clj" 82]
[hiccup.compiler$fn__49215$G__49210__49220 invoke "compiler.clj" 68]
[clojure.lang.Var invoke "Var.java" 384]
[metabase.email.messages$render_message_body invokeStatic "messages.clj" 368]
[metabase.email.messages$render_message_body invoke "messages.clj" 365]
[metabase.email.messages$render_pulse_email invokeStatic "messages.clj" 382]
[metabase.email.messages$render_pulse_email invoke "messages.clj" 379]
[metabase.pulse$fn__70588 invokeStatic "pulse.clj" 221]
[metabase.pulse$fn__70588 invoke "pulse.clj" 212]
[clojure.lang.MultiFn invoke "MultiFn.java" 239]
[metabase.pulse$results__GT_notifications$iter__70620__70624$fn__70625 invoke "pulse.clj" 265]
[clojure.lang.LazySeq sval "LazySeq.java" 42]
[clojure.lang.LazySeq seq "LazySeq.java" 51]
[clojure.lang.RT seq "RT.java" 535]
[clojure.core$seq__5402 invokeStatic "core.clj" 137]
[clojure.core$seq__5402 invoke "core.clj" 137]
[metabase.pulse$send_notifications_BANG_ invokeStatic "pulse.clj" 307]
[metabase.pulse$send_notifications_BANG_ invoke "pulse.clj" 306]
[metabase.pulse$send_pulse_BANG_ invokeStatic "pulse.clj" 333]
[metabase.pulse$send_pulse_BANG_ doInvoke "pulse.clj" 315]
[clojure.lang.RestFn invoke "RestFn.java" 410]
[metabase.api.pulse$fn__71150 invokeStatic "pulse.clj" 212]
[metabase.api.pulse$fn__71150 invoke "pulse.clj" 201]
[compojure.core$wrap_response$fn__1996 invoke "core.clj" 160]
[compojure.core$wrap_route_middleware$fn__1980 invoke "core.clj" 132]
[compojure.core$wrap_route_info$fn__1985 invoke "core.clj" 139]
[compojure.core$wrap_route_matches$fn__1989 invoke "core.clj" 151]
[compojure.core$routes$fn__2008$f__2009 invoke "core.clj" 198]
[compojure.core$routes$fn__2008$f__2009$respond_SINGLEQUOTE___2010 invoke "core.clj" 197]
[compojure.core$wrap_route_matches$fn__1989 invoke "core.clj" 153]
[compojure.core$routes$fn__2008$f__2009 invoke "core.clj" 198]
[compojure.core$routes$fn__2008$f__2009$respond_SINGLEQUOTE___2010 invoke "core.clj" 197]
[compojure.core$wrap_route_matches$fn__1989 invoke "core.clj" 153]
[compojure.core$routes$fn__2008$f__2009 invoke "core.clj" 198]
[compojure.core$routes$fn__2008$f__2009$respond_SINGLEQUOTE___2010 invoke "core.clj" 197]
[compojure.core$wrap_route_matches$fn__1989 invoke "core.clj" 153]
[compojure.core$routes$fn__2008$f__2009 invoke "core.clj" 198]
[compojure.core$routes$fn__2008$f__2009$respond_SINGLEQUOTE___2010 invoke "core.clj" 197]
[compojure.core$wrap_route_matches$fn__1989 invoke "core.clj" 152]
[compojure.core$routes$fn__2008$f__2009 invoke "core.clj" 198]
[compojure.core$routes$fn__2008 invoke "core.clj" 200]
[metabase.server.middleware.auth$enforce_authentication$fn__73892 invoke "auth.clj" 14]
[compojure.core$routes$fn__2008$f__2009 invoke "core.clj" 198]
[compojure.core$routes$fn__2008 invoke "core.clj" 200]
[compojure.core$make_context$handler__2036 invoke "core.clj" 287]
[compojure.core$make_context$fn__2038 invoke "core.clj" 296]
[compojure.core$routes$fn__2008$f__2009 invoke "core.clj" 198]
[compojure.core$routes$fn__2008$f__2009$respond_SINGLEQUOTE___2010 invoke "core.clj" 197]
[compojure.core$make_context$fn__2038 invoke "core.clj" 297]
[compojure.core$routes$fn__2008$f__2009 invoke "core.clj" 198]
[compojure.core$routes$fn__2008$f__2009$respond_SINGLEQUOTE___2010 invoke "core.clj" 197]
[compojure.core$make_context$fn__2038 invoke "core.clj" 297]
[compojure.core$routes$fn__2008$f__2009 invoke "core.clj" 198]
[compojure.core$routes$fn__2008$f__2009$respond_SINGLEQUOTE___2010 invoke "core.clj" 197]
[compojure.core$make_context$fn__2038 invoke "core.clj" 297]
[compojure.core$routes$fn__2008$f__2009 invoke "core.clj" 198]
[compojure.core$routes$fn__2008$f__2009$respond_SINGLEQUOTE___2010 invoke "core.clj" 197]
[compojure.core$make_context$fn__2038 invoke "core.clj" 297]
[compojure.core$routes$fn__2008$f__2009 invoke "core.clj" 198]
[compojure.core$routes$fn__2008$f__2009$respond_SINGLEQUOTE___2010 invoke "core.clj" 197]
[compojure.core$make_context$fn__2038 invoke "core.clj" 297]
[compojure.core$routes$fn__2008$f__2009 invoke "core.clj" 198]
[compojure.core$routes$fn__2008$f__2009$respond_SINGLEQUOTE___2010 invoke "core.clj" 197]
[compojure.core$make_context$fn__2038 invoke "core.clj" 297]
[compojure.core$routes$fn__2008$f__2009 invoke "core.clj" 198]
[compojure.core$routes$fn__2008$f__2009$respond_SINGLEQUOTE___2010 invoke "core.clj" 197]
[compojure.core$make_context$fn__2038 invoke "core.clj" 297]
[compojure.core$routes$fn__2008$f__2009 invoke "core.clj" 198]
[compojure.core$routes$fn__2008$f__2009$respond_SINGLEQUOTE___2010 invoke "core.clj" 197]
[compojure.core$make_context$fn__2038 invoke "core.clj" 297]
[compojure.core$routes$fn__2008$f__2009 invoke "core.clj" 198]
[compojure.core$routes$fn__2008$f__2009$respond_SINGLEQUOTE___2010 invoke "core.clj" 197]
[compojure.core$make_context$fn__2038 invoke "core.clj" 297]
[compojure.core$routes$fn__2008$f__2009 invoke "core.clj" 198]
[compojure.core$routes$fn__2008$f__2009$respond_SINGLEQUOTE___2010 invoke "core.clj" 197]
[compojure.core$make_context$fn__2038 invoke "core.clj" 297]
[compojure.core$routes$fn__2008$f__2009 invoke "core.clj" 198]
[compojure.core$routes$fn__2008$f__2009$respond_SINGLEQUOTE___2010 invoke "core.clj" 197]
[compojure.core$make_context$fn__2038 invoke "core.clj" 297]
[compojure.core$routes$fn__2008$f__2009 invoke "core.clj" 198]
[compojure.core$routes$fn__2008$f__2009$respond_SINGLEQUOTE___2010 invoke "core.clj" 197]
[compojure.core$make_context$fn__2038 invoke "core.clj" 297]
[compojure.core$routes$fn__2008$f__2009 invoke "core.clj" 198]
[compojure.core$routes$fn__2008$f__2009$respond_SINGLEQUOTE___2010 invoke "core.clj" 197]
[compojure.core$make_context$fn__2038 invoke "core.clj" 297]
[compojure.core$routes$fn__2008$f__2009 invoke "core.clj" 198]
[compojure.core$routes$fn__2008$f__2009$respond_SINGLEQUOTE___2010 invoke "core.clj" 197]
[compojure.core$make_context$fn__2038 invoke "core.clj" 297]
[compojure.core$routes$fn__2008$f__2009 invoke "core.clj" 198]
[compojure.core$routes$fn__2008$f__2009$respond_SINGLEQUOTE___2010 invoke "core.clj" 197]
[compojure.core$make_context$fn__2038 invoke "core.clj" 297]
[compojure.core$routes$fn__2008$f__2009 invoke "core.clj" 198]
[compojure.core$routes$fn__2008$f__2009$respond_SINGLEQUOTE___2010 invoke "core.clj" 197]
[compojure.core$make_context$fn__2038 invoke "core.clj" 297]
[compojure.core$routes$fn__2008$f__2009 invoke "core.clj" 198]
[compojure.core$routes$fn__2008$f__2009$respond_SINGLEQUOTE___2010 invoke "core.clj" 197]
[compojure.core$make_context$fn__2038 invoke "core.clj" 297]
[compojure.core$routes$fn__2008$f__2009 invoke "core.clj" 198]
[compojure.core$routes$fn__2008$f__2009$respond_SINGLEQUOTE___2010 invoke "core.clj" 197]
[compojure.core$make_context$fn__2038 invoke "core.clj" 297]
[compojure.core$routes$fn__2008$f__2009 invoke "core.clj" 198]
[compojure.core$routes$fn__2008$f__2009$respond_SINGLEQUOTE___2010 invoke "core.clj" 197]
[compojure.core$make_context$fn__2038 invoke "core.clj" 297]
[compojure.core$routes$fn__2008$f__2009 invoke "core.clj" 198]
[compojure.core$routes$fn__2008$f__2009$respond_SINGLEQUOTE___2010 invoke "core.clj" 197]
[compojure.core$make_context$fn__2038 invoke "core.clj" 297]
[compojure.core$routes$fn__2008$f__2009 invoke "core.clj" 198]
[compojure.core$routes$fn__2008$f__2009$respond_SINGLEQUOTE___2010 invoke "core.clj" 197]
[metabase.api.routes$fn__74014$fn__74016 invoke "routes.clj" 69]
[compojure.core$routes$fn__2008$f__2009 invoke "core.clj" 198]
[compojure.core$routes$fn__2008 invoke "core.clj" 200]
[clojure.lang.AFn applyToHelper "AFn.java" 160]
[clojure.lang.AFn applyTo "AFn.java" 144]
[clojure.core$apply invokeStatic "core.clj" 665]
[clojure.core$apply invoke "core.clj" 660]
[metabase.server.routes$fn__76247$fn__76248 doInvoke "routes.clj" 57]
[clojure.lang.RestFn invoke "RestFn.java" 436]
[compojure.core$routes$fn__2008$f__2009 invoke "core.clj" 198]
[compojure.core$routes$fn__2008 invoke "core.clj" 200]
[compojure.core$make_context$handler__2036 invoke "core.clj" 287]
[compojure.core$make_context$fn__2038 invoke "core.clj" 296]
[compojure.core$routes$fn__2008$f__2009 invoke "core.clj" 198]
[compojure.core$routes$fn__2008$f__2009$respond_SINGLEQUOTE___2010 invoke "core.clj" 197]
[compojure.core$wrap_route_matches$fn__1989 invoke "core.clj" 153]
[compojure.core$routes$fn__2008$f__2009 invoke "core.clj" 198]
[compojure.core$routes$fn__2008$f__2009$respond_SINGLEQUOTE___2010 invoke "core.clj" 197]
[compojure.core$wrap_route_matches$fn__1989 invoke "core.clj" 153]
[compojure.core$routes$fn__2008$f__2009 invoke "core.clj" 198]
[compojure.core$routes$fn__2008$f__2009$respond_SINGLEQUOTE___2010 invoke "core.clj" 197]
[compojure.core$wrap_route_matches$fn__1989 invoke "core.clj" 153]
[compojure.core$routes$fn__2008$f__2009 invoke "core.clj" 198]
[compojure.core$routes$fn__2008$f__2009$respond_SINGLEQUOTE___2010 invoke "core.clj" 197]
[metabase.server.routes$fn__76235$fn__76237 invoke "routes.clj" 41]
[compojure.core$routes$fn__2008$f__2009 invoke "core.clj" 198]
[compojure.core$routes$fn__2008 invoke "core.clj" 200]
[metabase.server.middleware.exceptions$catch_uncaught_exceptions$fn__74005 invoke "exceptions.clj" 98]
[metabase.server.middleware.exceptions$catch_api_exceptions$fn__74002 invoke "exceptions.clj" 86]
[metabase.server.middleware.log$log_api_call$fn__76163$fn__76164 invoke "log.clj" 195]
[toucan.db$_do_with_call_counting invokeStatic "db.clj" 216]
[toucan.db$_do_with_call_counting invoke "db.clj" 209]
[metabase.server.middleware.log$log_api_call$fn__76163 invoke "log.clj" 189]
[metabase.server.middleware.security$add_security_headers$fn__73967 invoke "security.clj" 142]
[metabase.server.middleware.json$wrap_json_body$fn__75944 invoke "json.clj" 62]
[metabase.server.middleware.json$wrap_streamed_json_response$fn__75962 invoke "json.clj" 98]
[ring.middleware.keyword_params$wrap_keyword_params$fn__76504 invoke "keyword_params.clj" 55]
[ring.middleware.params$wrap_params$fn__76520 invoke "params.clj" 69]
[metabase.server.middleware.misc$maybe_set_site_url$fn__34784 invoke "misc.clj" 58]
[metabase.server.middleware.session$bind_current_user$fn__41763$fn__41764 invoke "session.clj" 277]
[metabase.server.middleware.session$do_with_current_user invokeStatic "session.clj" 258]
[metabase.server.middleware.session$do_with_current_user invoke "session.clj" 250]
[metabase.server.middleware.session$bind_current_user$fn__41763 invoke "session.clj" 276]
[metabase.server.middleware.session$wrap_current_user_info$fn__41750 invoke "session.clj" 236]
[metabase.server.middleware.session$wrap_session_id$fn__41736 invoke "session.clj" 182]
[metabase.server.middleware.auth$wrap_api_key$fn__73900 invoke "auth.clj" 27]
[ring.middleware.cookies$wrap_cookies$fn__76424 invoke "cookies.clj" 216]
[metabase.server.middleware.misc$add_content_type$fn__34767 invoke "misc.clj" 27]
[metabase.server.middleware.misc$disable_streaming_buffering$fn__34792 invoke "misc.clj" 75]
[ring.middleware.gzip$wrap_gzip$fn__76466 invoke "gzip.clj" 86]
[metabase.server.middleware.misc$bind_request$fn__34795 invoke "misc.clj" 92]
[metabase.server.middleware.ssl$redirect_to_https_middleware$fn__76180 invoke "ssl.clj" 48]
[metabase.server$async_proxy_handler$fn__75777 invoke "server.clj" 71]
[metabase.server.proxy$org.eclipse.jetty.server.handler.AbstractHandler$ff19274a handle nil -1]
[org.eclipse.jetty.server.handler.HandlerWrapper handle "HandlerWrapper.java" 127]
[org.eclipse.jetty.server.Server handle "Server.java" 516]
[org.eclipse.jetty.server.HttpChannel lambda$handle$1 "HttpChannel.java" 383]
[org.eclipse.jetty.server.HttpChannel dispatch "HttpChannel.java" 556]
[org.eclipse.jetty.server.HttpChannel handle "HttpChannel.java" 375]
[org.eclipse.jetty.server.HttpConnection onFillable "HttpConnection.java" 273]
[org.eclipse.jetty.io.AbstractConnection$ReadCallback succeeded "AbstractConnection.java" 311]
[org.eclipse.jetty.io.FillInterest fillable "FillInterest.java" 105]
[org.eclipse.jetty.io.ChannelEndPoint$1 run "ChannelEndPoint.java" 104]
[org.eclipse.jetty.util.thread.strategy.EatWhatYouKill runTask "EatWhatYouKill.java" 336]
[org.eclipse.jetty.util.thread.strategy.EatWhatYouKill doProduce "EatWhatYouKill.java" 313]
[org.eclipse.jetty.util.thread.strategy.EatWhatYouKill tryProduce "EatWhatYouKill.java" 171]
[org.eclipse.jetty.util.thread.strategy.EatWhatYouKill run "EatWhatYouKill.java" 129]
[org.eclipse.jetty.util.thread.ReservedThreadExecutor$ReservedThread run "ReservedThreadExecutor.java" 375]
[org.eclipse.jetty.util.thread.QueuedThreadPool runJob "QueuedThreadPool.java" 773]
[org.eclipse.jetty.util.thread.QueuedThreadPool$Runner run "QueuedThreadPool.java" 905]
[java.lang.Thread run nil -1]],
:cause "Unsupported field: MonthOfYear",
:message "Unsupported field: MonthOfYear"}

flamber · June 22, 2021, 12:26pm

@Nishya Okay, then I guess we will never be able to fix the issue, since it has been reported 3 times, but no-one has provided enough information to figure out what is going on:
https://github.com/metabase/metabase/issues/15146

Nishya · June 22, 2021, 1:51pm

Maybe this will help, I did some digging myself. There was varchar column that was cast to time, which was causing the problem. When this column was removed, the email was sent successfully.

> select 
> date1               as date1_timestamp
> CAST(date1 AS time) as date1_time
> from table_a


> +---------------------+------------+
> |   date1_timestamp   | date1_time |
> +---------------------+------------+
> | 2021-06-30 11:00:00 | 11:00:00   |
> +---------------------+------------+

flamber · June 22, 2021, 2:17pm

@Nishya Awesome! https://github.com/metabase/metabase/issues/15146#issuecomment-866023392