There was a problem with this question in a subscription

Get Help
1

Hi,

For a client I have an issue with his Dashboard subscription.
He has 3 questions in his dashboard, where one of them is an SQL made question.

This question is always returning 'there was a problem with this question'.
In the loggings i can see it is related to permissions:

8b950757-20d8-43c5-afd4-898bacb5e07c] 2023-02-15T08:00:07+01:00 ERROR metabase.pulse.render Fout bij het opvragen van de pulskaart
clojure.lang.ExceptionInfo: Kaart heeft fouten: Je hebt onvoldoende rechten om deze query uit te voeren. {:database_id 12, :started_at #t "2

But i don't get it? That person is able to view that question, also in her own created dashboard. She has unlimited data access to that specific database as well. So I don't get why I get an error on the permissions part.

Also, you can send dashboards to emails that do not have a metabase account, how can they check permissions for them?

{
  "browser-info": {
    "language": "nl-NL",
    "platform": "Win32",
    "userAgent": "Mozilla/5.0 (Windows NT 6.3; Win64; x64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/109.0.0.0 Safari/537.36",
    "vendor": "Google Inc."
  },
  "system-info": {
    "file.encoding": "Cp1252",
    "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 Client VM",
    "java.vm.version": "11.0.13+8",
    "os.name": "Windows 8.1",
    "os.version": "6.3",
    "user.language": "nl",
    "user.timezone": "Europe/Paris"
  },
  "metabase-info": {
    "databases": [
      "postgres"
    ],
    "hosting-env": "unknown",
    "application-database": "postgres",
    "application-database-details": {
      "database": {
        "name": "PostgreSQL",
        "version": "14.2"
      },
      "jdbc-driver": {
        "name": "PostgreSQL JDBC Driver",
        "version": "42.5.0"
      }
    },
    "run-mode": "prod",
    "version": {
      "date": "2023-01-27",
      "tag": "v0.45.2.1",
      "branch": "release-x.45.2.x",
      "hash": "1a59de7"
    },
    "settings": {
      "report-timezone": "Europe/Brussels"
    }
  }
}
2

crap, @flamber not working anymore at MB? :slight_smile:

3

Please send the full logs when the user sees that question. Thanks

4

Hi, do you have enough with this?
Can't paste everything, it is to big.

[8b950757-20d8-43c5-afd4-898bacb5e07c] 2023-03-02T13:56:26+01:00 DEBUG metabase.server.middleware.log GET /api/bookmark 200 2,7 ms (1 DB-aanroepen) Applicatieverbindingen met DB: 0/15 Jetty-threads: 6/50 (1 wachtend, 0 in wachtrij) (133 totaal actieve threads) Query's actief nu: 0 (0 in wachtrij)
[8b950757-20d8-43c5-afd4-898bacb5e07c] 2023-03-02T13:56:26+01:00 DEBUG metabase.server.middleware.log GET /api/collection/tree 200 8,9 ms (6 DB-aanroepen) Applicatieverbindingen met DB: 0/15 Jetty-threads: 5/50 (1 wachtend, 0 in wachtrij) (133 totaal actieve threads) Query's actief nu: 0 (0 in wachtrij)
[8b950757-20d8-43c5-afd4-898bacb5e07c] 2023-03-02T13:56:26+01:00 DEBUG metabase.server.middleware.log GET /api/database 200 5,5 ms (3 DB-aanroepen) Applicatieverbindingen met DB: 0/15 Jetty-threads: 5/50 (1 wachtend, 0 in wachtrij) (133 totaal actieve threads) Query's actief nu: 0 (0 in wachtrij)
[8b950757-20d8-43c5-afd4-898bacb5e07c] 2023-03-02T13:56:26+01:00 DEBUG metabase.server.middleware.log GET /api/activity/recent_views 200 23,6 ms (8 DB-aanroepen) Applicatieverbindingen met DB: 0/15 Jetty-threads: 6/50 (1 wachtend, 0 in wachtrij) (134 totaal actieve threads) Query's actief nu: 0 (0 in wachtrij)
[8b950757-20d8-43c5-afd4-898bacb5e07c] 2023-03-02T13:56:26+01:00 DEBUG metabase.server.middleware.log GET /api/activity/popular_items 200 33,9 ms (10 DB-aanroepen) Applicatieverbindingen met DB: 0/15 Jetty-threads: 4/50 (1 wachtend, 0 in wachtrij) (134 totaal actieve threads) Query's actief nu: 0 (0 in wachtrij)
[8b950757-20d8-43c5-afd4-898bacb5e07c] 2023-03-02T13:56:28+01:00 DEBUG metabase.server.middleware.log GET /api/dashboard/54 200 10,6 ms (13 DB-aanroepen) Applicatieverbindingen met DB: 1/15 Jetty-threads: 4/50 (1 wachtend, 0 in wachtrij) (134 totaal actieve threads) Query's actief nu: 0 (0 in wachtrij)
[8b950757-20d8-43c5-afd4-898bacb5e07c] 2023-03-02T13:56:28+01:00 DEBUG metabase.server.middleware.log GET /api/field/405 200 4,7 ms (6 DB-aanroepen) Applicatieverbindingen met DB: 1/15 Jetty-threads: 5/50 (1 wachtend, 0 in wachtrij) (134 totaal actieve threads) Query's actief nu: 0 (0 in wachtrij)
[8b950757-20d8-43c5-afd4-898bacb5e07c] 2023-03-02T13:56:28+01:00 DEBUG metabase.server.middleware.log GET /api/field/626 200 4,7 ms (7 DB-aanroepen) Applicatieverbindingen met DB: 1/15 Jetty-threads: 5/50 (1 wachtend, 0 in wachtrij) (134 totaal actieve threads) Query's actief nu: 0 (0 in wachtrij)
[8b950757-20d8-43c5-afd4-898bacb5e07c] 2023-03-02T13:56:28+01:00 DEBUG metabase.server.middleware.log GET /api/collection/117 200 3,6 ms (5 DB-aanroepen) Applicatieverbindingen met DB: 1/15 Jetty-threads: 4/50 (1 wachtend, 0 in wachtrij) (135 totaal actieve threads) Query's actief nu: 0 (0 in wachtrij)
[8b950757-20d8-43c5-afd4-898bacb5e07c] 2023-03-02T13:56:28+01:00 DEBUG metabase.server.middleware.log GET /api/collection/105 200 4,3 ms (5 DB-aanroepen) Applicatieverbindingen met DB: 0/15 Jetty-threads: 4/50 (1 wachtend, 0 in wachtrij) (135 totaal actieve threads) Query's actief nu: 1 (0 in wachtrij)
[8b950757-20d8-43c5-afd4-898bacb5e07c] 2023-03-02T13:56:29+01:00 DEBUG metabase.server.middleware.log POST /api/dashboard/54/dashcard/492/card/30/query 202 [ASYNC: completed] 143,0 ms (19 DB-aanroepen) Applicatieverbindingen met DB: 2/15 Jetty-threads: 3/50 (1 wachtend, 0 in wachtrij) (135 totaal actieve threads) Query's actief nu: 0 (0 in wachtrij); postgres DB 2 connections: 0/1 (0 threads blocked)
[8b950757-20d8-43c5-afd4-898bacb5e07c] 2023-03-02T13:56:33+01:00 DEBUG metabase.server.middleware.log GET /api/pulse 200 6,3 ms (7 DB-aanroepen) Applicatieverbindingen met DB: 0/15 Jetty-threads: 4/50 (1 wachtend, 0 in wachtrij) (135 totaal actieve threads) Query's actief nu: 0 (0 in wachtrij)
[8b950757-20d8-43c5-afd4-898bacb5e07c] 2023-03-02T13:56:33+01:00 DEBUG metabase.server.middleware.log GET /api/pulse/form_input 200 325,3 µs (0 DB-aanroepen) Applicatieverbindingen met DB: 2/15 Jetty-threads: 6/50 (1 wachtend, 0 in wachtrij) (135 totaal actieve threads) Query's actief nu: 0 (0 in wachtrij)
[8b950757-20d8-43c5-afd4-898bacb5e07c] 2023-03-02T13:56:33+01:00 DEBUG metabase.server.middleware.log GET /api/user 200 3,0 ms (2 DB-aanroepen) Applicatieverbindingen met DB: 1/15 Jetty-threads: 6/50 (1 wachtend, 0 in wachtrij) (135 totaal actieve threads) Query's actief nu: 0 (0 in wachtrij)
[8b950757-20d8-43c5-afd4-898bacb5e07c] 2023-03-02T13:56:44+01:00 ERROR metabase.query-processor.middleware.catch-exceptions Fout bij het afhandelen van query: Je hebt onvoldoende rechten om deze query uit te voeren.
{:database_id 2,
 :started_at #t "2023-03-02T13:56:44.349698600+01:00[Europe/Paris]",
 :error_type :missing-required-permissions,
 :json_query
 {:constraints {:max-results 10000, :max-results-bare-rows 2000},
  :type :native,
  :middleware
  {:js-int-to-string? false,
   :ignore-cached-results? false,
   :process-viz-settings? true,
   :add-default-userland-constraints? true},
  :native
  {:query
   "select\n    familydetail.familyno,\n    familydetail.personid,\n    familydetail.saldo,\n    CONCAT(LTRIM(person.firstname), ' ',LTRIM(person.lastname)) AS \"Gezinshoofd\",\n    (select regdate from registration reg where reg.familyno = familydetail.familyno order by regdate desc limit 1) as \"Laatste registratie\"\nfrom \n    familydetail\n        inner join person on person.personid = familydetail.personid and person.persondetailsequenceno = familydetail.persondetailsequenceno\nwhere\n    saldo < 0 \n    [[and {{FamilyNo}}]]\n    [[and familydetail.familyno = (select familyno from person where {{PersonId}})]]\norder by\n    saldo asc",
   :template-tags
   {"FamilyNo"
    {:id "ee2466ad-13b0-ed08-1ea6-c702a23c2e95",
     :name "FamilyNo",
     :display-name "Familyno",
     :type :dimension,
     :dimension [:field 405 nil],
     :widget-type :id},
    "PersonId"
    {:id "9ce85c71-9318-9fdf-c800-7abb3354ebc7",
     :name "PersonId",
     :display-name "Personid",
     :type :dimension,
     :dimension [:field 626 nil],
     :widget-type :id}}},
  :database 2,
  :parameters [],
  :async? false,
  :cache-ttl nil},
 :status :failed,
 :class clojure.lang.ExceptionInfo,
 :stacktrace
 ["--> query_processor.middleware.permissions$perms_exception.invokeStatic(permissions.clj:30)"
  "query_processor.middleware.permissions$perms_exception.doInvoke(permissions.clj:24)"
  "query_processor.middleware.permissions$perms_exception.invokeStatic(permissions.clj:27)"
  "query_processor.middleware.permissions$perms_exception.invoke(permissions.clj:24)"
  "query_processor.middleware.permissions$fn__49209$check_ad_hoc_query_perms__49214$fn__49215.invoke(permissions.clj:84)"
  "query_processor.middleware.permissions$fn__49209$check_ad_hoc_query_perms__49214.invoke(permissions.clj:80)"
  "query_processor.middleware.permissions$fn__49240$check_query_permissions_STAR___49245$fn__49246.invoke(permissions.clj:99)"
  "query_processor.middleware.permissions$fn__49240$check_query_permissions_STAR___49245.invoke(permissions.clj:89)"
  "query_processor.middleware.permissions$check_query_permissions$fn__49259.invoke(permissions.clj:108)"
  "query_processor.middleware.mbql_to_native$mbql__GT_native$fn__52545.invoke(mbql_to_native.clj:23)"
  "query_processor$fn__55076$combined_post_process__55081$combined_post_process_STAR___55082.invoke(query_processor.clj:212)"
  "query_processor$fn__55076$combined_pre_process__55077$combined_pre_process_STAR___55078.invoke(query_processor.clj:209)"
  "query_processor.middleware.resolve_database_and_driver$resolve_database_and_driver$fn__53521$fn__53526.invoke(resolve_database_and_driver.clj:35)"
  "driver$do_with_driver.invokeStatic(driver.clj:76)"
  "driver$do_with_driver.invoke(driver.clj:72)"
  "query_processor.middleware.resolve_database_and_driver$resolve_database_and_driver$fn__53521.invoke(resolve_database_and_driver.clj:34)"
  "query_processor.middleware.fetch_source_query$resolve_card_id_source_tables$fn__49525.invoke(fetch_source_query.clj:314)"
  "query_processor.middleware.store$initialize_store$fn__49715$fn__49716.invoke(store.clj:11)"
  "query_processor.store$do_with_store.invokeStatic(store.clj:45)"
  "query_processor.store$do_with_store.invoke(store.clj:39)"
  "query_processor.middleware.store$initialize_store$fn__49715.invoke(store.clj:10)"
  "query_processor.middleware.normalize_query$normalize$fn__53793.invoke(normalize_query.clj:22)"
  "query_processor.middleware.constraints$add_default_userland_constraints$fn__50803.invoke(constraints.clj:53)"
  "query_processor.middleware.process_userland_query$process_userland_query$fn__53732.invoke(process_userland_query.clj:145)"
  "query_processor.middleware.catch_exceptions$catch_exceptions$fn__54104.invoke(catch_exceptions.clj:167)"
  "query_processor.reducible$async_qp$qp_STAR___45514$thunk__45516.invoke(reducible.clj:100)"
  "query_processor.reducible$async_qp$qp_STAR___45514.invoke(reducible.clj:106)"
  "query_processor.reducible$async_qp$qp_STAR___45514.invoke(reducible.clj:91)"
  "query_processor.reducible$async_qp$qp_STAR___45514.invoke(reducible.clj:88)"
  "query_processor.reducible$sync_qp$qp_STAR___45525.doInvoke(reducible.clj:126)"
  "query_processor$process_userland_query.invokeStatic(query_processor.clj:331)"
  "query_processor$process_userland_query.doInvoke(query_processor.clj:327)"
  "query_processor$fn__55123$process_query_and_save_execution_BANG___55132$fn__55133.invoke(query_processor.clj:339)"
  "query_processor$fn__55123$process_query_and_save_execution_BANG___55132.invoke(query_processor.clj:335)"
  "query_processor$fn__55167$process_query_and_save_with_max_results_constraints_BANG___55176$fn__55177.invoke(query_processor.clj:351)"
  "query_processor$fn__55167$process_query_and_save_with_max_results_constraints_BANG___55176.invoke(query_processor.clj:347)"
  "pulse$execute_dashboard_subscription_card$fn__80634$fn__80635.invoke(pulse.clj:67)"
  "query_processor.card$run_query_for_card_async.invokeStatic(card.clj:212)"
  "query_processor.card$run_query_for_card_async.doInvoke(card.clj:169)"
  "query_processor.dashboard$run_query_for_dashcard_async.invokeStatic(dashboard.clj:182)"
  "query_processor.dashboard$run_query_for_dashcard_async.doInvoke(dashboard.clj:153)"
  "pulse$execute_dashboard_subscription_card$fn__80634.invoke(pulse.clj:57)"
  "server.middleware.session$do_with_current_user.invokeStatic(session.clj:310)"
  "server.middleware.session$do_with_current_user.invoke(session.clj:299)"
  "pulse$execute_dashboard_subscription_card.invokeStatic(pulse.clj:56)"
  "pulse$execute_dashboard_subscription_card.invoke(pulse.clj:50)"
  "pulse$execute_dashboard$iter__80646__80650$fn__80651.invoke(pulse.clj:93)"
  "pulse$fn__80782.invokeStatic(pulse.clj:304)"
  "pulse$fn__80782.invoke(pulse.clj:298)"
  "pulse$results__GT_notifications$iter__80812__80816$fn__80817.invoke(pulse.clj:361)"
  "pulse$send_notifications_BANG_.invokeStatic(pulse.clj:481)"
  "pulse$send_notifications_BANG_.invoke(pulse.clj:480)"
  "pulse$send_pulse_BANG_.invokeStatic(pulse.clj:508)"
  "pulse$send_pulse_BANG_.doInvoke(pulse.clj:489)"
  "api.pulse$fn__82104.invokeStatic(pulse.clj:294)"
  "api.pulse$fn__82104.invoke(pulse.clj:280)"
  "server.middleware.auth$enforce_authentication$fn__70597.invoke(auth.clj:17)"
  "api.routes$fn__82628$fn__82631.invoke(routes.clj:64)"
  "server.routes$fn__82792$fn__82793.doInvoke(routes.clj:69)"
  "server.routes$fn__82777$fn__82779.invoke(routes.clj:46)"
  "server.middleware.exceptions$catch_uncaught_exceptions$fn__79072.invoke(exceptions.clj:98)"
  "server.middleware.exceptions$catch_api_exceptions$fn__79069.invoke(exceptions.clj:86)"
  "server.middleware.log$log_api_call$fn__84204$fn__84205$fn__84206.invoke(log.clj:211)"
  "driver.sql_jdbc.execute.diagnostic$do_with_diagnostic_info.invokeStatic(diagnostic.clj:15)"
  "driver.sql_jdbc.execute.diagnostic$do_with_diagnostic_info.invoke(diagnostic.clj:9)"
  "server.middleware.log$log_api_call$fn__84204$fn__84205.invoke(log.clj:203)"
  "server.middleware.log$log_api_call$fn__84204.invoke(log.clj:202)"
  "server.middleware.browser_cookie$ensure_browser_id_cookie$fn__87101.invoke(browser_cookie.clj:38)"
  "server.middleware.security$add_security_headers$fn__63926.invoke(security.clj:149)"
  "server.middleware.json$wrap_json_body$fn__86232.invoke(json.clj:63)"
  "server.middleware.json$wrap_streamed_json_response$fn__86250.invoke(json.clj:99)"
  "server.middleware.offset_paging$handle_paging$fn__63950.invoke(offset_paging.clj:42)"
  "server.middleware.misc$maybe_set_site_url$fn__36696.invoke(misc.clj:59)"
  "server.middleware.session$reset_session_timeout$fn__48385.invoke(session.clj:394)"
  "server.middleware.session$bind_current_user$fn__48368$fn__48369.invoke(session.clj:331)"
  "server.middleware.session$do_with_current_user.invokeStatic(session.clj:310)"
  "server.middleware.session$do_with_current_user.invoke(session.clj:299)"
  "server.middleware.session$bind_current_user$fn__48368.invoke(session.clj:330)"
  "server.middleware.session$wrap_current_user_info$fn__48350.invoke(session.clj:280)"
  "server.middleware.session$wrap_session_id$fn__48334.invoke(session.clj:213)"
  "server.middleware.auth$wrap_api_key$fn__70605.invoke(auth.clj:30)"
  "server.middleware.misc$add_content_type$fn__36679.invoke(misc.clj:27)"
  "server.middleware.misc$disable_streaming_buffering$fn__36704.invoke(misc.clj:76)"
  "server.middleware.misc$bind_request$fn__36707.invoke(misc.clj:93)"
  "server.middleware.ssl$redirect_to_https_middleware$fn__87117.invoke(ssl.clj:38)"
  "server$async_proxy_handler$fn__83000.invoke(server.clj:73)"
  "server.proxy$org.eclipse.jetty.server.handler.AbstractHandler$ff19274a.handle(Unknown Source)"],
 :card_id 30,
 :context :pulse,
 :error "Je hebt onvoldoende rechten om deze query uit te voeren.",
 :row_count 0,
 :running_time 0,
 :ex-data
 {:type :missing-required-permissions,
  :required-permissions #{"/db/2/native/"},
  :actual-permissions
  #{"/collection/4/read/"
    "/collection/85/read/"
    "/collection/94/read/"
    "/collection/63/read/"
    "/collection/7/read/"
    "/collection/33/read/"
    "/download/db/14/"
    "/collection/20/read/"
    "/collection/72/read/"
    "/collection/114/"
    "/collection/25/read/"
    "/collection/111/"
    "/collection/55/read/"
    "/db/6/schema/"
    "/download/db/6/"
    "/collection/90/read/"
    "/collection/22/read/"
    "/collection/56/read/"
    "/collection/103/"
    "/collection/41/read/"
    "/collection/28/read/"
    "/collection/43/read/"
    "/collection/81/read/"
    "/collection/82/read/"
    "/collection/99/"
    "/collection/26/read/"
    "/collection/31/read/"
    "/collection/57/read/"
    "/collection/66/read/"
    "/collection/92/read/"
    "/collection/32/read/"
    "/collection/16/read/"
    "/collection/59/read/"
    "/collection/117/"
    "/collection/19/read/"
    "/collection/87/read/"
    "/db/12/schema/"
    "/db/7/schema/"
    "/download/db/2/"
    "/collection/62/read/"
    "/download/db/12/"
    "/db/13/schema/"
    "/collection/5/read/"
    "/collection/112/"
    "/download/db/9/"
    "/collection/71/read/"
    "/collection/96/"
    "/collection/91/read/"
    "/collection/6/read/"
    "/db/2/schema/"
    "/collection/73/read/"
    "/collection/84/read/"
    "/collection/54/read/"
    "/collection/42/read/"
    "/download/db/13/"
    "/collection/65/read/"
    "/download/db/10/"
    "/collection/8/read/"
    "/collection/88/read/"
    "/collection/95/"
    "/collection/30/read/"
    "/collection/110/"
    "/collection/34/read/"
    "/collection/61/read/"
    "/collection/64/read/"
    "/collection/116/"
    "/application/subscription/"
    "/collection/109/"
    "/collection/12/read/"
    "/collection/83/read/"
    "/collection/102/"
    "/collection/44/read/"
    "/collection/86/read/"
    "/collection/69/read/"
    "/collection/24/read/"
    "/collection/98/"
    "/download/db/11/"
    "/collection/70/read/"
    "/collection/53/read/"
    "/collection/89/read/"
    "/collection/60/read/"
    "/collection/39/read/"
    "/collection/38/read/"
    "/collection/18/read/"
    "/collection/17/read/"
    "/collection/29/read/"
    "/collection/105/"
    "/collection/58/read/"
    "/collection/113/"
    "/collection/68/read/"
    "/download/db/7/"
    "/download/db/12/native/"
    "/collection/93/read/"
    "/collection/35/"
    "/db/11/schema/"
    "/collection/97/"
    "/db/9/schema/"
    "/collection/67/read/"
    "/collection/40/read/"
    "/collection/100/"},
  :permissions-error? true},
 :data {:rows [], :cols []}}

