Dashboard Failing to Interpret Filtered Question

Get Help
1

I have a sql question which is using a couple non-sql models and a required sql variable to calculate a single final number. That question has been placed on a dashboard which has a filter. That filter sets the sql variable's value.

When I enter a valid value into the filter, the question throws an error, seen here:
49%20PM

If I click on the question title, I am taken to the sql question itself, where the variable has been set and the data appears as expected.

43%20PM
43%20PM1905×586 24.2 KB

Why would the dashboard throw an error like this when clearly the question functions as expected?

Alternatively, how might I get some error logs at the dashboard level?

2

Hi @wj4
Post "Diagnostic Info" from Admin > Troubleshooting.
And the stacktrace error from Admin > Troubleshooting > Logs.

3

@flamber

Diagnostics:

      {"browser-info": {
        "language": "en-US",
        "platform": "MacIntel",
        "userAgent": "Mozilla/5.0 (Macintosh; Intel Mac OS X 10_15_7) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/102.0.0.0 Safari/537.36",
        "vendor": "Google Inc."
      },
      "system-info": {
        "file.encoding": "UTF-8",
        "java.runtime.name": "OpenJDK Runtime Environment",
        "java.runtime.version": "11.0.14.1+1",
        "java.vendor": "Eclipse Adoptium",
        "java.vendor.url": "https://adoptium.net/",
        "java.version": "11.0.14.1",
        "java.vm.name": "OpenJDK 64-Bit Server VM",
        "java.vm.version": "11.0.14.1+1",
        "os.name": "Linux",
        "os.version": "5.10.102-99.473.amzn2.x86_64",
        "user.language": "en",
        "user.timezone": "Canada/Atlantic"
      },
      "metabase-info": {
        "databases": [
          "h2",
          "postgres"
        ],
        "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": "2022-03-23",
          "tag": "v0.42.3",
          "branch": "release-x.42.x",
          "hash": "33fb268"
        },
        "settings": {
          "report-timezone": null
        }
      }
    }

