Issue with visualization charts in emails - An error occurred while displaying this card

[DianBoynov]

Hello everyone,

I have set up a couple of dashboards for each I have made a daily subscription to receive them by email. Each of the dashboards is set as a Question Type Query. When I received the email I could see all charts were not displayed and instead I had the following error: " An error occurred while displaying this card":

Here is the Diagnostic Info:

{ "browser-info": { "language": "en-US", "platform": "Win32", "userAgent": "Mozilla/5.0 (Windows NT 10.0; Win64; x64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/120.0.0.0 Safari/537.36", "vendor": "Google Inc." }, "system-info": { "file.encoding": "Cp1252", "java.runtime.name": "IBM Semeru Runtime Open Edition", "java.runtime.version": "11.0.17+8", "java.vendor": "IBM Corporation", "java.vendor.url": "https://www.ibm.com/semeru-runtimes", "java.version": "11.0.17", "java.vm.name": "Eclipse OpenJ9 VM", "java.vm.version": "openj9-0.35.0", "os.name": "Windows Server 2022", "os.version": "10.0", "user.language": "en", "user.timezone": "UTC" }, "metabase-info": { "databases": [ "mysql" ], "hosting-env": "unknown", "application-database": "h2", "application-database-details": { "database": { "name": "H2", "version": "2.1.214 (2022-06-13)" }, "jdbc-driver": { "name": "H2 JDBC Driver", "version": "2.1.214 (2022-06-13)" } }, "run-mode": "prod", "version": { "date": "2023-11-17", "tag": "v0.47.8", "branch": "?", "hash": "639fa5e" }, "settings": { "report-timezone": null } } }

Here is the Error Log (it is quite big, so I render it):

