An error occurred while displaying this card v0.49-RC1

Get Help
1

Hi All,

I have a challenge with a dashboard being rendered when sent as an email. Please note that this has been working in previous versions. Below is my error log and diagnostics information.

{
  "browser-info": {
    "language": "en-US",
    "platform": "Win32",
    "userAgent": "Mozilla/5.0 (Windows NT 10.0; Win64; x64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/121.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.22+7",
    "java.vendor": "Eclipse Adoptium",
    "java.vendor.url": "https://adoptium.net/",
    "java.version": "11.0.22",
    "java.vm.name": "OpenJDK 64-Bit Server VM",
    "java.vm.version": "11.0.22+7",
    "os.name": "Linux",
    "os.version": "5.15.0-91-generic",
    "user.language": "en",
    "user.timezone": "Africa/Maputo"
  },
  "metabase-info": {
    "databases": [
      "sqlserver",
      "googleanalytics",
      "mysql",
      "clickhouse"
    ],
    "hosting-env": "unknown",
    "application-database": "mysql",
    "application-database-details": {
      "database": {
        "name": "MariaDB",
        "version": "10.11.7-MariaDB-1:10.11.7+maria~ubu2204"
      },
      "jdbc-driver": {
        "name": "MariaDB Connector/J",
        "version": "2.7.10"
      }
    },
    "run-mode": "prod",
    "version": {
      "date": "2024-02-12",
      "tag": "v0.49.0-RC1",
      "hash": "8a571ac"
    },
    "settings": {
      "report-timezone": "Africa/Harare"
    }
  }
}

