Hi Team,
I have created a new native query in mongodb which runs fine when executed from the query editor, however when I save the question and refer it in another question I get the following error. Please help me understand what's wrong in the query
Diagnostic info:
{
"browser-info": {
"language": "en-IN",
"platform": "MacIntel",
"userAgent": "Mozilla/5.0 (Macintosh; Intel Mac OS X 10_15_7) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/112.0.0.0 Safari/537.36 Edg/112.0.1722.64",
"vendor": "Google Inc."
},
"system-info": {
"file.encoding": "UTF-8",
"java.runtime.name": "OpenJDK Runtime Environment",
"java.runtime.version": "17.0.7+7",
"java.vendor": "Eclipse Adoptium",
"java.vendor.url": "https://adoptium.net/",
"java.version": "17.0.7",
"java.vm.name": "OpenJDK 64-Bit Server VM",
"java.vm.version": "17.0.7+7",
"os.name": "Mac OS X",
"os.version": "13.3.1",
"user.language": "en",
"user.timezone": "Asia/Kolkata"
},
"metabase-info": {
"databases": [
"mongo"
],
"hosting-env": "unknown",
"application-database": "h2",
"application-database-details": {
"database": {
"name": "H2",
"version": "2.1.212 (2022-04-09)"
},
"jdbc-driver": {
"name": "H2 JDBC Driver",
"version": "2.1.212 (2022-04-09)"
}
},
"run-mode": "prod",
"version": {
"date": "2023-04-28",
"tag": "v0.46.2",
"branch": "release-x.46.x",
"hash": "8967c94"
},
"settings": {
"report-timezone": null
}
}
}
Stacktrace:
[20130669-e82f-4196-904a-56140c851498] 2023-05-01T21:35:00+05:30 INFO metabase.api.dataset Source query for this query is Card 108
[20130669-e82f-4196-904a-56140c851498] 2023-05-01T21:35:00+05:30 ERROR metabase.query-processor.middleware.catch-exceptions Error processing query: Input to trim-sql-query does not match schema:
[nil (named (not (instance? java.lang.String a-clojure.lang.PersistentArrayMap)) query-str)]
{:database_id 3,
:started_at #t "2023-05-01T21:35:00.392370+05:30[Asia/Kolkata]",
:error_type :invalid-query,
:json_query
{:database 3,
:query {:source-table "card__108"},
:type "query",
:parameters [],
:middleware {:js-int-to-string? true, :add-default-userland-constraints? true}},
:native nil,
:status :failed,
:class clojure.lang.ExceptionInfo,
:stacktrace
["--> query_processor.middleware.fetch_source_query$fn__64705$trim_sql_query__64710.invoke(fetch_source_query.clj:94)"
"query_processor.middleware.fetch_source_query$source_query.invokeStatic(fetch_source_query.clj:121)"
"query_processor.middleware.fetch_source_query$source_query.invoke(fetch_source_query.clj:106)"
"query_processor.middleware.fetch_source_query$fn__64747$card_id__GT_source_query_and_metadata__64756$fn__64759.invoke(fetch_source_query.clj:142)"
"query_processor.middleware.fetch_source_query$fn__64747$card_id__GT_source_query_and_metadata__64756.invoke(fetch_source_query.clj:126)"
"query_processor.middleware.fetch_source_query$fn__64747$card_id__GT_source_query_and_metadata__64756$fn__64757.invoke(fetch_source_query.clj:130)"
"query_processor.middleware.fetch_source_query$fn__64747$card_id__GT_source_query_and_metadata__64756.invoke(fetch_source_query.clj:126)"
"query_processor.middleware.fetch_source_query$check_for_circular_references.invokeStatic(fetch_source_query.clj:217)"
"query_processor.middleware.fetch_source_query$check_for_circular_references.invoke(fetch_source_query.clj:209)"
"query_processor.middleware.fetch_source_query$check_for_circular_references.invokeStatic(fetch_source_query.clj:214)"
"query_processor.middleware.fetch_source_query$check_for_circular_references.invoke(fetch_source_query.clj:209)"
"query_processor.middleware.fetch_source_query$fn__64907$resolve_all__64912$fn__64913.invoke(fetch_source_query.clj:279)"
"query_processor.middleware.fetch_source_query$fn__64907$resolve_all__64912.invoke(fetch_source_query.clj:272)"
"query_processor.middleware.fetch_source_query$fn__64931$resolve_card_id_source_tables_STAR___64936$fn__64940.invoke(fetch_source_query.clj:295)"
"query_processor.middleware.fetch_source_query$fn__64931$resolve_card_id_source_tables_STAR___64936.invoke(fetch_source_query.clj:286)"
"query_processor.middleware.fetch_source_query$resolve_card_id_source_tables$fn__64953.invoke(fetch_source_query.clj:302)"
"query_processor.middleware.store$initialize_store$fn__65131$fn__65132.invoke(store.clj:12)"
"query_processor.store$do_with_store.invokeStatic(store.clj:47)"
"query_processor.store$do_with_store.invoke(store.clj:41)"
"query_processor.middleware.store$initialize_store$fn__65131.invoke(store.clj:11)"
"query_processor.middleware.normalize_query$normalize$fn__69372.invoke(normalize_query.clj:25)"
"query_processor.middleware.constraints$add_default_userland_constraints$fn__66309.invoke(constraints.clj:54)"
"query_processor.middleware.process_userland_query$process_userland_query$fn__69308.invoke(process_userland_query.clj:150)"
"query_processor.middleware.catch_exceptions$catch_exceptions$fn__69685.invoke(catch_exceptions.clj:171)"
"query_processor.reducible$async_qp$qp_STAR___59455$thunk__59457.invoke(reducible.clj:103)"
"query_processor.reducible$async_qp$qp_STAR___59455.invoke(reducible.clj:109)"
"query_processor.reducible$async_qp$qp_STAR___59455.invoke(reducible.clj:94)"
"query_processor.reducible$sync_qp$qp_STAR___59467.doInvoke(reducible.clj:129)"
"query_processor$process_userland_query.invokeStatic(query_processor.clj:362)"
"query_processor$process_userland_query.doInvoke(query_processor.clj:358)"
"query_processor$fn__70739$process_query_and_save_execution_BANG___70748$fn__70751.invoke(query_processor.clj:373)"
"query_processor$fn__70739$process_query_and_save_execution_BANG___70748.invoke(query_processor.clj:366)"
"query_processor$fn__70784$process_query_and_save_with_max_results_constraints_BANG___70793$fn__70796.invoke(query_processor.clj:385)"
"query_processor$fn__70784$process_query_and_save_with_max_results_constraints_BANG___70793.invoke(query_processor.clj:378)"
"api.dataset$run_query_async$fn__86545.invoke(dataset.clj:73)"
"query_processor.streaming$streaming_response_STAR_$fn__54305$fn__54306.invoke(streaming.clj:166)"
"query_processor.streaming$streaming_response_STAR_$fn__54305.invoke(streaming.clj:165)"
"async.streaming_response$do_f_STAR_.invokeStatic(streaming_response.clj:69)"
"async.streaming_response$do_f_STAR_.invoke(streaming_response.clj:67)"
"async.streaming_response$do_f_async$task__36922.invoke(streaming_response.clj:88)"],
:card_id 108,
:context :ad-hoc,
:error
"Input to trim-sql-query does not match schema: \n\n\t [nil (named (not (instance? java.lang.String a-clojure.lang.PersistentArrayMap)) query-str)] \n\n",
:row_count 0,
:running_time 0,
:preprocessed nil,
:ex-data
{:type :schema.core/error,
:value
[108
{:collection "user",
:query
"[{"$project":{"_id":"$_id","updateDateTime":"$updateDateTime","createDateTime":"$createDateTime","givenName":"$givenName","familyName":"$familyName","gender":"$gender","email":"$email","roles":"$roles","timezone":"$timezone","lastLoginDateTime":{"$dateFromString":{"dateString":"$lastLoginDateTime","onError":"$lastLoginDateTime"}},"dateOfBirth":"$dateOfBirth","stats":"$stats","lastSubmitDateTime":"$lastSubmitDateTime","boardingStatus":"$boardingStatus","finishedOnboarding":"$finishedOnboarding","biologicalSex":"$biologicalSex","TaskCompliance":{"$cond":[{"$eq":["$stats.taskCompliance.total",0]},null,{"$divide":["$stats.taskCompliance.current","$stats.taskCompliance.total"]}]},"FullName":{"$concat":["$givenName"," ","$familyName"]},"Status":{"$cond":[{"$ne":["$boardingStatus.status",0]},"Offboarded","Active"]}}},{"$unwind":"$roles"},{"$match":{"$or":[{"roles.roleId":"User"},{"roles.roleId":"Proxy"}]}},{"$addFields":{"deploymentId":{"$cond":[{"$eq":[{"$first":{"$split":["$roles.resource","/"]}},"deployment"]},{"$last":{"$split":["$roles.resource","/"]}},null]}}},{"$match":{"deploymentId":{"$exists":true}}},{"$limit":1048575}]"}],
:error [nil (named (not (instance? java.lang.String a-clojure.lang.PersistentArrayMap)) query-str)]},
:data {:rows [], :cols []}}
[20130669-e82f-4196-904a-56140c851498] 2023-05-01T21:35:00+05:30 DEBUG metabase.server.middleware.log POST /api/dataset 202 [ASYNC: completed] 72.3 ms (11 DB calls) App DB connections: 0/10 Jetty threads: 4/50 (8 idle, 0 queued) (66 total active threads) Queries in flight: 0 (0 queued)
[20130669-e82f-4196-904a-56140c851498] 2023-05-01T21:35:36+05:30 DEBUG metabase.server.middleware.log GET /api/util/bug_report_details 200 11.2 ms (1 DB calls) App DB connections: 0/10 Jetty threads: 5/50 (11 idle, 0 queued) (62 total active threads) Queries in flight: 0 (0 queued)