An error occurred while displaying this card - Error in Dashboard Emailer

Get Help
1

One of the dashboard subscriptions has started giving this error. The Dashboard has all the questions as 2 series of line charts (as shown below):

image
image2880×524 100 KB

The Error in the email looks like this:

image
image1246×238 14.4 KB

There are 8 such questions (all of which give this error), and the dashboard emailer has been working fine until the last few instances.

I checked the other subscriptions and they're working absolutely fine as well, only this one is giving this error. I manually triggered the emailer a bunch of times and it's giving the same error.

I noticed one more thing, even though the subscription is set for 10:00PM local time everyday (IST or Asia/Kolkata), there is one more email sent at 10:30 PM which has always shown this error.

Any help is much appreciated. Let me know if more info is needed.

Here's the log for the same:

Diagnostic info:

{
  "browser-info": {
    "language": "en-GB",
    "platform": "MacIntel",
    "userAgent": "Mozilla/5.0 (Macintosh; Intel Mac OS X 10_15_7) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/108.0.0.0 Safari/537.36",
    "vendor": "Google Inc."
  },
  "system-info": {
    "file.encoding": "UTF-8",
    "java.runtime.name": "OpenJDK Runtime Environment",
    "java.runtime.version": "11.0.17+8",
    "java.vendor": "Eclipse Adoptium",
    "java.vendor.url": "https://adoptium.net/",
    "java.version": "11.0.17",
    "java.vm.name": "OpenJDK 64-Bit Server VM",
    "java.vm.version": "11.0.17+8",
    "os.name": "Linux",
    "os.version": "5.13.0-1031-aws",
    "user.language": "en",
    "user.timezone": "GMT"
  },
  "metabase-info": {
    "databases": [
      "postgres",
      "snowflake",
      "mysql",
      "h2"
    ],
    "hosting-env": "unknown",
    "application-database": "postgres",
    "application-database-details": {
      "database": {
        "name": "PostgreSQL",
        "version": "14.3"
      },
      "jdbc-driver": {
        "name": "PostgreSQL JDBC Driver",
        "version": "42.5.0"
      }
    },
    "run-mode": "prod",
    "version": {
      "date": "2022-12-07",
      "tag": "v0.45.1",
      "branch": "release-x.45.x",
      "hash": "019d31c"
    },
    "settings": {
      "report-timezone": "Asia/Kolkata"
    }
  }
}

Error Log:

