Dashboards embedding error

Anum · January 31, 2022, 1:53pm

My dashboards are not embedding correctly. I can see them on metabase though

Metabase version: latest

flamber · January 31, 2022, 1:56pm

Post "Diagnostic Info" from Admin > Troubleshooting.
Post errors from the log - Admin > Troubleshooting > Logs.

Anum · January 31, 2022, 1:58pm

{
"browser-info": {
"language": "en-US",
"platform": "Win32",
"userAgent": "Mozilla/5.0 (Windows NT 10.0; Win64; x64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/97.0.4692.99 Safari/537.36",
"vendor": "Google Inc."
},
"system-info": {
"file.encoding": "UTF-8",
"java.runtime.name": "OpenJDK Runtime Environment",
"java.runtime.version": "11.0.13+8",
"java.vendor": "Eclipse Adoptium",
"java.vendor.url": "https://adoptium.net/",
"java.version": "11.0.13",
"java.vm.name": "OpenJDK 64-Bit Server VM",
"java.vm.version": "11.0.13+8",
"os.name": "Linux",
"os.version": "5.11.0-1022-azure",
"user.language": "en",
"user.timezone": "GMT"
},
"metabase-info": {
"databases": [
"h2",
"sqlserver"
],
"hosting-env": "unknown",
"application-database": "mysql",
"application-database-details": {
"database": {
"name": "MySQL",
"version": "8.0.21"
},
"jdbc-driver": {
"name": "MariaDB Connector/J",
"version": "2.6.2"
}
},
"run-mode": "prod",
"version": {
"date": "2021-12-16",
"tag": "v0.41.5",
"branch": "release-x.41.x",
"hash": "fbfffc6"
},
"settings": {
"report-timezone": null
}
}
}

Anum · January 31, 2022, 1:58pm