[8b950757-20d8-43c5-afd4-898bacb5e07c] 2023-03-02T13:56:44+01:00 ERROR metabase.pulse.render Fout bij het opvragen van de pulskaart
clojure.lang.ExceptionInfo: Kaart heeft fouten: Je hebt onvoldoende rechten om deze query uit te voeren. {:database_id 2, :started_at #t "2023-03-02T13:56:44.349698600+01:00[Europe/Paris]", :error_type :missing-required-permissions, :json_query {:constraints {:max-results 10000, :max-results-bare-rows 2000}, :type :native, :middleware {:js-int-to-string? false, :ignore-cached-results? false, :process-viz-settings? true, :add-default-userland-constraints? true}, :native {:query "select\n    familydetail.familyno,\n    familydetail.personid,\n    familydetail.saldo,\n    CONCAT(LTRIM(person.firstname), ' ',LTRIM(person.lastname)) AS \"Gezinshoofd\",\n    (select regdate from registration reg where reg.familyno = familydetail.familyno order by regdate desc limit 1) as \"Laatste registratie\"\nfrom \n    familydetail\n        inner join person on person.personid = familydetail.personid and person.persondetailsequenceno = familydetail.persondetailsequenceno\nwhere\n    saldo < 0 \n    [[and {{FamilyNo}}]]\n    [[and familydetail.familyno = (select familyno from person where {{PersonId}})]]\norder by\n    saldo asc", :template-tags {"FamilyNo" {:id "ee2466ad-13b0-ed08-1ea6-c702a23c2e95", :name "FamilyNo", :display-name "Familyno", :type :dimension, :dimension [:field 405 nil], :widget-type :id}, "PersonId" {:id "9ce85c71-9318-9fdf-c800-7abb3354ebc7", :name "PersonId", :display-name "Personid", :type :dimension, :dimension [:field 626 nil], :widget-type :id}}}, :database 2, :parameters [], :async? false, :cache-ttl nil}, :status :failed, :class clojure.lang.ExceptionInfo, :stacktrace ["--> query_processor.middleware.permissions$perms_exception.invokeStatic(permissions.clj:30)" "query_processor.middleware.permissions$perms_exception.doInvoke(permissions.clj:24)" "query_processor.middleware.permissions$perms_exception.invokeStatic(permissions.clj:27)" "query_processor.middleware.permissions$perms_exception.invoke(permissions.clj:24)" "query_processor.middleware.permissions$fn__49209$check_ad_hoc_query_perms__49214$fn__49215.invoke(permissions.clj:84)" "query_processor.middleware.permissions$fn__49209$check_ad_hoc_query_perms__49214.invoke(permissions.clj:80)" "query_processor.middleware.permissions$fn__49240$check_query_permissions_STAR___49245$fn__49246.invoke(permissions.clj:99)" "query_processor.middleware.permissions$fn__49240$check_query_permissions_STAR___49245.invoke(permissions.clj:89)" "query_processor.middleware.permissions$check_query_permissions$fn__49259.invoke(permissions.clj:108)" "query_processor.middleware.mbql_to_native$mbql__GT_native$fn__52545.invoke(mbql_to_native.clj:23)" "query_processor$fn__55076$combined_post_process__55081$combined_post_process_STAR___55082.invoke(query_processor.clj:212)" "query_processor$fn__55076$combined_pre_process__55077$combined_pre_process_STAR___55078.invoke(query_processor.clj:209)" "query_processor.middleware.resolve_database_and_driver$resolve_database_and_driver$fn__53521$fn__53526.invoke(resolve_database_and_driver.clj:35)" "driver$do_with_driver.invokeStatic(driver.clj:76)" "driver$do_with_driver.invoke(driver.clj:72)" "query_processor.middleware.resolve_database_and_driver$resolve_database_and_driver$fn__53521.invoke(resolve_database_and_driver.clj:34)" "query_processor.middleware.fetch_source_query$resolve_card_id_source_tables$fn__49525.invoke(fetch_source_query.clj:314)" "query_processor.middleware.store$initialize_store$fn__49715$fn__49716.invoke(store.clj:11)" "query_processor.store$do_with_store.invokeStatic(store.clj:45)" "query_processor.store$do_with_store.invoke(store.clj:39)" "query_processor.middleware.store$initialize_store$fn__49715.invoke(store.clj:10)" "query_processor.middleware.normalize_query$normalize$fn__53793.invoke(normalize_query.clj:22)" "query_processor.middleware.constraints$add_default_userland_constraints$fn__50803.invoke(constraints.clj:53)" "query_processor.middleware.process_userland_query$process_userland_query$fn__53732.invoke(process_userland_query.clj:145)" "query_processor.middleware.catch_exceptions$catch_exceptions$fn__54104.invoke(catch_exceptions.clj:167)" "query_processor.reducible$async_qp$qp_STAR___45514$thunk__45516.invoke(reducible.clj:100)" "query_processor.reducible$async_qp$qp_STAR___45514.invoke(reducible.clj:106)" "query_processor.reducible$async_qp$qp_STAR___45514.invoke(reducible.clj:91)" "query_processor.reducible$async_qp$qp_STAR___45514.invoke(reducible.clj:88)" "query_processor.reducible$sync_qp$qp_STAR___45525.doInvoke(reducible.clj:126)" "query_processor$process_userland_query.invokeStatic(query_processor.clj:331)" "query_processor$process_userland_query.doInvoke(query_processor.clj:327)" "query_processor$fn__55123$process_query_and_save_execution_BANG___55132$fn__55133.invoke(query_processor.clj:339)" "query_processor$fn__55123$process_query_and_save_execution_BANG___55132.invoke(query_processor.clj:335)" "query_processor$fn__55167$process_query_and_save_with_max_results_constraints_BANG___55176$fn__55177.invoke(query_processor.clj:351)" "query_processor$fn__55167$process_query_and_save_with_max_results_constraints_BANG___55176.invoke(query_processor.clj:347)" "pulse$execute_dashboard_subscription_card$fn__80634$fn__80635.invoke(pulse.clj:67)" "query_processor.card$run_query_for_card_async.invokeStatic(card.clj:212)" "query_processor.card$run_query_for_card_async.doInvoke(card.clj:169)" "query_processor.dashboard$run_query_for_dashcard_async.invokeStatic(dashboard.clj:182)" "query_processor.dashboard$run_query_for_dashcard_async.doInvoke(dashboard.clj:153)" "pulse$execute_dashboard_subscription_card$fn__80634.invoke(pulse.clj:57)" "server.middleware.session$do_with_current_user.invokeStatic(session.clj:310)" "server.middleware.session$do_with_current_user.invoke(session.clj:299)" "pulse$execute_dashboard_subscription_card.invokeStatic(pulse.clj:56)" "pulse$execute_dashboard_subscription_card.invoke(pulse.clj:50)" "pulse$execute_dashboard$iter__80646__80650$fn__80651.invoke(pulse.clj:93)" "pulse$fn__80782.invokeStatic(pulse.clj:304)" "pulse$fn__80782.invoke(pulse.clj:298)" "pulse$results__GT_notifications$iter__80812__80816$fn__80817.invoke(pulse.clj:361)" "pulse$send_notifications_BANG_.invokeStatic(pulse.clj:481)" "pulse$send_notifications_BANG_.invoke(pulse.clj:480)" "pulse$send_pulse_BANG_.invokeStatic(pulse.clj:508)" "pulse$send_pulse_BANG_.doInvoke(pulse.clj:489)" "api.pulse$fn__82104.invokeStatic(pulse.clj:294)" "api.pulse$fn__82104.invoke(pulse.clj:280)" "server.middleware.auth$enforce_authentication$fn__70597.invoke(auth.clj:17)" "api.routes$fn__82628$fn__82631.invoke(routes.clj:64)" "server.routes$fn__82792$fn__82793.doInvoke(routes.clj:69)" "server.routes$fn__82777$fn__82779.invoke(routes.clj:46)" "server.middleware.exceptions$catch_uncaught_exceptions$fn__79072.invoke(exceptions.clj:98)" "server.middleware.exceptions$catch_api_exceptions$fn__79069.invoke(exceptions.clj:86)" "server.middleware.log$log_api_call$fn__84204$fn__84205$fn__84206.invoke(log.clj:211)" "driver.sql_jdbc.execute.diagnostic$do_with_diagnostic_info.invokeStatic(diagnostic.clj:15)" "driver.sql_jdbc.execute.diagnostic$do_with_diagnostic_info.invoke(diagnostic.clj:9)" "server.middleware.log$log_api_call$fn__84204$fn__84205.invoke(log.clj:203)" "server.middleware.log$log_api_call$fn__84204.invoke(log.clj:202)" "server.middleware.browser_cookie$ensure_browser_id_cookie$fn__87101.invoke(browser_cookie.clj:38)" "server.middleware.security$add_security_headers$fn__63926.invoke(security.clj:149)" "server.middleware.json$wrap_json_body$fn__86232.invoke(json.clj:63)" "server.middleware.json$wrap_streamed_json_response$fn__86250.invoke(json.clj:99)" "server.middleware.offset_paging$handle_paging$fn__63950.invoke(offset_paging.clj:42)" "server.middleware.misc$maybe_set_site_url$fn__36696.invoke(misc.clj:59)" "server.middleware.session$reset_session_timeout$fn__48385.invoke(session.clj:394)" "server.middleware.session$bind_current_user$fn__48368$fn__48369.invoke(session.clj:331)" "server.middleware.session$do_with_current_user.invokeStatic(session.clj:310)" "server.middleware.session$do_with_current_user.invoke(session.clj:299)" "server.middleware.session$bind_current_user$fn__48368.invoke(session.clj:330)" "server.middleware.session$wrap_current_user_info$fn__48350.invoke(session.clj:280)" "server.middleware.session$wrap_session_id$fn__48334.invoke(session.clj:213)" "server.middleware.auth$wrap_api_key$fn__70605.invoke(auth.clj:30)" "server.middleware.misc$add_content_type$fn__36679.invoke(misc.clj:27)" "server.middleware.misc$disable_streaming_buffering$fn__36704.invoke(misc.clj:76)" "server.middleware.misc$bind_request$fn__36707.invoke(misc.clj:93)" "server.middleware.ssl$redirect_to_https_middleware$fn__87117.invoke(ssl.clj:38)" "server$async_proxy_handler$fn__83000.invoke(server.clj:73)" "server.proxy$org.eclipse.jetty.server.handler.AbstractHandler$ff19274a.handle(Unknown Source)"], :card_id 30, :card-error true, :context :pulse, :error "Je hebt onvoldoende rechten om deze query uit te voeren.", :row_count 0, :running_time 0, :ex-data {:type :missing-required-permissions, :required-permissions #{"/db/2/native/"}, :actual-permissions #{"/collection/4/read/" "/collection/85/read/" "/collection/94/read/" "/collection/63/read/" "/collection/7/read/" "/collection/33/read/" "/download/db/14/" "/collection/20/read/" "/collection/72/read/" "/collection/114/" "/collection/25/read/" "/collection/111/" "/collection/55/read/" "/db/6/schema/" "/download/db/6/" "/collection/90/read/" "/collection/22/read/" "/collection/56/read/" "/collection/103/" "/collection/41/read/" "/collection/28/read/" "/collection/43/read/" "/collection/81/read/" "/collection/82/read/" "/collection/99/" "/collection/26/read/" "/collection/31/read/" "/collection/57/read/" "/collection/66/read/" "/collection/92/read/" "/collection/32/read/" "/collection/16/read/" "/collection/59/read/" "/collection/117/" "/collection/19/read/" "/collection/87/read/" "/db/12/schema/" "/db/7/schema/" "/download/db/2/" "/collection/62/read/" "/download/db/12/" "/db/13/schema/" "/collection/5/read/" "/collection/112/" "/download/db/9/" "/collection/71/read/" "/collection/96/" "/collection/91/read/" "/collection/6/read/" "/db/2/schema/" "/collection/73/read/" "/collection/84/read/" "/collection/54/read/" "/collection/42/read/" "/download/db/13/" "/collection/65/read/" "/download/db/10/" "/collection/8/read/" "/collection/88/read/" "/collection/95/" "/collection/30/read/" "/collection/110/" "/collection/34/read/" "/collection/61/read/" "/collection/64/read/" "/collection/116/" "/application/subscription/" "/collection/109/" "/collection/12/read/" "/collection/83/read/" "/collection/102/" "/collection/44/read/" "/collection/86/read/" "/collection/69/read/" "/collection/24/read/" "/collection/98/" "/download/db/11/" "/collection/70/read/" "/collection/53/read/" "/collection/89/read/" "/collection/60/read/" "/collection/39/read/" "/collection/38/read/" "/collection/18/read/" "/collection/17/read/" "/collection/29/read/" "/collection/105/" "/collection/58/read/" "/collection/113/" "/collection/68/read/" "/download/db/7/" "/download/db/12/native/" "/collection/93/read/" "/collection/35/" "/db/11/schema/" "/collection/97/" "/db/9/schema/" "/collection/67/read/" "/collection/40/read/" "/collection/100/"}, :permissions-error? true}, :data {:rows [], :cols []}}
	at metabase.pulse.render$fn__59305$render_pulse_card_body__59310$fn__59314.invoke(render.clj:122)
	at metabase.pulse.render$fn__59305$render_pulse_card_body__59310.invoke(render.clj:118)
	at metabase.pulse.render$fn__59344$render_pulse_card__59349$fn__59350.invoke(render.clj:154)
	at metabase.pulse.render$fn__59344$render_pulse_card__59349.invoke(render.clj:142)
	at metabase.pulse.render$fn__59373$render_pulse_section__59378$fn__59382$fn__59385.invoke(render.clj:186)
	at metabase.pulse.render$fn__59373$render_pulse_section__59378$fn__59382.invoke(render.clj:184)
	at metabase.pulse.render$fn__59373$render_pulse_section__59378.invoke(render.clj:181)
	at metabase.email.messages$render_result_card.invokeStatic(messages.clj:428)
	at metabase.email.messages$render_result_card.invoke(messages.clj:425)
	at metabase.email.messages$render_message_body$fn__60660$fn__60661.invoke(messages.clj:476)
	at clojure.core$mapv$fn__8535.invoke(core.clj:6979)
	at clojure.core.protocols$fn__8249.invokeStatic(protocols.clj:168)
	at clojure.core.protocols$fn__8249.invoke(protocols.clj:124)
	at clojure.core.protocols$fn__8204$G__8199__8213.invoke(protocols.clj:19)
	at clojure.core.protocols$seq_reduce.invokeStatic(protocols.clj:31)
	at clojure.core.protocols$fn__8236.invokeStatic(protocols.clj:75)
	at clojure.core.protocols$fn__8236.invoke(protocols.clj:75)
	at clojure.core.protocols$fn__8178$G__8173__8191.invoke(protocols.clj:13)
	at clojure.core$reduce.invokeStatic(core.clj:6886)
	at clojure.core$mapv.invokeStatic(core.clj:6970)
	at clojure.core$mapv.invoke(core.clj:6970)
	at metabase.email.messages$render_message_body$fn__60660.invoke(messages.clj:476)
	at metabase.email.messages$render_message_body.invokeStatic(messages.clj:475)
	at metabase.email.messages$render_message_body.invoke(messages.clj:473)
	at metabase.email.messages$render_pulse_email.invokeStatic(messages.clj:502)
	at metabase.email.messages$render_pulse_email.invoke(messages.clj:499)
	at metabase.pulse$fn__80782.invokeStatic(pulse.clj:309)
	at metabase.pulse$fn__80782.invoke(pulse.clj:298)
	at clojure.lang.MultiFn.invoke(MultiFn.java:239)
	at metabase.pulse$results__GT_notifications$iter__80812__80816$fn__80817.invoke(pulse.clj:361)
	at clojure.lang.LazySeq.sval(LazySeq.java:42)
	at clojure.lang.LazySeq.seq(LazySeq.java:51)
	at clojure.lang.RT.seq(RT.java:535)
	at clojure.core$seq__5467.invokeStatic(core.clj:139)
	at clojure.core$seq__5467.invoke(core.clj:139)
	at metabase.pulse$send_notifications_BANG_.invokeStatic(pulse.clj:481)
	at metabase.pulse$send_notifications_BANG_.invoke(pulse.clj:480)
	at metabase.pulse$send_pulse_BANG_.invokeStatic(pulse.clj:508)
	at metabase.pulse$send_pulse_BANG_.doInvoke(pulse.clj:489)
	at clojure.lang.RestFn.invoke(RestFn.java:410)
	at metabase.api.pulse$fn__82104.invokeStatic(pulse.clj:294)
	at metabase.api.pulse$fn__82104.invoke(pulse.clj:280)
	at compojure.core$wrap_response$fn__29313.invoke(core.clj:160)
	at compojure.core$wrap_route_middleware$fn__29297.invoke(core.clj:132)
	at compojure.core$wrap_route_info$fn__29302.invoke(core.clj:139)
	at compojure.core$wrap_route_matches$fn__29306.invoke(core.clj:151)
	at compojure.core$routes$fn__29325$f__29326.invoke(core.clj:198)
	at compojure.core$routes$fn__29325$f__29326$respond_SINGLEQUOTE___29327.invoke(core.clj:197)
	at compojure.core$wrap_route_matches$fn__29306.invoke(core.clj:153)
	at compojure.core$routes$fn__29325$f__29326.invoke(core.clj:198)
	at compojure.core$routes$fn__29325$f__29326$respond_SINGLEQUOTE___29327.invoke(core.clj:197)
	at compojure.core$wrap_route_matches$fn__29306.invoke(core.clj:153)
	at compojure.core$routes$fn__29325$f__29326.invoke(core.clj:198)
	at compojure.core$routes$fn__29325$f__29326$respond_SINGLEQUOTE___29327.invoke(core.clj:197)
	at compojure.core$wrap_route_matches$fn__29306.invoke(core.clj:153)
	at compojure.core$routes$fn__29325$f__29326.invoke(core.clj:198)
	at compojure.core$routes$fn__29325$f__29326$respond_SINGLEQUOTE___29327.invoke(core.clj:197)
	at compojure.core$wrap_route_matches$fn__29306.invoke(core.clj:152)
	at compojure.core$routes$fn__29325$f__29326.invoke(core.clj:198)
	at compojure.core$routes$fn__29325.invoke(core.clj:200)
	at metabase.server.middleware.auth$enforce_authentication$fn__70597.invoke(auth.clj:17)
	at compojure.core$routes$fn__29325$f__29326.invoke(core.clj:198)
	at compojure.core$routes$fn__29325.invoke(core.clj:200)
	at compojure.core$make_context$handler__29353.invoke(core.clj:289)
	at compojure.core$make_context$fn__29357.invoke(core.clj:299)
	at compojure.core$routes$fn__29325$f__29326.invoke(core.clj:198)
	at compojure.core$routes$fn__29325$f__29326$respond_SINGLEQUOTE___29327.invoke(core.clj:197)
	at compojure.core$make_context$fn__29357.invoke(core.clj:300)
	at compojure.core$routes$fn__29325$f__29326.invoke(core.clj:198)
	at compojure.core$routes$fn__29325$f__29326$respond_SINGLEQUOTE___29327.invoke(core.clj:197)
	at compojure.core$make_context$fn__29357.invoke(core.clj:300)
	at compojure.core$routes$fn__29325$f__29326.invoke(core.clj:198)
	at compojure.core$routes$fn__29325$f__29326$respond_SINGLEQUOTE___29327.invoke(core.clj:197)
	at compojure.core$make_context$fn__29357.invoke(core.clj:300)
	at compojure.core$routes$fn__29325$f__29326.invoke(core.clj:198)
	at compojure.core$routes$fn__29325$f__29326$respond_SINGLEQUOTE___29327.invoke(core.clj:197)
	at compojure.core$make_context$fn__29357.invoke(core.clj:300)
	at compojure.core$routes$fn__29325$f__29326.invoke(core.clj:198)
	at compojure.core$routes$fn__29325$f__29326$respond_SINGLEQUOTE___29327.invoke(core.clj:197)
	at compojure.core$make_context$fn__29357.invoke(core.clj:300)
	at compojure.core$routes$fn__29325$f__29326.invoke(core.clj:198)
	at compojure.core$routes$fn__29325$f__29326$respond_SINGLEQUOTE___29327.invoke(core.clj:197)
	at compojure.core$make_context$fn__29357.invoke(core.clj:300)
	at compojure.core$routes$fn__29325$f__29326.invoke(core.clj:198)
	at compojure.core$routes$fn__29325$f__29326$respond_SINGLEQUOTE___29327.invoke(core.clj:197)
	at compojure.core$make_context$fn__29357.invoke(core.clj:300)
	at compojure.core$routes$fn__29325$f__29326.invoke(core.clj:198)
	at compojure.core$routes$fn__29325$f__29326$respond_SINGLEQUOTE___29327.invoke(core.clj:197)
	at compojure.core$make_context$fn__29357.invoke(core.clj:300)
	at compojure.core$routes$fn__29325$f__29326.invoke(core.clj:198)
	at compojure.core$routes$fn__29325$f__29326$respond_SINGLEQUOTE___29327.invoke(core.clj:197)
	at compojure.core$make_context$fn__29357.invoke(core.clj:300)
	at compojure.core$routes$fn__29325$f__29326.invoke(core.clj:198)
	at compojure.core$routes$fn__29325$f__29326$respond_SINGLEQUOTE___29327.invoke(core.clj:197)
	at compojure.core$make_context$fn__29357.invoke(core.clj:300)
	at compojure.core$routes$fn__29325$f__29326.invoke(core.clj:198)
	at compojure.core$routes$fn__29325$f__29326$respond_SINGLEQUOTE___29327.invoke(core.clj:197)
	at compojure.core$make_context$fn__29357.invoke(core.clj:300)
	at compojure.core$routes$fn__29325$f__29326.invoke(core.clj:198)
	at compojure.core$routes$fn__29325$f__29326$respond_SINGLEQUOTE___29327.invoke(core.clj:197)
	at compojure.core$make_context$fn__29357.invoke(core.clj:300)
	at compojure.core$routes$fn__29325$f__29326.invoke(core.clj:198)
	at compojure.core$routes$fn__29325$f__29326$respond_SINGLEQUOTE___29327.invoke(core.clj:197)
	at compojure.core$make_context$fn__29357.invoke(core.clj:300)
	at compojure.core$routes$fn__29325$f__29326.invoke(core.clj:198)
	at compojure.core$routes$fn__29325$f__29326$respond_SINGLEQUOTE___29327.invoke(core.clj:197)
	at compojure.core$make_context$fn__29357.invoke(core.clj:300)
	at compojure.core$routes$fn__29325$f__29326.invoke(core.clj:198)
	at compojure.core$routes$fn__29325$f__29326$respond_SINGLEQUOTE___29327.invoke(core.clj:197)
	at compojure.core$make_context$fn__29357.invoke(core.clj:300)
	at compojure.core$routes$fn__29325$f__29326.invoke(core.clj:198)
	at compojure.core$routes$fn__29325$f__29326$respond_SINGLEQUOTE___29327.invoke(core.clj:197)
	at compojure.core$make_context$fn__29357.invoke(core.clj:300)
	at compojure.core$routes$fn__29325$f__29326.invoke(core.clj:198)
	at compojure.core$routes$fn__29325$f__29326$respond_SINGLEQUOTE___29327.invoke(core.clj:197)
	at compojure.core$make_context$fn__29357.invoke(core.clj:300)
	at compojure.core$routes$fn__29325$f__29326.invoke(core.clj:198)
	at compojure.core$routes$fn__29325$f__29326$respond_SINGLEQUOTE___29327.invoke(core.clj:197)
	at compojure.core$make_context$fn__29357.invoke(core.clj:300)
	at compojure.core$routes$fn__29325$f__29326.invoke(core.clj:198)
	at compojure.core$routes$fn__29325$f__29326$respond_SINGLEQUOTE___29327.invoke(core.clj:197)
	at compojure.core$make_context$fn__29357.invoke(core.clj:300)
	at compojure.core$routes$fn__29325$f__29326.invoke(core.clj:198)
	at compojure.core$routes$fn__29325$f__29326$respond_SINGLEQUOTE___29327.invoke(core.clj:197)
	at compojure.core$make_context$fn__29357.invoke(core.clj:300)
	at compojure.core$routes$fn__29325$f__29326.invoke(core.clj:198)
	at compojure.core$routes$fn__29325$f__29326$respond_SINGLEQUOTE___29327.invoke(core.clj:197)
	at compojure.core$make_context$fn__29357.invoke(core.clj:300)
	at compojure.core$routes$fn__29325$f__29326.invoke(core.clj:198)
	at compojure.core$routes$fn__29325$f__29326$respond_SINGLEQUOTE___29327.invoke(core.clj:197)
	at compojure.core$make_context$fn__29357.invoke(core.clj:300)
	at compojure.core$routes$fn__29325$f__29326.invoke(core.clj:198)
	at compojure.core$routes$fn__29325$f__29326$respond_SINGLEQUOTE___29327.invoke(core.clj:197)
	at compojure.core$make_context$fn__29357.invoke(core.clj:300)
	at compojure.core$routes$fn__29325$f__29326.invoke(core.clj:198)
	at compojure.core$routes$fn__29325$f__29326$respond_SINGLEQUOTE___29327.invoke(core.clj:197)
	at compojure.core$make_context$fn__29357.invoke(core.clj:300)
	at compojure.core$routes$fn__29325$f__29326.invoke(core.clj:198)
	at compojure.core$routes$fn__29325$f__29326$respond_SINGLEQUOTE___29327.invoke(core.clj:197)
	at compojure.core$make_context$fn__29357.invoke(core.clj:300)
	at compojure.core$routes$fn__29325$f__29326.invoke(core.clj:198)
	at compojure.core$routes$fn__29325$f__29326$respond_SINGLEQUOTE___29327.invoke(core.clj:197)
	at compojure.core$make_context$fn__29357.invoke(core.clj:300)
	at compojure.core$routes$fn__29325$f__29326.invoke(core.clj:198)
	at compojure.core$routes$fn__29325$f__29326$respond_SINGLEQUOTE___29327.invoke(core.clj:197)
	at compojure.core$make_context$fn__29357.invoke(core.clj:300)
	at compojure.core$routes$fn__29325$f__29326.invoke(core.clj:198)
	at compojure.core$routes$fn__29325$f__29326$respond_SINGLEQUOTE___29327.invoke(core.clj:197)
	at metabase.api.routes$fn__82628$fn__82631.invoke(routes.clj:64)
	at compojure.core$routes$fn__29325$f__29326.invoke(core.clj:198)
	at compojure.core$routes$fn__29325.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__82792$fn__82793.doInvoke(routes.clj:69)
	at clojure.lang.RestFn.invoke(RestFn.java:436)
	at compojure.core$routes$fn__29325$f__29326.invoke(core.clj:198)
	at compojure.core$routes$fn__29325.invoke(core.clj:200)
	at compojure.core$make_context$handler__29353.invoke(core.clj:289)
	at compojure.core$make_context$fn__29357.invoke(core.clj:299)
	at compojure.core$routes$fn__29325$f__29326.invoke(core.clj:198)
	at compojure.core$routes$fn__29325$f__29326$respond_SINGLEQUOTE___29327.invoke(core.clj:197)
	at compojure.core$wrap_route_matches$fn__29306.invoke(core.clj:153)
	at compojure.core$routes$fn__29325$f__29326.invoke(core.clj:198)
	at compojure.core$routes$fn__29325$f__29326$respond_SINGLEQUOTE___29327.invoke(core.clj:197)
	at compojure.core$wrap_route_matches$fn__29306.invoke(core.clj:153)
	at compojure.core$routes$fn__29325$f__29326.invoke(core.clj:198)
	at compojure.core$routes$fn__29325$f__29326$respond_SINGLEQUOTE___29327.invoke(core.clj:197)
	at compojure.core$wrap_route_matches$fn__29306.invoke(core.clj:153)
	at compojure.core$routes$fn__29325$f__29326.invoke(core.clj:198)
	at compojure.core$routes$fn__29325$f__29326$respond_SINGLEQUOTE___29327.invoke(core.clj:197)
	at metabase.server.routes$fn__82777$fn__82779.invoke(routes.clj:46)
	at compojure.core$routes$fn__29325$f__29326.invoke(core.clj:198)
	at compojure.core$routes$fn__29325.invoke(core.clj:200)
	at metabase.server.middleware.exceptions$catch_uncaught_exceptions$fn__79072.invoke(exceptions.clj:98)
	at metabase.server.middleware.exceptions$catch_api_exceptions$fn__79069.invoke(exceptions.clj:86)
	at metabase.server.middleware.log$log_api_call$fn__84204$fn__84205$fn__84206.invoke(log.clj:211)
	at metabase.driver.sql_jdbc.execute.diagnostic$do_with_diagnostic_info.invokeStatic(diagnostic.clj:15)
	at metabase.driver.sql_jdbc.execute.diagnostic$do_with_diagnostic_info.invoke(diagnostic.clj:9)
	at metabase.server.middleware.log$log_api_call$fn__84204$fn__84205.invoke(log.clj:203)
	at toucan.db$_do_with_call_counting.invokeStatic(db.clj:236)
	at toucan.db$_do_with_call_counting.invoke(db.clj:229)
	at metabase.server.middleware.log$log_api_call$fn__84204.invoke(log.clj:202)
	at metabase.server.middleware.browser_cookie$ensure_browser_id_cookie$fn__87101.invoke(browser_cookie.clj:38)
	at metabase.server.middleware.security$add_security_headers$fn__63926.invoke(security.clj:149)
	at metabase.server.middleware.json$wrap_json_body$fn__86232.invoke(json.clj:63)
	at metabase.server.middleware.json$wrap_streamed_json_response$fn__86250.invoke(json.clj:99)
	at metabase.server.middleware.offset_paging$handle_paging$fn__63950.invoke(offset_paging.clj:42)
	at ring.middleware.keyword_params$wrap_keyword_params$fn__87368.invoke(keyword_params.clj:55)
	at ring.middleware.params$wrap_params$fn__87387.invoke(params.clj:77)
	at metabase.server.middleware.misc$maybe_set_site_url$fn__36696.invoke(misc.clj:59)
	at metabase.server.middleware.session$reset_session_timeout$fn__48385.invoke(session.clj:394)
	at metabase.server.middleware.session$bind_current_user$fn__48368$fn__48369.invoke(session.clj:331)
	at metabase.server.middleware.session$do_with_current_user.invokeStatic(session.clj:310)
	at metabase.server.middleware.session$do_with_current_user.invoke(session.clj:299)
	at metabase.server.middleware.session$bind_current_user$fn__48368.invoke(session.clj:330)
	at metabase.server.middleware.session$wrap_current_user_info$fn__48350.invoke(session.clj:280)
	at metabase.server.middleware.session$wrap_session_id$fn__48334.invoke(session.clj:213)
	at metabase.server.middleware.auth$wrap_api_key$fn__70605.invoke(auth.clj:30)
	at ring.middleware.cookies$wrap_cookies$fn__87288.invoke(cookies.clj:216)
	at metabase.server.middleware.misc$add_content_type$fn__36679.invoke(misc.clj:27)
	at metabase.server.middleware.misc$disable_streaming_buffering$fn__36704.invoke(misc.clj:76)
	at ring.middleware.gzip$wrap_gzip$fn__87330.invoke(gzip.clj:86)
	at metabase.server.middleware.misc$bind_request$fn__36707.invoke(misc.clj:93)
	at metabase.server.middleware.ssl$redirect_to_https_middleware$fn__87117.invoke(ssl.clj:38)
	at metabase.server$async_proxy_handler$fn__83000.invoke(server.clj:73)
	at metabase.server.proxy$org.eclipse.jetty.server.handler.AbstractHandler$ff19274a.handle(Unknown Source)
	at org.eclipse.jetty.server.handler.StatisticsHandler.handle(StatisticsHandler.java:181)
	at org.eclipse.jetty.server.handler.HandlerWrapper.handle(HandlerWrapper.java:127)
	at org.eclipse.jetty.server.Server.handle(Server.java:516)
	at org.eclipse.jetty.server.HttpChannel.lambda$handle$1(HttpChannel.java:487)
	at org.eclipse.jetty.server.HttpChannel.dispatch(HttpChannel.java:732)
	at org.eclipse.jetty.server.HttpChannel.handle(HttpChannel.java:479)
	at org.eclipse.jetty.server.HttpConnection.onFillable(HttpConnection.java:277)
	at org.eclipse.jetty.io.AbstractConnection$ReadCallback.succeeded(AbstractConnection.java:311)
	at org.eclipse.jetty.io.FillInterest.fillable(FillInterest.java:105)
	at org.eclipse.jetty.io.ChannelEndPoint$1.run(ChannelEndPoint.java:104)
	at org.eclipse.jetty.util.thread.strategy.EatWhatYouKill.runTask(EatWhatYouKill.java:338)
	at org.eclipse.jetty.util.thread.strategy.EatWhatYouKill.doProduce(EatWhatYouKill.java:315)
	at org.eclipse.jetty.util.thread.strategy.EatWhatYouKill.tryProduce(EatWhatYouKill.java:173)
	at org.eclipse.jetty.util.thread.strategy.EatWhatYouKill.run(EatWhatYouKill.java:131)
	at org.eclipse.jetty.util.thread.ReservedThreadExecutor$ReservedThread.run(ReservedThreadExecutor.java:409)
	at org.eclipse.jetty.util.thread.QueuedThreadPool.runJob(QueuedThreadPool.java:883)
	at org.eclipse.jetty.util.thread.QueuedThreadPool$Runner.run(QueuedThreadPool.java:1034)
	at java.base/java.lang.Thread.run(Unknown Source)
[8b950757-20d8-43c5-afd4-898bacb5e07c] 2023-03-02T13:56:45+01:00 DEBUG metabase.server.middleware.log POST /api/pulse/test 200 1,5 s (31 DB-aanroepen) Applicatieverbindingen met DB: 0/15 Jetty-threads: 4/50 (1 wachtend, 0 in wachtrij) (135 totaal actieve threads) Query's actief nu: 0 (0 in wachtrij)
[8b950757-20d8-43c5-afd4-898bacb5e07c] 2023-03-02T14:00:00+01:00 INFO metabase.task.send-pulses Geplande pulsen verzenden ...
[8b950757-20d8-43c5-afd4-898bacb5e07c] 2023-03-02T14:05:35+01:00 DEBUG metabase.server.middleware.log GET /api/user/current 200 11,1 ms (10 DB-aanroepen) Applicatieverbindingen met DB: 0/15 Jetty-threads: 4/50 (3 wachtend, 0 in wachtrij) (132 totaal actieve threads) Query's actief nu: 0 (0 in wachtrij)
[8b950757-20d8-43c5-afd4-898bacb5e07c] 2023-03-02T14:05:35+01:00 DEBUG metabase.server.middleware.log GET /api/session/properties 200 17,0 ms (4 DB-aanroepen) Applicatieverbindingen met DB: 0/15 Jetty-threads: 5/50 (2 wachtend, 0 in wachtrij) (132 totaal actieve threads) Query's actief nu: 0 (0 in wachtrij)
[8b950757-20d8-43c5-afd4-898bacb5e07c] 2023-03-02T14:05:39+01:00 DEBUG metabase.server.middleware.log GET /api/collection/root 200 3,2 ms (2 DB-aanroepen) Applicatieverbindingen met DB: 0/15 Jetty-threads: 4/50 (2 wachtend, 0 in wachtrij) (133 totaal actieve threads) Query's actief nu: 0 (0 in wachtrij)
[8b950757-20d8-43c5-afd4-898bacb5e07c] 2023-03-02T14:05:39+01:00 DEBUG metabase.server.middleware.log GET /api/collection/tree 200 18,7 ms (19 DB-aanroepen) Applicatieverbindingen met DB: 0/15 Jetty-threads: 4/50 (2 wachtend, 0 in wachtrij) (133 totaal actieve threads) Query's actief nu: 0 (0 in wachtrij)
[8b950757-20d8-43c5-afd4-898bacb5e07c] 2023-03-02T14:05:39+01:00 DEBUG metabase.server.middleware.log GET /api/bookmark 200 3,2 ms (1 DB-aanroepen) Applicatieverbindingen met DB: 0/15 Jetty-threads: 4/50 (2 wachtend, 0 in wachtrij) (133 totaal actieve threads) Query's actief nu: 0 (0 in wachtrij)
[8b950757-20d8-43c5-afd4-898bacb5e07c] 2023-03-02T14:05:39+01:00 DEBUG metabase.server.middleware.log GET /api/database 200 13,3 ms (3 DB-aanroepen) Applicatieverbindingen met DB: 0/15 Jetty-threads: 6/50 (1 wachtend, 0 in wachtrij) (133 totaal actieve threads) Query's actief nu: 0 (0 in wachtrij)
[8b950757-20d8-43c5-afd4-898bacb5e07c] 2023-03-02T14:05:39+01:00 DEBUG metabase.server.middleware.log GET /api/activity/recent_views 200 23,4 ms (8 DB-aanroepen) Applicatieverbindingen met DB: 1/15 Jetty-threads: 6/50 (1 wachtend, 0 in wachtrij) (133 totaal actieve threads) Query's actief nu: 0 (0 in wachtrij)
[8b950757-20d8-43c5-afd4-898bacb5e07c] 2023-03-02T14:05:39+01:00 DEBUG metabase.server.middleware.log GET /api/activity/popular_items 200 27,3 ms (10 DB-aanroepen) Applicatieverbindingen met DB: 0/15 Jetty-threads: 4/50 (1 wachtend, 0 in wachtrij) (133 totaal actieve threads) Query's actief nu: 0 (0 in wachtrij)
[8b950757-20d8-43c5-afd4-898bacb5e07c] 2023-03-02T14:05:44+01:00 DEBUG metabase.server.middleware.log GET /api/session/properties 200 13,2 ms (4 DB-aanroepen) Applicatieverbindingen met DB: 0/15 Jetty-threads: 5/50 (1 wachtend, 0 in wachtrij) (133 totaal actieve threads) Query's actief nu: 0 (0 in wachtrij)
[8b950757-20d8-43c5-afd4-898bacb5e07c] 2023-03-02T14:05:44+01:00 DEBUG metabase.server.middleware.log GET /api/setting 200 18,3 ms (3 DB-aanroepen) Applicatieverbindingen met DB: 0/15 Jetty-threads: 5/50 (1 wachtend, 0 in wachtrij) (133 totaal actieve threads) Query's actief nu: 0 (0 in wachtrij)
[8b950757-20d8-43c5-afd4-898bacb5e07c] 2023-03-02T14:05:44+01:00 DEBUG metabase.server.middleware.log GET /api/setup/admin_checklist 200 4,1 ms (11 DB-aanroepen) Applicatieverbindingen met DB: 0/15 Jetty-threads: 4/50 (1 wachtend, 0 in wachtrij) (135 totaal actieve threads) Query's actief nu: 0 (0 in wachtrij)
[8b950757-20d8-43c5-afd4-898bacb5e07c] 2023-03-02T14:05:45+01:00 DEBUG metabase.server.middleware.log GET /api/util/bug_report_details 200 3,3 ms (1 DB-aanroepen) Applicatieverbindingen met DB: 0/15 Jetty-threads: 4/50 (1 wachtend, 0 in wachtrij) (135 totaal actieve threads) Query's actief nu: 0 (0 in wachtrij)
[8b950757-20d8-43c5-afd4-898bacb5e07c] 2023-03-02T14:06:00+01:00 INFO metabase.task.sync-databases Synchronisatietaak starten voor Database 6.
[8b950757-20d8-43c5-afd4-898bacb5e07c] 2023-03-02T14:06:00+01:00 INFO metabase.sync.util STARTING: Sync metadata for postgres Database 6 'RecycSoft Opwijk'
[8b950757-20d8-43c5-afd4-898bacb5e07c] 2023-03-02T14:06:00+01:00 INFO metabase.sync.util STARTING: stap "sync-timezone" voor postgres Database 6 'RecycSoft Opwijk'
[8b950757-20d8-43c5-afd4-898bacb5e07c] 2023-03-02T14:06:00+01:00 INFO metabase.sync.util FINISHED: stap "sync-timezone" voor postgres Database 6 'RecycSoft Opwijk' (2,0 ms)
[8b950757-20d8-43c5-afd4-898bacb5e07c] 2023-03-02T14:06:00+01:00 INFO metabase.sync.util STARTING: stap "sync-tables" voor postgres Database 6 'RecycSoft Opwijk'
[8b950757-20d8-43c5-afd4-898bacb5e07c] 2023-03-02T14:06:00+01:00 INFO metabase.sync.util FINISHED: stap "sync-tables" voor postgres Database 6 'RecycSoft Opwijk' (3,5 ms)
[8b950757-20d8-43c5-afd4-898bacb5e07c] 2023-03-02T14:06:00+01:00 INFO metabase.sync.util STARTING: stap "sync-fields" voor postgres Database 6 'RecycSoft Opwijk'
[8b950757-20d8-43c5-afd4-898bacb5e07c] 2023-03-02T14:06:00+01:00 INFO metabase.sync.util FINISHED: stap "sync-fields" voor postgres Database 6 'RecycSoft Opwijk' (893,3 ms)
[8b950757-20d8-43c5-afd4-898bacb5e07c] 2023-03-02T14:06:00+01:00 INFO metabase.sync.util STARTING: stap "sync-fks" voor postgres Database 6 'RecycSoft Opwijk'
[8b950757-20d8-43c5-afd4-898bacb5e07c] 2023-03-02T14:06:01+01:00 INFO metabase.sync.util FINISHED: stap "sync-fks" voor postgres Database 6 'RecycSoft Opwijk' (187,2 ms)
[8b950757-20d8-43c5-afd4-898bacb5e07c] 2023-03-02T14:06:01+01:00 INFO metabase.sync.util STARTING: stap "sync-metabase-metadata" voor postgres Database 6 'RecycSoft Opwijk'
[8b950757-20d8-43c5-afd4-898bacb5e07c] 2023-03-02T14:06:01+01:00 INFO metabase.sync.util FINISHED: stap "sync-metabase-metadata" voor postgres Database 6 'RecycSoft Opwijk' (597,8 µs)
[8b950757-20d8-43c5-afd4-898bacb5e07c] 2023-03-02T14:06:01+01:00 INFO metabase.sync.util FINISHED: Sync metadata for postgres Database 6 'RecycSoft Opwijk' (1,4 s)
[8b950757-20d8-43c5-afd4-898bacb5e07c] 2023-03-02T14:06:01+01:00 INFO metabase.sync.util STARTING: Analyze data for postgres Database 6 'RecycSoft Opwijk'
[8b950757-20d8-43c5-afd4-898bacb5e07c] 2023-03-02T14:06:01+01:00 INFO metabase.sync.util STARTING: stap "fingerprint-fields" voor postgres Database 6 'RecycSoft Opwijk'
[8b950757-20d8-43c5-afd4-898bacb5e07c] 2023-03-02T14:06:01+01:00 INFO metabase.sync.analyze fingerprint-fields Analyzed [*****·············································]    10% Tabel 551 "public.person"
[8b950757-20d8-43c5-afd4-898bacb5e07c] 2023-03-02T14:06:01+01:00 INFO metabase.sync.analyze fingerprint-fields Analyzed [**********········································]    21% Tabel 606 "public.badge"
[8b950757-20d8-43c5-afd4-898bacb5e07c] 2023-03-02T14:06:01+01:00 INFO metabase.sync.analyze fingerprint-fields Analyzed [***************···································]    31% Tabel 520 "public.registrationweigh"
[8b950757-20d8-43c5-afd4-898bacb5e07c] 2023-03-02T14:06:01+01:00 INFO metabase.sync.util FINISHED: stap "fingerprint-fields" voor postgres Database 6 'RecycSoft Opwijk' (128,1 ms)
[8b950757-20d8-43c5-afd4-898bacb5e07c] 2023-03-02T14:06:01+01:00 INFO metabase.sync.util STARTING: stap "classify-fields" voor postgres Database 6 'RecycSoft Opwijk'
[8b950757-20d8-43c5-afd4-898bacb5e07c] 2023-03-02T14:06:01+01:00 INFO metabase.sync.analyze classify-fields Analyzed [********************······························]    42% Tabel 559 "public.mutatie"
[8b950757-20d8-43c5-afd4-898bacb5e07c] 2023-03-02T14:06:01+01:00 INFO metabase.sync.analyze classify-fields Analyzed [**************************························]    52% Tabel 610 "public.wastegroup"
[8b950757-20d8-43c5-afd4-898bacb5e07c] 2023-03-02T14:06:01+01:00 INFO metabase.sync.analyze classify-fields Analyzed [*******************************···················]    63% Tabel 568 "public.registrationpayment"
[8b950757-20d8-43c5-afd4-898bacb5e07c] 2023-03-02T14:06:01+01:00 INFO metabase.sync.util FINISHED: stap "classify-fields" voor postgres Database 6 'RecycSoft Opwijk' (14,3 ms)
[8b950757-20d8-43c5-afd4-898bacb5e07c] 2023-03-02T14:06:01+01:00 INFO metabase.sync.util STARTING: stap "classify-tables" voor postgres Database 6 'RecycSoft Opwijk'
[8b950757-20d8-43c5-afd4-898bacb5e07c] 2023-03-02T14:06:01+01:00 INFO metabase.sync.analyze classify-tables Analyzed [************************************··············]    73% Tabel 566 "public.saldocorrection"
[8b950757-20d8-43c5-afd4-898bacb5e07c] 2023-03-02T14:06:01+01:00 INFO metabase.sync.analyze classify-tables Analyzed [*****************************************·········]    84% Tabel 616 "public.familydetail"
[8b950757-20d8-43c5-afd4-898bacb5e07c] 2023-03-02T14:06:01+01:00 INFO metabase.sync.analyze classify-tables Analyzed [***********************************************···]    94% Tabel 611 "public.family"
[8b950757-20d8-43c5-afd4-898bacb5e07c] 2023-03-02T14:06:01+01:00 INFO metabase.sync.util FINISHED: stap "classify-tables" voor postgres Database 6 'RecycSoft Opwijk' (19,6 ms)
[8b950757-20d8-43c5-afd4-898bacb5e07c] 2023-03-02T14:06:01+01:00 INFO metabase.sync.util FINISHED: Analyze data for postgres Database 6 'RecycSoft Opwijk' (359,6 ms)
5

I see that it needs the following permissions:

or that's what metabase tells you in the logs. It only has /db/2/schema/ which is a table permission I think

6

How can I see what exactly that is?
The users is having access to every tables in those databases and see also see those reports in the dashboard.
It is only in the email the report is not showing.
Also other reports are showing in the mail, it is only the SQL based report that is not showing.

7

Could it be relate to the fact that "Native query editing" is on "No"?
Scherm­afbeelding 2023-03-02 om 16.19.50

8

Ok got confirmation from the client that putting that on Yes fixed it.
Allthough i don't think it should work like that.

9

Nope, you're absolutely right, you found a bug (a big one): "Pulse card query error" on user without native SQL permissions · Issue #28947 · metabase/metabase · GitHub

10

Thanks for the headsup.
Will follow it up so once it's fixed i can turn it back off again.