Stack Trace Error:

    [086bc1f3-eb9c-4cc2-9892-17ae354fba3a] 2022-06-22T15:45:21-04:00 DEBUG metabase.server.middleware.log POST /api/dashboard/34/dashcard/13/card/59/query 202 [ASYNC: completed] 418.7 ms (41 DB calls) App DB connections: 0/15 Jetty threads: 2/50 (6 idle, 0 queued) (113 total active threads) Queries in flight: 1 (0 queued); postgres DB 35 connections: 0/4 (0 threads blocked)
    [086bc1f3-eb9c-4cc2-9892-17ae354fba3a] 2022-06-22T15:45:21-04:00 DEBUG metabase.server.middleware.log POST /api/dashboard/34/dashcard/24/card/66/query 202 [ASYNC: completed] 499.2 ms (49 DB calls) App DB connections: 0/15 Jetty threads: 2/50 (6 idle, 0 queued) (113 total active threads) Queries in flight: 0 (0 queued); postgres DB 35 connections: 0/4 (0 threads blocked)
    [086bc1f3-eb9c-4cc2-9892-17ae354fba3a] 2022-06-22T15:45:40-04:00 DEBUG metabase.server.middleware.log GET /api/search 200 5.5 ms (3 DB calls) App DB connections: 0/15 Jetty threads: 3/50 (6 idle, 0 queued) (113 total active threads) Queries in flight: 0 (0 queued)
    [086bc1f3-eb9c-4cc2-9892-17ae354fba3a] 2022-06-22T15:45:47-04:00 DEBUG metabase.server.middleware.log GET /api/card/57 200 19.5 ms (9 DB calls) App DB connections: 0/15 Jetty threads: 4/50 (5 idle, 0 queued) (113 total active threads) Queries in flight: 0 (0 queued)
    [086bc1f3-eb9c-4cc2-9892-17ae354fba3a] 2022-06-22T15:45:47-04:00 DEBUG metabase.server.middleware.log GET /api/card/56 200 29.3 ms (9 DB calls) App DB connections: 0/15 Jetty threads: 4/50 (5 idle, 0 queued) (113 total active threads) Queries in flight: 0 (0 queued)
    [086bc1f3-eb9c-4cc2-9892-17ae354fba3a] 2022-06-22T15:45:54-04:00 ERROR metabase.query-processor.middleware.catch-exceptions Error processing query: null
    {:database_id 35,
     :started_at #t "2022-06-22T16:45:53.971015-03:00[Canada/Atlantic]",
     :via
     [{:status :failed,
       :class clojure.lang.ExceptionInfo,
       :error "Error executing query: ERROR: syntax error at or near \"where\"\n  Position: 120",
       :stacktrace
       ["--> driver.sql_jdbc.execute$execute_reducible_query$fn__53301.invoke(execute.clj:504)"
        "driver.sql_jdbc.execute$execute_reducible_query.invokeStatic(execute.clj:501)"
        "driver.sql_jdbc.execute$execute_reducible_query.invoke(execute.clj:487)"
        "driver.sql_jdbc.execute$execute_reducible_query.invokeStatic(execute.clj:496)"
        "driver.sql_jdbc.execute$execute_reducible_query.invoke(execute.clj:487)"
        "driver.sql_jdbc$fn__82002.invokeStatic(sql_jdbc.clj:54)"
        "driver.sql_jdbc$fn__82002.invoke(sql_jdbc.clj:52)"
        "query_processor.context$executef.invokeStatic(context.clj:59)"
        "query_processor.context$executef.invoke(context.clj:48)"
        "query_processor.context.default$default_runf.invokeStatic(default.clj:68)"
        "query_processor.context.default$default_runf.invoke(default.clj:66)"
        "query_processor.context$runf.invokeStatic(context.clj:45)"
        "query_processor.context$runf.invoke(context.clj:39)"
        "query_processor.reducible$pivot.invokeStatic(reducible.clj:34)"
        "query_processor.reducible$pivot.invoke(reducible.clj:31)"
        "query_processor.middleware.mbql_to_native$mbql__GT_native$fn__49655.invoke(mbql_to_native.clj:25)"
        "query_processor.middleware.check_features$check_features$fn__50401.invoke(check_features.clj:42)"
        "query_processor.middleware.limit$limit$fn__47991.invoke(limit.clj:37)"
        "query_processor.middleware.cache$maybe_return_cached_results$fn__50784.invoke(cache.clj:204)"
        "query_processor.middleware.optimize_temporal_filters$optimize_temporal_filters$fn__51848.invoke(optimize_temporal_filters.clj:204)"
        "query_processor.middleware.validate_temporal_bucketing$validate_temporal_bucketing$fn__51892.invoke(validate_temporal_bucketing.clj:50)"
        "query_processor.middleware.auto_parse_filter_values$auto_parse_filter_values$fn__49712.invoke(auto_parse_filter_values.clj:43)"
        "query_processor.middleware.wrap_value_literals$wrap_value_literals$fn__39780.invoke(wrap_value_literals.clj:161)"
        "query_processor.middleware.annotate$add_column_info$fn__44546.invoke(annotate.clj:659)"
        "query_processor.middleware.permissions$check_query_permissions$fn__46288.invoke(permissions.clj:108)"
        "query_processor.middleware.pre_alias_aggregations$pre_alias_aggregations$fn__51006.invoke(pre_alias_aggregations.clj:40)"
        "query_processor.middleware.cumulative_aggregations$handle_cumulative_aggregations$fn__46684.invoke(cumulative_aggregations.clj:60)"
        "query_processor.middleware.visualization_settings$update_viz_settings$fn__46622.invoke(visualization_settings.clj:63)"
        "query_processor.middleware.escape_join_aliases$escape_join_aliases_middleware$fn__48032.invoke(escape_join_aliases.clj:64)"
        "query_processor.middleware.fix_bad_references$fix_bad_references_middleware$fn__50971.invoke(fix_bad_references.clj:91)"
        "query_processor.middleware.resolve_joined_fields$resolve_joined_fields$fn__47569.invoke(resolve_joined_fields.clj:111)"
        "query_processor.middleware.resolve_joins$resolve_joins$fn__51618.invoke(resolve_joins.clj:178)"
        "query_processor.middleware.add_implicit_joins$add_implicit_joins$fn__51160.invoke(add_implicit_joins.clj:246)"
        "query_processor.middleware.large_int_id$convert_id_to_string$fn__47588.invoke(large_int_id.clj:59)"
        "query_processor.middleware.format_rows$format_rows$fn__51212.invoke(format_rows.clj:74)"
        "query_processor.middleware.add_default_temporal_unit$add_default_temporal_unit$fn__46956.invoke(add_default_temporal_unit.clj:23)"
        "query_processor.middleware.desugar$desugar$fn__46595.invoke(desugar.clj:21)"
        "query_processor.middleware.binning$update_binning_strategy$fn__39509.invoke(binning.clj:232)"
        "query_processor.middleware.resolve_fields$resolve_fields$fn__45930.invoke(resolve_fields.clj:34)"
        "query_processor.middleware.add_dimension_projections$add_remapping$fn__50338.invoke(add_dimension_projections.clj:487)"
        "query_processor.middleware.add_implicit_clauses$add_implicit_clauses$fn__50632.invoke(add_implicit_clauses.clj:164)"
        "query_processor.middleware.upgrade_field_literals$upgrade_field_literals$fn__47976.invoke(upgrade_field_literals.clj:117)"
        "query_processor.middleware.add_source_metadata$add_source_metadata_for_source_queries$fn__47333.invoke(add_source_metadata.clj:125)"
        "query_processor.middleware.reconcile_breakout_and_order_by_bucketing$reconcile_breakout_and_order_by_bucketing$fn__50883.invoke(reconcile_breakout_and_order_by_bucketing.clj:100)"
        "query_processor.middleware.auto_bucket_datetimes$auto_bucket_datetimes$fn__48970.invoke(auto_bucket_datetimes.clj:147)"
        "query_processor.middleware.resolve_source_table$resolve_source_tables$fn__45911.invoke(resolve_source_table.clj:45)"
        "query_processor.middleware.parameters$substitute_parameters$fn__48624.invoke(parameters.clj:109)"
        "query_processor.middleware.resolve_referenced$resolve_referenced_card_resources$fn__45984.invoke(resolve_referenced.clj:79)"
        "query_processor.middleware.expand_macros$expand_macros$fn__52276.invoke(expand_macros.clj:184)"
        "query_processor.middleware.add_timezone_info$add_timezone_info$fn__48404.invoke(add_timezone_info.clj:15)"
        "query_processor.middleware.splice_params_in_response$splice_params_in_response$fn__51227.invoke(splice_params_in_response.clj:32)"
        "query_processor.middleware.resolve_database_and_driver$resolve_database_and_driver$fn__50643$fn__50648.invoke(resolve_database_and_driver.clj:35)"
        "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__50643.invoke(resolve_database_and_driver.clj:34)"
        "query_processor.middleware.fetch_source_query$resolve_card_id_source_tables$fn__46530.invoke(fetch_source_query.clj:286)"
        "query_processor.middleware.store$initialize_store$fn__46721$fn__46722.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__46721.invoke(store.clj:10)"
        "query_processor.middleware.validate$validate_query$fn__50978.invoke(validate.clj:10)"
        "query_processor.middleware.normalize_query$normalize$fn__50985.invoke(normalize_query.clj:22)"
        "query_processor.middleware.add_rows_truncated$add_rows_truncated$fn__48350.invoke(add_rows_truncated.clj:35)"
        "query_processor.middleware.results_metadata$record_and_return_metadata_BANG_$fn__49641.invoke(results_metadata.clj:82)"
        "query_processor.middleware.constraints$add_default_userland_constraints$fn__48368.invoke(constraints.clj:42)"
        "query_processor.middleware.process_userland_query$process_userland_query$fn__50919.invoke(process_userland_query.clj:146)"
        "query_processor.middleware.catch_exceptions$catch_exceptions$fn__51307.invoke(catch_exceptions.clj:169)"
        "query_processor.reducible$async_qp$qp_STAR___43282$thunk__43283.invoke(reducible.clj:103)"
        "query_processor.reducible$async_qp$qp_STAR___43282.invoke(reducible.clj:109)"
        "query_processor.reducible$sync_qp$qp_STAR___43291$fn__43294.invoke(reducible.clj:135)"
        "query_processor.reducible$sync_qp$qp_STAR___43291.invoke(reducible.clj:134)"
        "query_processor$process_userland_query.invokeStatic(query_processor.clj:247)"
        "query_processor$process_userland_query.doInvoke(query_processor.clj:243)"
        "query_processor$fn__52324$process_query_and_save_execution_BANG___52333$fn__52336.invoke(query_processor.clj:258)"
        "query_processor$fn__52324$process_query_and_save_execution_BANG___52333.invoke(query_processor.clj:251)"
        "query_processor$fn__52368$process_query_and_save_with_max_results_constraints_BANG___52377$fn__52380.invoke(query_processor.clj:270)"
        "query_processor$fn__52368$process_query_and_save_with_max_results_constraints_BANG___52377.invoke(query_processor.clj:263)"
        "api.dataset$run_query_async$fn__65303.invoke(dataset.clj:69)"
        "query_processor.streaming$streaming_response_STAR_$fn__38418$fn__38419.invoke(streaming.clj:162)"
        "query_processor.streaming$streaming_response_STAR_$fn__38418.invoke(streaming.clj:161)"
        "async.streaming_response$do_f_STAR_.invokeStatic(streaming_response.clj:65)"
        "async.streaming_response$do_f_STAR_.invoke(streaming_response.clj:63)"
        "async.streaming_response$do_f_async$task__26888.invoke(streaming_response.clj:84)"],
       :error_type :invalid-query,
       :ex-data
       {:sql
        "-- Metabase:: userID: 33 queryType: native queryHash: b625efc0dcaaae44e6aa096614618832f3ea45567df678dab32ab6e0dfe7b409\nwhere orgs.id = registered.\"Member Group - Group__id\"",
        :params nil,
        :type :invalid-query}}],
     :state "42601",
     :error_type :invalid-query,
     :json_query
     {:type "native",
      :native
      {:query "\nwhere orgs.id = registered.\"Member Group - Group__id\" [[and orgs.name = {{organization}}]]",
       :template-tags
       {:organization
        {:id "c47b43af-b2cb-0da4-fc90-4b92538530f6",
         :name "organization",
         :display-name "Organization",
         :type "text",
         :required false}}},
      :database 35,
      :parameters [],
      :middleware {:js-int-to-string? true, :add-default-userland-constraints? true}},
     :status :failed,
     :class org.postgresql.util.PSQLException,
     :stacktrace
     ["org.postgresql.core.v3.QueryExecutorImpl.receiveErrorResponse(QueryExecutorImpl.java:2552)"
      "org.postgresql.core.v3.QueryExecutorImpl.processResults(QueryExecutorImpl.java:2284)"
      "org.postgresql.core.v3.QueryExecutorImpl.execute(QueryExecutorImpl.java:322)"
      "org.postgresql.jdbc.PgStatement.executeInternal(PgStatement.java:481)"
      "org.postgresql.jdbc.PgStatement.execute(PgStatement.java:401)"
      "org.postgresql.jdbc.PgStatement.executeWithFlags(PgStatement.java:322)"
      "org.postgresql.jdbc.PgStatement.executeCachedSql(PgStatement.java:308)"
      "org.postgresql.jdbc.PgStatement.executeWithFlags(PgStatement.java:284)"
      "org.postgresql.jdbc.PgStatement.execute(PgStatement.java:279)"
      "com.mchange.v2.c3p0.impl.NewProxyStatement.execute(NewProxyStatement.java:75)"
      "--> driver.sql_jdbc.execute$fn__53221.invokeStatic(execute.clj:368)"
      "driver.sql_jdbc.execute$fn__53221.invoke(execute.clj:366)"
      "driver.sql_jdbc.execute$execute_statement_or_prepared_statement_BANG_.invokeStatic(execute.clj:376)"
      "driver.sql_jdbc.execute$execute_statement_or_prepared_statement_BANG_.invoke(execute.clj:373)"
      "driver.sql_jdbc.execute$execute_reducible_query$fn__53301.invoke(execute.clj:502)"
      "driver.sql_jdbc.execute$execute_reducible_query.invokeStatic(execute.clj:501)"
      "driver.sql_jdbc.execute$execute_reducible_query.invoke(execute.clj:487)"
      "driver.sql_jdbc.execute$execute_reducible_query.invokeStatic(execute.clj:496)"
      "driver.sql_jdbc.execute$execute_reducible_query.invoke(execute.clj:487)"
      "driver.sql_jdbc$fn__82002.invokeStatic(sql_jdbc.clj:54)"
      "driver.sql_jdbc$fn__82002.invoke(sql_jdbc.clj:52)"
      "query_processor.context$executef.invokeStatic(context.clj:59)"
      "query_processor.context$executef.invoke(context.clj:48)"
      "query_processor.context.default$default_runf.invokeStatic(default.clj:68)"
      "query_processor.context.default$default_runf.invoke(default.clj:66)"
      "query_processor.context$runf.invokeStatic(context.clj:45)"
      "query_processor.context$runf.invoke(context.clj:39)"
      "query_processor.reducible$pivot.invokeStatic(reducible.clj:34)"
      "query_processor.reducible$pivot.invoke(reducible.clj:31)"
      "query_processor.middleware.mbql_to_native$mbql__GT_native$fn__49655.invoke(mbql_to_native.clj:25)"
      "query_processor.middleware.check_features$check_features$fn__50401.invoke(check_features.clj:42)"
      "query_processor.middleware.limit$limit$fn__47991.invoke(limit.clj:37)"
      "query_processor.middleware.cache$maybe_return_cached_results$fn__50784.invoke(cache.clj:204)"
      "query_processor.middleware.optimize_temporal_filters$optimize_temporal_filters$fn__51848.invoke(optimize_temporal_filters.clj:204)"
      "query_processor.middleware.validate_temporal_bucketing$validate_temporal_bucketing$fn__51892.invoke(validate_temporal_bucketing.clj:50)"
      "query_processor.middleware.auto_parse_filter_values$auto_parse_filter_values$fn__49712.invoke(auto_parse_filter_values.clj:43)"
      "query_processor.middleware.wrap_value_literals$wrap_value_literals$fn__39780.invoke(wrap_value_literals.clj:161)"
      "query_processor.middleware.annotate$add_column_info$fn__44546.invoke(annotate.clj:659)"
      "query_processor.middleware.permissions$check_query_permissions$fn__46288.invoke(permissions.clj:108)"
      "query_processor.middleware.pre_alias_aggregations$pre_alias_aggregations$fn__51006.invoke(pre_alias_aggregations.clj:40)"
      "query_processor.middleware.cumulative_aggregations$handle_cumulative_aggregations$fn__46684.invoke(cumulative_aggregations.clj:60)"
      "query_processor.middleware.visualization_settings$update_viz_settings$fn__46622.invoke(visualization_settings.clj:63)"
      "query_processor.middleware.escape_join_aliases$escape_join_aliases_middleware$fn__48032.invoke(escape_join_aliases.clj:64)"
      "query_processor.middleware.fix_bad_references$fix_bad_references_middleware$fn__50971.invoke(fix_bad_references.clj:91)"
      "query_processor.middleware.resolve_joined_fields$resolve_joined_fields$fn__47569.invoke(resolve_joined_fields.clj:111)"
      "query_processor.middleware.resolve_joins$resolve_joins$fn__51618.invoke(resolve_joins.clj:178)"
      "query_processor.middleware.add_implicit_joins$add_implicit_joins$fn__51160.invoke(add_implicit_joins.clj:246)"
      "query_processor.middleware.large_int_id$convert_id_to_string$fn__47588.invoke(large_int_id.clj:59)"
      "query_processor.middleware.format_rows$format_rows$fn__51212.invoke(format_rows.clj:74)"
      "query_processor.middleware.add_default_temporal_unit$add_default_temporal_unit$fn__46956.invoke(add_default_temporal_unit.clj:23)"
      "query_processor.middleware.desugar$desugar$fn__46595.invoke(desugar.clj:21)"
      "query_processor.middleware.binning$update_binning_strategy$fn__39509.invoke(binning.clj:232)"
      "query_processor.middleware.resolve_fields$resolve_fields$fn__45930.invoke(resolve_fields.clj:34)"
      "query_processor.middleware.add_dimension_projections$add_remapping$fn__50338.invoke(add_dimension_projections.clj:487)"
      "query_processor.middleware.add_implicit_clauses$add_implicit_clauses$fn__50632.invoke(add_implicit_clauses.clj:164)"
      "query_processor.middleware.upgrade_field_literals$upgrade_field_literals$fn__47976.invoke(upgrade_field_literals.clj:117)"
      "query_processor.middleware.add_source_metadata$add_source_metadata_for_source_queries$fn__47333.invoke(add_source_metadata.clj:125)"
      "query_processor.middleware.reconcile_breakout_and_order_by_bucketing$reconcile_breakout_and_order_by_bucketing$fn__50883.invoke(reconcile_breakout_and_order_by_bucketing.clj:100)"
      "query_processor.middleware.auto_bucket_datetimes$auto_bucket_datetimes$fn__48970.invoke(auto_bucket_datetimes.clj:147)"
      "query_processor.middleware.resolve_source_table$resolve_source_tables$fn__45911.invoke(resolve_source_table.clj:45)"
      "query_processor.middleware.parameters$substitute_parameters$fn__48624.invoke(parameters.clj:109)"
      "query_processor.middleware.resolve_referenced$resolve_referenced_card_resources$fn__45984.invoke(resolve_referenced.clj:79)"
      "query_processor.middleware.expand_macros$expand_macros$fn__52276.invoke(expand_macros.clj:184)"
      "query_processor.middleware.add_timezone_info$add_timezone_info$fn__48404.invoke(add_timezone_info.clj:15)"
      "query_processor.middleware.splice_params_in_response$splice_params_in_response$fn__51227.invoke(splice_params_in_response.clj:32)"
      "query_processor.middleware.resolve_database_and_driver$resolve_database_and_driver$fn__50643$fn__50648.invoke(resolve_database_and_driver.clj:35)"
      "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__50643.invoke(resolve_database_and_driver.clj:34)"
      "query_processor.middleware.fetch_source_query$resolve_card_id_source_tables$fn__46530.invoke(fetch_source_query.clj:286)"
      "query_processor.middleware.store$initialize_store$fn__46721$fn__46722.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__46721.invoke(store.clj:10)"
      "query_processor.middleware.validate$validate_query$fn__50978.invoke(validate.clj:10)"
      "query_processor.middleware.normalize_query$normalize$fn__50985.invoke(normalize_query.clj:22)"
      "query_processor.middleware.add_rows_truncated$add_rows_truncated$fn__48350.invoke(add_rows_truncated.clj:35)"
      "query_processor.middleware.results_metadata$record_and_return_metadata_BANG_$fn__49641.invoke(results_metadata.clj:82)"
      "query_processor.middleware.constraints$add_default_userland_constraints$fn__48368.invoke(constraints.clj:42)"
      "query_processor.middleware.process_userland_query$process_userland_query$fn__50919.invoke(process_userland_query.clj:146)"
      "query_processor.middleware.catch_exceptions$catch_exceptions$fn__51307.invoke(catch_exceptions.clj:169)"
      "query_processor.reducible$async_qp$qp_STAR___43282$thunk__43283.invoke(reducible.clj:103)"
      "query_processor.reducible$async_qp$qp_STAR___43282.invoke(reducible.clj:109)"
      "query_processor.reducible$sync_qp$qp_STAR___43291$fn__43294.invoke(reducible.clj:135)"
      "query_processor.reducible$sync_qp$qp_STAR___43291.invoke(reducible.clj:134)"
      "query_processor$process_userland_query.invokeStatic(query_processor.clj:247)"
      "query_processor$process_userland_query.doInvoke(query_processor.clj:243)"
      "query_processor$fn__52324$process_query_and_save_execution_BANG___52333$fn__52336.invoke(query_processor.clj:258)"
      "query_processor$fn__52324$process_query_and_save_execution_BANG___52333.invoke(query_processor.clj:251)"
      "query_processor$fn__52368$process_query_and_save_with_max_results_constraints_BANG___52377$fn__52380.invoke(query_processor.clj:270)"
      "query_processor$fn__52368$process_query_and_save_with_max_results_constraints_BANG___52377.invoke(query_processor.clj:263)"
      "api.dataset$run_query_async$fn__65303.invoke(dataset.clj:69)"
      "query_processor.streaming$streaming_response_STAR_$fn__38418$fn__38419.invoke(streaming.clj:162)"
      "query_processor.streaming$streaming_response_STAR_$fn__38418.invoke(streaming.clj:161)"
      "async.streaming_response$do_f_STAR_.invokeStatic(streaming_response.clj:65)"
      "async.streaming_response$do_f_STAR_.invoke(streaming_response.clj:63)"
      "async.streaming_response$do_f_async$task__26888.invoke(streaming_response.clj:84)"],
     :card_id nil,
     :context :ad-hoc,
     :error "ERROR: syntax error at or near \"where\"\n  Position: 120",
     :row_count 0,
     :running_time 0,
     :data {:rows [], :cols []}}