[5231fc01-0ecb-453c-8f9b-ffbdb99b506e] 2022-01-31T18:06:52+05:00 INFO metabase.models.dashboard Referenced Fields in Dashboard params have changed: Was: #{385 387 386} Is Now: #{385 387 241 247 248 255 245 386} Newly Added: #{241 247 248 255 245}
[5231fc01-0ecb-453c-8f9b-ffbdb99b506e] 2022-01-31T18:06:52+05:00 ERROR metabase.models.params Could not find matching Field ID for target: [:dimension [:template-tag store]]
clojure.lang.ExceptionInfo: Output of unwrap-field-clause does not match schema:
[(not (present? :field)) (not (present? "id-or-name")) (not (present? "options"))]
{:type :schema.core/error, :schema (constrained [(one (eq :field) :field) (one (cond-pre (constrained Int "positive integer") (constrained Str "Non-blank string")) "id-or-name") (one (maybe (recursive (var metabase.mbql.schema/FieldOptions))) "options")] ":field clauses using a string field name must specify :base-type."), :value nil, :error [(not (present? :field)) (not (present? "id-or-name")) (not (present? "options"))]}
at metabase.models.params$fn__38135$unwrap_field_clause__38140.invoke(params.clj:21)
at metabase.models.params$fn__38177$param_target__GT_field_clause__38182$fn__38183.invoke(params.clj:81)
at metabase.models.params$fn__38177$param_target__GT_field_clause__38182.invoke(params.clj:73)
at metabase.models.params$fn__38280$dashboard__GT_parameter_mapping_field_clauses__38285$fn__38286$iter__38287__38293$fn__38294$iter__38289__38295$fn__38296$fn__38297.invoke(params.clj:189)
at metabase.models.params$fn__38280$dashboard__GT_parameter_mapping_field_clauses__38285$fn__38286$iter__38287__38293$fn__38294$iter__38289__38295$fn__38296.invoke(params.clj:187)
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__5419.invokeStatic(core.clj:139)
at clojure.core$seq__5419.invoke(core.clj:139)
at metabase.models.params$fn__38280$dashboard__GT_parameter_mapping_field_clauses__38285$fn__38286$iter__38287__38293$fn__38294.invoke(params.clj:187)
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__5419.invokeStatic(core.clj:139)
at clojure.core$seq__5419.invoke(core.clj:139)
at metabase.models.params$fn__38280$dashboard__GT_parameter_mapping_field_clauses__38285$fn__38286.invoke(params.clj:187)
at metabase.models.params$fn__38280$dashboard__GT_parameter_mapping_field_clauses__38285.invoke(params.clj:183)
at metabase.models.params$fn__38345$dashboard__GT_param_field_ids__38350$fn__38351.invoke(params.clj:211)
at metabase.models.params$fn__38345$dashboard__GT_param_field_ids__38350.invoke(params.clj:205)
at metabase.models.dashboard$dashboard_id__GT_param_field_ids.invokeStatic(dashboard.clj:250)
at metabase.models.dashboard$dashboard_id__GT_param_field_ids.invoke(dashboard.clj:246)
at metabase.models.dashboard$add_dashcard_BANG_.invokeStatic(dashboard.clj:273)
at metabase.models.dashboard$add_dashcard_BANG_.doInvoke(dashboard.clj:266)
at clojure.lang.RestFn.invoke(RestFn.java:442)
at metabase.api.dashboard$fn__73901$fn__73904.invoke(dashboard.clj:244)
at toucan.db$do_in_transaction$fn__21119.invoke(db.clj:147)
at clojure.java.jdbc$db_transaction_STAR_.invokeStatic(jdbc.clj:807)
at clojure.java.jdbc$db_transaction_STAR_.invoke(jdbc.clj:776)
at clojure.java.jdbc$db_transaction_STAR_.invokeStatic(jdbc.clj:852)
at clojure.java.jdbc$db_transaction_STAR_.invoke(jdbc.clj:776)
at clojure.java.jdbc$db_transaction_STAR_.invokeStatic(jdbc.clj:789)
at clojure.java.jdbc$db_transaction_STAR_.invoke(jdbc.clj:776)
at toucan.db$do_in_transaction.invokeStatic(db.clj:145)
at toucan.db$do_in_transaction.invoke(db.clj:142)
at metabase.api.dashboard$fn__73901.invokeStatic(dashboard.clj:236)
at metabase.api.dashboard$fn__73901.invoke(dashboard.clj:220)
at compojure.core$wrap_response$fn__32066.invoke(core.clj:160)
at compojure.core$wrap_route_middleware$fn__32050.invoke(core.clj:132)
at compojure.core$wrap_route_info$fn__32055.invoke(core.clj:139)
at compojure.core$wrap_route_matches$fn__32059.invoke(core.clj:151)
at compojure.core$routes$fn__32078$f__32079.invoke(core.clj:198)
at compojure.core$routes$fn__32078$f__32079$respond_SINGLEQUOTE___32080.invoke(core.clj:197)
at compojure.core$wrap_route_matches$fn__32059.invoke(core.clj:152)
at compojure.core$routes$fn__32078$f__32079.invoke(core.clj:198)
at compojure.core$routes$fn__32078$f__32079$respond_SINGLEQUOTE___32080.invoke(core.clj:197)
at compojure.core$wrap_route_matches$fn__32059.invoke(core.clj:152)
at compojure.core$routes$fn__32078$f__32079.invoke(core.clj:198)
at compojure.core$routes$fn__32078$f__32079$respond_SINGLEQUOTE___32080.invoke(core.clj:197)
at compojure.core$wrap_route_matches$fn__32059.invoke(core.clj:153)
at compojure.core$routes$fn__32078$f__32079.invoke(core.clj:198)
at compojure.core$routes$fn__32078$f__32079$respond_SINGLEQUOTE___32080.invoke(core.clj:197)
at compojure.core$wrap_route_matches$fn__32059.invoke(core.clj:153)
at compojure.core$routes$fn__32078$f__32079.invoke(core.clj:198)
at compojure.core$routes$fn__32078$f__32079$respond_SINGLEQUOTE___32080.invoke(core.clj:197)
at compojure.core$wrap_route_matches$fn__32059.invoke(core.clj:153)
at compojure.core$routes$fn__32078$f__32079.invoke(core.clj:198)
at compojure.core$routes$fn__32078$f__32079$respond_SINGLEQUOTE___32080.invoke(core.clj:197)
at compojure.core$wrap_route_matches$fn__32059.invoke(core.clj:153)
at compojure.core$routes$fn__32078$f__32079.invoke(core.clj:198)
at compojure.core$routes$fn__32078$f__32079$respond_SINGLEQUOTE___32080.invoke(core.clj:197)
at compojure.core$wrap_route_matches$fn__32059.invoke(core.clj:153)
at compojure.core$routes$fn__32078$f__32079.invoke(core.clj:198)
at compojure.core$routes$fn__32078$f__32079$respond_SINGLEQUOTE___32080.invoke(core.clj:197)
at compojure.core$wrap_route_matches$fn__32059.invoke(core.clj:152)
at compojure.core$routes$fn__32078$f__32079.invoke(core.clj:198)
at compojure.core$routes$fn__32078$f__32079$respond_SINGLEQUOTE___32080.invoke(core.clj:197)
at compojure.core$wrap_route_matches$fn__32059.invoke(core.clj:153)
at compojure.core$routes$fn__32078$f__32079.invoke(core.clj:198)
at compojure.core$routes$fn__32078$f__32079$respond_SINGLEQUOTE___32080.invoke(core.clj:197)
at compojure.core$wrap_route_matches$fn__32059.invoke(core.clj:152)
at compojure.core$routes$fn__32078$f__32079.invoke(core.clj:198)
at compojure.core$routes$fn__32078$f__32079$respond_SINGLEQUOTE___32080.invoke(core.clj:197)
at compojure.core$wrap_route_matches$fn__32059.invoke(core.clj:153)
at compojure.core$routes$fn__32078$f__32079.invoke(core.clj:198)
at compojure.core$routes$fn__32078$f__32079$respond_SINGLEQUOTE___32080.invoke(core.clj:197)
at compojure.core$wrap_route_matches$fn__32059.invoke(core.clj:153)
at compojure.core$routes$fn__32078$f__32079.invoke(core.clj:198)
at compojure.core$routes$fn__32078$f__32079$respond_SINGLEQUOTE___32080.invoke(core.clj:197)
at compojure.core$wrap_route_matches$fn__32059.invoke(core.clj:153)
at compojure.core$routes$fn__32078$f__32079.invoke(core.clj:198)
at compojure.core$routes$fn__32078$f__32079$respond_SINGLEQUOTE___32080.invoke(core.clj:197)
at compojure.core$wrap_route_matches$fn__32059.invoke(core.clj:153)
at compojure.core$routes$fn__32078$f__32079.invoke(core.clj:198)
at compojure.core$routes$fn__32078$f__32079$respond_SINGLEQUOTE___32080.invoke(core.clj:197)
at compojure.core$wrap_route_matches$fn__32059.invoke(core.clj:152)
at compojure.core$routes$fn__32078$f__32079.invoke(core.clj:198)
at compojure.core$routes$fn__32078$f__32079$respond_SINGLEQUOTE___32080.invoke(core.clj:197)
at compojure.core$wrap_route_matches$fn__32059.invoke(core.clj:152)
at compojure.core$routes$fn__32078$f__32079.invoke(core.clj:198)
at compojure.core$routes$fn__32078.invoke(core.clj:200)
at metabase.server.middleware.auth$enforce_authentication$fn__70354.invoke(auth.clj:14)
at compojure.core$routes$fn__32078$f__32079.invoke(core.clj:198)
at compojure.core$routes$fn__32078.invoke(core.clj:200)
at compojure.core$make_context$handler__32106.invoke(core.clj:289)
at compojure.core$make_context$fn__32110.invoke(core.clj:299)
at compojure.core$routes$fn__32078$f__32079.invoke(core.clj:198)
at compojure.core$routes$fn__32078$f__32079$respond_SINGLEQUOTE___32080.invoke(core.clj:197)
at compojure.core$make_context$fn__32110.invoke(core.clj:300)
at compojure.core$routes$fn__32078$f__32079.invoke(core.clj:198)
at compojure.core$routes$fn__32078$f__32079$respond_SINGLEQUOTE___32080.invoke(core.clj:197)
at compojure.core$make_context$fn__32110.invoke(core.clj:300)
at compojure.core$routes$fn__32078$f__32079.invoke(core.clj:198)
at compojure.core$routes$fn__32078$f__32079$respond_SINGLEQUOTE___32080.invoke(core.clj:197)
at compojure.core$make_context$fn__32110.invoke(core.clj:300)
at compojure.core$routes$fn__32078$f__32079.invoke(core.clj:198)
at compojure.core$routes$fn__32078$f__32079$respond_SINGLEQUOTE___32080.invoke(core.clj:197)
at compojure.core$make_context$fn__32110.invoke(core.clj:300)
at compojure.core$routes$fn__32078$f__32079.invoke(core.clj:198)
at compojure.core$routes$fn__32078$f__32079$respond_SINGLEQUOTE___32080.invoke(core.clj:197)
at compojure.core$make_context$fn__32110.invoke(core.clj:300)
at compojure.core$routes$fn__32078$f__32079.invoke(core.clj:198)
at compojure.core$routes$fn__32078$f__32079$respond_SINGLEQUOTE___32080.invoke(core.clj:197)
at metabase.api.routes$fn__79831$fn__79834.invoke(routes.clj:56)
at compojure.core$routes$fn__32078$f__32079.invoke(core.clj:198)
at compojure.core$routes$fn__32078.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__79976$fn__79977.doInvoke(routes.clj:57)
at clojure.lang.RestFn.invoke(RestFn.java:436)
at compojure.core$routes$fn__32078$f__32079.invoke(core.clj:198)
at compojure.core$routes$fn__32078.invoke(core.clj:200)
at compojure.core$make_context$handler__32106.invoke(core.clj:289)
at compojure.core$make_context$fn__32110.invoke(core.clj:299)
at compojure.core$routes$fn__32078$f__32079.invoke(core.clj:198)
at compojure.core$routes$fn__32078$f__32079$respond_SINGLEQUOTE___32080.invoke(core.clj:197)
at compojure.core$wrap_route_matches$fn__32059.invoke(core.clj:153)
at compojure.core$routes$fn__32078$f__32079.invoke(core.clj:198)
at compojure.core$routes$fn__32078$f__32079$respond_SINGLEQUOTE___32080.invoke(core.clj:197)
at compojure.core$wrap_route_matches$fn__32059.invoke(core.clj:153)
at compojure.core$routes$fn__32078$f__32079.invoke(core.clj:198)
at compojure.core$routes$fn__32078$f__32079$respond_SINGLEQUOTE___32080.invoke(core.clj:197)
at compojure.core$wrap_route_matches$fn__32059.invoke(core.clj:153)
at compojure.core$routes$fn__32078$f__32079.invoke(core.clj:198)
at compojure.core$routes$fn__32078$f__32079$respond_SINGLEQUOTE___32080.invoke(core.clj:197)
at metabase.server.routes$fn__79964$fn__79966.invoke(routes.clj:41)
at compojure.core$routes$fn__32078$f__32079.invoke(core.clj:198)
at compojure.core$routes$fn__32078.invoke(core.clj:200)
at metabase.server.middleware.exceptions$catch_uncaught_exceptions$fn__77436.invoke(exceptions.clj:98)
at metabase.server.middleware.exceptions$catch_api_exceptions$fn__77433.invoke(exceptions.clj:86)
at metabase.server.middleware.log$log_api_call$fn__80431$fn__80432$fn__80433.invoke(log.clj:209)
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__80431$fn__80432.invoke(log.clj:201)
at toucan.db$_do_with_call_counting.invokeStatic(db.clj:216)
at toucan.db$_do_with_call_counting.invoke(db.clj:209)
at metabase.server.middleware.log$log_api_call$fn__80431.invoke(log.clj:200)
at metabase.server.middleware.browser_cookie$ensure_browser_id_cookie$fn__83644.invoke(browser_cookie.clj:30)
at metabase.server.middleware.security$add_security_headers$fn__59281.invoke(security.clj:147)
at metabase.server.middleware.json$wrap_json_body$fn__82788.invoke(json.clj:62)
at metabase.server.middleware.json$wrap_streamed_json_response$fn__82806.invoke(json.clj:98)
at metabase.server.middleware.offset_paging$handle_paging$fn__59305.invoke(offset_paging.clj:42)
at ring.middleware.keyword_params$wrap_keyword_params$fn__83911.invoke(keyword_params.clj:55)
at ring.middleware.params$wrap_params$fn__83927.invoke(params.clj:69)
at metabase.server.middleware.misc$maybe_set_site_url$fn__34077.invoke(misc.clj:59)
at metabase.server.middleware.session$bind_current_user$fn__44978$fn__44979.invoke(session.clj:257)
at metabase.server.middleware.session$do_with_current_user.invokeStatic(session.clj:238)
at metabase.server.middleware.session$do_with_current_user.invoke(session.clj:230)
at metabase.server.middleware.session$bind_current_user$fn__44978.invoke(session.clj:256)
at metabase.server.middleware.session$wrap_current_user_info$fn__44965.invoke(session.clj:216)
at metabase.server.middleware.session$wrap_session_id$fn__44951.invoke(session.clj:162)
at metabase.server.middleware.auth$wrap_api_key$fn__70362.invoke(auth.clj:27)
at ring.middleware.cookies$wrap_cookies$fn__83831.invoke(cookies.clj:216)
at metabase.server.middleware.misc$add_content_type$fn__34060.invoke(misc.clj:27)
at metabase.server.middleware.misc$disable_streaming_buffering$fn__34085.invoke(misc.clj:76)
at ring.middleware.gzip$wrap_gzip$fn__83873.invoke(gzip.clj:86)
at metabase.server.middleware.misc$bind_request$fn__34088.invoke(misc.clj:93)
at metabase.server.middleware.ssl$redirect_to_https_middleware$fn__83660.invoke(ssl.clj:38)
at metabase.server$async_proxy_handler$fn__80204.invoke(server.clj:71)
at metabase.server.proxy$org.eclipse.jetty.server.handler.AbstractHandler$ff19274a.handle(Unknown Source)
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:388)
at org.eclipse.jetty.server.HttpChannel.dispatch(HttpChannel.java:633)
at org.eclipse.jetty.server.HttpChannel.handle(HttpChannel.java:380)
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:386)
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)