2023-12-07 15:47:15,073 [qtp-2101399005-83] ERRORmetabase.pulse.render - Pulse card render error org.graalvm.polyglot.PolyglotException: SyntaxError: java.lang.StringIndexOutOfBoundsException java.lang.StringIndexOutOfBoundsException java.lang.StringIndexOutOfBoundsException color_selector.js:1:161 Expected an operand but found, ?/the rendered part, which is the query execution and data aggregation/ at org.graalvm.polyglot.Context.eval(Context.java:399) ~[metabase.jar:?] at metabase.pulse.render.js_engine$load_resource.invokeStatic(js_engine.clj:44) ~[metabase.jar:?] at metabase.pulse.render.js_engine$load_resource.invoke(js_engine.clj:37) ~[metabase.jar:?] at metabase.pulse.render.js_svg$load_viz_bundle.invokeStatic(js_svg.clj:35) ~[metabase.jar:?] at metabase.pulse.render.js_svg$load_viz_bundle.invoke(js_svg.clj:33) ~[metabase.jar:?] at metabase.pulse.render.js_svg$fn__52658.invokeStatic(js_svg.clj:42) ~[metabase.jar:?] at metabase.pulse.render.js_svg$fn__52658.invoke(js_svg.clj:42) ~[metabase.jar:?] at clojure.lang.Delay.deref(Delay.java:42) ~[metabase.jar:?] at clojure.core$deref.invokeStatic(core.clj:2337) ~[metabase.jar:?] at clojure.core$deref.invoke(core.clj:2323) ~[metabase.jar:?] at metabase.pulse.render.js_svg$context.invokeStatic(js_svg.clj:48) ~[metabase.jar:?] at metabase.pulse.render.js_svg$context.invoke(js_svg.clj:44) ~[metabase.jar:?] at metabase.pulse.render.js_svg$combo_chart.invokeStatic(js_svg.clj:142) ~[metabase.jar:?] at metabase.pulse.render.js_svg$combo_chart.invoke(js_svg.clj:133) ~[metabase.jar:?] at metabase.pulse.render.body$lab_image_bundle.invokeStatic(body.clj:832) ~[metabase.jar:?] at metabase.pulse.render.body$lab_image_bundle.invoke(body.clj:807) ~[metabase.jar:?] at metabase.pulse.render.body$fn__83184$render__83172__83189$fn__83190.invoke(body.clj:851) ~[metabase.jar:?] at metabase.pulse.render.body$fn__83184$render__83172__83189.invoke(body.clj:849) ~[metabase.jar:?] at clojure.lang.MultiFn.invoke(MultiFn.java:261) ~[metabase.jar:?] at metabase.pulse.render$fn__83907$render_pulse_card_body__83912$fn__83916.invoke(render.clj:131) ~[metabase.jar:?] at metabase.pulse.render$fn__83907$render_pulse_card_body__83912.invoke(render.clj:121) ~[metabase.jar:?] at metabase.pulse.render$fn__83948$render_pulse_card__83953$fn__83954.invoke(render.clj:163) ~[metabase.jar:?] at metabase.pulse.render$fn__83948$render_pulse_card__83953.invoke(render.clj:145) ~[metabase.jar:?] at metabase.pulse.render$fn__83980$render_pulse_section__83985$fn__83989$fn__83992.invoke(render.clj:195) ~[metabase.jar:?] at metabase.pulse.render$fn__83980$render_pulse_section__83985$fn__83989.invoke(render.clj:193) ~[metabase.jar:?] at metabase.pulse.render$fn__83980$render_pulse_section__83985.invoke(render.clj:190) ~[metabase.jar:?] at metabase.email.messages$render_part.invokeStatic(messages.clj:440) ~[metabase.jar:?] at metabase.email.messages$render_part.invoke(messages.clj:436) ~[metabase.jar:?] at metabase.email.messages$render_message_body$fn__85102$fn__85103.invoke(messages.clj:493) ~[metabase.jar:?] at clojure.core$mapv$fn__8535.invoke(core.clj:6979) ~[metabase.jar:?] at clojure.core.protocols$fn__8249.invokeStatic(protocols.clj:168) ~[metabase.jar:?] at clojure.core.protocols$fn__8249.invoke(protocols.clj:124) ~[metabase.jar:?] at clojure.core.protocols$fn__8204$G__8199__8213.invoke(protocols.clj:19) ~[metabase.jar:?] at clojure.core.protocols$seq_reduce.invokeStatic(protocols.clj:31) ~[metabase.jar:?] at clojure.core.protocols$fn__8236.invokeStatic(protocols.clj:75) ~[metabase.jar:?] at clojure.core.protocols$fn__8236.invoke(protocols.clj:75) ~[metabase.jar:?] at clojure.core.protocols$fn__8178$G__8173__8191.invoke(protocols.clj:13) ~[metabase.jar:?] at clojure.core$reduce.invokeStatic(core.clj:6886) ~[metabase.jar:?] at clojure.core$mapv.invokeStatic(core.clj:6970) ~[metabase.jar:?] at clojure.core$mapv.invoke(core.clj:6970) ~[metabase.jar:?] at metabase.email.messages$render_message_body$fn__85102.invoke(messages.clj:493) ~[metabase.jar:?] at metabase.email.messages$render_message_body.invokeStatic(messages.clj:492) ~[metabase.jar:?] at metabase.email.messages$render_message_body.invoke(messages.clj:490) ~[metabase.jar:?] at metabase.email.messages$render_pulse_email.invokeStatic(messages.clj:519) ~[metabase.jar:?] at metabase.email.messages$render_pulse_email.invoke(messages.clj:516) ~[metabase.jar:?] at metabase.pulse$fn__110339.invokeStatic(pulse.clj:431) ~[metabase.jar:?] at metabase.pulse$fn__110339.invoke(pulse.clj:420) ~[metabase.jar:?] at clojure.lang.MultiFn.invoke(MultiFn.java:239) ~[metabase.jar:?] at metabase.pulse$parts__GT_notifications$iter__110413__110417$fn__110418$fn__110419.invoke(pulse.clj:494) ~[metabase.jar:?] at metabase.pulse$parts__GT_notifications$iter__110413__110417$fn__110418.invoke(pulse.clj:492) ~[metabase.jar:?] at clojure.lang.LazySeq.sval(LazySeq.java:42) ~[metabase.jar:?] at clojure.lang.LazySeq.seq(LazySeq.java:51) ~[metabase.jar:?] at clojure.lang.RT.seq(RT.java:535) ~[metabase.jar:?] at clojure.core$seq__5467.invokeStatic(core.clj:139) ~[metabase.jar:?] at clojure.core$seq__5467.invoke(core.clj:139) ~[metabase.jar:?] at metabase.pulse$send_notifications_BANG_.invokeStatic(pulse.clj:615) ~[metabase.jar:?] at metabase.pulse$send_notifications_BANG_.invoke(pulse.clj:614) ~[metabase.jar:?] at metabase.pulse$send_pulse_BANG_.invokeStatic(pulse.clj:642) ~[metabase.jar:?] at metabase.pulse$send_pulse_BANG_.doInvoke(pulse.clj:623) ~[metabase.jar:?] at clojure.lang.RestFn.invoke(RestFn.java:410) ~[metabase.jar:?] at metabase.api.pulse$fn__111591.invokeStatic(pulse.clj:322) ~[metabase.jar:?] at metabase.api.pulse$fn__111591.invoke(pulse.clj:308) ~[metabase.jar:?] at compojure.core$wrap_response$fn__44401.invoke(core.clj:160) ~[metabase.jar:?] at compojure.core$wrap_route_middleware$fn__44385.invoke(core.clj:132) ~[metabase.jar:?] at compojure.core$wrap_route_info$fn__44390.invoke(core.clj:139) ~[metabase.jar:?] at compojure.core$wrap_route_matches$fn__44394.invoke(core.clj:151) ~[metabase.jar:?] at compojure.core$routes$fn__44413$f__44414.invoke(core.clj:198) ~[metabase.jar:?] at compojure.core$routes$fn__44413$f__44414$respond_SINGLEQUOTE___44415.invoke(core.clj:197) ~[metabase.jar:?] at compojure.core$wrap_route_matches$fn__44394.invoke(core.clj:153) ~[metabase.jar:?] at compojure.core$routes$fn__44413$f__44414.invoke(core.clj:198) ~[metabase.jar:?] at compojure.core$routes$fn__44413$f__44414$respond_SINGLEQUOTE___44415.invoke(core.clj:197) ~[metabase.jar:?] at compojure.core$wrap_route_matches$fn__44394.invoke(core.clj:153) ~[metabase.jar:?] at compojure.core$routes$fn__44413$f__44414.invoke(core.clj:198) ~[metabase.jar:?] at compojure.core$routes$fn__44413$f__44414$respond_SINGLEQUOTE___44415.invoke(core.clj:197) ~[metabase.jar:?] at compojure.core$wrap_route_matches$fn__44394.invoke(core.clj:153) ~[metabase.jar:?] at compojure.core$routes$fn__44413$f__44414.invoke(core.clj:198) ~[metabase.jar:?] at compojure.core$routes$fn__44413$f__44414$respond_SINGLEQUOTE___44415.invoke(core.clj:197) ~[metabase.jar:?] at compojure.core$wrap_route_matches$fn__44394.invoke(core.clj:152) ~[metabase.jar:?] at compojure.core$routes$fn__44413$f__44414.invoke(core.clj:198) ~[metabase.jar:?] at compojure.core$routes$fn__44413.invoke(core.clj:200) ~[metabase.jar:?] at metabase.server.middleware.auth$enforce_authentication$fn__100419.invoke(auth.clj:17) ~[metabase.jar:?] at compojure.core$routes$fn__44413$f__44414.invoke(core.clj:198) ~[metabase.jar:?] at compojure.core$routes$fn__44413.invoke(core.clj:200) ~[metabase.jar:?] at compojure.core$make_context$handler__44441.invoke(core.clj:290) ~[metabase.jar:?] at compojure.core$make_context$fn__44445.invoke(core.clj:300) ~[metabase.jar:?] at compojure.core$routes$fn__44413$f__44414.invoke(core.clj:198) ~[metabase.jar:?] at compojure.core$routes$fn__44413$f__44414$respond_SINGLEQUOTE___44415.invoke(core.clj:197) ~[metabase.jar:?] at compojure.core$make_context$fn__44445.invoke(core.clj:301) ~[metabase.jar:?] at compojure.core$routes$fn__44413$f__44414.invoke(core.clj:198) ~[metabase.jar:?] at compojure.core$routes$fn__44413$f__44414$respond_SINGLEQUOTE___44415.invoke(core.clj:197) ~[metabase.jar:?] at compojure.core$make_context$fn__44445.invoke(core.clj:301) ~[metabase.jar:?] at compojure.core$routes$fn__44413$f__44414.invoke(core.clj:198) ~[metabase.jar:?] at compojure.core$routes$fn__44413$f__44414$respond_SINGLEQUOTE___44415.invoke(core.clj:197) ~[metabase.jar:?] at compojure.core$make_context$fn__44445.invoke(core.clj:301) ~[metabase.jar:?] at compojure.core$routes$fn__44413$f__44414.invoke(core.clj:198) ~[metabase.jar:?] at compojure.core$routes$fn__44413$f__44414$respond_SINGLEQUOTE___44415.invoke(core.clj:197) ~[metabase.jar:?] at compojure.core$make_context$fn__44445.invoke(core.clj:301) ~[metabase.jar:?] at compojure.core$routes$fn__44413$f__44414.invoke(core.clj:198) ~[metabase.jar:?] at compojure.core$routes$fn__44413$f__44414$respond_SINGLEQUOTE___44415.invoke(core.clj:197) ~[metabase.jar:?] at compojure.core$make_context$fn__44445.invoke(core.clj:301) ~[metabase.jar:?] at compojure.core$routes$fn__44413$f__44414.invoke(core.clj:198) ~[metabase.jar:?] at compojure.core$routes$fn__44413$f__44414$respond_SINGLEQUOTE___44415.invoke(core.clj:197) ~[metabase.jar:?] at compojure.core$make_context$fn__44445.invoke(core.clj:301) ~[metabase.jar:?] at compojure.core$routes$fn__44413$f__44414.invoke(core.clj:198) ~[metabase.jar:?] at compojure.core$routes$fn__44413$f__44414$respond_SINGLEQUOTE___44415.invoke(core.clj:197) ~[metabase.jar:?] at compojure.core$make_context$fn__44445.invoke(core.clj:301) ~[metabase.jar:?] at compojure.core$routes$fn__44413$f__44414.invoke(core.clj:198) ~[metabase.jar:?] at compojure.core$routes$fn__44413$f__44414$respond_SINGLEQUOTE___44415.invoke(core.clj:197) ~[metabase.jar:?] at compojure.core$make_context$fn__44445.invoke(core.clj:301) ~[metabase.jar:?] at compojure.core$routes$fn__44413$f__44414.invoke(core.clj:198) ~[metabase.jar:?] at compojure.core$routes$fn__44413$f__44414$respond_SINGLEQUOTE___44415.invoke(core.clj:197) ~[metabase.jar:?] at compojure.core$make_context$fn__44445.invoke(core.clj:301) ~[metabase.jar:?] at compojure.core$routes$fn__44413$f__44414.invoke(core.clj:198) ~[metabase.jar:?] at compojure.core$routes$fn__44413$f__44414$respond_SINGLEQUOTE___44415.invoke(core.clj:197) ~[metabase.jar:?] at compojure.core$make_context$fn__44445.invoke(core.clj:301) ~[metabase.jar:?] at compojure.core$routes$fn__44413$f__44414.invoke(core.clj:198) ~[metabase.jar:?] at compojure.core$routes$fn__44413$f__44414$respond_SINGLEQUOTE___44415.invoke(core.clj:197) ~[metabase.jar:?] at compojure.core$make_context$fn__44445.invoke(core.clj:301) ~[metabase.jar:?] at compojure.core$routes$fn__44413$f__44414.invoke(core.clj:198) ~[metabase.jar:?] at compojure.core$routes$fn__44413$f__44414$respond_SINGLEQUOTE___44415.invoke(core.clj:197) ~[metabase.jar:?] at compojure.core$make_context$fn__44445.invoke(core.clj:301) ~[metabase.jar:?] at compojure.core$routes$fn__44413$f__44414.invoke(core.clj:198) ~[metabase.jar:?] at compojure.core$routes$fn__44413$f__44414$respond_SINGLEQUOTE___44415.invoke(core.clj:197) ~[metabase.jar:?] at compojure.core$make_context$fn__44445.invoke(core.clj:301) ~[metabase.jar:?] at compojure.core$routes$fn__44413$f__44414.invoke(core.clj:198) ~[metabase.jar:?] at compojure.core$routes$fn__44413$f__44414$respond_SINGLEQUOTE___44415.invoke(core.clj:197) ~[metabase.jar:?] at compojure.core$make_context$fn__44445.invoke(core.clj:301) ~[metabase.jar:?] at compojure.core$routes$fn__44413$f__44414.invoke(core.clj:198) ~[metabase.jar:?] at compojure.core$routes$fn__44413$f__44414$respond_SINGLEQUOTE___44415.invoke(core.clj:197) ~[metabase.jar:?] at compojure.core$make_context$fn__44445.invoke(core.clj:301) ~[metabase.jar:?] at compojure.core$routes$fn__44413$f__44414.invoke(core.clj:198) ~[metabase.jar:?] at compojure.core$routes$fn__44413$f__44414$respond_SINGLEQUOTE___44415.invoke(core.clj:197) ~[metabase.jar:?] at compojure.core$make_context$fn__44445.invoke(core.clj:301) ~[metabase.jar:?] at compojure.core$routes$fn__44413$f__44414.invoke(core.clj:198) ~[metabase.jar:?] at compojure.core$routes$fn__44413$f__44414$respond_SINGLEQUOTE___44415.invoke(core.clj:197) ~[metabase.jar:?] at compojure.core$make_context$fn__44445.invoke(core.clj:301) ~[metabase.jar:?] at compojure.core$routes$fn__44413$f__44414.invoke(core.clj:198) ~[metabase.jar:?] at compojure.core$routes$fn__44413$f__44414$respond_SINGLEQUOTE___44415.invoke(core.clj:197) ~[metabase.jar:?] at compojure.core$make_context$fn__44445.invoke(core.clj:301) ~[metabase.jar:?] at compojure.core$routes$fn__44413$f__44414.invoke(core.clj:198) ~[metabase.jar:?] at compojure.core$routes$fn__44413$f__44414$respond_SINGLEQUOTE___44415.invoke(core.clj:197) ~[metabase.jar:?] at compojure.core$make_context$fn__44445.invoke(core.clj:301) ~[metabase.jar:?] at compojure.core$routes$fn__44413$f__44414.invoke(core.clj:198) ~[metabase.jar:?] at compojure.core$routes$fn__44413$f__44414$respond_SINGLEQUOTE___44415.invoke(core.clj:197) ~[metabase.jar:?] at compojure.core$make_context$fn__44445.invoke(core.clj:301) ~[metabase.jar:?] at compojure.core$routes$fn__44413$f__44414.invoke(core.clj:198) ~[metabase.jar:?] at compojure.core$routes$fn__44413$f__44414$respond_SINGLEQUOTE___44415.invoke(core.clj:197) ~[metabase.jar:?] at compojure.core$make_context$fn__44445.invoke(core.clj:301) ~[metabase.jar:?] at compojure.core$routes$fn__44413$f__44414.invoke(core.clj:198) ~[metabase.jar:?] at compojure.core$routes$fn__44413$f__44414$respond_SINGLEQUOTE___44415.invoke(core.clj:197) ~[metabase.jar:?] at compojure.core$make_context$fn__44445.invoke(core.clj:301) ~[metabase.jar:?] at compojure.core$routes$fn__44413$f__44414.invoke(core.clj:198) ~[metabase.jar:?] at compojure.core$routes$fn__44413$f__44414$respond_SINGLEQUOTE___44415.invoke(core.clj:197) ~[metabase.jar:?] at compojure.core$make_context$fn__44445.invoke(core.clj:301) ~[metabase.jar:?] at compojure.core$routes$fn__44413$f__44414.invoke(core.clj:198) ~[metabase.jar:?] at compojure.core$routes$fn__44413$f__44414$respond_SINGLEQUOTE___44415.invoke(core.clj:197) ~[metabase.jar:?] at compojure.core$make_context$fn__44445.invoke(core.clj:301) ~[metabase.jar:?] at compojure.core$routes$fn__44413$f__44414.invoke(core.clj:198) ~[metabase.jar:?] at compojure.core$routes$fn__44413$f__44414$respond_SINGLEQUOTE___44415.invoke(core.clj:197) ~[metabase.jar:?] at compojure.core$make_context$fn__44445.invoke(core.clj:301) ~[metabase.jar:?] at compojure.core$routes$fn__44413$f__44414.invoke(core.clj:198) ~[metabase.jar:?] at compojure.core$routes$fn__44413$f__44414$respond_SINGLEQUOTE___44415.invoke(core.clj:197) ~[metabase.jar:?] at compojure.core$make_context$fn__44445.invoke(core.clj:301) ~[metabase.jar:?] at compojure.core$routes$fn__44413$f__44414.invoke(core.clj:198) ~[metabase.jar:?] at compojure.core$routes$fn__44413$f__44414$respond_SINGLEQUOTE___44415.invoke(core.clj:197) ~[metabase.jar:?] at compojure.core$make_context$fn__44445.invoke(core.clj:301) ~[metabase.jar:?] at compojure.core$routes$fn__44413$f__44414.invoke(core.clj:198) ~[metabase.jar:?] at compojure.core$routes$fn__44413$f__44414$respond_SINGLEQUOTE___44415.invoke(core.clj:197) ~[metabase.jar:?] at metabase.api.routes$fn__112191$fn__112194.invoke(routes.clj:66) ~[metabase.jar:?] at compojure.core$routes$fn__44413$f__44414.invoke(core.clj:198) ~[metabase.jar:?] at compojure.core$routes$fn__44413.invoke(core.clj:200) ~[metabase.jar:?] at clojure.lang.AFn.applyToHelper(AFn.java:160) ~[metabase.jar:?] at clojure.lang.AFn.applyTo(AFn.java:144) ~[metabase.jar:?] at clojure.core$apply.invokeStatic(core.clj:667) ~[metabase.jar:?] at clojure.core$apply.invoke(core.clj:662) ~[metabase.jar:?] at metabase.server.routes$fn__112356$fn__112357.doInvoke(routes.clj:70) ~[metabase.jar:?] at clojure.lang.RestFn.invoke(RestFn.java:436) ~[metabase.jar:?] at compojure.core$routes$fn__44413$f__44414.invoke(core.clj:198) ~[metabase.jar:?] at compojure.core$routes$fn__44413.invoke(core.clj:200) ~[metabase.jar:?] at compojure.core$make_context$handler__44441.invoke(core.clj:290) ~[metabase.jar:?] at compojure.core$make_context$fn__44445.invoke(core.clj:300) ~[metabase.jar:?] at compojure.core$routes$fn__44413$f__44414.invoke(core.clj:198) ~[metabase.jar:?] at compojure.core$routes$fn__44413$f__44414$respond_SINGLEQUOTE___44415.invoke(core.clj:197) ~[metabase.jar:?] at compojure.core$wrap_route_matches$fn__44394.invoke(core.clj:153) ~[metabase.jar:?] at compojure.core$routes$fn__44413$f__44414.invoke(core.clj:198) ~[metabase.jar:?] at compojure.core$routes$fn__44413$f__44414$respond_SINGLEQUOTE___44415.invoke(core.clj:197) ~[metabase.jar:?] at compojure.core$wrap_route_matches$fn__44394.invoke(core.clj:153) ~[metabase.jar:?] at compojure.core$routes$fn__44413$f__44414.invoke(core.clj:198) ~[metabase.jar:?] at compojure.core$routes$fn__44413$f__44414$respond_SINGLEQUOTE___44415.invoke(core.clj:197) ~[metabase.jar:?] at compojure.core$wrap_route_matches$fn__44394.invoke(core.clj:153) ~[metabase.jar:?] at compojure.core$routes$fn__44413$f__44414.invoke(core.clj:198) ~[metabase.jar:?] at compojure.core$routes$fn__44413$f__44414$respond_SINGLEQUOTE___44415.invoke(core.clj:197) ~[metabase.jar:?] at metabase.server.routes$fn__112341$fn__112343.invoke(routes.clj:47) ~[metabase.jar:?] at compojure.core$routes$fn__44413$f__44414.invoke(core.clj:198) ~[metabase.jar:?] at compojure.core$routes$fn__44413.invoke(core.clj:200) ~[metabase.jar:?] at metabase.server.middleware.exceptions$catch_uncaught_exceptions$fn__108783.invoke(exceptions.clj:107) ~[metabase.jar:?] at metabase.server.middleware.exceptions$catch_api_exceptions$fn__108780.invoke(exceptions.clj:95) ~[metabase.jar:?] at metabase.server.middleware.log$log_api_call$fn__112628$fn__112629$fn__112630.invoke(log.clj:216) ~[metabase.jar:?] at metabase.driver.sql_jdbc.execute.diagnostic$do_with_diagnostic_info.invokeStatic(diagnostic.clj:18) ~[metabase.jar:?] at metabase.driver.sql_jdbc.execute.diagnostic$do_with_diagnostic_info.invoke(diagnostic.clj:12) ~[metabase.jar:?] at metabase.server.middleware.log$log_api_call$fn__112628$fn__112629.invoke(log.clj:208) ~[metabase.jar:?] at toucan2.execute$do_with_call_counts.invokeStatic(execute.clj:112) ~[metabase.jar:?] at toucan2.execute$do_with_call_counts.invoke(execute.clj:103) ~[metabase.jar:?] at metabase.server.middleware.log$log_api_call$fn__112628.invoke(log.clj:207) ~[metabase.jar:?] at metabase.server.middleware.browser_cookie$ensure_browser_id_cookie$fn__114773.invoke(browser_cookie.clj:42) ~[metabase.jar:?] at metabase.server.middleware.security$add_security_headers$fn__90932.invoke(security.clj:153) ~[metabase.jar:?] at metabase.server.middleware.json$wrap_json_body$fn__113328.invoke(json.clj:67) ~[metabase.jar:?] at metabase.server.middleware.offset_paging$handle_paging$fn__90956.invoke(offset_paging.clj:45) ~[metabase.jar:?] at metabase.server.middleware.json$wrap_streamed_json_response$fn__113346.invoke(json.clj:103) ~[metabase.jar:?] at ring.middleware.keyword_params$wrap_keyword_params$fn__115040.invoke(keyword_params.clj:55) ~[metabase.jar:?] at ring.middleware.params$wrap_params$fn__115059.invoke(params.clj:77) ~[metabase.jar:?] at metabase.server.middleware.misc$maybe_set_site_url$fn__57325.invoke(misc.clj:61) ~[metabase.jar:?] at metabase.server.middleware.session$reset_session_timeout$fn__71837.invoke(session.clj:457) ~[metabase.jar:?] at metabase.server.middleware.session$bind_current_user$fn__71804$fn__71805.invoke(session.clj:352) ~[metabase.jar:?] at metabase.server.middleware.session$do_with_current_user.invokeStatic(session.clj:331) ~[metabase.jar:?] at metabase.server.middleware.session$do_with_current_user.invoke(session.clj:315) ~[metabase.jar:?] at metabase.server.middleware.session$bind_current_user$fn__71804.invoke(session.clj:351) ~[metabase.jar:?] at metabase.server.middleware.session$wrap_current_user_info$fn__71785.invoke(session.clj:285) ~[metabase.jar:?] at metabase.server.middleware.session$wrap_session_id$fn__71768.invoke(session.clj:217) ~[metabase.jar:?] at metabase.server.middleware.auth$wrap_api_key$fn__100427.invoke(auth.clj:30) ~[metabase.jar:?] at ring.middleware.cookies$wrap_cookies$fn__114960.invoke(cookies.clj:216) ~[metabase.jar:?] at metabase.server.middleware.misc$add_content_type$fn__57307.invoke(misc.clj:29) ~[metabase.jar:?] at metabase.server.middleware.misc$disable_streaming_buffering$fn__57333.invoke(misc.clj:78) ~[metabase.jar:?] at ring.middleware.gzip$wrap_gzip$fn__115002.invoke(gzip.clj:86) ~[metabase.jar:?] at metabase.server.middleware.misc$bind_request$fn__57336.invoke(misc.clj:95) ~[metabase.jar:?] at metabase.server.middleware.ssl$redirect_to_https_middleware$fn__114789.invoke(ssl.clj:51) ~[metabase.jar:?] at metabase.server$async_proxy_handler$fn__79599.invoke(server.clj:77) ~[metabase.jar:?] at metabase.server.proxy$org.eclipse.jetty.server.handler.AbstractHandler$ff19274a.handle(Unknown Source) ~[metabase.jar:?] at org.eclipse.jetty.server.handler.StatisticsHandler.handle(StatisticsHandler.java:173) ~[metabase.jar:?] at org.eclipse.jetty.server.handler.HandlerWrapper.handle(HandlerWrapper.java:122) ~[metabase.jar:?] at org.eclipse.jetty.server.Server.handle(Server.java:563) ~[metabase.jar:?] at org.eclipse.jetty.server.HttpChannel.lambda$handle$0(HttpChannel.java:505) ~[metabase.jar:?] at org.eclipse.jetty.server.HttpChannel.dispatch(HttpChannel.java:762) ~[metabase.jar:?] at org.eclipse.jetty.server.HttpChannel.handle(HttpChannel.java:497) ~[metabase.jar:?] at org.eclipse.jetty.server.HttpConnection.onFillable(HttpConnection.java:282) ~[metabase.jar:?] at org.eclipse.jetty.io.AbstractConnection$ReadCallback.succeeded(AbstractConnection.java:314) ~[metabase.jar:?] at org.eclipse.jetty.io.FillInterest.fillable(FillInterest.java:100) ~[metabase.jar:?] at org.eclipse.jetty.io.SelectableChannelEndPoint$1.run(SelectableChannelEndPoint.java:53) ~[metabase.jar:?] at org.eclipse.jetty.util.thread.strategy.AdaptiveExecutionStrategy.runTask(AdaptiveExecutionStrategy.java:416) ~[metabase.jar:?] at org.eclipse.jetty.util.thread.strategy.AdaptiveExecutionStrategy.consumeTask(AdaptiveExecutionStrategy.java:385) ~[metabase.jar:?] at org.eclipse.jetty.util.thread.strategy.AdaptiveExecutionStrategy.tryProduce(AdaptiveExecutionStrategy.java:272) ~[metabase.jar:?] at org.eclipse.jetty.util.thread.strategy.AdaptiveExecutionStrategy.lambda$new$0(AdaptiveExecutionStrategy.java:140) ~[metabase.jar:?] at org.eclipse.jetty.util.thread.ReservedThreadExecutor$ReservedThread.run(ReservedThreadExecutor.java:411) [metabase.jar:?] at org.eclipse.jetty.util.thread.QueuedThreadPool.runJob(QueuedThreadPool.java:936) [metabase.jar:?] at org.eclipse.jetty.util.thread.QueuedThreadPool$Runner.run(QueuedThreadPool.java:1080) [metabase.jar:?] at java.lang.Thread.run(Thread.java:839) [?:?]