4

@wj4 I have no idea how it has been possible for you to see a result, since the query is missing most of its syntax.

Seems like it must be different questions, or some browser caching causing the difference.

Try recreating the question, and add the new question to a dashboard.

Either way, latest release is 0.43.3:
https://github.com/metabase/metabase/releases/latest
And you should migrate away from H2 if you are using Metabase in production:
https://www.metabase.com/docs/latest/operations-guide/migrating-from-h2.html

5

@flamber Ill work on getting the update and migration done, but I just added the same question to an entirely new dashboard and am finding the same issue. What do you mean that my query is missing syntax?

Here's the query itself:

with orgs as ({{#57}}), registered as ({{#56}}) 
select
    cast((select count(distinct id) from registered [[where "Member Group - Group__name" = {{organization}}]]) as decimal) / 
    cast((select sum(subscriptions_total) from orgs [[where "name" = {{organization}}]]) as decimal) as adoption

where #57 is a list of organizations and #56 is a list of members of those organizations. Both are models derived from questions generated in the notebook editor

6

@wj4 Hmmm..... it looks an awful lot like https://github.com/metabase/metabase/issues/22486, which I remember testing on several databases, but could only reproduce on Mongo.

7

If I am unable to find a solution, what is the "right" way for me to produce these types of results? I need to be able to calculate a value, display it on a dashboard, and have the calculation depend on a dashboard-level filter. The way I'm doing it now feels very hacked together - is there some other component I'm missing?

8

@wj4 Think you might be seeing this issue, which is fixed, so upgrade to latest release first: https://github.com/metabase/metabase/issues/21246

Get as close as possible to the source to avoid as many nested queries as possible, but otherwise your query looks fine. How would you make this query less "hacky"?

The query looks completely off in the stacktrace you included. I cannot reproduce on 0.43.3

9

I hope the update fixes it, but I don't believe it's the same issue. The issue you linked is explicitly a problem with date filters, no?

10

@wj4 Make a backup, upgrade, test. If it is still a problem, then try to reproduce with Sample Database.