[a42639ab-627d-4f56-aee2-0b8d4398acbc] 2022-12-26T23:18:48+05:30 INFO metabase.query-processor.card Question's average execution duration is 5.0 s; using 'magic' TTL of 50.0 s 💾
[a42639ab-627d-4f56-aee2-0b8d4398acbc] 2022-12-26T23:18:53+05:30 INFO metabase.query-processor.middleware.cache Query took 5.0 s to run; minimum for cache eligibility is 20.0 s
[a42639ab-627d-4f56-aee2-0b8d4398acbc] 2022-12-26T23:18:53+05:30 DEBUG metabase.server.middleware.log POST /api/card/3650/query 202 [ASYNC: completed] 5.0 s (15 DB calls) App DB connections: 2/15 Jetty threads: 4/50 (5 idle, 0 queued) (190 total active threads) Queries in flight: 0 (0 queued); postgres DB 2 connections: 0/8 (0 threads blocked)
[a42639ab-627d-4f56-aee2-0b8d4398acbc] 2022-12-26T23:18:57+05:30 INFO metabase.query-processor.card Question's average execution duration is 1.5 s; using 'magic' TTL of 15.0 s 💾
[a42639ab-627d-4f56-aee2-0b8d4398acbc] 2022-12-26T23:18:58+05:30 INFO metabase.query-processor.middleware.cache Query took 1.5 s to run; minimum for cache eligibility is 20.0 s
[a42639ab-627d-4f56-aee2-0b8d4398acbc] 2022-12-26T23:18:58+05:30 ERROR metabase.pulse.render Pulse card render error
java.lang.ArithmeticException: Divide by zero
	at clojure.lang.Numbers.divide(Numbers.java:190)
	at metabase.pulse.render.body$overlap.invokeStatic(body.clj:562)
	at metabase.pulse.render.body$overlap.invoke(body.clj:515)
	at metabase.pulse.render.body$group_axes$fn__58444.invoke(body.clj:575)
	at clojure.core$group_by$fn__8597.invoke(core.clj:7224)
	at clojure.lang.ArrayChunk.reduce(ArrayChunk.java:58)
	at clojure.core.protocols$fn__8244.invokeStatic(protocols.clj:136)
	at clojure.core.protocols$fn__8244.invoke(protocols.clj:124)
	at clojure.core.protocols$fn__8204$G__8199__8213.invoke(protocols.clj:19)
	at clojure.core.protocols$seq_reduce.invokeStatic(protocols.clj:31)
	at clojure.core.protocols$fn__8234.invokeStatic(protocols.clj:75)
	at clojure.core.protocols$fn__8234.invoke(protocols.clj:75)
	at clojure.core.protocols$fn__8178$G__8173__8191.invoke(protocols.clj:13)
	at clojure.core$reduce.invokeStatic(core.clj:6886)
	at clojure.core$group_by.invokeStatic(core.clj:7214)
	at clojure.core$group_by.invoke(core.clj:7214)
	at metabase.pulse.render.body$group_axes.invokeStatic(body.clj:575)
	at metabase.pulse.render.body$group_axes.invoke(body.clj:565)
	at metabase.pulse.render.body$default_y_pos.invokeStatic(body.clj:585)
	at metabase.pulse.render.body$default_y_pos.invoke(body.clj:579)
	at metabase.pulse.render.body$single_x_axis_combo_series$iter__58485__58489$fn__58490$fn__58491.invoke(body.clj:651)
	at metabase.pulse.render.body$single_x_axis_combo_series$iter__58485__58489$fn__58490.invoke(body.clj:644)
	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__5467.invokeStatic(core.clj:139)
	at clojure.core.protocols$seq_reduce.invokeStatic(protocols.clj:24)
	at clojure.core.protocols$fn__8236.invokeStatic(protocols.clj:75)
	at clojure.core.protocols$fn__8236.invoke(protocols.clj:75)
	at clojure.core.protocols$fn__8178$G__8173__8191.invoke(protocols.clj:13)
	at clojure.core$reduce.invokeStatic(core.clj:6886)
	at clojure.core$reduce.invoke(core.clj:6868)
	at cheshire.generate$generate.invokeStatic(generate.clj:133)
	at cheshire.generate$generate.invoke(generate.clj:119)
	at cheshire.generate$generate$fn__3931.invoke(generate.clj:127)
	at clojure.lang.PersistentVector.reduce(PersistentVector.java:343)
	at clojure.core$reduce.invokeStatic(core.clj:6885)
	at clojure.core$reduce.invoke(core.clj:6868)
	at cheshire.generate$generate.invokeStatic(generate.clj:127)
	at cheshire.generate$generate.invoke(generate.clj:119)
	at cheshire.core$generate_string.invokeStatic(core.clj:74)
	at cheshire.core$generate_string.invoke(core.clj:49)
	at cheshire.core$generate_string.invokeStatic(core.clj:55)
	at cheshire.core$generate_string.invoke(core.clj:49)
	at metabase.pulse.render.js_svg$combo_chart.invokeStatic(js_svg.clj:140)
	at metabase.pulse.render.js_svg$combo_chart.invoke(js_svg.clj:129)
	at metabase.pulse.render.body$lab_image_bundle.invokeStatic(body.clj:749)
	at metabase.pulse.render.body$lab_image_bundle.invoke(body.clj:722)
	at metabase.pulse.render.body$fn__58646$render__58635__58651$fn__58652.invoke(body.clj:760)
	at metabase.pulse.render.body$fn__58646$render__58635__58651.invoke(body.clj:758)
	at clojure.lang.MultiFn.invoke(MultiFn.java:261)
	at metabase.pulse.render$fn__59228$render_pulse_card_body__59233$fn__59237.invoke(render.clj:128)
	at metabase.pulse.render$fn__59228$render_pulse_card_body__59233.invoke(render.clj:118)
	at metabase.pulse.render$fn__59267$render_pulse_card__59272$fn__59273.invoke(render.clj:154)
	at metabase.pulse.render$fn__59267$render_pulse_card__59272.invoke(render.clj:142)
	at metabase.pulse.render$fn__59296$render_pulse_section__59301$fn__59305$fn__59308.invoke(render.clj:186)
	at metabase.pulse.render$fn__59296$render_pulse_section__59301$fn__59305.invoke(render.clj:184)
	at metabase.pulse.render$fn__59296$render_pulse_section__59301.invoke(render.clj:181)
	at metabase.email.messages$render_result_card.invokeStatic(messages.clj:428)
	at metabase.email.messages$render_result_card.invoke(messages.clj:425)
	at metabase.email.messages$render_message_body$fn__60583$fn__60584.invoke(messages.clj:476)
	at clojure.core$mapv$fn__8535.invoke(core.clj:6979)
	at clojure.core.protocols$fn__8249.invokeStatic(protocols.clj:168)
	at clojure.core.protocols$fn__8249.invoke(protocols.clj:124)
	at clojure.core.protocols$fn__8204$G__8199__8213.invoke(protocols.clj:19)
	at clojure.core.protocols$seq_reduce.invokeStatic(protocols.clj:31)
	at clojure.core.protocols$fn__8236.invokeStatic(protocols.clj:75)
	at clojure.core.protocols$fn__8236.invoke(protocols.clj:75)
	at clojure.core.protocols$fn__8178$G__8173__8191.invoke(protocols.clj:13)
	at clojure.core$reduce.invokeStatic(core.clj:6886)
	at clojure.core$mapv.invokeStatic(core.clj:6970)
	at clojure.core$mapv.invoke(core.clj:6970)
	at metabase.email.messages$render_message_body$fn__60583.invoke(messages.clj:476)
	at metabase.email.messages$render_message_body.invokeStatic(messages.clj:475)
	at metabase.email.messages$render_message_body.invoke(messages.clj:473)
	at metabase.email.messages$render_pulse_email.invokeStatic(messages.clj:502)
	at metabase.email.messages$render_pulse_email.invoke(messages.clj:499)
	at metabase.pulse$fn__80655.invokeStatic(pulse.clj:309)
	at metabase.pulse$fn__80655.invoke(pulse.clj:298)
	at clojure.lang.MultiFn.invoke(MultiFn.java:239)
	at metabase.pulse$results__GT_notifications$iter__80685__80689$fn__80690.invoke(pulse.clj:361)
	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__5467.invokeStatic(core.clj:139)
	at clojure.core$seq__5467.invoke(core.clj:139)
	at metabase.pulse$send_notifications_BANG_.invokeStatic(pulse.clj:481)
	at metabase.pulse$send_notifications_BANG_.invoke(pulse.clj:480)
	at metabase.pulse$send_pulse_BANG_.invokeStatic(pulse.clj:508)
	at metabase.pulse$send_pulse_BANG_.doInvoke(pulse.clj:489)
	at clojure.lang.RestFn.invoke(RestFn.java:410)
	at metabase.api.pulse$fn__81899.invokeStatic(pulse.clj:244)
	at metabase.api.pulse$fn__81899.invoke(pulse.clj:230)
	at compojure.core$wrap_response$fn__29287.invoke(core.clj:160)
	at compojure.core$wrap_route_middleware$fn__29271.invoke(core.clj:132)
	at compojure.core$wrap_route_info$fn__29276.invoke(core.clj:139)
	at compojure.core$wrap_route_matches$fn__29280.invoke(core.clj:151)
	at compojure.core$routes$fn__29299$f__29300.invoke(core.clj:198)
	at compojure.core$routes$fn__29299$f__29300$respond_SINGLEQUOTE___29301.invoke(core.clj:197)
	at compojure.core$wrap_route_matches$fn__29280.invoke(core.clj:153)
	at compojure.core$routes$fn__29299$f__29300.invoke(core.clj:198)
	at compojure.core$routes$fn__29299$f__29300$respond_SINGLEQUOTE___29301.invoke(core.clj:197)
	at compojure.core$wrap_route_matches$fn__29280.invoke(core.clj:153)
	at compojure.core$routes$fn__29299$f__29300.invoke(core.clj:198)
	at compojure.core$routes$fn__29299$f__29300$respond_SINGLEQUOTE___29301.invoke(core.clj:197)
	at compojure.core$wrap_route_matches$fn__29280.invoke(core.clj:153)
	at compojure.core$routes$fn__29299$f__29300.invoke(core.clj:198)
	at compojure.core$routes$fn__29299$f__29300$respond_SINGLEQUOTE___29301.invoke(core.clj:197)
	at compojure.core$wrap_route_matches$fn__29280.invoke(core.clj:152)
	at compojure.core$routes$fn__29299$f__29300.invoke(core.clj:198)
	at compojure.core$routes$fn__29299.invoke(core.clj:200)
	at metabase.server.middleware.auth$enforce_authentication$fn__70471.invoke(auth.clj:14)
	at compojure.core$routes$fn__29299$f__29300.invoke(core.clj:198)
	at compojure.core$routes$fn__29299.invoke(core.clj:200)
	at compojure.core$make_context$handler__29327.invoke(core.clj:289)
	at compojure.core$make_context$fn__29331.invoke(core.clj:299)
	at compojure.core$routes$fn__29299$f__29300.invoke(core.clj:198)
	at compojure.core$routes$fn__29299$f__29300$respond_SINGLEQUOTE___29301.invoke(core.clj:197)
	at compojure.core$make_context$fn__29331.invoke(core.clj:300)
	at compojure.core$routes$fn__29299$f__29300.invoke(core.clj:198)
	at compojure.core$routes$fn__29299$f__29300$respond_SINGLEQUOTE___29301.invoke(core.clj:197)
	at compojure.core$make_context$fn__29331.invoke(core.clj:300)
	at compojure.core$routes$fn__29299$f__29300.invoke(core.clj:198)
	at compojure.core$routes$fn__29299$f__29300$respond_SINGLEQUOTE___29301.invoke(core.clj:197)
	at compojure.core$make_context$fn__29331.invoke(core.clj:300)
	at compojure.core$routes$fn__29299$f__29300.invoke(core.clj:198)
	at compojure.core$routes$fn__29299$f__29300$respond_SINGLEQUOTE___29301.invoke(core.clj:197)
	at compojure.core$make_context$fn__29331.invoke(core.clj:300)
	at compojure.core$routes$fn__29299$f__29300.invoke(core.clj:198)
	at compojure.core$routes$fn__29299$f__29300$respond_SINGLEQUOTE___29301.invoke(core.clj:197)
	at compojure.core$make_context$fn__29331.invoke(core.clj:300)
	at compojure.core$routes$fn__29299$f__29300.invoke(core.clj:198)
	at compojure.core$routes$fn__29299$f__29300$respond_SINGLEQUOTE___29301.invoke(core.clj:197)
	at compojure.core$make_context$fn__29331.invoke(core.clj:300)
	at compojure.core$routes$fn__29299$f__29300.invoke(core.clj:198)
	at compojure.core$routes$fn__29299$f__29300$respond_SINGLEQUOTE___29301.invoke(core.clj:197)
	at compojure.core$make_context$fn__29331.invoke(core.clj:300)
	at compojure.core$routes$fn__29299$f__29300.invoke(core.clj:198)
	at compojure.core$routes$fn__29299$f__29300$respond_SINGLEQUOTE___29301.invoke(core.clj:197)
	at compojure.core$make_context$fn__29331.invoke(core.clj:300)
	at compojure.core$routes$fn__29299$f__29300.invoke(core.clj:198)
	at compojure.core$routes$fn__29299$f__29300$respond_SINGLEQUOTE___29301.invoke(core.clj:197)
	at compojure.core$make_context$fn__29331.invoke(core.clj:300)
	at compojure.core$routes$fn__29299$f__29300.invoke(core.clj:198)
	at compojure.core$routes$fn__29299$f__29300$respond_SINGLEQUOTE___29301.invoke(core.clj:197)
	at compojure.core$make_context$fn__29331.invoke(core.clj:300)
	at compojure.core$routes$fn__29299$f__29300.invoke(core.clj:198)
	at compojure.core$routes$fn__29299$f__29300$respond_SINGLEQUOTE___29301.invoke(core.clj:197)
	at compojure.core$make_context$fn__29331.invoke(core.clj:300)
	at compojure.core$routes$fn__29299$f__29300.invoke(core.clj:198)
	at compojure.core$routes$fn__29299$f__29300$respond_SINGLEQUOTE___29301.invoke(core.clj:197)
	at compojure.core$make_context$fn__29331.invoke(core.clj:300)
	at compojure.core$routes$fn__29299$f__29300.invoke(core.clj:198)
	at compojure.core$routes$fn__29299$f__29300$respond_SINGLEQUOTE___29301.invoke(core.clj:197)
	at compojure.core$make_context$fn__29331.invoke(core.clj:300)
	at compojure.core$routes$fn__29299$f__29300.invoke(core.clj:198)
	at compojure.core$routes$fn__29299$f__29300$respond_SINGLEQUOTE___29301.invoke(core.clj:197)
	at compojure.core$make_context$fn__29331.invoke(core.clj:300)
	at compojure.core$routes$fn__29299$f__29300.invoke(core.clj:198)
	at compojure.core$routes$fn__29299$f__29300$respond_SINGLEQUOTE___29301.invoke(core.clj:197)
	at compojure.core$make_context$fn__29331.invoke(core.clj:300)
	at compojure.core$routes$fn__29299$f__29300.invoke(core.clj:198)
	at compojure.core$routes$fn__29299$f__29300$respond_SINGLEQUOTE___29301.invoke(core.clj:197)
	at compojure.core$make_context$fn__29331.invoke(core.clj:300)
	at compojure.core$routes$fn__29299$f__29300.invoke(core.clj:198)
	at compojure.core$routes$fn__29299$f__29300$respond_SINGLEQUOTE___29301.invoke(core.clj:197)
	at compojure.core$make_context$fn__29331.invoke(core.clj:300)
	at compojure.core$routes$fn__29299$f__29300.invoke(core.clj:198)
	at compojure.core$routes$fn__29299$f__29300$respond_SINGLEQUOTE___29301.invoke(core.clj:197)
	at compojure.core$make_context$fn__29331.invoke(core.clj:300)
	at compojure.core$routes$fn__29299$f__29300.invoke(core.clj:198)
	at compojure.core$routes$fn__29299$f__29300$respond_SINGLEQUOTE___29301.invoke(core.clj:197)
	at compojure.core$make_context$fn__29331.invoke(core.clj:300)
	at compojure.core$routes$fn__29299$f__29300.invoke(core.clj:198)
	at compojure.core$routes$fn__29299$f__29300$respond_SINGLEQUOTE___29301.invoke(core.clj:197)
	at compojure.core$make_context$fn__29331.invoke(core.clj:300)
	at compojure.core$routes$fn__29299$f__29300.invoke(core.clj:198)
	at compojure.core$routes$fn__29299$f__29300$respond_SINGLEQUOTE___29301.invoke(core.clj:197)
	at compojure.core$make_context$fn__29331.invoke(core.clj:300)
	at compojure.core$routes$fn__29299$f__29300.invoke(core.clj:198)
	at compojure.core$routes$fn__29299$f__29300$respond_SINGLEQUOTE___29301.invoke(core.clj:197)
	at compojure.core$make_context$fn__29331.invoke(core.clj:300)
	at compojure.core$routes$fn__29299$f__29300.invoke(core.clj:198)
	at compojure.core$routes$fn__29299$f__29300$respond_SINGLEQUOTE___29301.invoke(core.clj:197)
	at compojure.core$make_context$fn__29331.invoke(core.clj:300)
	at compojure.core$routes$fn__29299$f__29300.invoke(core.clj:198)
	at compojure.core$routes$fn__29299$f__29300$respond_SINGLEQUOTE___29301.invoke(core.clj:197)
	at compojure.core$make_context$fn__29331.invoke(core.clj:300)
	at compojure.core$routes$fn__29299$f__29300.invoke(core.clj:198)
	at compojure.core$routes$fn__29299$f__29300$respond_SINGLEQUOTE___29301.invoke(core.clj:197)
	at compojure.core$make_context$fn__29331.invoke(core.clj:300)
	at compojure.core$routes$fn__29299$f__29300.invoke(core.clj:198)
	at compojure.core$routes$fn__29299$f__29300$respond_SINGLEQUOTE___29301.invoke(core.clj:197)
	at compojure.core$make_context$fn__29331.invoke(core.clj:300)
	at compojure.core$routes$fn__29299$f__29300.invoke(core.clj:198)
	at compojure.core$routes$fn__29299$f__29300$respond_SINGLEQUOTE___29301.invoke(core.clj:197)
	at compojure.core$make_context$fn__29331.invoke(core.clj:300)
	at compojure.core$routes$fn__29299$f__29300.invoke(core.clj:198)
	at compojure.core$routes$fn__29299$f__29300$respond_SINGLEQUOTE___29301.invoke(core.clj:197)
	at metabase.api.routes$fn__82423$fn__82426.invoke(routes.clj:64)
	at compojure.core$routes$fn__29299$f__29300.invoke(core.clj:198)
	at compojure.core$routes$fn__29299.invoke(core.clj:200)
	at clojure.lang.AFn.applyToHelper(AFn.java:160)
	at clojure.lang.AFn.applyTo(AFn.java:144)
	at clojure.core$apply.invokeStatic(core.clj:667)
	at clojure.core$apply.invoke(core.clj:662)
	at metabase.server.routes$fn__82586$fn__82587.doInvoke(routes.clj:67)
	at clojure.lang.RestFn.invoke(RestFn.java:436)
	at compojure.core$routes$fn__29299$f__29300.invoke(core.clj:198)
	at compojure.core$routes$fn__29299.invoke(core.clj:200)
	at compojure.core$make_context$handler__29327.invoke(core.clj:289)
	at compojure.core$make_context$fn__29331.invoke(core.clj:299)
	at compojure.core$routes$fn__29299$f__29300.invoke(core.clj:198)
	at compojure.core$routes$fn__29299$f__29300$respond_SINGLEQUOTE___29301.invoke(core.clj:197)
	at compojure.core$wrap_route_matches$fn__29280.invoke(core.clj:153)
	at compojure.core$routes$fn__29299$f__29300.invoke(core.clj:198)
	at compojure.core$routes$fn__29299$f__29300$respond_SINGLEQUOTE___29301.invoke(core.clj:197)
	at compojure.core$wrap_route_matches$fn__29280.invoke(core.clj:153)
	at compojure.core$routes$fn__29299$f__29300.invoke(core.clj:198)
	at compojure.core$routes$fn__29299$f__29300$respond_SINGLEQUOTE___29301.invoke(core.clj:197)
	at compojure.core$wrap_route_matches$fn__29280.invoke(core.clj:153)
	at compojure.core$routes$fn__29299$f__29300.invoke(core.clj:198)
	at compojure.core$routes$fn__29299$f__29300$respond_SINGLEQUOTE___29301.invoke(core.clj:197)
	at metabase.server.routes$fn__82572$fn__82574.invoke(routes.clj:45)
	at compojure.core$routes$fn__29299$f__29300.invoke(core.clj:198)
	at compojure.core$routes$fn__29299.invoke(core.clj:200)
	at metabase.server.middleware.exceptions$catch_uncaught_exceptions$fn__78945.invoke(exceptions.clj:98)
	at metabase.server.middleware.exceptions$catch_api_exceptions$fn__78942.invoke(exceptions.clj:86)
	at metabase.server.middleware.log$log_api_call$fn__83998$fn__83999$fn__84000.invoke(log.clj:211)
	at metabase.driver.sql_jdbc.execute.diagnostic$do_with_diagnostic_info.invokeStatic(diagnostic.clj:15)
	at metabase.driver.sql_jdbc.execute.diagnostic$do_with_diagnostic_info.invoke(diagnostic.clj:9)
	at metabase.server.middleware.log$log_api_call$fn__83998$fn__83999.invoke(log.clj:203)
	at toucan.db$_do_with_call_counting.invokeStatic(db.clj:236)
	at toucan.db$_do_with_call_counting.invoke(db.clj:229)
	at metabase.server.middleware.log$log_api_call$fn__83998.invoke(log.clj:202)
	at metabase.server.middleware.browser_cookie$ensure_browser_id_cookie$fn__86895.invoke(browser_cookie.clj:38)
	at metabase.server.middleware.security$add_security_headers$fn__63843.invoke(security.clj:149)
	at metabase.server.middleware.json$wrap_json_body$fn__86026.invoke(json.clj:63)
	at metabase.server.middleware.json$wrap_streamed_json_response$fn__86044.invoke(json.clj:99)
	at metabase.server.middleware.offset_paging$handle_paging$fn__63867.invoke(offset_paging.clj:42)
	at ring.middleware.keyword_params$wrap_keyword_params$fn__87162.invoke(keyword_params.clj:55)
	at ring.middleware.params$wrap_params$fn__87181.invoke(params.clj:77)
	at metabase.server.middleware.misc$maybe_set_site_url$fn__36664.invoke(misc.clj:59)
	at metabase.server.middleware.session$reset_session_timeout$fn__48310.invoke(session.clj:394)
	at metabase.server.middleware.session$bind_current_user$fn__48293$fn__48294.invoke(session.clj:331)
	at metabase.server.middleware.session$do_with_current_user.invokeStatic(session.clj:310)
	at metabase.server.middleware.session$do_with_current_user.invoke(session.clj:299)
	at metabase.server.middleware.session$bind_current_user$fn__48293.invoke(session.clj:330)
	at metabase.server.middleware.session$wrap_current_user_info$fn__48275.invoke(session.clj:280)
	at metabase.server.middleware.session$wrap_session_id$fn__48259.invoke(session.clj:213)
	at metabase.server.middleware.auth$wrap_api_key$fn__70479.invoke(auth.clj:27)
	at ring.middleware.cookies$wrap_cookies$fn__87082.invoke(cookies.clj:216)
	at metabase.server.middleware.misc$add_content_type$fn__36647.invoke(misc.clj:27)
	at metabase.server.middleware.misc$disable_streaming_buffering$fn__36672.invoke(misc.clj:76)
	at ring.middleware.gzip$wrap_gzip$fn__87124.invoke(gzip.clj:86)
	at metabase.server.middleware.misc$bind_request$fn__36675.invoke(misc.clj:93)
	at metabase.server.middleware.ssl$redirect_to_https_middleware$fn__86911.invoke(ssl.clj:48)
	at metabase.server$async_proxy_handler$fn__82794.invoke(server.clj:73)
	at metabase.server.proxy$org.eclipse.jetty.server.handler.AbstractHandler$ff19274a.handle(Unknown Source)
	at org.eclipse.jetty.server.handler.StatisticsHandler.handle(StatisticsHandler.java:181)
	at org.eclipse.jetty.server.handler.HandlerWrapper.handle(HandlerWrapper.java:127)
	at org.eclipse.jetty.server.Server.handle(Server.java:516)
	at org.eclipse.jetty.server.HttpChannel.lambda$handle$1(HttpChannel.java:487)
	at org.eclipse.jetty.server.HttpChannel.dispatch(HttpChannel.java:732)
	at org.eclipse.jetty.server.HttpChannel.handle(HttpChannel.java:479)
	at org.eclipse.jetty.server.HttpConnection.onFillable(HttpConnection.java:277)
	at org.eclipse.jetty.io.AbstractConnection$ReadCallback.succeeded(AbstractConnection.java:311)
	at org.eclipse.jetty.io.FillInterest.fillable(FillInterest.java:105)
	at org.eclipse.jetty.io.ChannelEndPoint$1.run(ChannelEndPoint.java:104)
	at org.eclipse.jetty.util.thread.strategy.EatWhatYouKill.runTask(EatWhatYouKill.java:338)
	at org.eclipse.jetty.util.thread.strategy.EatWhatYouKill.doProduce(EatWhatYouKill.java:315)
	at org.eclipse.jetty.util.thread.strategy.EatWhatYouKill.tryProduce(EatWhatYouKill.java:173)
	at org.eclipse.jetty.util.thread.strategy.EatWhatYouKill.run(EatWhatYouKill.java:131)
	at org.eclipse.jetty.util.thread.ReservedThreadExecutor$ReservedThread.run(ReservedThreadExecutor.java:409)
	at org.eclipse.jetty.util.thread.QueuedThreadPool.runJob(QueuedThreadPool.java:883)
	at org.eclipse.jetty.util.thread.QueuedThreadPool$Runner.run(QueuedThreadPool.java:1034)
	at java.base/java.lang.Thread.run(Unknown Source)