[paoliniluis]

Can you give us some details about the color selection of the charts?

[DianBoynov]

Hello @paoliniluis, can you please advise how I can check that as I am pretty new to MetaBase itself? Attaching a screenshot of the Dashboard:

[paoliniluis]

there is one of those cards that has the colors changed in the visualization settings. If you go to each of the cards and check the visualization settings you might be able to look for the colors that have changed

[DianBoynov]

Hello @paoliniluis, I clicked each of the cards to reset by default for the visualization option and then sent out again the email, where the result is the same. Should I do something else in that regards to regarding the visualization of the setting I mean?

Furthermore, as there is no modification on the card which is presented as a Table visualization, should at least this card be visualized correctly?

[DianBoynov]

Hello @paoliniluis , a kind reminder on the topic above :)

[paoliniluis]

@DianBoynov we can't know which of those cards is the problematic one as you covered the titles.

What I see in the error is that there's something around the colors picked
java.lang.StringIndexOutOfBoundsException color_selector.js:1:161

unfortunately if we don't have a way to reproduce this, we won't be able to fix it

[DianBoynov]

Thank you for the provided feedback @paoliniluis. I was not aware you would need the title. Here is another screenshot:

Please let me know if you need something additional information. I would like to know what I am doing wrong so I can fix it once and for all.