[56f2f141-9a8c-4c24-b9a6-039f2a72796f] 2024-02-15T17:00:21+02:00 INFO metabase.query-processor.middleware.cache Query took 528.0 ms to run; minimum for cache eligibility is 20.0 s; not eligible
[56f2f141-9a8c-4c24-b9a6-039f2a72796f] 2024-02-15T17:00:21+02:00 ERROR metabase.pulse.render Pulse card render error
Error: Failed to compute trend data for GLB
	at <js> nz(file:/home/metabase/metabase.jar!/frontend_client/app/dist/lib-static-viz.bundle.js:42:2630259-2630309)
	at <js> :anonymous(file:/home/metabase/metabase.jar!/frontend_client/app/dist/lib-static-viz.bundle.js:28:502910-502923)
	at <js> K(file:/home/metabase/metabase.jar!/frontend_client/app/dist/lib-static-viz.bundle.js:28:502277-503855)
	at <js> K.render(file:/home/metabase/metabase.jar!/frontend_client/app/dist/lib-static-viz.bundle.js:28:502186-503901)
	at <js> K.read(file:/home/metabase/metabase.jar!/frontend_client/app/dist/lib-static-viz.bundle.js:28:501755-501793)
	at <js> renderToStaticMarkup(file:/home/metabase/metabase.jar!/frontend_client/app/dist/lib-static-viz.bundle.js:28:509500-509510)
	at <js> cA(file:/home/metabase/metabase.jar!/frontend_client/app/dist/lib-static-viz.bundle.js:46:3779530-3779680)
	at <js> javascript_visualization(file:/home/metabase/metabase.jar!/frontend_shared/static_viz_interface.js:96-100:2314-2424)
	at org.graalvm.polyglot.Value.execute(Value.java:880)
	at metabase.pulse.render.js_engine$execute_fn_name.invokeStatic(js_engine.clj:52)
	at metabase.pulse.render.js_engine$execute_fn_name.doInvoke(js_engine.clj:46)
	at clojure.lang.RestFn.invoke(RestFn.java:490)
	at metabase.pulse.render.js_svg$javascript_visualization.invokeStatic(js_svg.clj:138)
	at metabase.pulse.render.js_svg$javascript_visualization.invoke(js_svg.clj:135)
	at metabase.pulse.render.body$fn__73725$render__73713__73730$fn__73731.invoke(body.clj:906)
	at metabase.pulse.render.body$fn__73725$render__73713__73730.invoke(body.clj:899)
	at clojure.lang.MultiFn.invoke(MultiFn.java:261)
	at metabase.pulse.render$fn__74334$render_pulse_card_body__74339$fn__74343.invoke(render.clj:140)
	at metabase.pulse.render$fn__74334$render_pulse_card_body__74339.invoke(render.clj:130)
	at metabase.pulse.render$fn__74374$render_pulse_card__74379$fn__74380.invoke(render.clj:169)
	at metabase.pulse.render$fn__74374$render_pulse_card__74379.invoke(render.clj:151)
	at metabase.pulse.render$fn__74407$render_pulse_section__74412$fn__74416$fn__74419.invoke(render.clj:203)
	at metabase.pulse.render$fn__74407$render_pulse_section__74412$fn__74416.invoke(render.clj:201)
	at metabase.pulse.render$fn__74407$render_pulse_section__74412.invoke(render.clj:198)
	at metabase.email.messages$render_part.invokeStatic(messages.clj:413)
	at metabase.email.messages$render_part.invoke(messages.clj:409)
	at metabase.email.messages$render_message_body$fn__75436$fn__75437.invoke(messages.clj:466)
	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__75436.invoke(messages.clj:466)
	at metabase.email.messages$render_message_body.invokeStatic(messages.clj:465)
	at metabase.email.messages$render_message_body.invoke(messages.clj:463)
	at metabase.email.messages$render_pulse_email.invokeStatic(messages.clj:492)
	at metabase.email.messages$render_pulse_email.invoke(messages.clj:489)
	at metabase.pulse$fn__98010.invokeStatic(pulse.clj:438)
	at metabase.pulse$fn__98010.invoke(pulse.clj:427)
	at clojure.lang.MultiFn.invoke(MultiFn.java:239)
	at metabase.pulse$parts__GT_notifications$iter__98085__98089$fn__98090$fn__98091.invoke(pulse.clj:509)
	at metabase.pulse$parts__GT_notifications$iter__98085__98089$fn__98090.invoke(pulse.clj:507)
	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:562)
	at metabase.pulse$send_notifications_BANG_.invoke(pulse.clj:561)
	at metabase.pulse$send_pulse_BANG_.invokeStatic(pulse.clj:589)
	at metabase.pulse$send_pulse_BANG_.doInvoke(pulse.clj:570)
	at clojure.lang.RestFn.invoke(RestFn.java:410)
	at metabase.api.pulse$fn__100267.invokeStatic(pulse.clj:349)
	at metabase.api.pulse$fn__100267.invoke(pulse.clj:331)
	at compojure.core$wrap_response$fn__44397.invoke(core.clj:160)
	at compojure.core$wrap_route_middleware$fn__44381.invoke(core.clj:132)
	at compojure.core$wrap_route_info$fn__44386.invoke(core.clj:139)
	at compojure.core$wrap_route_matches$fn__44390.invoke(core.clj:151)
	at clojure.lang.Var.invoke(Var.java:393)
	at compojure.core$routes$fn__44409$f__44410.invoke(core.clj:198)
	at compojure.core$routes$fn__44409$f__44410$respond_SINGLEQUOTE___44411.invoke(core.clj:197)
	at compojure.core$wrap_route_matches$fn__44390.invoke(core.clj:153)
	at clojure.lang.Var.invoke(Var.java:393)
	at compojure.core$routes$fn__44409$f__44410.invoke(core.clj:198)
	at compojure.core$routes$fn__44409$f__44410$respond_SINGLEQUOTE___44411.invoke(core.clj:197)
	at compojure.core$wrap_route_matches$fn__44390.invoke(core.clj:153)
	at clojure.lang.Var.invoke(Var.java:393)
	at compojure.core$routes$fn__44409$f__44410.invoke(core.clj:198)
	at compojure.core$routes$fn__44409$f__44410$respond_SINGLEQUOTE___44411.invoke(core.clj:197)
	at compojure.core$wrap_route_matches$fn__44390.invoke(core.clj:153)
	at clojure.lang.Var.invoke(Var.java:393)
	at compojure.core$routes$fn__44409$f__44410.invoke(core.clj:198)
	at compojure.core$routes$fn__44409$f__44410$respond_SINGLEQUOTE___44411.invoke(core.clj:197)
	at compojure.core$wrap_route_matches$fn__44390.invoke(core.clj:152)
	at clojure.lang.Var.invoke(Var.java:393)
	at compojure.core$routes$fn__44409$f__44410.invoke(core.clj:198)
	at compojure.core$routes$fn__44409.invoke(core.clj:200)
	at metabase.pulse.preview$style_tag_nonce_middleware$fn__98430.invoke(preview.clj:165)
	at metabase.server.middleware.auth$enforce_authentication$fn__92976.invoke(auth.clj:17)
	at compojure.core$routes$fn__44409$f__44410.invoke(core.clj:198)
	at compojure.core$routes$fn__44409.invoke(core.clj:200)
	at compojure.core$make_context$handler__44437.invoke(core.clj:290)
	at compojure.core$make_context$fn__44441.invoke(core.clj:300)
	at compojure.core$routes$fn__44409$f__44410.invoke(core.clj:198)
	at compojure.core$routes$fn__44409$f__44410$respond_SINGLEQUOTE___44411.invoke(core.clj:197)
	at compojure.core$make_context$fn__44441.invoke(core.clj:301)
	at compojure.core$routes$fn__44409$f__44410.invoke(core.clj:198)
	at compojure.core$routes$fn__44409$f__44410$respond_SINGLEQUOTE___44411.invoke(core.clj:197)
	at compojure.core$make_context$fn__44441.invoke(core.clj:301)
	at compojure.core$routes$fn__44409$f__44410.invoke(core.clj:198)
	at compojure.core$routes$fn__44409$f__44410$respond_SINGLEQUOTE___44411.invoke(core.clj:197)
	at compojure.core$make_context$fn__44441.invoke(core.clj:301)
	at compojure.core$routes$fn__44409$f__44410.invoke(core.clj:198)
	at compojure.core$routes$fn__44409$f__44410$respond_SINGLEQUOTE___44411.invoke(core.clj:197)
	at compojure.core$make_context$fn__44441.invoke(core.clj:301)
	at compojure.core$routes$fn__44409$f__44410.invoke(core.clj:198)
	at compojure.core$routes$fn__44409$f__44410$respond_SINGLEQUOTE___44411.invoke(core.clj:197)
	at compojure.core$make_context$fn__44441.invoke(core.clj:301)
	at compojure.core$routes$fn__44409$f__44410.invoke(core.clj:198)
	at compojure.core$routes$fn__44409$f__44410$respond_SINGLEQUOTE___44411.invoke(core.clj:197)
	at compojure.core$make_context$fn__44441.invoke(core.clj:301)
	at compojure.core$routes$fn__44409$f__44410.invoke(core.clj:198)
	at compojure.core$routes$fn__44409$f__44410$respond_SINGLEQUOTE___44411.invoke(core.clj:197)
	at compojure.core$make_context$fn__44441.invoke(core.clj:301)
	at compojure.core$routes$fn__44409$f__44410.invoke(core.clj:198)
	at compojure.core$routes$fn__44409$f__44410$respond_SINGLEQUOTE___44411.invoke(core.clj:197)
	at compojure.core$make_context$fn__44441.invoke(core.clj:301)
	at compojure.core$routes$fn__44409$f__44410.invoke(core.clj:198)
	at compojure.core$routes$fn__44409$f__44410$respond_SINGLEQUOTE___44411.invoke(core.clj:197)
	at compojure.core$make_context$fn__44441.invoke(core.clj:301)
	at compojure.core$routes$fn__44409$f__44410.invoke(core.clj:198)
	at compojure.core$routes$fn__44409$f__44410$respond_SINGLEQUOTE___44411.invoke(core.clj:197)
	at compojure.core$make_context$fn__44441.invoke(core.clj:301)
	at compojure.core$routes$fn__44409$f__44410.invoke(core.clj:198)
	at compojure.core$routes$fn__44409$f__44410$respond_SINGLEQUOTE___44411.invoke(core.clj:197)
	at compojure.core$make_context$fn__44441.invoke(core.clj:301)
	at compojure.core$routes$fn__44409$f__44410.invoke(core.clj:198)
	at compojure.core$routes$fn__44409$f__44410$respond_SINGLEQUOTE___44411.invoke(core.clj:197)
	at compojure.core$make_context$fn__44441.invoke(core.clj:301)
	at compojure.core$routes$fn__44409$f__44410.invoke(core.clj:198)
	at compojure.core$routes$fn__44409$f__44410$respond_SINGLEQUOTE___44411.invoke(core.clj:197)
	at compojure.core$make_context$fn__44441.invoke(core.clj:301)
	at compojure.core$routes$fn__44409$f__44410.invoke(core.clj:198)
	at compojure.core$routes$fn__44409$f__44410$respond_SINGLEQUOTE___44411.invoke(core.clj:197)
	at compojure.core$make_context$fn__44441.invoke(core.clj:301)
	at compojure.core$routes$fn__44409$f__44410.invoke(core.clj:198)
	at compojure.core$routes$fn__44409$f__44410$respond_SINGLEQUOTE___44411.invoke(core.clj:197)
	at compojure.core$make_context$fn__44441.invoke(core.clj:301)
	at compojure.core$routes$fn__44409$f__44410.invoke(core.clj:198)
	at compojure.core$routes$fn__44409$f__44410$respond_SINGLEQUOTE___44411.invoke(core.clj:197)
	at compojure.core$make_context$fn__44441.invoke(core.clj:301)
	at compojure.core$routes$fn__44409$f__44410.invoke(core.clj:198)
	at compojure.core$routes$fn__44409$f__44410$respond_SINGLEQUOTE___44411.invoke(core.clj:197)
	at compojure.core$make_context$fn__44441.invoke(core.clj:301)
	at compojure.core$routes$fn__44409$f__44410.invoke(core.clj:198)
	at compojure.core$routes$fn__44409$f__44410$respond_SINGLEQUOTE___44411.invoke(core.clj:197)
	at compojure.core$make_context$fn__44441.invoke(core.clj:301)
	at compojure.core$routes$fn__44409$f__44410.invoke(core.clj:198)
	at compojure.core$routes$fn__44409$f__44410$respond_SINGLEQUOTE___44411.invoke(core.clj:197)
	at compojure.core$make_context$fn__44441.invoke(core.clj:301)
	at compojure.core$routes$fn__44409$f__44410.invoke(core.clj:198)
	at compojure.core$routes$fn__44409$f__44410$respond_SINGLEQUOTE___44411.invoke(core.clj:197)
	at compojure.core$make_context$fn__44441.invoke(core.clj:301)
	at compojure.core$routes$fn__44409$f__44410.invoke(core.clj:198)
	at compojure.core$routes$fn__44409$f__44410$respond_SINGLEQUOTE___44411.invoke(core.clj:197)
	at compojure.core$make_context$fn__44441.invoke(core.clj:301)
	at compojure.core$routes$fn__44409$f__44410.invoke(core.clj:198)
	at compojure.core$routes$fn__44409$f__44410$respond_SINGLEQUOTE___44411.invoke(core.clj:197)
	at compojure.core$make_context$fn__44441.invoke(core.clj:301)
	at compojure.core$routes$fn__44409$f__44410.invoke(core.clj:198)
	at compojure.core$routes$fn__44409$f__44410$respond_SINGLEQUOTE___44411.invoke(core.clj:197)
	at compojure.core$make_context$fn__44441.invoke(core.clj:301)
	at compojure.core$routes$fn__44409$f__44410.invoke(core.clj:198)
	at compojure.core$routes$fn__44409$f__44410$respond_SINGLEQUOTE___44411.invoke(core.clj:197)
	at compojure.core$make_context$fn__44441.invoke(core.clj:301)
	at compojure.core$routes$fn__44409$f__44410.invoke(core.clj:198)
	at compojure.core$routes$fn__44409$f__44410$respond_SINGLEQUOTE___44411.invoke(core.clj:197)
	at compojure.core$make_context$fn__44441.invoke(core.clj:301)
	at compojure.core$routes$fn__44409$f__44410.invoke(core.clj:198)
	at compojure.core$routes$fn__44409$f__44410$respond_SINGLEQUOTE___44411.invoke(core.clj:197)
	at compojure.core$make_context$fn__44441.invoke(core.clj:301)
	at compojure.core$routes$fn__44409$f__44410.invoke(core.clj:198)
	at compojure.core$routes$fn__44409$f__44410$respond_SINGLEQUOTE___44411.invoke(core.clj:197)
	at compojure.core$make_context$fn__44441.invoke(core.clj:301)
	at compojure.core$routes$fn__44409$f__44410.invoke(core.clj:198)
	at compojure.core$routes$fn__44409$f__44410$respond_SINGLEQUOTE___44411.invoke(core.clj:197)
	at metabase.api.routes$fn__100870$fn__100873.invoke(routes.clj:67)
	at compojure.core$routes$fn__44409$f__44410.invoke(core.clj:198)
	at compojure.core$routes$fn__44409.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__101035$fn__101036.doInvoke(routes.clj:72)
	at clojure.lang.RestFn.invoke(RestFn.java:436)
	at compojure.core$routes$fn__44409$f__44410.invoke(core.clj:198)
	at compojure.core$routes$fn__44409.invoke(core.clj:200)
	at compojure.core$make_context$handler__44437.invoke(core.clj:290)
	at compojure.core$make_context$fn__44441.invoke(core.clj:300)
	at compojure.core$routes$fn__44409$f__44410.invoke(core.clj:198)
	at compojure.core$routes$fn__44409$f__44410$respond_SINGLEQUOTE___44411.invoke(core.clj:197)
	at compojure.core$wrap_route_matches$fn__44390.invoke(core.clj:153)
	at compojure.core$routes$fn__44409$f__44410.invoke(core.clj:198)
	at compojure.core$routes$fn__44409$f__44410$respond_SINGLEQUOTE___44411.invoke(core.clj:197)
	at compojure.core$wrap_route_matches$fn__44390.invoke(core.clj:153)
	at compojure.core$routes$fn__44409$f__44410.invoke(core.clj:198)
	at compojure.core$routes$fn__44409$f__44410$respond_SINGLEQUOTE___44411.invoke(core.clj:197)
	at compojure.core$wrap_route_matches$fn__44390.invoke(core.clj:153)
	at compojure.core$routes$fn__44409$f__44410.invoke(core.clj:198)
	at compojure.core$routes$fn__44409$f__44410$respond_SINGLEQUOTE___44411.invoke(core.clj:197)
	at metabase.server.routes$fn__101020$fn__101022.invoke(routes.clj:49)
	at compojure.core$routes$fn__44409$f__44410.invoke(core.clj:198)
	at compojure.core$routes$fn__44409.invoke(core.clj:200)
	at metabase.server.middleware.exceptions$catch_uncaught_exceptions$fn__97664.invoke(exceptions.clj:108)
	at metabase.server.middleware.exceptions$catch_api_exceptions$fn__97661.invoke(exceptions.clj:96)
	at metabase.server.middleware.log$log_api_call$fn__101303$fn__101304$fn__101305.invoke(log.clj:216)
	at metabase.driver.sql_jdbc.execute.diagnostic$do_with_diagnostic_info.invokeStatic(diagnostic.clj:18)
	at metabase.driver.sql_jdbc.execute.diagnostic$do_with_diagnostic_info.invoke(diagnostic.clj:12)
	at metabase.server.middleware.log$log_api_call$fn__101303$fn__101304.invoke(log.clj:208)
	at toucan2.execute$do_with_call_counts.invokeStatic(execute.clj:112)
	at toucan2.execute$do_with_call_counts.invoke(execute.clj:103)
	at metabase.server.middleware.log$log_api_call$fn__101303.invoke(log.clj:207)
	at metabase.server.middleware.browser_cookie$ensure_browser_id_cookie$fn__103276.invoke(browser_cookie.clj:40)
	at metabase.server.middleware.security$add_security_headers$fn__83853.invoke(security.clj:182)
	at metabase.server.middleware.json$wrap_json_body$fn__45755.invoke(json.clj:67)
	at metabase.server.middleware.offset_paging$handle_paging$fn__83877.invoke(offset_paging.clj:45)
	at metabase.server.middleware.json$wrap_streamed_json_response$fn__45773.invoke(json.clj:103)
	at ring.middleware.keyword_params$wrap_keyword_params$fn__103543.invoke(keyword_params.clj:55)
	at ring.middleware.params$wrap_params$fn__103562.invoke(params.clj:77)
	at metabase.server.middleware.misc$maybe_set_site_url$fn__66612.invoke(misc.clj:61)
	at metabase.server.middleware.session$reset_session_timeout$fn__71785.invoke(session.clj:542)
	at metabase.server.middleware.session$bind_current_user$fn__71751$fn__71752.invoke(session.clj:437)
	at metabase.server.middleware.session$do_with_current_user.invokeStatic(session.clj:416)
	at metabase.server.middleware.session$do_with_current_user.invoke(session.clj:400)
	at metabase.server.middleware.session$bind_current_user$fn__71751.invoke(session.clj:436)
	at metabase.server.middleware.session$wrap_current_user_info$fn__71734.invoke(session.clj:375)
	at metabase.server.middleware.session$wrap_session_id$fn__71706.invoke(session.clj:254)
	at metabase.server.middleware.auth$wrap_static_api_key$fn__92984.invoke(auth.clj:30)
	at ring.middleware.cookies$wrap_cookies$fn__103463.invoke(cookies.clj:216)
	at metabase.server.middleware.misc$add_content_type$fn__66594.invoke(misc.clj:29)
	at metabase.server.middleware.misc$disable_streaming_buffering$fn__66620.invoke(misc.clj:78)
	at ring.middleware.gzip$wrap_gzip$fn__103505.invoke(gzip.clj:86)
	at metabase.server.middleware.misc$bind_request$fn__66623.invoke(misc.clj:95)
	at metabase.server.middleware.ssl$redirect_to_https_middleware$fn__103292.invoke(ssl.clj:51)
	at metabase.server$async_proxy_handler$fn__66797.invoke(server.clj:78)
	at metabase.server.proxy$org.eclipse.jetty.server.handler.AbstractHandler$ff19274a.handle(Unknown Source)
	at org.eclipse.jetty.server.handler.StatisticsHandler.handle(StatisticsHandler.java:173)
	at org.eclipse.jetty.server.handler.HandlerWrapper.handle(HandlerWrapper.java:122)
	at org.eclipse.jetty.server.Server.handle(Server.java:563)
	at org.eclipse.jetty.server.HttpChannel$RequestDispatchable.dispatch(HttpChannel.java:1598)
	at org.eclipse.jetty.server.HttpChannel.dispatch(HttpChannel.java:753)
	at org.eclipse.jetty.server.HttpChannel.handle(HttpChannel.java:501)
	at org.eclipse.jetty.server.HttpConnection.onFillable(HttpConnection.java:287)
	at org.eclipse.jetty.io.AbstractConnection$ReadCallback.succeeded(AbstractConnection.java:314)
	at org.eclipse.jetty.io.FillInterest.fillable(FillInterest.java:100)
	at org.eclipse.jetty.io.SelectableChannelEndPoint$1.run(SelectableChannelEndPoint.java:53)
	at org.eclipse.jetty.util.thread.strategy.AdaptiveExecutionStrategy.runTask(AdaptiveExecutionStrategy.java:421)
	at org.eclipse.jetty.util.thread.strategy.AdaptiveExecutionStrategy.consumeTask(AdaptiveExecutionStrategy.java:390)
	at org.eclipse.jetty.util.thread.strategy.AdaptiveExecutionStrategy.tryProduce(AdaptiveExecutionStrategy.java:277)
	at org.eclipse.jetty.util.thread.strategy.AdaptiveExecutionStrategy.run(AdaptiveExecutionStrategy.java:199)
	at org.eclipse.jetty.util.thread.ReservedThreadExecutor$ReservedThread.run(ReservedThreadExecutor.java:411)
	at org.eclipse.jetty.util.thread.QueuedThreadPool.runJob(QueuedThreadPool.java:969)
	at org.eclipse.jetty.util.thread.QueuedThreadPool$Runner.doRunJob(QueuedThreadPool.java:1194)
	at org.eclipse.jetty.util.thread.QueuedThreadPool$Runner.run(QueuedThreadPool.java:1149)
	at java.base/java.lang.Thread.run(Thread.java:829)
