Hi. I’m getting this error (“Distinct, non-empty sequence of Field clauses”) when I try to join a custom saved question with a table (student.id = student_id) and I don’t know what is causing it. Could someone find the problem?
I read something about SSH tunnel in other topics, but it’s not my case.
Log says:
[3c1d1fdd-ed09-42d0-bb58-3ed3aa60a953] 2020-12-02T19:15:23-03:00 ERROR metabase.query-processor.middleware.catch-exceptions Erro ao processar a query: null
{:database_id 2,
:started_at #t “2020-12-02T22:15:22.983589Z[GMT]”,
:error_type :invalid-query,
:json_query
{:type “query”,
:query
{:source-table “card__394”,
:joins
[{:fields “all”,
:source-table 96,
:condition ["=" [“field-literal” “ID Aluno” “type/BigInteger”] [“joined-field” “Área de Interesse (interest_areas)” [“field-id” 542]]],
:alias “Área de Interesse (interest_areas)”}]},
:database 2,
:parameters [],
:middleware {:js-int-to-string? true, :add-default-userland-constraints? true}},
:native nil,
:status :failed,
:class clojure.lang.ExceptionInfo,
:stacktrace
["–> query_processor.middleware.add_implicit_clauses$fn__40610$source_metadata__GT_fields__40615.invoke(add_implicit_clauses.clj:54)"
“query_processor.middleware.add_implicit_clauses$fn__40681$add_implicit_fields__40686$fn__40690.invoke(add_implicit_clauses.clj:88)”
“query_processor.middleware.add_implicit_clauses$fn__40681$add_implicit_fields__40686.invoke(add_implicit_clauses.clj:80)”
“query_processor.middleware.add_implicit_clauses$add_implicit_mbql_clauses.invokeStatic(add_implicit_clauses.clj:124)”
“query_processor.middleware.add_implicit_clauses$add_implicit_mbql_clauses.invoke(add_implicit_clauses.clj:120)”
“query_processor.middleware.add_implicit_clauses$maybe_add_implicit_clauses.invokeStatic(add_implicit_clauses.clj:134)”
“query_processor.middleware.add_implicit_clauses$maybe_add_implicit_clauses.invoke(add_implicit_clauses.clj:131)”
“query_processor.middleware.add_implicit_clauses$add_implicit_clauses$fn__40771.invoke(add_implicit_clauses.clj:141)”
“query_processor.middleware.add_source_metadata$add_source_metadata_for_source_queries$fn__41169.invoke(add_source_metadata.clj:105)”
“query_processor.middleware.reconcile_breakout_and_order_by_bucketing$reconcile_breakout_and_order_by_bucketing$fn__48337.invoke(reconcile_breakout_and_order_by_bucketing.clj:98)”
“query_processor.middleware.auto_bucket_datetimes$auto_bucket_datetimes$fn__45480.invoke(auto_bucket_datetimes.clj:125)”
“query_processor.middleware.resolve_source_table$resolve_source_tables$fn__46456.invoke(resolve_source_table.clj:46)”
“query_processor.middleware.parameters$substitute_parameters$fn__48122.invoke(parameters.clj:114)”
“query_processor.middleware.resolve_referenced$resolve_referenced_card_resources$fn__46508.invoke(resolve_referenced.clj:80)”
“query_processor.middleware.expand_macros$expand_macros$fn__47127.invoke(expand_macros.clj:158)”
“query_processor.middleware.add_timezone_info$add_timezone_info$fn__41200.invoke(add_timezone_info.clj:15)”
“query_processor.middleware.splice_params_in_response$splice_params_in_response$fn__49058.invoke(splice_params_in_response.clj:32)”
“query_processor.middleware.resolve_database_and_driver$resolve_database_and_driver$fn__48348$fn__48352.invoke(resolve_database_and_driver.clj:33)”
“driver$do_with_driver.invokeStatic(driver.clj:61)”
“driver$do_with_driver.invoke(driver.clj:57)”
“query_processor.middleware.resolve_database_and_driver$resolve_database_and_driver$fn__48348.invoke(resolve_database_and_driver.clj:27)”
“query_processor.middleware.fetch_source_query$resolve_card_id_source_tables$fn__47345.invoke(fetch_source_query.clj:267)”
“query_processor.middleware.store$initialize_store$fn__49067$fn__49068.invoke(store.clj:11)”
“query_processor.store$do_with_store.invokeStatic(store.clj:46)”
“query_processor.store$do_with_store.invoke(store.clj:40)”
“query_processor.middleware.store$initialize_store$fn__49067.invoke(store.clj:10)”
“query_processor.middleware.cache$maybe_return_cached_results$fn__46385.invoke(cache.clj:214)”
“query_processor.middleware.validate$validate_query$fn__49076.invoke(validate.clj:10)”
“query_processor.middleware.normalize_query$normalize$fn__47470.invoke(normalize_query.clj:22)”
“query_processor.middleware.add_rows_truncated$add_rows_truncated$fn__41038.invoke(add_rows_truncated.clj:36)”
“query_processor.middleware.results_metadata$record_and_return_metadata_BANG_$fn__49043.invoke(results_metadata.clj:147)”
“query_processor.middleware.constraints$add_default_userland_constraints$fn__46748.invoke(constraints.clj:42)”
“query_processor.middleware.process_userland_query$process_userland_query$fn__48211.invoke(process_userland_query.clj:136)”
“query_processor.middleware.catch_exceptions$catch_exceptions$fn__46691.invoke(catch_exceptions.clj:174)”
“query_processor.reducible$async_qp$qp_STAR___39827$thunk__39828.invoke(reducible.clj:103)”
“query_processor.reducible$async_qp$qp_STAR___39827.invoke(reducible.clj:109)”
“query_processor.reducible$sync_qp$qp_STAR___39836$fn__39839.invoke(reducible.clj:135)”
“query_processor.reducible$sync_qp$qp_STAR___39836.invoke(reducible.clj:134)”
“query_processor$process_userland_query.invokeStatic(query_processor.clj:237)”
“query_processor$process_userland_query.doInvoke(query_processor.clj:233)”
“query_processor$fn__49234$process_query_and_save_execution_BANG___49243$fn__49246.invoke(query_processor.clj:249)”
“query_processor$fn__49234$process_query_and_save_execution_BANG___49243.invoke(query_processor.clj:241)”
“query_processor$fn__49278$process_query_and_save_with_max_results_constraints_BANG___49287$fn__49290.invoke(query_processor.clj:261)”
“query_processor$fn__49278$process_query_and_save_with_max_results_constraints_BANG___49287.invoke(query_processor.clj:254)”
“api.dataset$fn__52603$fn__52606.invoke(dataset.clj:59)”
“query_processor.streaming$streaming_response_STAR_$fn__37131$fn__37132.invoke(streaming.clj:73)”
“query_processor.streaming$streaming_response_STAR_$fn__37131.invoke(streaming.clj:72)”
“async.streaming_response$do_f_STAR_.invokeStatic(streaming_response.clj:66)”
“async.streaming_response$do_f_STAR_.invoke(streaming_response.clj:64)”
“async.streaming_response$do_f_async$fn__24639.invoke(streaming_response.clj:85)”],
:context :ad-hoc,
:error “Distinct, non-empty sequence of Field clauses”,
:row_count 0,
:running_time 0,
:preprocessed nil,
:ex-data
{:type :schema.core/error,
:value
([:field-literal “ID Aluno” :type/BigInteger]
[:field-literal “Nome” :type/Text]
[:field-literal “Email corporativo” :type/Text]
[:field-literal “Matrícula / Unidade de negócio” :type/Text]
[:field-literal “Email pessoal” :type/Text]
[:field-literal “CPF” :type/Text]
[:field-literal “Área” :type/Text]
[:field-literal “Cargo” :type/Text]
[:field-literal “Logins realizados” :type/Integer]
[:field-literal “Acesso ao APP” :type/Boolean]
[:field-literal “Nº de telefone” :type/Text]
[:field-literal “Perfil de acesso” :type/Text]
[:field-literal “ID Perfil de acesso” :type/BigInteger]
[:field-literal “Pula Witson” :type/Boolean]
[:field-literal “Perfil de trial” :type/Boolean]
[:field-literal “Empresa” :type/Text]
[:field-literal “ID Empresa” :type/BigInteger]
[:field-literal “Aniversário” :type/Text]
[:field-literal “Data de cadastro” :type/Text]
[:field-literal “Última atualização” :type/Text]
[:field-literal “case” :type/Text]
[:field-literal “case” :type/Text]
[:field-literal “Acesso SSA” :type/Boolean]
[:field-literal “Acesso HRA” :type/Boolean]
[:field-literal “Acesso Idapt” :type/Boolean]
[:field-literal “Acesso JRAcademy” :type/Boolean]
[:field-literal “Acesso Onboarding Siemens” :type/Boolean]
[:field-literal “Acesso LDC” :type/Boolean]
[:field-literal “Acesso Academia de Produtividade” :type/Boolean]
[:field-literal “Acesso Academia Witseed” :type/Boolean]),
:error (named (not (“distinct” a-clojure.lang.LazySeq)) “Distinct, non-empty sequence of Field clauses”)},
:data {:rows [], :cols []}}
Other infos:
{
"browser-info": {
"language": "pt-BR",
"platform": "Linux x86_64",
"userAgent": "Mozilla/5.0 (X11; Linux x86_64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/84.0.4147.105 Safari/537.36",
"vendor": "Google Inc."
},
"system-info": {
"file.encoding": "UTF-8",
"java.runtime.name": "OpenJDK Runtime Environment",
"java.runtime.version": "11.0.7+10",
"java.vendor": "AdoptOpenJDK",
"java.vendor.url": "https://adoptopenjdk.net/",
"java.version": "11.0.7",
"java.vm.name": "OpenJDK 64-Bit Server VM",
"java.vm.version": "11.0.7+10",
"os.name": "Linux",
"os.version": "4.14.200-155.322.amzn2.x86_64",
"user.language": "en",
"user.timezone": "GMT"
},
"metabase-info": {
"databases": [
"postgres"
],
"hosting-env": "elastic-beanstalk",
"application-database": "postgres",
"application-database-details": {
"database": {
"name": "PostgreSQL",
"version": "11.8"
},
"jdbc-driver": {
"name": "PostgreSQL JDBC Driver",
"version": "42.2.8"
}
},
"run-mode": "prod",
"version": {
"date": "2020-11-16",
"tag": "v0.37.2",
"branch": "release-x.37.x",
"hash": "25e5f70"
},
"settings": {
"report-timezone": "America/Sao_Paulo"
}
}
}