This is the log file of metabase when above error is showing from the dashboard
03-16 08:11:55 DEBUG metabase.query-processor ::
QUERY: ?
{:database 2,
:type “native”,
:native
{:query
“\nselect (SELECT count(subscriptions
.subscriber_id
)\nFROM subscriptions
\nWHERE (subscriptions
.is_inactive
= 0\n AND subscriptions
.is_ghost
= 0 AND subscriptions
.customer_id
= {{customerid}}))\n+\n(select count(subscriptions_firefox
.subscriber_id
)\nFrom subscriptions_firefox
WHERE (subscriptions_firefox
.customer_id
= {{customerid}}\n AND subscriptions_firefox
.is_ghost
= 0 AND subscriptions_firefox
.is_inactive
= 0))\n\n\n\n”,
:template_tags {:customerid {:id “03d4e263-ffc6-f83a-5a01-a379e0b74cc9”, :name “customerid”, :display_name “Customerid”, :type “number”, :required false}}},
:parameters nil,
:constraints {:max-results 10000, :max-results-bare-rows 2000},
:info {:executed-by 1, :card-id 33, :uuid “4b0b38a0-2b6e-48a5-adc2-9139385972cc”, :query-hash -1053220492, :query-type “native”}}
03-16 08:11:55 ERROR metabase.query-processor :: {:status :failed,
:class java.lang.NullPointerException,
:error “java.lang.NullPointerException”,
:stacktrace
[“query_processor.sql_parameters$replace_param.invokeStatic(sql_parameters.clj:111)”
“query_processor.sql_parameters$replace_param.invoke(sql_parameters.clj:106)”
“query_processor.sql_parameters$handle_simple.invokeStatic(sql_parameters.clj:119)”
“query_processor.sql_parameters$handle_simple.invoke(sql_parameters.clj:113)”
“query_processor.sql_parameters$substitute.invokeStatic(sql_parameters.clj:139)”
“query_processor.sql_parameters$substitute.invoke(sql_parameters.clj:128)”
“util$rpartial$fn__4620.doInvoke(util.clj:433)”
“query_processor.sql_parameters$expand_params.invokeStatic(sql_parameters.clj:216)”
“query_processor.sql_parameters$expand_params.invoke(sql_parameters.clj:211)”
“query_processor.parameters$expand_params_COLON_native.invokeStatic(parameters.clj:175)”
“query_processor.parameters$expand_params_COLON_native.invoke(parameters.clj:172)”
“query_processor.parameters$expand_parameters.invokeStatic(parameters.clj:189)”
“query_processor.parameters$expand_parameters.invoke(parameters.clj:183)”
“query_processor$substitute_parameters.invokeStatic(query_processor.clj:163)”
“query_processor$substitute_parameters.invoke(query_processor.clj:160)”
“query_processor$wrap_catch_exceptions$fn__21572.invoke(query_processor.clj:122)”
“query_processor$process_query.invokeStatic(query_processor.clj:538)”
“query_processor$process_query.invoke(query_processor.clj:529)”
“query_processor$dataset_query.invokeStatic(query_processor.clj:621)”
“query_processor$dataset_query.invoke(query_processor.clj:579)”
“api.card$run_query_for_card.invokeStatic(card.clj:272)”
“api.card$run_query_for_card.invoke(card.clj:265)”
“api.card$fn__22765$fn__22768.invoke(card.clj:282)”
“api.common.internal$wrap_catch_api_exceptions.invokeStatic(internal.clj:222)”
“api.common.internal$wrap_catch_api_exceptions.invoke(internal.clj:219)”
“api.card$fn__22765.invokeStatic(card.clj:279)”
“api.card$fn__22765.invoke(card.clj:279)”
“middleware$enforce_authentication$fn__30829.invoke(middleware.clj:84)”
“api.routes$fn__30929.invokeStatic(routes.clj:40)”
“api.routes$fn__30929.invoke(routes.clj:40)”
“routes$fn__31914.invokeStatic(routes.clj:24)”
“routes$fn__31914.invoke(routes.clj:24)”
“middleware$log_api_call$fn__30917$fn__30919.invoke(middleware.clj:275)”
“db$_do_with_call_counting.invokeStatic(db.clj:458)”
“db$_do_with_call_counting.invoke(db.clj:452)”
“middleware$log_api_call$fn__30917.invoke(middleware.clj:274)”
“middleware$add_security_headers$fn__30876.invoke(middleware.clj:209)”
“middleware$bind_current_user$fn__30833.invoke(middleware.clj:104)”],
:query
{:type “native”,
:native
{:query
“\nselect (SELECT count(subscriptions
.subscriber_id
)\nFROM subscriptions
\nWHERE (subscriptions
.is_inactive
= 0\n AND subscriptions
.is_ghost
= 0 AND subscriptions
.customer_id
= {{customerid}}))\n+\n(select count(subscriptions_firefox
.subscriber_id
)\nFrom subscriptions_firefox
WHERE (subscriptions_firefox
.customer_id
= {{customerid}}\n AND subscriptions_firefox
.is_ghost
= 0 AND subscriptions_firefox
.is_inactive
= 0))\n\n\n\n”,
:template_tags {:customerid {:id “03d4e263-ffc6-f83a-5a01-a379e0b74cc9”, :name “customerid”, :display_name “Customerid”, :type “number”, :required false}}},
:parameters nil,
:constraints {:max-results 10000, :max-results-bare-rows 2000},
:info {:executed-by 1, :card-id 33, :uuid “4b0b38a0-2b6e-48a5-adc2-9139385972cc”, :query-hash -1053220492, :query-type “native”}},
:expanded-query nil}
03-16 08:11:55 ERROR metabase.query-processor :: Query failure: java.lang.NullPointerException
[“query_processor$assert_valid_query_result.invokeStatic(query_processor.clj:577)”
“query_processor$assert_valid_query_result.invoke(query_processor.clj:572)”
“query_processor$dataset_query.invokeStatic(query_processor.clj:622)”
“query_processor$dataset_query.invoke(query_processor.clj:579)”
“api.card$run_query_for_card.invokeStatic(card.clj:272)”
“api.card$run_query_for_card.invoke(card.clj:265)”
“api.card$fn__22765$fn__22768.invoke(card.clj:282)”
“api.common.internal$wrap_catch_api_exceptions.invokeStatic(internal.clj:222)”
“api.common.internal$wrap_catch_api_exceptions.invoke(internal.clj:219)”
“api.card$fn__22765.invokeStatic(card.clj:279)”
“api.card$fn__22765.invoke(card.clj:279)”
“middleware$enforce_authentication$fn__30829.invoke(middleware.clj:84)”
“api.routes$fn__30929.invokeStatic(routes.clj:40)”
“api.routes$fn__30929.invoke(routes.clj:40)”
“routes$fn__31914.invokeStatic(routes.clj:24)”
“routes$fn__31914.invoke(routes.clj:24)”
“middleware$log_api_call$fn__30917$fn__30919.invoke(middleware.clj:275)”
“db$_do_with_call_counting.invokeStatic(db.clj:458)”
“db$_do_with_call_counting.invoke(db.clj:452)”
“middleware$log_api_call$fn__30917.invoke(middleware.clj:274)”
“middleware$add_security_headers$fn__30876.invoke(middleware.clj:209)”
“middleware$bind_current_user$fn__30833.invoke(middleware.clj:104)”]
03-16 08:11:55 ERROR metabase.middleware :: POST /api/card/33/query/csv 500 (155 ms) (3 DB calls)
“java.lang.NullPointerException”