Please note that a simple table (visualization as Table) is also not presented in the email for some reason, and they I didn't add any colors and ect.

[paoliniluis]

ok so the cards that are failing are the line chart with the values and the bar chart

can you post the API responses here of those 2 cards? for that you need to go to http://yourmetabaseurl/api/card/<question_id> for each of the questions and also to
http://yourmetabaseurl/api/dashboard/<dashboard_id> for that single dashboard

[DianBoynov]

Hello @paoliniluis, please note that I am using Enterly the interface for the dashboard setup and for the email subscription. There is no development interference and API requests and therefore responses. Please share further feedback in that regard.

Reminder: I have recreated some of the reports and the result is the same. I have 3 charts with lines and bars and another 3 in a table format. Non of them are actually working in the email visualization.

[paoliniluis]

I don’t know what Enterly is

[DianBoynov]

I am referring that I am using the Interface itself.

[paoliniluis]

@DianBoynov we need to know the API responses that you get with your browser by going to the browser dev tools on the network tab, otherwise we won't be able to reproduce

[DianBoynov]

Hello, @paoliniluis, got it, thank you. Here are the API responses:

[paoliniluis]

Thanks but we need to know the contents of the responses I asked before

[DianBoynov]

@paoliniluis do you have some preferences on how to provide the information? I cannot upload the HAR file, because of the chat limitations.