2

Hi @atharva_c
What does this mean, "has been working fine until the last few instances" ?
I'm guessing that "Hour Wise Booking Count - Today + Yesterday" is question ID 3650, so can you include the question metadata by going to the URL /api/card/3650 ?

3

By 'last few instances' I mean the last few emails sent via the dashboard subscription.
Here's the result_metadata for this particular question:

    "result_metadata": [
        {
            "display_name": "sortorder",
            "field_ref": [
                "field",
                "sortorder",
                {
                    "base-type": "type/Integer"
                }
            ],
            "name": "sortorder",
            "base_type": "type/Integer",
            "effective_type": "type/Integer",
            "semantic_type": null,
            "fingerprint": {
                "global": {
                    "distinct-count": 1,
                    "nil%": 0.0
                },
                "type": {
                    "type/Number": {
                        "min": 1.0,
                        "q1": 1.0,
                        "q3": 1.0,
                        "max": 1.0,
                        "sd": 0.0,
                        "avg": 1.0
                    }
                }
            }
        },
        {
            "display_name": "Hour",
            "field_ref": [
                "field",
                "Hour",
                {
                    "base-type": "type/Text"
                }
            ],
            "name": "Hour",
            "base_type": "type/Text",
            "effective_type": "type/Text",
            "semantic_type": null,
            "fingerprint": {
                "global": {
                    "distinct-count": 16,
                    "nil%": 0.0
                },
                "type": {
                    "type/Text": {
                        "percent-json": 0.0,
                        "percent-url": 0.0,
                        "percent-email": 0.0,
                        "percent-state": 0.0,
                        "average-length": 5.0
                    }
                }
            }
        },
        {
            "display_name": "Booking Count Today",
            "field_ref": [
                "field",
                "Booking Count Today",
                {
                    "base-type": "type/BigInteger"
                }
            ],
            "name": "Booking Count Today",
            "base_type": "type/BigInteger",
            "effective_type": "type/BigInteger",
            "semantic_type": null,
            "fingerprint": {
                "global": {
                    "distinct-count": 15,
                    "nil%": 0.0
                },
                "type": {
                    "type/Number": {
                        "min": 5.0,
                        "q1": 15.5,
                        "q3": 187.5,
                        "max": 242.0,
                        "sd": 85.411064856961,
                        "avg": 103.625
                    }
                }
            }
        },
        {
            "display_name": "Booking Count Yesterday",
            "field_ref": [
                "field",
                "Booking Count Yesterday",
                {
                    "base-type": "type/BigInteger"
                }
            ],
            "name": "Booking Count Yesterday",
            "base_type": "type/BigInteger",
            "effective_type": "type/BigInteger",
            "semantic_type": null,
            "fingerprint": {
                "global": {
                    "distinct-count": 14,
                    "nil%": 0.0
                },
                "type": {
                    "type/Number": {
                        "min": 1.0,
                        "q1": 20.301515190165002,
                        "q3": 176.5,
                        "max": 205.0,
                        "sd": 78.80175547959999,
                        "avg": 101.125
                    }
                }
            }
        }
    ],
