Subscriptions dashboard sending not working

aris_pg · February 22, 2021, 11:46am

When I send a dashboard to an email I receive a card error in all cards from dashboard

This is diagnostic info

{
“browser-info”: {
“language”: “en”,
“platform”: “Linux x86_64”,
“userAgent”: “Mozilla/5.0 (X11; Linux x86_64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/81.0.4044.138 Safari/537.36”,
“vendor”: “Google Inc.”
},
“system-info”: {
“file.encoding”: “UTF-8”,
“java.runtime.name”: “OpenJDK Runtime Environment”,
“java.runtime.version”: “11.0.6+10-LTS”,
“java.vendor”: “[Amazon.com](http://amazon.com/) Inc.”,
“java.vendor.url”: “https://aws.amazon.com/corretto/”,
“java.version”: “11.0.6”,
“java.vm.name”: “OpenJDK 64-Bit Server VM”,
“java.vm.version”: “11.0.6+10-LTS”,
“os.name”: “Linux”,
“os.version”: “4.14.173-137.228.amzn2.x86_64”,
“user.language”: “en”,
“user.timezone”: “UTC”
},
“metabase-info”: {
“databases”: [
“redshift”,
“postgres”
],
“hosting-env”: “unknown”,
“application-database”: “postgres”,
“application-database-details”: {
“database”: {
“name”: “PostgreSQL”,
“version”: “10.4”
},
“jdbc-driver”: {
“name”: “PostgreSQL JDBC Driver”,
“version”: “42.2.18”
}
},
“run-mode”: “prod”,
“version”: {
“date”: “2021-02-19”,
“tag”: “v0.38.0.1”,
“branch”: “release-x.38.x”,
“hash”: “0635914”
},
“settings”: {
“report-timezone”: “UTC”
}
}
}

flamber · February 22, 2021, 11:54am

Hi @aris_pg
There should be errors in the logs during the creation of the pulse. Admin > Troubleshooting > Logs.
While I’m sure it’s not a problem using Corretto Java, I have seen a lot of pulse problems, where generating the images was caused by problems with the JRE.
Could you try Adopt OpenJDK? https://www.metabase.com/docs/latest/operations-guide/java-versions.html

aris_pg · February 23, 2021, 6:23am

Thanks, we’ll try to do it

RomainDeschamps · March 2, 2021, 3:13pm

Hello,

Same trouble here after installing and running Adopt OpenJDK

When I click on the send now button, Metabase just say “sending fails”
(test email works)

What could I send you from my logs to help solve the problem ?

This is diagnostic info

{
  "browser-info": {
    "language": "fr",
    "platform": "Win32",
    "userAgent": "Mozilla/5.0 (Windows NT 10.0; Win64; x64; rv:86.0) Gecko/20100101 Firefox/86.0",
    "vendor": ""
  },
  "system-info": {
    "file.encoding": "Cp1252",
    "java.runtime.name": "OpenJDK Runtime Environment",
    "java.runtime.version": "11.0.10+9",
    "java.vendor": "AdoptOpenJDK",
    "java.vendor.url": "https://adoptopenjdk.net/",
    "java.version": "11.0.10",
    "java.vm.name": "OpenJDK 64-Bit Server VM",
    "java.vm.version": "11.0.10+9",
    "os.name": "Windows 10",
    "os.version": "10.0",
    "user.language": "fr",
    "user.timezone": "Europe/Paris"
  },
  "metabase-info": {
    "databases": [
      "mysql"
    ],
    "hosting-env": "unknown",
    "application-database": "h2",
    "application-database-details": {
      "database": {
        "name": "H2",
        "version": "1.4.197 (2018-03-18)"
      },
      "jdbc-driver": {
        "name": "H2 JDBC Driver",
        "version": "1.4.197 (2018-03-18)"
      }
    },
    "run-mode": "prod",
    "version": {
      "date": "2021-02-16",
      "tag": "v0.38.0",
      "branch": "release-x.38.x",
      "hash": "471aa51"
    },
    "settings": {
      "report-timezone": "Europe/Berlin"
    }
  }
}

flamber · March 2, 2021, 3:25pm

@RomainDeschamps You should send the log lines from around the time, when you see the error.

RomainDeschamps · March 4, 2021, 11:29am

Your instructions, properly carried out, are working very well !

aris_pg · March 5, 2021, 6:18am

@flamber I coudn’t test Adopt OpenJDK yet but I obtained this error when I try to send a dashboard to an email. I hope this could help

[5652b0d0-5388-4d9b-bc6e-7be194450307] 2021-03-05T07:12:03+01:00 ERROR metabase.query-processor.middleware.catch-exceptions Error processing query: null
{:database_id 2,
 :started_at #t "2021-03-05T06:12:02.517829Z[UTC]",
 :via
 [{:status :failed,
   :class clojure.lang.ExceptionInfo,
   :error "Unable to substitute parameters",
   :stacktrace
   ["--> driver.sql.parameters.substitute$substitute$fn__78910.invoke(substitute.clj:83)"
    "driver.sql.parameters.substitute$substitute.invokeStatic(substitute.clj:80)"
    "driver.sql.parameters.substitute$substitute.invoke(substitute.clj:71)"
    "driver.sql$fn__78943.invokeStatic(sql.clj:44)"
    "driver.sql$fn__78943.invoke(sql.clj:40)"
    "query_processor.middleware.parameters.native$expand_inner.invokeStatic(native.clj:39)"
    "query_processor.middleware.parameters.native$expand_inner.invoke(native.clj:30)"
    "query_processor.middleware.parameters$expand_one.invokeStatic(parameters.clj:50)"
    "query_processor.middleware.parameters$expand_one.invoke(parameters.clj:41)"
    "query_processor.middleware.parameters$expand_all$replace_46941__46942.invoke(parameters.clj:59)"
    "mbql.util.match$replace_in_collection$iter__17910__17914$fn__17915.invoke(match.clj:139)"
    "mbql.util.match$replace_in_collection.invokeStatic(match.clj:138)"
    "mbql.util.match$replace_in_collection.invoke(match.clj:133)"
    "query_processor.middleware.parameters$expand_all$replace_46941__46942.invoke(parameters.clj:59)"
    "query_processor.middleware.parameters$expand_all.invokeStatic(parameters.clj:59)"
    "query_processor.middleware.parameters$expand_all.invoke(parameters.clj:53)"
    "query_processor.middleware.parameters$expand_all.invokeStatic(parameters.clj:56)"
    "query_processor.middleware.parameters$expand_all.invoke(parameters.clj:53)"
    "query_processor.middleware.parameters$expand_parameters.invokeStatic(parameters.clj:77)"
    "query_processor.middleware.parameters$expand_parameters.invoke(parameters.clj:73)"
    "query_processor.middleware.parameters$fn__46957$substitute_parameters_STAR___46962$fn__46963.invoke(parameters.clj:82)"
    "query_processor.middleware.parameters$fn__46957$substitute_parameters_STAR___46962.invoke(parameters.clj:79)"
    "query_processor.middleware.parameters$substitute_parameters$fn__46983.invoke(parameters.clj:111)"
    "query_processor.middleware.resolve_referenced$resolve_referenced_card_resources$fn__45363.invoke(resolve_referenced.clj:79)"
    "query_processor.middleware.expand_macros$expand_macros$fn__45984.invoke(expand_macros.clj:155)"
    "query_processor.middleware.add_timezone_info$add_timezone_info$fn__44142.invoke(add_timezone_info.clj:15)"
    "query_processor.middleware.splice_params_in_response$splice_params_in_response$fn__47985.invoke(splice_params_in_response.clj:32)"
    "query_processor.middleware.resolve_database_and_driver$resolve_database_and_driver$fn__47209$fn__47213.invoke(resolve_database_and_driver.clj:31)"
    "driver$do_with_driver.invokeStatic(driver.clj:60)"
    "driver$do_with_driver.invoke(driver.clj:56)"
    "query_processor.middleware.resolve_database_and_driver$resolve_database_and_driver$fn__47209.invoke(resolve_database_and_driver.clj:25)"
    "query_processor.middleware.fetch_source_query$resolve_card_id_source_tables$fn__46202.invoke(fetch_source_query.clj:264)"
    "query_processor.middleware.store$initialize_store$fn__47994$fn__47995.invoke(store.clj:11)"
    "query_processor.store$do_with_store.invokeStatic(store.clj:44)"
    "query_processor.store$do_with_store.invoke(store.clj:38)"
    "query_processor.middleware.store$initialize_store$fn__47994.invoke(store.clj:10)"
    "query_processor.middleware.validate$validate_query$fn__48056.invoke(validate.clj:10)"
    "query_processor.middleware.normalize_query$normalize$fn__46326.invoke(normalize_query.clj:22)"
    "query_processor.middleware.add_rows_truncated$add_rows_truncated$fn__43994.invoke(add_rows_truncated.clj:35)"
    "query_processor.middleware.results_metadata$record_and_return_metadata_BANG_$fn__47970.invoke(results_metadata.clj:147)"
    "query_processor.middleware.constraints$add_default_userland_constraints$fn__45605.invoke(constraints.clj:42)"
    "query_processor.middleware.process_userland_query$process_userland_query$fn__47072.invoke(process_userland_query.clj:135)"
    "query_processor.middleware.catch_exceptions$catch_exceptions$fn__45548.invoke(catch_exceptions.clj:173)"
    "query_processor.reducible$async_qp$qp_STAR___37408$thunk__37409.invoke(reducible.clj:103)"
    "query_processor.reducible$async_qp$qp_STAR___37408.invoke(reducible.clj:109)"
    "query_processor.reducible$async_qp$qp_STAR___37408.invoke(reducible.clj:96)"
    "query_processor.reducible$sync_qp$qp_STAR___37417$fn__37418.invoke(reducible.clj:131)"
    "query_processor.reducible$sync_qp$qp_STAR___37417.invoke(reducible.clj:130)"
    "query_processor$process_userland_query.invokeStatic(query_processor.clj:237)"
    "query_processor$process_userland_query.doInvoke(query_processor.clj:233)"
    "query_processor$fn__48102$process_query_and_save_execution_BANG___48111$fn__48112.invoke(query_processor.clj:246)"
    "query_processor$fn__48102$process_query_and_save_execution_BANG___48111.invoke(query_processor.clj:241)"
    "query_processor$fn__48146$process_query_and_save_with_max_results_constraints_BANG___48155$fn__48156.invoke(query_processor.clj:258)"
    "query_processor$fn__48146$process_query_and_save_with_max_results_constraints_BANG___48155.invoke(query_processor.clj:254)"
    "pulse$execute_dashboard_subscription_card$fn__70272$fn__70273.doInvoke(pulse.clj:74)"
    "api.card$run_query_for_card_async.invokeStatic(card.clj:618)"
    "api.card$run_query_for_card_async.doInvoke(card.clj:594)"
    "pulse$execute_dashboard_subscription_card$fn__70272.invoke(pulse.clj:67)"
    "server.middleware.session$do_with_current_user.invokeStatic(session.clj:258)"
    "server.middleware.session$do_with_current_user.invoke(session.clj:250)"
    "pulse$execute_dashboard_subscription_card.invokeStatic(pulse.clj:66)"
    "pulse$execute_dashboard_subscription_card.invoke(pulse.clj:55)"
    "pulse$execute_dashboard$iter__70284__70288$fn__70289$fn__70290.invoke(pulse.clj:86)"
    "pulse$execute_dashboard$iter__70284__70288$fn__70289.invoke(pulse.clj:85)"
    "pulse$fn__70408.invokeStatic(pulse.clj:215)"
    "pulse$fn__70408.invoke(pulse.clj:210)"
    "pulse$results__GT_notifications$iter__70440__70444$fn__70445.invoke(pulse.clj:263)"
    "pulse$send_notifications_BANG_.invokeStatic(pulse.clj:305)"
    "pulse$send_notifications_BANG_.invoke(pulse.clj:304)"
    "pulse$send_pulse_BANG_.invokeStatic(pulse.clj:331)"
    "pulse$send_pulse_BANG_.doInvoke(pulse.clj:313)"
    "api.pulse$fn__70970.invokeStatic(pulse.clj:209)"
    "api.pulse$fn__70970.invoke(pulse.clj:198)"
    "server.middleware.auth$enforce_authentication$fn__73703.invoke(auth.clj:14)"
    "api.routes$fn__73824$fn__73826.invoke(routes.clj:69)"
    "server.routes$fn__76006$fn__76007.doInvoke(routes.clj:57)"
    "server.routes$fn__75994$fn__75996.invoke(routes.clj:41)"
    "server.middleware.exceptions$catch_uncaught_exceptions$fn__73815.invoke(exceptions.clj:96)"
    "server.middleware.exceptions$catch_api_exceptions$fn__73812.invoke(exceptions.clj:84)"
    "server.middleware.log$log_api_call$fn__75922$fn__75923.invoke(log.clj:195)"
    "server.middleware.log$log_api_call$fn__75922.invoke(log.clj:189)"
    "server.middleware.security$add_security_headers$fn__73778.invoke(security.clj:142)"
    "server.middleware.json$wrap_json_body$fn__75703.invoke(json.clj:62)"
    "server.middleware.json$wrap_streamed_json_response$fn__75721.invoke(json.clj:98)"
    "server.middleware.misc$maybe_set_site_url$fn__35083.invoke(misc.clj:58)"
    "server.middleware.session$bind_current_user$fn__41826$fn__41827.invoke(session.clj:277)"
    "server.middleware.session$do_with_current_user.invokeStatic(session.clj:258)"
    "server.middleware.session$do_with_current_user.invoke(session.clj:250)"
    "server.middleware.session$bind_current_user$fn__41826.invoke(session.clj:276)"
    "server.middleware.session$wrap_current_user_info$fn__41813.invoke(session.clj:236)"
    "server.middleware.session$wrap_session_id$fn__41799.invoke(session.clj:182)"
    "server.middleware.auth$wrap_api_key$fn__73711.invoke(auth.clj:27)"
    "server.middleware.misc$add_content_type$fn__35066.invoke(misc.clj:27)"
    "server.middleware.misc$disable_streaming_buffering$fn__35091.invoke(misc.clj:75)"
    "server.middleware.misc$bind_request$fn__35094.invoke(misc.clj:92)"
    "server.middleware.ssl$redirect_to_https_middleware$fn__75939.invoke(ssl.clj:48)"
    "server$async_proxy_handler$fn__75536.invoke(server.clj:71)"
    "server.proxy$org.eclipse.jetty.server.handler.AbstractHandler$ff19274a.handle(Unknown Source)"],
   :error_type :invalid-query,
   :ex-data
   {:type :schema.core/error,
    :params
    {"Period"
     (metabase.driver.common.parameters/map->FieldFilter
      {:field {:name "period", :parent_id nil, :table_id 116, :base_type :type/Text, :special_type :type/Category},
       :value {:name "Period", :slug "period", :id "94131d19", :type :category, :default ["day"]}}),
     "countrydesc"
     (metabase.driver.common.parameters/map->FieldFilter
      {:field {:name "countrydesc", :parent_id nil, :table_id 19, :base_type :type/Text, :special_type :type/Country},
       :value {:name "Countries", :slug "countries", :id "7163847d", :type :location/country}}),
     "excludeCountries"
     (metabase.driver.common.parameters/map->FieldFilter
      {:field {:name "country", :parent_id nil, :table_id 41, :base_type :type/Text, :special_type :type/Country},
       :value {:name "ExcludedCountry", :slug "excludedcountry", :id "c5661cc", :type :location/country, :default ["India"]}}),
     "dateFrom"
     (metabase.driver.common.parameters/map->FieldFilter
      {:field {:name "datekpi", :parent_id nil, :table_id 19, :base_type :type/Date, :special_type nil},
       :value {:name "First Login", :slug "first_login", :id "360e3a96", :type :date/all-options, :default "past30days"}}),
     "version"
     (metabase.driver.common.parameters/map->FieldFilter
      {:field {:name "version", :parent_id nil, :table_id 19, :base_type :type/Text, :special_type :type/Category}, :value {:name "Version", :slug "version", :id "5397c339", :type :category}}),
     "zone"
     (metabase.driver.common.parameters/map->FieldFilter
      {:field {:name "zone", :parent_id nil, :table_id 19, :base_type :type/Text, :special_type :type/Category}, :value {:name "ZoneCountry", :slug "zonecountry", :id "7241b8ac", :type :category}}),
     "tier"
     (metabase.driver.common.parameters/map->FieldFilter
      {:field {:name "tier", :parent_id nil, :table_id 19, :base_type :type/Integer, :special_type :type/Category},
       :value {:name "TierCountry", :slug "tiercountry", :id "6468d40", :type :category}}),
     "game"
     (metabase.driver.common.parameters/map->FieldFilter
      {:field {:name "game", :parent_id nil, :table_id 99, :base_type :type/Text, :special_type :type/Category},
       :value {:name "Game", :slug "game", :id "721a6662", :type :category, :default ["Massive Warfare Aftermath"]}}),
     "platform"
     (metabase.driver.common.parameters/map->FieldFilter
      {:field {:name "platform", :parent_id nil, :table_id 19, :base_type :type/Text, :special_type :type/Category}, :value {:name "Platform", :slug "platform", :id "2232f478", :type :category}}),
     "organic"
     (metabase.driver.common.parameters/map->FieldFilter
      {:field {:name "organic", :parent_id nil, :table_id 19, :base_type :type/Text, :special_type :type/Category}, :value {:name "Network", :slug "network", :id "984f2bd8", :type :category}})},
    :parsed-query
    ["with \n\nSelectedPeriod as (select Period\n            from SelPeriod\n            where "
     (param "Period")
     "),\n            \ndata_by_date as (\nSELECT z_v_kpis_desc.kpidesc AS kpidesc,\nz_v_kpis_desc.orderkpi,\nz_v_kpis_desc.datekpi,\nCAST(sum(z_v_kpis_desc.value) AS float) AS ret,\ncase when sum(z_v_kpis_desc.value) is null then 0 else sum(z_v_kpis_desc_2.value) end as new_users\nFROM z_v_kpis_desc\nLEFT JOIN z_v_kpis_desc z_v_kpis_desc_2 \n-- ON z_v_kpis_desc.joinfield = z_v_kpis_desc_2.joinfield\n\non z_v_kpis_desc.datekpi = z_v_kpis_desc_2.datekpi\nand z_v_kpis_desc.country = z_v_kpis_desc_2.country\nand z_v_kpis_desc.version = z_v_kpis_desc_2.version\nand z_v_kpis_desc.organic = z_v_kpis_desc_2.organic\nand z_v_kpis_desc.id_game = z_v_kpis_desc_2.id_game\nand z_v_kpis_desc.platform = z_v_kpis_desc_2.platform\nand z_v_kpis_desc.payer = z_v_kpis_desc_2.payer\nand z_v_kpis_desc.adsUser = z_v_kpis_desc_2.adsUser\n\nLEFT JOIN mastergames ON z_v_kpis_desc.id_game = mastergames.id_game\nWHERE "
     (optional (param "dateFrom") "--")
     " z_v_kpis_desc.datekpi >= current_date -30\n"
     (optional "and z_v_kpis_desc.country not in (select iso from countryclasifications where " (param "excludeCountries") ")")
     "\nand z_v_kpis_desc.kpiid in (3,4,5,6,7,8,9,10,11,12)\nAND z_v_kpis_desc_2.kpiid = 1\nand "
     (param "game")
     "\n"
     (optional "and " (param "platform"))
     "\n"
     (optional "and " (param "countrydesc"))
     "\n"
     (optional "and " (param "tier"))
     "\n"
     (optional "and " (param "zone"))
     "\n"
     (optional "and " (param "organic"))
     "\n"
     (optional "and " (param "version"))
     "\n\nGROUP BY 1, 2,3)\n\n\nselect kpidesc,\norderkpi,\ndate_trunc(Period, datekpi) as datekpi,\ncase when sum(new_users) = 0 then null else sum(ret)/sum(new_users) end as ret,\nsum(new_users) as users\nfrom data_by_date\ninner join SelectedPeriod on 1=1\ngroup by 1,2,3\norder by 3,2;\n\n\n"]}}],
 :error_type :invalid-query,
 :json_query
 {:constraints {:max-results 10000, :max-results-bare-rows 2000},
  :type :native,
  :middleware {:js-int-to-string? true, :add-default-userland-constraints? true},
  :native
  {:query
   "with \n\nSelectedPeriod as (select Period\n            from SelPeriod\n            where {{Period}}),\n            \ndata_by_date as (\nSELECT z_v_kpis_desc.kpidesc AS kpidesc,\nz_v_kpis_desc.orderkpi,\nz_v_kpis_desc.datekpi,\nCAST(sum(z_v_kpis_desc.value) AS float) AS ret,\ncase when sum(z_v_kpis_desc.value) is null then 0 else sum(z_v_kpis_desc_2.value) end as new_users\nFROM z_v_kpis_desc\nLEFT JOIN z_v_kpis_desc z_v_kpis_desc_2 \n-- ON z_v_kpis_desc.joinfield = z_v_kpis_desc_2.joinfield\n\non z_v_kpis_desc.datekpi = z_v_kpis_desc_2.datekpi\nand z_v_kpis_desc.country = z_v_kpis_desc_2.country\nand z_v_kpis_desc.version = z_v_kpis_desc_2.version\nand z_v_kpis_desc.organic = z_v_kpis_desc_2.organic\nand z_v_kpis_desc.id_game = z_v_kpis_desc_2.id_game\nand z_v_kpis_desc.platform = z_v_kpis_desc_2.platform\nand z_v_kpis_desc.payer = z_v_kpis_desc_2.payer\nand z_v_kpis_desc.adsUser = z_v_kpis_desc_2.adsUser\n\nLEFT JOIN mastergames ON z_v_kpis_desc.id_game = mastergames.id_game\nWHERE [[{{dateFrom}}--]] z_v_kpis_desc.datekpi >= current_date -30\n[[and z_v_kpis_desc.country not in (select iso from countryclasifications where {{excludeCountries}})]]\nand z_v_kpis_desc.kpiid in (3,4,5,6,7,8,9,10,11,12)\nAND z_v_kpis_desc_2.kpiid = 1\nand {{game}}\n[[and {{platform}}]]\n[[and {{countrydesc}}]]\n[[and {{tier}}]]\n[[and {{zone}}]]\n[[and {{organic}}]]\n[[and {{version}}]]\n\nGROUP BY 1, 2,3)\n\n\nselect kpidesc,\norderkpi,\ndate_trunc(Period, datekpi) as datekpi,\ncase when sum(new_users) = 0 then null else sum(ret)/sum(new_users) end as ret,\nsum(new_users) as users\nfrom data_by_date\ninner join SelectedPeriod on 1=1\ngroup by 1,2,3\norder by 3,2;\n\n\n",
   :template-tags
   {"Period" {:id "691da710-acaf-bec3-4c0f-ff4eed344818", :name "Period", :display-name "Period", :type :dimension, :dimension [:field-id 1782], :widget-type :category, :required true},
    "countrydesc" {:id "61189101-df15-9fac-8060-d6b86052856e", :name "countrydesc", :display-name "Country", :type :dimension, :dimension [:field-id 844], :widget-type :location/country},
    "excludeCountries"
    {:id "1c0738db-90db-f2bb-11a1-c05dbfeae3e2", :name "excludeCountries", :display-name "ExcludeCountries", :type :dimension, :dimension [:field-id 850], :widget-type :location/country},
    "dateFrom" {:id "ce3cdb38-caf0-6ca0-0531-5b15dbf716f2", :name "dateFrom", :display-name "Date", :type :dimension, :dimension [:field-id 576], :widget-type :date/range},
    "version" {:id "28baf672-c96e-547e-8289-9019183ad627", :name "version", :display-name "Version", :type :dimension, :dimension [:field-id 2531], :widget-type :category},
    "zone" {:id "4cb14205-af7a-50d3-250b-fecb8efe4d2e", :name "zone", :display-name "ZoneCountry", :type :dimension, :dimension [:field-id 846], :widget-type :category},
    "tier" {:id "ffaf20d6-cddf-9b59-aa69-c9623c805fe3", :name "tier", :display-name "TierCountry", :type :dimension, :dimension [:field-id 843], :widget-type :category},
    "game" {:id "4ed0ac87-fe9a-15fc-816f-893bb1470e3c", :name "game", :display-name "Game", :type :dimension, :dimension [:field-id 1518], :widget-type :category, :required true},
    "platform" {:id "64bf0c88-23eb-700a-258f-71c1a017ee4e", :name "platform", :display-name "Platform", :type :dimension, :dimension [:field-id 592], :widget-type :category},
    "organic" {:id "2e62690c-fcef-f24a-9f2a-3564c4fc2505", :name "organic", :display-name "Organic", :type :dimension, :dimension [:field-id 579], :widget-type :category}}},
  :database 2,
  :parameters
  ({:name "Game", :slug "game", :id "721a6662", :type "category", :default ["Massive Warfare Aftermath"], :target [:dimension [:template-tag "game"]]}
   {:name "First Login", :slug "first_login", :id "360e3a96", :type "date/all-options", :default "past30days", :target [:dimension [:template-tag "dateFrom"]]}
   {:name "Countries", :slug "countries", :id "7163847d", :type "location/country", :target [:dimension [:template-tag "countrydesc"]]}
   {:name "Platform", :slug "platform", :id "2232f478", :type "category", :target [:dimension [:template-tag "platform"]]}
   {:name "TierCountry", :slug "tiercountry", :id "6468d40", :type "category", :target [:dimension [:template-tag "tier"]]}
   {:name "ZoneCountry", :slug "zonecountry", :id "7241b8ac", :type "category", :target [:dimension [:template-tag "zone"]]}
   {:name "Network", :slug "network", :id "984f2bd8", :type "category", :target [:dimension [:template-tag "organic"]]}
   {:name "ExcludedCountry", :slug "excludedcountry", :id "c5661cc", :type "location/country", :default ["India"], :target [:dimension [:template-tag "excludeCountries"]]}
   {:name "Period", :slug "period", :id "94131d19", :type "category", :default ["day"], :target [:dimension [:template-tag "Period"]]}
   {:name "Version", :slug "version", :id "5397c339", :type "category", :target [:dimension [:template-tag "version"]]}),
  :async? false,
  :cache-ttl nil},
 :status :failed,
 :class clojure.lang.ExceptionInfo,
 :stacktrace
 ["--> driver.common.parameters.dates$fn__46731$date_string__GT_range__46740.invoke(dates.clj:274)"
  "driver.common.parameters.dates$fn__46731$date_string__GT_range__46740$fn__46741.invoke(dates.clj:290)"
  "driver.common.parameters.dates$fn__46731$date_string__GT_range__46740.invoke(dates.clj:274)"
  "driver.sql.parameters.substitution$fn__78682$date_range_field_filter__GT_replacement_snippet_info__78687$fn__78688.invoke(substitution.clj:199)"
  "driver.sql.parameters.substitution$fn__78682$date_range_field_filter__GT_replacement_snippet_info__78687.invoke(substitution.clj:197)"
  "driver.sql.parameters.substitution$fn__78754$field_filter__GT_replacement_snippet_info__78759$fn__78763.invoke(substitution.clj:218)"
  "driver.sql.parameters.substitution$fn__78754$field_filter__GT_replacement_snippet_info__78759.invoke(substitution.clj:213)"
  "driver.sql.parameters.substitution$fn__78834.invokeStatic(substitution.clj:263)"
  "driver.sql.parameters.substitution$fn__78834.invoke(substitution.clj:248)"
  "driver.sql.parameters.substitute$substitute_field_filter.invokeStatic(substitute.clj:14)"
  "driver.sql.parameters.substitute$substitute_field_filter.invoke(substitute.clj:9)"
  "driver.sql.parameters.substitute$substitute_param.invokeStatic(substitute.clj:31)"
  "driver.sql.parameters.substitute$substitute_param.invoke(substitute.clj:25)"
  "driver.sql.parameters.substitute$substitute_STAR_$fn__78901.invoke(substitute.clj:64)"
  "driver.sql.parameters.substitute$substitute_STAR_.invokeStatic(substitute.clj:57)"
  "driver.sql.parameters.substitute$substitute_STAR_.invoke(substitute.clj:54)"
  "driver.sql.parameters.substitute$substitute_optional.invokeStatic(substitute.clj:49)"
  "driver.sql.parameters.substitute$substitute_optional.invoke(substitute.clj:48)"
  "driver.sql.parameters.substitute$substitute_STAR_$fn__78901.invoke(substitute.clj:67)"
  "driver.sql.parameters.substitute$substitute_STAR_.invokeStatic(substitute.clj:57)"
  "driver.sql.parameters.substitute$substitute_STAR_.invoke(substitute.clj:54)"
  "driver.sql.parameters.substitute$substitute$fn__78910.invoke(substitute.clj:81)"
  "driver.sql.parameters.substitute$substitute.invokeStatic(substitute.clj:80)"
  "driver.sql.parameters.substitute$substitute.invoke(substitute.clj:71)"
  "driver.sql$fn__78943.invokeStatic(sql.clj:44)"
  "driver.sql$fn__78943.invoke(sql.clj:40)"
  "query_processor.middleware.parameters.native$expand_inner.invokeStatic(native.clj:39)"
  "query_processor.middleware.parameters.native$expand_inner.invoke(native.clj:30)"
  "query_processor.middleware.parameters$expand_one.invokeStatic(parameters.clj:50)"
  "query_processor.middleware.parameters$expand_one.invoke(parameters.clj:41)"
  "query_processor.middleware.parameters$expand_all$replace_46941__46942.invoke(parameters.clj:59)"
  "mbql.util.match$replace_in_collection$iter__17910__17914$fn__17915.invoke(match.clj:139)"
  "mbql.util.match$replace_in_collection.invokeStatic(match.clj:138)"
  "mbql.util.match$replace_in_collection.invoke(match.clj:133)"
  "query_processor.middleware.parameters$expand_all$replace_46941__46942.invoke(parameters.clj:59)"
  "query_processor.middleware.parameters$expand_all.invokeStatic(parameters.clj:59)"
  "query_processor.middleware.parameters$expand_all.invoke(parameters.clj:53)"
  "query_processor.middleware.parameters$expand_all.invokeStatic(parameters.clj:56)"
  "query_processor.middleware.parameters$expand_all.invoke(parameters.clj:53)"
  "query_processor.middleware.parameters$expand_parameters.invokeStatic(parameters.clj:77)"
  "query_processor.middleware.parameters$expand_parameters.invoke(parameters.clj:73)"
  "query_processor.middleware.parameters$fn__46957$substitute_parameters_STAR___46962$fn__46963.invoke(parameters.clj:82)"
  "query_processor.middleware.parameters$fn__46957$substitute_parameters_STAR___46962.invoke(parameters.clj:79)"
  "query_processor.middleware.parameters$substitute_parameters$fn__46983.invoke(parameters.clj:111)"
  "query_processor.middleware.resolve_referenced$resolve_referenced_card_resources$fn__45363.invoke(resolve_referenced.clj:79)"
  "query_processor.middleware.expand_macros$expand_macros$fn__45984.invoke(expand_macros.clj:155)"
  "query_processor.middleware.add_timezone_info$add_timezone_info$fn__44142.invoke(add_timezone_info.clj:15)"
  "query_processor.middleware.splice_params_in_response$splice_params_in_response$fn__47985.invoke(splice_params_in_response.clj:32)"
  "query_processor.middleware.resolve_database_and_driver$resolve_database_and_driver$fn__47209$fn__47213.invoke(resolve_database_and_driver.clj:31)"
  "driver$do_with_driver.invokeStatic(driver.clj:60)"
  "driver$do_with_driver.invoke(driver.clj:56)"
  "query_processor.middleware.resolve_database_and_driver$resolve_database_and_driver$fn__47209.invoke(resolve_database_and_driver.clj:25)"
  "query_processor.middleware.fetch_source_query$resolve_card_id_source_tables$fn__46202.invoke(fetch_source_query.clj:264)"
  "query_processor.middleware.store$initialize_store$fn__47994$fn__47995.invoke(store.clj:11)"
  "query_processor.store$do_with_store.invokeStatic(store.clj:44)"
  "query_processor.store$do_with_store.invoke(store.clj:38)"
  "query_processor.middleware.store$initialize_store$fn__47994.invoke(store.clj:10)"
  "query_processor.middleware.validate$validate_query$fn__48056.invoke(validate.clj:10)"
  "query_processor.middleware.normalize_query$normalize$fn__46326.invoke(normalize_query.clj:22)"
  "query_processor.middleware.add_rows_truncated$add_rows_truncated$fn__43994.invoke(add_rows_truncated.clj:35)"
  "query_processor.middleware.results_metadata$record_and_return_metadata_BANG_$fn__47970.invoke(results_metadata.clj:147)"
  "query_processor.middleware.constraints$add_default_userland_constraints$fn__45605.invoke(constraints.clj:42)"
  "query_processor.middleware.process_userland_query$process_userland_query$fn__47072.invoke(process_userland_query.clj:135)"
  "query_processor.middleware.catch_exceptions$catch_exceptions$fn__45548.invoke(catch_exceptions.clj:173)"
  "query_processor.reducible$async_qp$qp_STAR___37408$thunk__37409.invoke(reducible.clj:103)"
  "query_processor.reducible$async_qp$qp_STAR___37408.invoke(reducible.clj:109)"
  "query_processor.reducible$async_qp$qp_STAR___37408.invoke(reducible.clj:96)"
  "query_processor.reducible$sync_qp$qp_STAR___37417$fn__37418.invoke(reducible.clj:131)"
  "query_processor.reducible$sync_qp$qp_STAR___37417.invoke(reducible.clj:130)"
  "query_processor$process_userland_query.invokeStatic(query_processor.clj:237)"
  "query_processor$process_userland_query.doInvoke(query_processor.clj:233)"
  "query_processor$fn__48102$process_query_and_save_execution_BANG___48111$fn__48112.invoke(query_processor.clj:246)"
  "query_processor$fn__48102$process_query_and_save_execution_BANG___48111.invoke(query_processor.clj:241)"
  "query_processor$fn__48146$process_query_and_save_with_max_results_constraints_BANG___48155$fn__48156.invoke(query_processor.clj:258)"
  "query_processor$fn__48146$process_query_and_save_with_max_results_constraints_BANG___48155.invoke(query_processor.clj:254)"
  "pulse$execute_dashboard_subscription_card$fn__70272$fn__70273.doInvoke(pulse.clj:74)"
  "api.card$run_query_for_card_async.invokeStatic(card.clj:618)"
  "api.card$run_query_for_card_async.doInvoke(card.clj:594)"
  "pulse$execute_dashboard_subscription_card$fn__70272.invoke(pulse.clj:67)"
  "server.middleware.session$do_with_current_user.invokeStatic(session.clj:258)"
  "server.middleware.session$do_with_current_user.invoke(session.clj:250)"
  "pulse$execute_dashboard_subscription_card.invokeStatic(pulse.clj:66)"
  "pulse$execute_dashboard_subscription_card.invoke(pulse.clj:55)"
  "pulse$execute_dashboard$iter__70284__70288$fn__70289$fn__70290.invoke(pulse.clj:86)"
  "pulse$execute_dashboard$iter__70284__70288$fn__70289.invoke(pulse.clj:85)"
  "pulse$fn__70408.invokeStatic(pulse.clj:215)"
  "pulse$fn__70408.invoke(pulse.clj:210)"
  "pulse$results__GT_notifications$iter__70440__70444$fn__70445.invoke(pulse.clj:263)"
  "pulse$send_notifications_BANG_.invokeStatic(pulse.clj:305)"
  "pulse$send_notifications_BANG_.invoke(pulse.clj:304)"
  "pulse$send_pulse_BANG_.invokeStatic(pulse.clj:331)"
  "pulse$send_pulse_BANG_.doInvoke(pulse.clj:313)"
  "api.pulse$fn__70970.invokeStatic(pulse.clj:209)"
  "api.pulse$fn__70970.invoke(pulse.clj:198)"
  "server.middleware.auth$enforce_authentication$fn__73703.invoke(auth.clj:14)"
  "api.routes$fn__73824$fn__73826.invoke(routes.clj:69)"
  "server.routes$fn__76006$fn__76007.doInvoke(routes.clj:57)"
  "server.routes$fn__75994$fn__75996.invoke(routes.clj:41)"
  "server.middleware.exceptions$catch_uncaught_exceptions$fn__73815.invoke(exceptions.clj:96)"
  "server.middleware.exceptions$catch_api_exceptions$fn__73812.invoke(exceptions.clj:84)"
  "server.middleware.log$log_api_call$fn__75922$fn__75923.invoke(log.clj:195)"
  "server.middleware.log$log_api_call$fn__75922.invoke(log.clj:189)"
  "server.middleware.security$add_security_headers$fn__73778.invoke(security.clj:142)"
  "server.middleware.json$wrap_json_body$fn__75703.invoke(json.clj:62)"
  "server.middleware.json$wrap_streamed_json_response$fn__75721.invoke(json.clj:98)"
  "server.middleware.misc$maybe_set_site_url$fn__35083.invoke(misc.clj:58)"
  "server.middleware.session$bind_current_user$fn__41826$fn__41827.invoke(session.clj:277)"
  "server.middleware.session$do_with_current_user.invokeStatic(session.clj:258)"
  "server.middleware.session$do_with_current_user.invoke(session.clj:250)"
  "server.middleware.session$bind_current_user$fn__41826.invoke(session.clj:276)"
  "server.middleware.session$wrap_current_user_info$fn__41813.invoke(session.clj:236)"
  "server.middleware.session$wrap_session_id$fn__41799.invoke(session.clj:182)"
  "server.middleware.auth$wrap_api_key$fn__73711.invoke(auth.clj:27)"
  "server.middleware.misc$add_content_type$fn__35066.invoke(misc.clj:27)"
  "server.middleware.misc$disable_streaming_buffering$fn__35091.invoke(misc.clj:75)"
  "server.middleware.misc$bind_request$fn__35094.invoke(misc.clj:92)"
  "server.middleware.ssl$redirect_to_https_middleware$fn__75939.invoke(ssl.clj:48)"
  "server$async_proxy_handler$fn__75536.invoke(server.clj:71)"
  "server.proxy$org.eclipse.jetty.server.handler.AbstractHandler$ff19274a.handle(Unknown Source)"],
 :context :pulse,
 :error "Input to date-string->range does not match schema: \n\n\t   [(named (not (instance? java.lang.String nil)) date-string) nil]  \n\n",
 :row_count 0,
 :running_time 0,
 :ex-data {:type :schema.core/error, :value [nil nil], :error [(named (not (instance? java.lang.String nil)) date-string) nil]},
 :data {:rows [], :cols []}}

flamber · March 5, 2021, 9:29am

@aris_pg You are seeing this issue:
https://github.com/metabase/metabase/issues/15067 - upvote by clicking on the first post
But you also have a question with a required variable, which fails, since dashboard filters are currently not being parsed along.

aris_pg · March 5, 2021, 9:55am

@flamber But this will be solved if we install Adopt OpenJDK?

flamber · March 5, 2021, 9:59am

@aris_pg No, but you didn’t include the logs in the the first post, so I had no idea what the problem was.

aris_pg · March 5, 2021, 10:02am

ok, thanks