[ignacio-mb]

Hi @DianBoynov, Luis was referring to the responses of the cards and dashboards themselves. To get this, replace the following links with your metabase instance name and dashbaord/card numbers (these are in the link already)

• http://yourmetabaseurl/api/card/<question_id> for each of the questions and also to
• http://yourmetabaseurl/api/dashboard/<dashboard_id> for that single dashbojard

You can paste the responses here as they are jsons

[DianBoynov]

Hello @paoliniluis @ignacio-mb
Appologies for the delay. I am sharing one card, let me know if need more information, here is the requested information:
URL: https://bbi-reporting.jfdsystems.com/api/dashboard/705/dashcard/1031/card/1033/query
Payload:
{parameters: [], dashboard_id: 705} dashboard_id : 705 parameters : []

Response:
{ "data": { "rows": [ [ 5, 5, "2023-12-28T00:00:00Z" ], [ 5, 5, "2023-12-29T00:00:00Z" ], [ 12, 12, "2024-01-02T00:00:00Z" ], [ 2, 2, "2024-01-08T00:00:00Z" ], [ 5, 5, "2024-01-09T00:00:00Z" ], [ 1, 1, "2023-12-27T00:00:00Z" ], [ 5, 5, "2024-01-03T00:00:00Z" ], [ 3, 3, "2024-01-04T00:00:00Z" ], [ 6, 6, "2024-01-05T00:00:00Z" ] ], "cols": [ { "display_name": "Login", "source": "native", "field_ref": [ "field", "Login", { "base-type": "type/BigInteger" } ], "name": "Login", "base_type": "type/BigInteger", "effective_type": "type/BigInteger" }, { "display_name": "Email", "source": "native", "field_ref": [ "field", "Email", { "base-type": "type/BigInteger" } ], "name": "Email", "base_type": "type/BigInteger", "effective_type": "type/BigInteger" }, { "display_name": "Registration_Date", "source": "native", "field_ref": [ "field", "Registration_Date", { "base-type": "type/Date" } ], "name": "Registration_Date", "base_type": "type/Date", "effective_type": "type/Date" } ], "native_form": { "query": "SELECT\r\n Count (mta.account_number) AS Login,\r\n Count (mta.email) AS Email,\r\n mta.creation_date AS Registration_Date\r\nFROM\r\n dim_mt_trade_accounts mta\r\n WHERE\r\n (\r\n mta.creation_date >= CURDATE() - INTERVAL 14 DAY\r\n AND mta.creation_date < CURDATE() \r\n )\r\n AND (mta.jfd_entity IN ('JFD GROUP', 'JFD OV'))\r\n AND (mta.jfd_professional IN ('PRO', 'RETAIL'))\r\n AND (mta.mt_server_type IN (1, 2, 3))\r\n AND ((mta.id <> 'Excluded') OR (mta.idIS NULL))\r\n AND mta.group_name Not Like '%manager%'\r\n AND mta.group_name not LIKE '%nlp%'\r\n AND mta.group_name not LIKE '%system%'\r\n AND mta.group_name not LIKE '%test%' \r\n AND mta.group_name not LIKE '%test%'\r\n AND mta.group_name not LIKE '%reb%'\r\n AND mta.group_name not LIKE '%pro_qfx%'\r\n AND mta.group_name not LIKE '%rb_mam%'\r\n AND mta.group_name not LIKE '%mam_rb%'\r\n AND mta.group_name not LIKE '%WL%' \r\n AND mta.group_name not LIKE '%ZM%'\r\n AND mta.group_name not LIKE '%demo%'\r\n \r\n GROUP BY mta.creation_date", "params": null }, "results_timezone": "UTC", "results_metadata": { "columns": [ { "display_name": "Login", "field_ref": [ "field", "Login", { "base-type": "type/BigInteger" } ], "name": "Login", "base_type": "type/BigInteger", "effective_type": "type/BigInteger", "semantic_type": null, "fingerprint": { "global": { "distinct-count": 6, "nil%": 0.0 }, "type": { "type/Number": { "min": 1.0, "q1": 2.75, "q3": 5.551597373362762, "max": 12.0, "sd": 3.140240613569462, "avg": 4.888888888888889 } } } }, { "display_name": "Email", "field_ref": [ "field", "Email", { "base-type": "type/BigInteger" } ], "name": "Email", "base_type": "type/BigInteger", "effective_type": "type/BigInteger", "semantic_type": null, "fingerprint": { "global": { "distinct-count": 6, "nil%": 0.0 }, "type": { "type/Number": { "min": 1.0, "q1": 2.75, "q3": 5.551597373362762, "max": 12.0, "sd": 3.140240613569462, "avg": 4.888888888888889 } } } }, { "display_name": "Registration_Date", "field_ref": [ "field", "Registration_Date", { "base-type": "type/Date" } ], "name": "Registration_Date", "base_type": "type/Date", "effective_type": "type/Date", "semantic_type": null, "fingerprint": { "global": { "distinct-count": 9, "nil%": 0.0 }, "type": { "type/DateTime": { "earliest": "2023-12-27T00:00:00Z", "latest": "2024-01-09T00:00:00Z" } } } } ] }, "insights": [ { "previous-value": 3, "unit": "day", "offset": -611.499999998518, "last-change": 1.0, "col": "Login", "slope": 0.031249999999924862, "last-value": 6, "best-fit": [ "+", -611.499999998518, [ "*", 0.031249999999924862, "x" ] ] }, { "previous-value": 3, "unit": "day", "offset": -611.499999998518, "last-change": 1.0, "col": "Email", "slope": 0.031249999999924862, "last-value": 6, "best-fit": [ "+", -611.499999998518, [ "*", 0.031249999999924862, "x" ] ] } ] }, "cached": false, "database_id": 66, "started_at": "2024-01-10T09:40:08.7661054Z", "json_query": { "constraints": { "max-results": 100000, "max-results-bare-rows": 100000 }, "type": "native", "middleware": { "js-int-to-string?": true, "ignore-cached-results?": false }, "native": { "query": "SELECT\r\n Count (mta.account_number) ASLogin,\r\n Count (mta.email) AS Email,\r\n mta.creation_date AS Registration_Date\r\nFROM\r\n dim_mt_trade_accounts mta\r\n WHERE\r\n (\r\n mta.creation_date >= CURDATE() - INTERVAL 14 DAY\r\n AND mta.creation_date < CURDATE() \r\n )\r\n AND (mta.jfd_entity IN ('JFD GROUP', 'JFD OV'))\r\n AND (mta.jfd_professional IN ('PRO', 'RETAIL'))\r\n AND (mta.mt_server_type IN (1, 2, 3))\r\n AND ((mta.id <> 'Excluded') OR (mta.id IS NULL))\r\n AND mta.group_name Not Like '%manager%'\r\n AND mta.group_name not LIKE '%nlp%'\r\n AND mta.group_name not LIKE '%system%'\r\n AND mta.group_name not LIKE '%test%' \r\n AND mta.group_name not LIKE '%test%'\r\n AND mta.group_name not LIKE '%reb%'\r\n AND mta.group_name not LIKE '%pro_qfx%'\r\n AND mta.group_name not LIKE '%rb_mam%'\r\n AND mta.group_name not LIKE '%mam_rb%'\r\n AND mta.group_name not LIKE '%WL%' \r\n AND mta.group_name not LIKE '%ZM%'\r\n AND mta.group_name not LIKE '%demo%'\r\n \r\n GROUP BY mta.creation_date", "template-tags": {} }, "viz-settings": { "graph.show_goal": true, "graph.show_values": true, "graph.series_order_dimension": null, "graph.x_axis.axis_enabled": "compact", "graph.goal_value": 50, "graph.metrics": [ "Login", "Email" ], "graph.label_value_formatting": "auto", "graph.series_order": null, "graph.dimensions": [ "Registration_Date" ] }, "database": 66, "async?": true, "cache-ttl": null }, "average_execution_time": null, "status": "completed", "context": "dashboard", "row_count": 9, "running_time": 2125 }

[DianBoynov]

Hello @paoliniluis @ignacio-mb , is everything needed, provided in my latest response?

[DianBoynov]

Hello @paoliniluis, sorry for bothering you, but did you manage to find the issue, which I am experiencing?

[alxnddr]

The failing charts are line and bar ones. We revamped the implementation which should've fixed this issue. #41395