[56f2f141-9a8c-4c24-b9a6-039f2a72796f] 2024-02-15T17:00:21+02:00 DEBUG metabase.server.middleware.log
2

"Failed to compute trend data for GLB", can you tell us a bit more about the dashboard? we want to try to reproduce this issue

3

Hi,

I have done tests on the trend charts, that are created using the notebook query are working fine in the email subscription. But all trend charts created using SQL are failing to render in the subscription. For instance, the GLB trend chart compares a metric in the current month with the same date in the previous month and the question is written in SQL. I am using Clickhouse database as a data source.

4

When I turn the trend chart to a table, the viz renders as expected in the email subscription.

5

Hi @asimumba, would you be able to inspect the network calls in your browser and tell us what the JSON response for this API call is? https://<your_metabase_url>/api/card/<card_id>/query

Please don't post it here if the data is sensitive but if it is not, that will help with debugging this issue.

6

Hi,

See below the JSON

{
   "description":null,
   "archived":false,
   "collection_position":null,
   "table_id":null,
   "result_metadata":[
      {
         "display_name":"Business Date",
         "field_ref":[
            "field",
            "Business Date",
            {
               "base-type":"type/Date"
            }
         ],
         "name":"Business Date",
         "base_type":"type/Date",
         "effective_type":"type/Date",
         "semantic_type":null,
         "fingerprint":{
            "global":{
               "distinct-count":2,
               "nil%":0.0
            },
            "type":{
               "type/DateTime":{
                  "earliest":"2024-01-22T00:00:00+02:00",
                  "latest":"2024-02-22T00:00:00+02:00"
               }
            }
         }
      },
      {
         "display_name":"PAR 0 %",
         "field_ref":[
            "field",
            "PAR 0 %",
            {
               "base-type":"type/Float"
            }
         ],
         "name":"PAR 0 %",
         "base_type":"type/Float",
         "effective_type":"type/Float",
         "semantic_type":null,
         "fingerprint":{
            "global":{
               "distinct-count":2,
               "nil%":0.0
            },
            "type":{
               "type/Number":{
                  "min":0.7380546476056263,
                  "q1":0.7380546476056263,
                  "q3":0.7550365995066497,
                  "max":0.7550365995066497,
                  "sd":0.0120080533469974,
                  "avg":0.7465456235561381
               }
            }
         }
      }
   ],
   "creator":{
   xxxxx
   },
   "initially_published_at":null,
   "can_write":true,
   "database_id":64,
   "enable_embedding":false,
   "collection_id":143,
   "query_type":"native",
   "name":"Global PAR 0%",
   "last_query_start":"2024-02-23T09:42:31.115633+02:00",
   "dashboard_count":2,
   "type":"question",
   "average_query_time":6898.4402,
   "creator_id":1,
   "moderation_reviews":[
      
   ],
   "updated_at":"2024-02-23T09:42:31.809472+02:00",
   "made_public_by_id":null,
   "embedding_params":null,
   "cache_ttl":null,
   "dataset_query":{
      "database":64,
      "type":"native",
      "native":{
         "template-tags":{
            "#696-model-summary":{
               "type":"card",
               "name":"#696-model-summary",
               "id":"f3ebb482-c525-49f6-969a-dbfb0ed59c89",
               "display-name":"#696 Model Summary",
               "card-id":696
            }
         },
         "query":"select \r\n      `Business Date`,\r\n      sum(`Global PAR 0 %`) as `PAR 0 %`\r\nfrom {{#696-model-summary}}\r\nwhere\r\n`Business Date` IN\r\n    (select dateSub(max_date, INTERVAL number month) as comparable_date\r\n     from\r\n      (select max(`Business Date`) as max_date\r\n        from {{#696-model-summary}}\r\n        where `Business Date` <= toDate(now()) ) array\r\n     join [0,1] as number)\r\n    group by `Business Date`\r\n    order by `Business Date`"
      }
   },
   "id":665,
   "parameter_mappings":[
      
   ],
   "display":"smartscalar",
   "entity_id":"9scZAsxFln5ihKsHETJ1D",
   "collection_preview":true,
   "last-edit-info":{
   xxxx
   },
   "visualization_settings":{
      "scalar.field":"Balance",
      "table.pivot_column":"Business Date",
      "table.cell_column":"Rim No",
      "scalar.comparisons":[
         {
            "id":"b4d77bd8-6e0a-f564-8603-fc0fc1166818",
            "type":"previousValue"
         },
         {
            "id":"93821ab2-1bca-b662-ecc7-61a826ef676d",
            "type":"staticNumber",
            "label":"Budget",
            "value":0.92
         }
      ],
      "graph.dimensions":[
         "Business Date"
      ],
      "column_settings":{
         "[\"name\",\"sum(PAR 0 %)\"]":{
            "number_style":"percent"
         },
         "[\"name\",\"sum(Global PAR 0 %)\"]":{
            "number_style":"percent",
            "decimals":2
         },
         "[\"name\",\"PAR 0 %\"]":{
            "number_style":"percent"
         }
      },
      "graph.metrics":[
         "PAR 0 %"
      ]
   },
   "collection":{
      "authority_level":null,
      "description":null,
      "archived":false,
      "slug":"port_questions",
      "name":"Port Questions",
      "personal_owner_id":null,
      "type":null,
      "id":143,
      "entity_id":"tbBwtmlSXCUgJeRUa9Vfr",
      "location":"/116/",
      "namespace":null,
      "is_personal":false,
      "created_at":"2024-01-11T11:50:47.36685+02:00"
   },
   "metabase_version":"v0.48.1 (a8302d4)",
   "parameters":[
      
   ],
   "dataset":false,
   "created_at":"2023-12-31T20:04:13+02:00",
   "parameter_usage_count":0,
   "public_uuid":null
}
7

Hi all,

I'm not able to reproduce the error with this example code below.

SELECT 
    CASE 
        WHEN number = 0 THEN toDate(now())
        ELSE dateSub(max_date, INTERVAL number MONTH)
    END AS `Business Date`,
    rand() * 1000 AS `Column1`
FROM system.one
CROSS JOIN (
    SELECT '2024-02-23' AS max_date
) AS max_dates
ARRAY JOIN [0, 1] AS number
order by `Business Date`

EDIT: when I create a fresh question and add it to the dashboard, it renders properly in an email subscription.

8

So the same sql works in a new question but it does not work in the existing question?

9

Hi @vamsi , yes, so all the SQL questions when a new question is generated work fine. So I don't know if it has anything to do with the upgrade process.