flamber · January 31, 2022, 2:01pm

@Anum

You are not using the latest version of Metabase: https://github.com/metabase/metabase/releases/latest
The error is unrelated to your problem: https://github.com/metabase/metabase/issues/15494
Post your embed code.

Anum · January 31, 2022, 2:06pm

The preview works fine though. When the app is loaded i don't see the dashboard

Anum · January 31, 2022, 2:07pm

Oh yes, the .6 is the latest version and i'm using .5

flamber · January 31, 2022, 2:09pm

@Anum

Make sure that the Site URL is actually correct in Admin > Settings > General.
You need to rotate your embed secret, since you have posted it publicly.
You need to check your logs for details about the error
I'm quite sure that you are using a different embed code than what is used for the preview.

Anum · January 31, 2022, 2:15pm

How can i check that that the embed code is same as that of the preview?
My site URL is correct

flamber · January 31, 2022, 2:19pm

@Anum
Post your embed code.
Most browser don't allow http in https environments anymore. You're setting yourself of for problems.

Anum · January 31, 2022, 2:22pm

Can i see my code embedding from the view iframe of the app?
Also, should I try changing HTTP to https from the setting?

flamber · January 31, 2022, 2:26pm

@Anum You would use a reverse-proxy or something like that to handle certificates for HTTPS. Search the internet or the forum, you'll find a lot of posts, so I'm not going to go into that.

You are misunderstanding how embedding works - read this again, and then problem another time:
https://www.metabase.com/docs/latest/administration-guide/13-embedding.html

Anum · January 31, 2022, 2:26pm

Any solution?

flamber · January 31, 2022, 2:28pm

@Anum Okay, then I cannot help you. You'll need to talk to the developer.

Anum · January 31, 2022, 5:08pm

Had this been an issue with the site URL, why would the dashboard load? I see an iframe but the cards are not loaded?

flamber · January 31, 2022, 5:11pm

@Anum Go to Admin > Troubleshooting > Logs - look at all the errors that occurs, when you are seeing errors on the dashboard.