4

@atharva_c I need the entire question metadata. If it recently stopped working without any changes to the question (or Metabase), then it's likely caused by the results, but without fully understanding how the question is constructed, then it's difficult to tell.

5

Sure , here's the full question info:

{
    "description": null,
    "archived": false,
    "collection_position": null,
    "table_id": null,
    "result_metadata": [
        {
            "display_name": "sortorder",
            "field_ref": [
                "field",
                "sortorder",
                {
                    "base-type": "type/Integer"
                }
            ],
            "name": "sortorder",
            "base_type": "type/Integer",
            "effective_type": "type/Integer",
            "semantic_type": null,
            "fingerprint": {
                "global": {
                    "distinct-count": 1,
                    "nil%": 0.0
                },
                "type": {
                    "type/Number": {
                        "min": 1.0,
                        "q1": 1.0,
                        "q3": 1.0,
                        "max": 1.0,
                        "sd": 0.0,
                        "avg": 1.0
                    }
                }
            }
        },
        {
            "display_name": "Hour",
            "field_ref": [
                "field",
                "Hour",
                {
                    "base-type": "type/Text"
                }
            ],
            "name": "Hour",
            "base_type": "type/Text",
            "effective_type": "type/Text",
            "semantic_type": null,
            "fingerprint": {
                "global": {
                    "distinct-count": 16,
                    "nil%": 0.0
                },
                "type": {
                    "type/Text": {
                        "percent-json": 0.0,
                        "percent-url": 0.0,
                        "percent-email": 0.0,
                        "percent-state": 0.0,
                        "average-length": 5.0
                    }
                }
            }
        },
        {
            "display_name": "Booking Count Today",
            "field_ref": [
                "field",
                "Booking Count Today",
                {
                    "base-type": "type/BigInteger"
                }
            ],
            "name": "Booking Count Today",
            "base_type": "type/BigInteger",
            "effective_type": "type/BigInteger",
            "semantic_type": null,
            "fingerprint": {
                "global": {
                    "distinct-count": 15,
                    "nil%": 0.0
                },
                "type": {
                    "type/Number": {
                        "min": 5.0,
                        "q1": 15.5,
                        "q3": 187.5,
                        "max": 242.0,
                        "sd": 84.97332914901396,
                        "avg": 106.75
                    }
                }
            }
        },
        {
            "display_name": "Booking Count Yesterday",
            "field_ref": [
                "field",
                "Booking Count Yesterday",
                {
                    "base-type": "type/BigInteger"
                }
            ],
            "name": "Booking Count Yesterday",
            "base_type": "type/BigInteger",
            "effective_type": "type/BigInteger",
            "semantic_type": null,
            "fingerprint": {
                "global": {
                    "distinct-count": 14,
                    "nil%": 0.0
                },
                "type": {
                    "type/Number": {
                        "min": 1.0,
                        "q1": 20.301515190165002,
                        "q3": 176.5,
                        "max": 205.0,
                        "sd": 78.80175547959999,
                        "avg": 101.125
                    }
                }
            }
        }
    ],
    "creator": {
        "email": "atharva.choudhary@redcliffelabs.com",
        "first_name": "Atharva",
        "last_login": "2022-12-27T07:50:10.887109Z",
        "is_qbnewb": false,
        "is_superuser": true,
        "id": 2,
        "last_name": "Choudhary",
        "date_joined": "2022-04-25T09:51:25.502458Z",
        "common_name": "Atharva Choudhary"
    },
    "can_write": true,
    "database_id": 2,
    "enable_embedding": false,
    "collection_id": 64,
    "query_type": "native",
    "name": "Hour Wise Booking Count - Today + Yesterday",
    "last_query_start": "2022-12-27T10:27:24.585685Z",
    "dashboard_count": 1,
    "average_query_time": 1243.7857142857142857,
    "creator_id": 2,
    "moderation_reviews": [],
    "updated_at": "2022-12-27T10:27:26.054984Z",
    "made_public_by_id": null,
    "embedding_params": null,
    "cache_ttl": null,
    "dataset_query": {
        "database": 2,
        "native": {
            "template-tags": {
                "snippet: b2c_homedx_bookings": {
                    "id": "dd60ed3f-843a-9ab3-0c1e-b8d7a6166a29",
                    "name": "snippet: b2c_homedx_bookings",
                    "display-name": "Snippet: b2c homedx bookings",
                    "type": "snippet",
                    "snippet-name": "b2c_homedx_bookings",
                    "snippet-id": 29
                }
            },
            "query": "select * from (select\n    1 as sortorder,\n    to_char(date_trunc('hour', booking_booking.created_at),'HH24:MI') as \"Hour\",\n    count(distinct(case when booking_booking.created_at::date = localtimestamp::date then booking_booking.id else null end)) as \"Booking Count Today\",\n    count(distinct(case when booking_booking.created_at::date = localtimestamp::date - 1 then booking_booking.id else null end)) as \"Booking Count Yesterday\"\nfrom\n    booking_booking\nleft join panel_paneluser on booking_booking.agent_id = panel_paneluser.id\nleft join authentication_user on panel_paneluser.user_id = authentication_user.uuid\n\nwhere\n    booking_booking.created_at::date >= localtimestamp::date - 1\n    and {{snippet: b2c_homedx_bookings}}\n    \ngroup by \"Hour\"\n\n-- union\n\n-- select\n--     0 as sortorder,\n--     'Total' as \"Hour\",\n--     count(distinct(case when booking_booking.created_at::date = localtimestamp::date then booking_booking.id else null end)) as \"Booking Count Today\",\n--     count(distinct(case when booking_booking.created_at::date = localtimestamp::date - 1 then booking_booking.id else null end)) as \"Booking Count Yesterday\"\n-- from\n--     booking_booking\n-- left join panel_paneluser on booking_booking.agent_id = panel_paneluser.id\n-- left join authentication_user on panel_paneluser.user_id = authentication_user.uuid\n\n-- where\n--     booking_booking.created_at::date >= localtimestamp::date - 1\n--     and {{snippet: b2c_homedx_bookings}}\n    \n-- order by sortorder, \"Hour\" desc\n) as main\n\nwhere (\"Hour\" <= to_char(date_trunc('hour', localtimestamp),'HH24:MI') or (\"Hour\" = 'Total'))"
        },
        "type": "native"
    },
    "id": 1819,
    "parameter_mappings": null,
    "display": "line",
    "entity_id": null,
    "collection_preview": true,
    "last-edit-info": {
        "id": 2,
        "email": "atharva.choudhary@redcliffelabs.com",
        "first_name": "Atharva",
        "last_name": "Choudhary",
        "timestamp": "2022-12-26T17:39:19.481971Z"
    },
    "visualization_settings": {
        "graph.show_goal": false,
        "graph.show_values": true,
        "table.columns": [
            {
                "name": "sortorder",
                "fieldRef": [
                    "field",
                    "sortorder",
                    {
                        "base-type": "type/Integer"
                    }
                ],
                "enabled": false
            },
            {
                "name": "Hour",
                "fieldRef": [
                    "field",
                    "Hour",
                    {
                        "base-type": "type/Text"
                    }
                ],
                "enabled": true
            },
            {
                "name": "Booking Count Today",
                "fieldRef": [
                    "field",
                    "Booking Count Today",
                    {
                        "base-type": "type/BigInteger"
                    }
                ],
                "enabled": true
            },
            {
                "name": "Booking Count Yesterday",
                "fieldRef": [
                    "field",
                    "Booking Count Yesterday",
                    {
                        "base-type": "type/BigInteger"
                    }
                ],
                "enabled": true
            }
        ],
        "table.cell_column": "Booking Count Today",
        "graph.y_axis.auto_split": false,
        "graph.label_value_frequency": "fit",
        "graph.metrics": [
            "Booking Count Today",
            "Booking Count Yesterday"
        ],
        "graph.label_value_formatting": "compact",
        "table.pivot_column": "sortorder",
        "column_settings": {
            "[\"name\",\"Hour\"]": {
                "date_abbreviate": false
            }
        },
        "series_settings": {
            "Lead Count Today": {
                "color": "#88BF4D"
            },
            "Lead Count Yesterday": {
                "color": "#509EE3"
            },
            "Booking Count Today": {
                "color": "#88BF4D",
                "title": "Booking Count Today",
                "line.interpolate": "cardinal",
                "line.marker_enabled": null,
                "show_series_values": true
            },
            "Booking Count Yesterday": {
                "color": "#4C5773",
                "title": "Booking Count Yesterday"
            }
        },
        "graph.dimensions": [
            "Hour"
        ]
    },
    "is_write": false,
    "collection": {
        "authority_level": null,
        "description": null,
        "archived": false,
        "slug": "tech",
        "color": "#509EE3",
        "name": "Tech",
        "personal_owner_id": null,
        "id": 64,
        "entity_id": null,
        "location": "/",
        "namespace": null,
        "created_at": "2022-04-28T07:36:15.507853Z"
    },
    "parameters": [],
    "dataset": false,
    "created_at": "2022-08-26T08:20:04.508172Z",
    "public_uuid": null
}
6

@atharva_c I've created an issue for it:
https://github.com/metabase/metabase/issues/27427 - upvote by clicking :+1: on the first post

7

Thanks a lot @flamber :slight_smile: , the unused column is actually legacy and can be removable for our use case, and the subscription is working perfectly now.