Hello,
I've been trying to solve this error for hours but am stuck. I have two tables. For each table I created a custom column called "FilingReferenceID" by concatting two IDs (concat ([FilingID],[ReferenceID]).
Now, I want to join both tables. When doing so, I get this error. I rescanned the DB schema and synced all field values multiple times before to no avail.
Input to source-aliases does not match schema: e[0;33m [nil (named {:source-query {:fields (named (not ("Non-empty" a-clojure.lang.LazySeq)) "Distinct, non-empty sequence of Field clauses")}} inner-query)] e[0m
My configuration:
{
"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/96.0.4664.55 Safari/537.36",
"vendor": "Google Inc."
},
"system-info": {
"file.encoding": "UTF-8",
"java.runtime.name": "OpenJDK Runtime Environment",
"java.runtime.version": "1.8.0_312-heroku-b05",
"java.vendor": "Oracle Corporation",
"java.vendor.url": "http://java.oracle.com/",
"java.version": "1.8.0_312-heroku",
"java.vm.name": "OpenJDK 64-Bit Server VM",
"java.vm.version": "25.312-b05",
"os.name": "Linux",
"os.version": "4.4.0-1097-aws",
"user.language": "en",
"user.timezone": "Etc/UTC"
},
"metabase-info": {
"databases": [
"postgres"
],
"hosting-env": "heroku",
"application-database": "postgres",
"application-database-details": {
"database": {
"name": "PostgreSQL",
"version": "13.5 (Ubuntu 13.5-2.pgdg20.04+1)"
},
"jdbc-driver": {
"name": "PostgreSQL JDBC Driver",
"version": "42.2.23"
}
},
"run-mode": "prod",
"version": {
"tag": "v0.41.3.1",
"date": "2021-12-02",
"branch": "release-x.41.x",
"hash": "20f9097"
},
"settings": {
"report-timezone": null
}
}
}
The logs I grabbed from the admin panel:
{:database 2,
:query
{:source-metadata
[{:semantic_type nil,
:coercion_strategy nil,
:name "FilingID",
:field_ref [:field 773 nil],
:effective_type :type/BigInteger,
:id 773,
:display_name "FilingID",
:fingerprint
{:global {:distinct-count 2617, :nil% 0.0},
:type
{:type/Text
{:percent-json 0.0, :percent-url 0.0, :percent-email 0.0, :percent-state 0.0, :average-length 6.0002}}},
:base_type :type/BigInteger}
{:semantic_type nil,
:coercion_strategy nil,
:name "Fund Name",
:field_ref [:field 772 nil],
:effective_type :type/Text,
:id 772,
:display_name "Fund Name",
:fingerprint
{:global {:distinct-count 8522, :nil% 0.0},
:type
{:type/Text
{:percent-json 0.0, :percent-url 0.0, :percent-email 0.0, :percent-state 0.0, :average-length 30.9832}}},
:base_type :type/Text}
{:semantic_type nil,
:coercion_strategy nil,
:name "Fund ID",
:field_ref [:field 764 nil],
:effective_type :type/Text,
:id 764,
:display_name "Fund ID",
:fingerprint
{:global {:distinct-count 8608, :nil% 0.0},
:type
{:type/Text
{:percent-json 0.0, :percent-url 0.0, :percent-email 0.0, :percent-state 0.0, :average-length 14.0}}},
:base_type :type/Text}
{:semantic_type nil,
:coercion_strategy nil,
:name "ReferenceID",
:field_ref [:field 745 nil],
:effective_type :type/BigInteger,
:id 745,
:display_name "ReferenceID",
:fingerprint
{:global {:distinct-count 8645, :nil% 0.0},
:type
{:type/Text
{:percent-json 0.0, :percent-url 0.0, :percent-email 0.0, :percent-state 0.0, :average-length 5.0112}}},
:base_type :type/BigInteger}
{:semantic_type nil,
:coercion_strategy nil,
:name "State",
:field_ref [:field 762 nil],
:effective_type :type/Text,
:id 762,
:display_name "State",
:fingerprint
{:global {:distinct-count 36, :nil% 0.0},
:type
{:type/Text
{:percent-json 0.0, :percent-url 0.0, :percent-email 0.0, :percent-state 0.5586, :average-length 4.4829}}},
:base_type :type/Text}
{:semantic_type :type/Country,
:coercion_strategy nil,
:name "Country",
:field_ref [:field 750 nil],
:effective_type :type/Text,
:id 750,
:display_name "Country",
:fingerprint
{:global {:distinct-count 41, :nil% 0.0},
:type
{:type/Text
{:percent-json 0.0, :percent-url 0.0, :percent-email 0.0, :percent-state 0.0, :average-length 12.4872}}},
:base_type :type/Text}
{:semantic_type :type/Category,
:coercion_strategy nil,
:name "3(c)(1) Exclusion",
:field_ref [:field 761 nil],
:effective_type :type/Text,
:id 761,
:display_name "3(c)(1) Exclusion",
:fingerprint
{:global {:distinct-count 2, :nil% 0.0},
:type
{:type/Text {:percent-json 0.0, :percent-url 0.0, :percent-email 0.0, :percent-state 0.0, :average-length 1.0}}},
:base_type :type/Text}
{:semantic_type :type/Category,
:coercion_strategy nil,
:name "3(c)(7) Exclusion",
:field_ref [:field 753 nil],
:effective_type :type/Text,
:id 753,
:display_name "3(c)(7) Exclusion",
:fingerprint
{:global {:distinct-count 2, :nil% 0.0},
:type
{:type/Text {:percent-json 0.0, :percent-url 0.0, :percent-email 0.0, :percent-state 0.0, :average-length 1.0}}},
:base_type :type/Text}
{:semantic_type :type/Category,
:coercion_strategy nil,
:name "Master Fund",
:field_ref [:field 778 nil],
:effective_type :type/Text,
:id 778,
:display_name "Master Fund",
:fingerprint
{:global {:distinct-count 2, :nil% 0.0},
:type
{:type/Text {:percent-json 0.0, :percent-url 0.0, :percent-email 0.0, :percent-state 0.0, :average-length 1.0}}},
:base_type :type/Text}
{:semantic_type :type/Category,
:coercion_strategy nil,
:name "Feeder Fund",
:field_ref [:field 755 nil],
:effective_type :type/Text,
:id 755,
:display_name "Feeder Fund",
:fingerprint
{:global {:distinct-count 2, :nil% 0.0},
:type
{:type/Text {:percent-json 0.0, :percent-url 0.0, :percent-email 0.0, :percent-state 0.0, :average-length 1.0}}},
:base_type :type/Text}
{:semantic_type nil,
:coercion_strategy nil,
:name "Master Fund Name",
:field_ref [:field 769 nil],
:effective_type :type/Text,
:id 769,
:display_name "Master Fund Name",
:fingerprint
{:global {:distinct-count 222, :nil% 0.0},
:type
{:type/Text
{:percent-json 0.0, :percent-url 0.0, :percent-email 0.0, :percent-state 0.0, :average-length 1.2471}}},
:base_type :type/Text}
{:semantic_type nil,
:coercion_strategy nil,
:name "Master Fund ID",
:field_ref [:field 763 nil],
:effective_type :type/Text,
:id 763,
:display_name "Master Fund ID",
:fingerprint
{:global {:distinct-count 179, :nil% 0.0},
:type
{:type/Text
{:percent-json 0.0, :percent-url 0.0, :percent-email 0.0, :percent-state 0.0, :average-length 0.4312}}},
:base_type :type/Text}
{:semantic_type :type/Category,
:coercion_strategy nil,
:name "Fund of Funds",
:field_ref [:field 748 nil],
:effective_type :type/Text,
:id 748,
:display_name "Fund Of Funds",
:fingerprint
{:global {:distinct-count 2, :nil% 0.0},
:type
{:type/Text {:percent-json 0.0, :percent-url 0.0, :percent-email 0.0, :percent-state 0.0, :average-length 1.0}}},
:base_type :type/Text}
{:semantic_type :type/Category,
:coercion_strategy nil,
:name "Fund Invested Self or Related",
:field_ref [:field 747 nil],
:effective_type :type/Text,
:id 747,
:display_name "Fund Invested Self Or Related",
:fingerprint
{:global {:distinct-count 3, :nil% 0.0},
:type
{:type/Text
{:percent-json 0.0, :percent-url 0.0, :percent-email 0.0, :percent-state 0.0, :average-length 0.0716}}},
:base_type :type/Text}
{:semantic_type :type/Category,
:coercion_strategy nil,
:name "Fund Invested in Securities",
:field_ref [:field 746 nil],
:effective_type :type/Text,
:id 746,
:display_name "Fund Invested In Securities",
:fingerprint
{:global {:distinct-count 2, :nil% 0.0},
:type
{:type/Text {:percent-json 0.0, :percent-url 0.0, :percent-email 0.0, :percent-state 0.0, :average-length 1.0}}},
:base_type :type/Text}
{:semantic_type :type/Category,
:coercion_strategy nil,
:name "Fund Type",
:field_ref [:field 757 nil],
:effective_type :type/Text,
:id 757,
:display_name "Fund Type",
:fingerprint
{:global {:distinct-count 7, :nil% 0.0},
:type
{:type/Text
{:percent-json 0.0, :percent-url 0.0, :percent-email 0.0, :percent-state 0.0, :average-length 17.7156}}},
:base_type :type/Text}
{:semantic_type nil,
:coercion_strategy nil,
:name "Fund Type Other",
:field_ref [:field 781 nil],
:effective_type :type/Text,
:id 781,
:display_name "Fund Type Other",
:fingerprint
{:global {:distinct-count 143, :nil% 0.0},
:type
{:type/Text
{:percent-json 0.0, :percent-url 0.0, :percent-email 0.0, :percent-state 0.0, :average-length 1.318}}},
:base_type :type/Text}
{:semantic_type nil,
:coercion_strategy nil,
:name "Gross Asset Value",
:field_ref [:field 749 nil],
:effective_type :type/Text,
:id 749,
:display_name "Gross Asset Value",
:fingerprint
{:global {:distinct-count 7940, :nil% 0.0},
:type
{:type/Text
{:percent-json 0.0, :percent-url 0.0, :percent-email 0.0, :percent-state 0.0, :average-length 7.6171}}},
:base_type :type/Text}
{:semantic_type nil,
:coercion_strategy nil,
:name "Minimum Investment",
:field_ref [:field 756 nil],
:effective_type :type/Text,
:id 756,
:display_name "Minimum Investment",
:fingerprint
{:global {:distinct-count 593, :nil% 0.0},
:type
{:type/Text
{:percent-json 0.0, :percent-url 0.0, :percent-email 0.0, :percent-state 0.0, :average-length 5.1362}}},
:base_type :type/Text}
{:semantic_type :type/Owner,
:coercion_strategy nil,
:name "Owners",
:field_ref [:field 775 nil],
:effective_type :type/Text,
:id 775,
:display_name "Owners",
:fingerprint
{:global {:distinct-count 297, :nil% 0.0},
:type
{:type/Text
{:percent-json 0.0, :percent-url 0.0, :percent-email 0.0, :percent-state 0.0, :average-length 1.7587}}},
:base_type :type/Text}
{:semantic_type nil,
:coercion_strategy nil,
:name "%Owned You or Related",
:field_ref [:field 780 nil],
:effective_type :type/Text,
:id 780,
:display_name "%Owned You Or Related",
:fingerprint
{:global {:distinct-count 101, :nil% 0.0},
:type
{:type/Text
{:percent-json 0.0, :percent-url 0.0, :percent-email 0.0, :percent-state 0.0, :average-length 1.2848}}},
:base_type :type/Text}
{:semantic_type nil,
:coercion_strategy nil,
:name "%Owned Funds",
:field_ref [:field 777 nil],
:effective_type :type/Text,
:id 777,
:display_name "%Owned Funds",
:fingerprint
{:global {:distinct-count 101, :nil% 0.0},
:type
{:type/Text
{:percent-json 0.0, :percent-url 0.0, :percent-email 0.0, :percent-state 0.0, :average-length 1.3282}}},
:base_type :type/Text}
{:semantic_type nil,
:coercion_strategy nil,
:name "%Owned Non-US",
:field_ref [:field 779 nil],
:effective_type :type/Text,
:id 779,
:display_name "%Owned Non Us",
:fingerprint
{:global {:distinct-count 103, :nil% 0.0},
:type
{:type/Text
{:percent-json 0.0, :percent-url 0.0, :percent-email 0.0, :percent-state 0.0, :average-length 1.6021}}},
:base_type :type/Text}
{:semantic_type :type/Category,
:coercion_strategy nil,
:name "Subadviser",
:field_ref [:field 768 nil],
:effective_type :type/Text,
:id 768,
:display_name "Subadviser",
:fingerprint
{:global {:distinct-count 4, :nil% 0.0},
:type
{:type/Text
{:percent-json 0.0, :percent-url 0.0, :percent-email 0.0, :percent-state 0.0, :average-length 1.0002}}},
:base_type :type/Text}
{:semantic_type :type/Category,
:coercion_strategy nil,
:name "Other IAs Advise",
:field_ref [:field 760 nil],
:effective_type :type/Text,
:id 760,
:display_name "Other IAs Advise",
:fingerprint
{:global {:distinct-count 2, :nil% 0.0},
:type
{:type/Text {:percent-json 0.0, :percent-url 0.0, :percent-email 0.0, :percent-state 0.0, :average-length 1.0}}},
:base_type :type/Text}
{:semantic_type :type/Category,
:coercion_strategy nil,
:name "Clients Solicited",
:field_ref [:field 758 nil],
:effective_type :type/Text,
:id 758,
:display_name "Clients Solicited",
:fingerprint
{:global {:distinct-count 2, :nil% 0.0},
:type
{:type/Text {:percent-json 0.0, :percent-url 0.0, :percent-email 0.0, :percent-state 0.0, :average-length 1.0}}},
:base_type :type/Text}
{:semantic_type nil,
:coercion_strategy nil,
:name "Percentage Invested",
:field_ref [:field 752 nil],
:effective_type :type/Text,
:id 752,
:display_name "Percentage Invested",
:fingerprint
{:global {:distinct-count 89, :nil% 0.0},
:type
{:type/Text
{:percent-json 0.0, :percent-url 0.0, :percent-email 0.0, :percent-state 0.0, :average-length 1.129}}},
:base_type :type/Text}
{:semantic_type :type/Category,
:coercion_strategy nil,
:name "Exempt from Registration",
:field_ref [:field 754 nil],
:effective_type :type/Text,
:id 754,
:display_name "Exempt From Registration",
:fingerprint
{:global {:distinct-count 3, :nil% 0.0},
:type
{:type/Text {:percent-json 0.0, :percent-url 0.0, :percent-email 0.0, :percent-state 0.0, :average-length 1.0}}},
:base_type :type/Text}
{:semantic_type :type/Category,
:coercion_strategy nil,
:name "Annual Audit",
:field_ref [:field 751 nil],
:effective_type :type/Text,
:id 751,
:display_name "Annual Audit",
:fingerprint
{:global {:distinct-count 2, :nil% 0.0},
:type
{:type/Text {:percent-json 0.0, :percent-url 0.0, :percent-email 0.0, :percent-state 0.0, :average-length 1.0}}},
:base_type :type/Text}
{:semantic_type :type/Category,
:coercion_strategy nil,
:name "GAAP",
:field_ref [:field 776 nil],
:effective_type :type/Text,
:id 776,
:display_name "Gaap",
:fingerprint
{:global {:distinct-count 3, :nil% 0.0},
:type
{:type/Text
{:percent-json 0.0, :percent-url 0.0, :percent-email 0.0, :percent-state 0.0, :average-length 0.9683}}},
:base_type :type/Text}
{:semantic_type :type/Category,
:coercion_strategy nil,
:name "FS Distributed",
:field_ref [:field 770 nil],
:effective_type :type/Text,
:id 770,
:display_name "Fs Distributed",
:fingerprint
{:global {:distinct-count 3, :nil% 0.0},
:type
{:type/Text
{:percent-json 0.0, :percent-url 0.0, :percent-email 0.0, :percent-state 0.0, :average-length 0.9427}}},
:base_type :type/Text}
{:semantic_type :type/Category,
:coercion_strategy nil,
:name "Unqualified Opinion",
:field_ref [:field 774 nil],
:effective_type :type/Text,
:id 774,
:display_name "Unqualified Opinion",
:fingerprint
{:global {:distinct-count 5, :nil% 0.0},
:type
{:type/Text
{:percent-json 0.0, :percent-url 0.0, :percent-email 0.0, :percent-state 0.0, :average-length 6.7115}}},
:base_type :type/Text}
{:semantic_type :type/Category,
:coercion_strategy nil,
:name "Prime Brokers",
:field_ref [:field 766 nil],
:effective_type :type/Text,
:id 766,
:display_name "Prime Brokers",
:fingerprint
{:global {:distinct-count 3, :nil% 0.0},
:type
{:type/Text
{:percent-json 0.0, :percent-url 0.0, :percent-email 0.0, :percent-state 0.0, :average-length 1.0004}}},
:base_type :type/Text}
{:semantic_type :type/Category,
:coercion_strategy nil,
:name "Custodians",
:field_ref [:field 767 nil],
:effective_type :type/Text,
:id 767,
:display_name "Custodians",
:fingerprint
{:global {:distinct-count 2, :nil% 0.0},
:type
{:type/Text {:percent-json 0.0, :percent-url 0.0, :percent-email 0.0, :percent-state 0.0, :average-length 1.0}}},
:base_type :type/Text}
{:semantic_type :type/Category,
:coercion_strategy nil,
:name "Administrator",
:field_ref [:field 759 nil],
:effective_type :type/Text,
:id 759,
:display_name "Administrator",
:fingerprint
{:global {:distinct-count 2, :nil% 0.0},
:type
{:type/Text {:percent-json 0.0, :percent-url 0.0, :percent-email 0.0, :percent-state 0.0, :average-length 1.0}}},
:base_type :type/Text}
{:semantic_type nil,
:coercion_strategy nil,
:name "% Assets Valued",
:field_ref [:field 765 nil],
:effective_type :type/Text,
:id 765,
:display_name "% Assets Valued",
:fingerprint
{:global {:distinct-count 77, :nil% 0.0},
:type
{:type/Text
{:percent-json 0.0, :percent-url 0.0, :percent-email 0.0, :percent-state 0.0, :average-length 1.4647}}},
:base_type :type/Text}
{:semantic_type :type/Category,
:coercion_strategy nil,
:name "Marketing",
:field_ref [:field 771 nil],
:effective_type :type/Text,
:id 771,
:display_name "Marketing",
:fingerprint
{:global {:distinct-count 4, :nil% 0.0},
:type
{:type/Text
{:percent-json 0.0, :percent-url 0.0, :percent-email 0.0, :percent-state 0.0, :average-length 1.0002}}},
:base_type :type/Text}
{:name "FilingReferenceID",
:display_name "FilingReferenceID",
:base_type :type/Text,
:effective_type :type/Text,
:field_ref [:expression "FilingReferenceID"],
:semantic_type nil,
:fingerprint
{:global {:distinct-count 2000, :nil% 0.0},
:type
{:type/Text
{:percent-json 0.0, :percent-url 0.0, :percent-email 0.0, :percent-state 0.0, :average-length 10.963}}}}],
:fields
[[:field 773 nil]
[:field 772 nil]
[:field 764 nil]
[:field 745 nil]
[:field 762 nil]
[:field 750 nil]
[:field 761 nil]
[:field 753 nil]
[:field 778 nil]
[:field 755 nil]
[:field 769 nil]
[:field 763 nil]
[:field 748 nil]
[:field 747 nil]
[:field 746 nil]
[:field 757 nil]
[:field 781 nil]
[:field 749 nil]
[:field 756 nil]
[:field 775 nil]
[:field 780 nil]
[:field 777 nil]
[:field 779 nil]
[:field 768 nil]
[:field 760 nil]
[:field 758 nil]
[:field 752 nil]
[:field 754 nil]
[:field 751 nil]
[:field 776 nil]
[:field 770 nil]
[:field 774 nil]
[:field 766 nil]
[:field 767 nil]
[:field 759 nil]
[:field 765 nil]
[:field 771 nil]
[:field "FilingReferenceID" {:base-type :type/Text}]
[:field 880 {:join-alias "Question 19"}]
[:field 872 {:join-alias "Question 19"}]
[:field 875 {:join-alias "Question 19"}]
[:field 879 {:join-alias "Question 19"}]
[:field 876 {:join-alias "Question 19"}]
[:field 873 {:join-alias "Question 19"}]
[:field 874 {:join-alias "Question 19"}]
[:field 877 {:join-alias "Question 19"}]
[:field 878 {:join-alias "Question 19"}]
[:field "FilingReferenceID" {:base-type :type/Text, :join-alias "Question 19"}]],
:joins
[{:strategy :left-join,
:condition
[:=
[:field "FilingReferenceID" {:base-type :type/Text}]
[:field "FilingReferenceID" {:base-type :type/Text, :join-alias "Question 19"}]],
:alias "Question 19",
:source-query {:source-table 92, :expressions {:FilingReferenceID [:concat [:field 880 nil] [:field 872 nil]]}},
:source-metadata
[{:semantic_type nil,
:coercion_strategy nil,
:name "FilingID",
:field_ref [:field 880 nil],
:effective_type :type/BigInteger,
:id 880,
:display_name "FilingID",
:fingerprint
{:global {:distinct-count 3002, :nil% 0.0},
:type
{:type/Text
{:percent-json 0.0, :percent-url 0.0, :percent-email 0.0, :percent-state 0.0, :average-length 6.1288}}},
:base_type :type/BigInteger}
{:semantic_type nil,
:coercion_strategy nil,
:name "ReferenceID",
:field_ref [:field 872 nil],
:effective_type :type/BigInteger,
:id 872,
:display_name "ReferenceID",
:fingerprint
{:global {:distinct-count 2581, :nil% 0.0},
:type
{:type/Text
{:percent-json 0.0, :percent-url 0.0, :percent-email 0.0, :percent-state 0.0, :average-length 5.0044}}},
:base_type :type/BigInteger}
{:semantic_type nil,
:coercion_strategy nil,
:name "Name of Prime Broker",
:field_ref [:field 875 nil],
:effective_type :type/Text,
:id 875,
:display_name "Name Of Prime Broker",
:fingerprint
{:global {:distinct-count 468, :nil% 0.0},
:type
{:type/Text
{:percent-json 0.0, :percent-url 0.0, :percent-email 0.0, :percent-state 0.0, :average-length 25.8162}}},
:base_type :type/Text}
{:semantic_type nil,
:coercion_strategy nil,
:name "SEC Number",
:field_ref [:field 879 nil],
:effective_type :type/Text,
:id 879,
:display_name "Sec Number",
:fingerprint
{:global {:distinct-count 132, :nil% 0.0},
:type
{:type/Text
{:percent-json 0.0, :percent-url 0.0, :percent-email 0.0, :percent-state 0.0, :average-length 3.0474}}},
:base_type :type/Text}
{:semantic_type nil,
:coercion_strategy nil,
:name "CRD Number",
:field_ref [:field 876 nil],
:effective_type :type/Text,
:id 876,
:display_name "Crd Number",
:fingerprint
{:global {:distinct-count 119, :nil% 0.0},
:type
{:type/Text
{:percent-json 0.0, :percent-url 0.0, :percent-email 0.0, :percent-state 0.0, :average-length 2.0301}}},
:base_type :type/Text}
{:semantic_type :type/City,
:coercion_strategy nil,
:name "City",
:field_ref [:field 873 nil],
:effective_type :type/Text,
:id 873,
:display_name "City",
:fingerprint
{:global {:distinct-count 132, :nil% 0.0},
:type
{:type/Text
{:percent-json 0.0, :percent-url 0.0, :percent-email 0.0, :percent-state 0.3111, :average-length 7.7851}}},
:base_type :type/Text}
{:semantic_type nil,
:coercion_strategy nil,
:name "State",
:field_ref [:field 874 nil],
:effective_type :type/Text,
:id 874,
:display_name "State",
:fingerprint
{:global {:distinct-count 31, :nil% 0.0},
:type
{:type/Text
{:percent-json 0.0, :percent-url 0.0, :percent-email 0.0, :percent-state 0.5185, :average-length 4.47}}},
:base_type :type/Text}
{:semantic_type :type/Country,
:coercion_strategy nil,
:name "Country",
:field_ref [:field 877 nil],
:effective_type :type/Text,
:id 877,
:display_name "Country",
:fingerprint
{:global {:distinct-count 45, :nil% 0.0},
:type
{:type/Text
{:percent-json 0.0, :percent-url 0.0, :percent-email 0.0, :percent-state 0.0, :average-length 12.9723}}},
:base_type :type/Text}
{:semantic_type :type/Category,
:coercion_strategy nil,
:name "Custodian",
:field_ref [:field 878 nil],
:effective_type :type/Text,
:id 878,
:display_name "Custodian",
:fingerprint
{:global {:distinct-count 2, :nil% 0.0},
:type
{:type/Text
{:percent-json 0.0, :percent-url 0.0, :percent-email 0.0, :percent-state 0.0, :average-length 1.0}}},
:base_type :type/Text}
{:name "FilingReferenceID",
:display_name "FilingReferenceID",
:base_type :type/Text,
:effective_type :type/Text,
:field_ref [:expression "FilingReferenceID"],
:semantic_type nil,
:fingerprint
{:global {:distinct-count 1245, :nil% 0.0},
:type
{:type/Text
{:percent-json 0.0, :percent-url 0.0, :percent-email 0.0, :percent-state 0.0, :average-length 10.9485}}}}]}],
:source-query
{:source-table 84,
:expressions {:FilingReferenceID [:concat [:field 773 nil] [:field 745 nil]]},
:fields
[[:field 773 nil]
[:field 772 nil]
[:field 764 nil]
[:field 745 nil]
[:field 762 nil]
[:field 750 nil]
[:field 761 nil]
[:field 753 nil]
[:field 778 nil]
[:field 755 nil]
[:field 769 nil]
[:field 763 nil]
[:field 748 nil]
[:field 747 nil]
[:field 746 nil]
[:field 757 nil]
[:field 781 nil]
[:field 749 nil]
[:field 756 nil]
[:field 775 nil]
[:field 780 nil]
[:field 777 nil]
[:field 779 nil]
[:field 768 nil]
[:field 760 nil]
[:field 758 nil]
[:field 752 nil]
[:field 754 nil]
[:field 751 nil]
[:field 776 nil]
[:field 770 nil]
[:field 774 nil]
[:field 766 nil]
[:field 767 nil]
[:field 759 nil]
[:field 765 nil]
[:field 771 nil]
[:expression "FilingReferenceID"]]},
:limit 2000},
:type :query,
:middleware {:js-int-to-string? true, :add-default-userland-constraints? true},
:info
{:executed-by 1,
:context :ad-hoc,
:card-id 18,
:nested? true,
:query-hash
[122, -118, -15, -55, -33, -26, 12, -65, -30, -34, -84, -38, 37, -107, 12, 54, 91, 34, 68, 65, 51, -64, 36, -34,
-106, 55, -54, 96, 17, -38, 63, -121]},
:constraints {:max-results 10000, :max-results-bare-rows 2000}},
:ex-data
{:type :schema.core/error,
:value
[:postgres
{:source-query
{:source-table 92, :expressions {:FilingReferenceID [:concat [:field 880 nil] [:field 872 nil]]}, :fields ()}}],
:error
[nil
(named {:source-query {:fields (named (not ("Non-empty" a-clojure.lang.LazySeq)) "Distinct, non-empty sequence of Field clauses")}} inner-query)]},
:data {:rows [], :cols []}}
[da2248af-2fb8-4d17-8d69-8ba5f189935d] 2021-12-07T11:57:15-08:00 DEBUG metabase.server.middleware.log POST /api/dataset 202 [ASYNC: completed] 1.2 s (53 DB calls) App DB connections: 0/10 Jetty threads: 4/50 (4 idle, 0 queued) (74 total active threads) Queries in flight: 0 (0 queued)
[da2248af-2fb8-4d17-8d69-8ba5f189935d] 2021-12-07T11:57:47-08:00 INFO metabase.query-processor.middleware.fetch-source-query Fetched source query from Card 18:
{:source-table 84, :expressions {:FilingReferenceID [:concat [:field 773 nil] [:field 745 nil]]}}
[da2248af-2fb8-4d17-8d69-8ba5f189935d] 2021-12-07T11:57:47-08:00 INFO metabase.query-processor.middleware.fetch-source-query Fetched source query from Card 19:
{:source-table 92, :expressions {:FilingReferenceID [:concat [:field 880 nil] [:field 872 nil]]}}
[da2248af-2fb8-4d17-8d69-8ba5f189935d] 2021-12-07T11:57:47-08:00 INFO metabase.query-processor.middleware.fetch-source-query Fetched source query from Card 18:
{:source-table 84, :expressions {:FilingReferenceID [:concat [:field 773 nil] [:field 745 nil]]}}
[da2248af-2fb8-4d17-8d69-8ba5f189935d] 2021-12-07T11:57:47-08:00 INFO metabase.query-processor.middleware.fetch-source-query Fetched source query from Card 19:
{:source-table 92, :expressions {:FilingReferenceID [:concat [:field 880 nil] [:field 872 nil]]}}
[da2248af-2fb8-4d17-8d69-8ba5f189935d] 2021-12-07T11:57:47-08:00 INFO metabase.query-processor.middleware.fetch-source-query Fetched source query from Card 18:
{:source-table 84, :expressions {:FilingReferenceID [:concat [:field 773 nil] [:field 745 nil]]}}
[da2248af-2fb8-4d17-8d69-8ba5f189935d] 2021-12-07T11:57:47-08:00 INFO metabase.query-processor.middleware.fetch-source-query Fetched source query from Card 19:
{:source-table 92, :expressions {:FilingReferenceID [:concat [:field 880 nil] [:field 872 nil]]}}
[da2248af-2fb8-4d17-8d69-8ba5f189935d] 2021-12-07T11:57:47-08:00 INFO metabase.query-processor.middleware.fetch-source-query Fetched source query from Card 18:
{:source-table 84, :expressions {:FilingReferenceID [:concat [:field 773 nil] [:field 745 nil]]}}
[da2248af-2fb8-4d17-8d69-8ba5f189935d] 2021-12-07T11:57:47-08:00 INFO metabase.query-processor.middleware.fetch-source-query Fetched source query from Card 19:
{:source-table 92, :expressions {:FilingReferenceID [:concat [:field 880 nil] [:field 872 nil]]}}
[da2248af-2fb8-4d17-8d69-8ba5f189935d] 2021-12-07T11:57:48-08:00 ERROR metabase.server.middleware.log POST /api/dataset/native 500 678.8 ms (27 DB calls)
{:via
[{:type clojure.lang.ExceptionInfo,
:message
"Input to source-aliases does not match schema: \n\n\t [nil (named {:source-query {:fields (named (not (\"Non-empty\" a-clojure.lang.LazySeq)) \"Distinct, non-empty sequence of Field clauses\")}} inner-query)] \n\n",
:data
{:type :schema.core/error,
:schema
[{:schema Any, :optional? false, :name driver}
{:schema
(conditional
clojure.core$every-pred/ep2--8612
{(optional-key :template-tags) {(constrained Str "Non-blank string") Any},
(optional-key :collection) (maybe (constrained Str "Non-blank string")),
Keyword Any,
:native Any}
clojure.core$constantly/fn--5689
(recursive #'metabase.mbql.schema/MBQLQuery)),
:optional? false,
:name inner-query}],
:value
[:postgres
{:source-query
{:source-table 92, :expressions {:FilingReferenceID [:concat [:field 880 nil] [:field 872 nil]]}, :fields ()}}],
:error
[nil
(named {:source-query {:fields (named (not ("Non-empty" a-clojure.lang.LazySeq)) "Distinct, non-empty sequence of Field clauses")}} inner-query)]},
:at [metabase.driver.sql.query_processor$fn__44696$source_aliases__44701 invoke "query_processor.clj" 1036]}],
:trace
[[metabase.driver.sql.query_processor$fn__44696$source_aliases__44701 invoke "query_processor.clj" 1036]
[metabase.driver.sql.query_processor$apply_clauses invokeStatic "query_processor.clj" 1064]
[metabase.driver.sql.query_processor$apply_clauses invoke "query_processor.clj" 1059]
[metabase.driver.sql.query_processor$mbql__GT_honeysql invokeStatic "query_processor.clj" 1101]
[metabase.driver.sql.query_processor$mbql__GT_honeysql invoke "query_processor.clj" 1098]
[metabase.driver.sql.query_processor$fn__44530 invokeStatic "query_processor.clj" 840]
[metabase.driver.sql.query_processor$fn__44530 invoke "query_processor.clj" 832]
[clojure.lang.MultiFn invoke "MultiFn.java" 234]
[metabase.driver.sql.query_processor$fn__44542$join__GT_honeysql__44535__44547$fn__44551
invoke
"query_processor.clj"
855]
[metabase.driver.sql.query_processor$fn__44542$join__GT_honeysql__44535__44547 invoke "query_processor.clj" 853]
[clojure.lang.AFn applyToHelper "AFn.java" 156]
[clojure.lang.AFn applyTo "AFn.java" 144]
[clojure.lang.AFunction$1 doInvoke "AFunction.java" 31]
[clojure.lang.RestFn invoke "RestFn.java" 421]
[clojure.lang.MultiFn invoke "MultiFn.java" 234]
[metabase.driver.sql.query_processor$fn__44564$fn__44567 invoke "query_processor.clj" 869]
[clojure.lang.PersistentVector reduce "PersistentVector.java" 343]
[clojure.core$reduce invokeStatic "core.clj" 6829]
[clojure.core$reduce invoke "core.clj" 6812]
[metabase.driver.sql.query_processor$fn__44564 invokeStatic "query_processor.clj" 867]
[metabase.driver.sql.query_processor$fn__44564 invoke "query_processor.clj" 865]
[clojure.lang.MultiFn invoke "MultiFn.java" 244]
[metabase.driver.sql.query_processor$apply_top_level_clauses$fn__44624 invoke "query_processor.clj" 977]
[clojure.lang.ArraySeq reduce "ArraySeq.java" 116]
[clojure.core$reduce invokeStatic "core.clj" 6829]
[clojure.core$reduce invoke "core.clj" 6812]
[metabase.driver.sql.query_processor$apply_top_level_clauses invokeStatic "query_processor.clj" 975]
[metabase.driver.sql.query_processor$apply_top_level_clauses invoke "query_processor.clj" 971]
[metabase.driver.sql.query_processor$apply_clauses_with_aliased_source_query_table
invokeStatic
"query_processor.clj"
1013]
[metabase.driver.sql.query_processor$apply_clauses_with_aliased_source_query_table invoke "query_processor.clj" 1007]
[metabase.driver.sql.query_processor$apply_clauses invokeStatic "query_processor.clj" 1066]
[metabase.driver.sql.query_processor$apply_clauses invoke "query_processor.clj" 1059]
[metabase.driver.sql.query_processor$mbql__GT_honeysql invokeStatic "query_processor.clj" 1101]
[metabase.driver.sql.query_processor$mbql__GT_honeysql invoke "query_processor.clj" 1098]
[metabase.driver.sql.query_processor$mbql__GT_native invokeStatic "query_processor.clj" 1112]
[metabase.driver.sql.query_processor$mbql__GT_native invoke "query_processor.clj" 1109]
[metabase.driver.sql$fn__81661 invokeStatic "sql.clj" 40]
[metabase.driver.sql$fn__81661 invoke "sql.clj" 38]
[clojure.lang.MultiFn invoke "MultiFn.java" 234]
[metabase.query_processor.middleware.mbql_to_native$query__GT_native_form invokeStatic "mbql_to_native.clj" 14]
[metabase.query_processor.middleware.mbql_to_native$query__GT_native_form invoke "mbql_to_native.clj" 9]
[metabase.query_processor.middleware.mbql_to_native$mbql__GT_native$fn__49090 invoke "mbql_to_native.clj" 22]
[metabase.query_processor.middleware.check_features$check_features$fn__49576 invoke "check_features.clj" 39]
[metabase.query_processor.middleware.limit$limit$fn__47463 invoke "limit.clj" 37]
[metabase.query_processor.middleware.cache$maybe_return_cached_results$fn__49950 invoke "cache.clj" 204]
[metabase.query_processor.middleware.optimize_temporal_filters$optimize_temporal_filters$fn__50943
invoke
"optimize_temporal_filters.clj"
204]
[metabase.query_processor.middleware.validate_temporal_bucketing$validate_temporal_bucketing$fn__50987
invoke
"validate_temporal_bucketing.clj"
50]
[metabase.query_processor.middleware.auto_parse_filter_values$auto_parse_filter_values$fn__49147
invoke
"auto_parse_filter_values.clj"
43]
[metabase.query_processor.middleware.wrap_value_literals$wrap_value_literals$fn__39249
invoke
"wrap_value_literals.clj"
161]
[metabase.query_processor.middleware.annotate$add_column_info$fn__43680 invoke "annotate.clj" 615]
[metabase.query_processor.middleware.permissions$check_query_permissions$fn__45618 invoke "permissions.clj" 108]
[metabase.query_processor.middleware.pre_alias_aggregations$pre_alias_aggregations$fn__50127
invoke
"pre_alias_aggregations.clj"
40]
[metabase.query_processor.middleware.cumulative_aggregations$handle_cumulative_aggregations$fn__46016
invoke
"cumulative_aggregations.clj"
60]
[metabase.query_processor.middleware.visualization_settings$update_viz_settings$fn__45954
invoke
"visualization_settings.clj"
63]
[metabase.query_processor.middleware.resolve_joined_fields$resolve_joined_fields$fn__47061
invoke
"resolve_joined_fields.clj"
102]
[metabase.query_processor.middleware.resolve_joins$resolve_joins$fn__50713 invoke "resolve_joins.clj" 171]
[metabase.query_processor.middleware.add_implicit_joins$add_implicit_joins$fn__50249
invoke
"add_implicit_joins.clj"
190]
[metabase.query_processor.middleware.large_int_id$convert_id_to_string$fn__47080 invoke "large_int_id.clj" 59]
[metabase.query_processor.middleware.format_rows$format_rows$fn__50301 invoke "format_rows.clj" 74]
[metabase.query_processor.middleware.add_default_temporal_unit$add_default_temporal_unit$fn__46452
invoke
"add_default_temporal_unit.clj"
23]
[metabase.query_processor.middleware.desugar$desugar$fn__45927 invoke "desugar.clj" 21]
[metabase.query_processor.middleware.binning$update_binning_strategy$fn__39149 invoke "binning.clj" 229]
[metabase.query_processor.middleware.resolve_fields$resolve_fields$fn__45261 invoke "resolve_fields.clj" 34]
[metabase.query_processor.middleware.add_dimension_projections$add_remapping$fn__49502
invoke
"add_dimension_projections.clj"
314]
[metabase.query_processor.middleware.add_implicit_clauses$add_implicit_clauses$fn__49799
invoke
"add_implicit_clauses.clj"
147]
[metabase.query_processor.middleware.upgrade_field_literals$upgrade_field_literals$fn__47448
invoke
"upgrade_field_literals.clj"
40]
[metabase.query_processor.middleware.add_source_metadata$add_source_metadata_for_source_queries$fn__46829
invoke
"add_source_metadata.clj"
123]
[metabase.query_processor.middleware.reconcile_breakout_and_order_by_bucketing$reconcile_breakout_and_order_by_bucketing$fn__50049
invoke
"reconcile_breakout_and_order_by_bucketing.clj"
100]
[metabase.query_processor.middleware.auto_bucket_datetimes$auto_bucket_datetimes$fn__48399
invoke
"auto_bucket_datetimes.clj"
147]
[metabase.query_processor.middleware.resolve_source_table$resolve_source_tables$fn__45242
invoke
"resolve_source_table.clj"
45]
[metabase.query_processor.middleware.parameters$substitute_parameters$fn__48053 invoke "parameters.clj" 111]
[metabase.query_processor.middleware.resolve_referenced$resolve_referenced_card_resources$fn__45315
invoke
"resolve_referenced.clj"
79]
[metabase.query_processor.middleware.expand_macros$expand_macros$fn__51371 invoke "expand_macros.clj" 184]
[metabase.query_processor.middleware.add_timezone_info$add_timezone_info$fn__47832 invoke "add_timezone_info.clj" 15]
[metabase.query_processor.middleware.splice_params_in_response$splice_params_in_response$fn__50316
invoke
"splice_params_in_response.clj"
32]
[metabase.query_processor.middleware.resolve_database_and_driver$resolve_database_and_driver$fn__49810$fn__49814
invoke
"resolve_database_and_driver.clj"
31]
[metabase.driver$do_with_driver invokeStatic "driver.clj" 60]
[metabase.driver$do_with_driver invoke "driver.clj" 56]
[metabase.query_processor.middleware.resolve_database_and_driver$resolve_database_and_driver$fn__49810
invoke
"resolve_database_and_driver.clj"
25]
[metabase.query_processor.middleware.fetch_source_query$resolve_card_id_source_tables$fn__45865
invoke
"fetch_source_query.clj"
273]
[metabase.query_processor.middleware.store$initialize_store$fn__46053$fn__46054 invoke "store.clj" 11]
[metabase.query_processor.store$do_with_store invokeStatic "store.clj" 44]
[metabase.query_processor.store$do_with_store invoke "store.clj" 38]
[metabase.query_processor.middleware.store$initialize_store$fn__46053 invoke "store.clj" 10]
[metabase.query_processor.middleware.validate$validate_query$fn__50099 invoke "validate.clj" 10]
[metabase.query_processor.middleware.normalize_query$normalize$fn__50106 invoke "normalize_query.clj" 22]
[metabase.query_processor.middleware.add_rows_truncated$add_rows_truncated$fn__47778
invoke
"add_rows_truncated.clj"
35]
[metabase.query_processor.middleware.results_metadata$record_and_return_metadata_BANG_$fn__49076
invoke
"results_metadata.clj"
147]
[metabase.query_processor.reducible$async_qp$qp_STAR___42500$thunk__42501 invoke "reducible.clj" 103]
[metabase.query_processor.reducible$async_qp$qp_STAR___42500 invoke "reducible.clj" 109]
[metabase.query_processor.reducible$sync_qp$qp_STAR___42509$fn__42512 invoke "reducible.clj" 135]
[metabase.query_processor.reducible$sync_qp$qp_STAR___42509 invoke "reducible.clj" 134]
[metabase.query_processor$preprocess_query invokeStatic "query_processor.clj" 168]
[metabase.query_processor$preprocess_query invoke "query_processor.clj" 160]
[metabase.query_processor$query__GT_native invokeStatic "query_processor.clj" 199]
[metabase.query_processor$query__GT_native invoke "query_processor.clj" 195]
[metabase.query_processor$query__GT_native_with_spliced_params invokeStatic "query_processor.clj" 212]
[metabase.query_processor$query__GT_native_with_spliced_params invoke "query_processor.clj" 203]
[metabase.api.dataset$fn__57857 invokeStatic "dataset.clj" 149]
[metabase.api.dataset$fn__57857 invoke "dataset.clj" 145]
[compojure.core$wrap_response$fn__32066 invoke "core.clj" 160]
[compojure.core$wrap_route_middleware$fn__32050 invoke "core.clj" 132]
[compojure.core$wrap_route_info$fn__32055 invoke "core.clj" 139]
[compojure.core$wrap_route_matches$fn__32059 invoke "core.clj" 151]
[compojure.core$routes$fn__32078$f__32079 invoke "core.clj" 198]
[compojure.core$routes$fn__32078$f__32079$respond_SINGLEQUOTE___32080 invoke "core.clj" 197]
[compojure.core$wrap_route_matches$fn__32059 invoke "core.clj" 152]
[compojure.core$routes$fn__32078$f__32079 invoke "core.clj" 198]
[compojure.core$routes$fn__32078$f__32079$respond_SINGLEQUOTE___32080 invoke "core.clj" 197]
[compojure.core$wrap_route_matches$fn__32059 invoke "core.clj" 152]
[compojure.core$routes$fn__32078$f__32079 invoke "core.clj" 198]
[compojure.core$routes$fn__32078$f__32079$respond_SINGLEQUOTE___32080 invoke "core.clj" 197]
[compojure.core$wrap_route_matches$fn__32059 invoke "core.clj" 152]
[compojure.core$routes$fn__32078$f__32079 invoke "core.clj" 198]
[compojure.core$routes$fn__32078 invoke "core.clj" 200]
[metabase.server.middleware.auth$enforce_authentication$fn__70282 invoke "auth.clj" 14]
[compojure.core$routes$fn__32078$f__32079 invoke "core.clj" 198]
[compojure.core$routes$fn__32078 invoke "core.clj" 200]
[compojure.core$make_context$handler__32106 invoke "core.clj" 289]
[compojure.core$make_context$fn__32110 invoke "core.clj" 299]
[compojure.core$routes$fn__32078$f__32079 invoke "core.clj" 198]
[compojure.core$routes$fn__32078$f__32079$respond_SINGLEQUOTE___32080 invoke "core.clj" 197]
[compojure.core$make_context$fn__32110 invoke "core.clj" 300]
[compojure.core$routes$fn__32078$f__32079 invoke "core.clj" 198]
[compojure.core$routes$fn__32078$f__32079$respond_SINGLEQUOTE___32080 invoke "core.clj" 197]
[compojure.core$make_context$fn__32110 invoke "core.clj" 300]
[compojure.core$routes$fn__32078$f__32079 invoke "core.clj" 198]
[compojure.core$routes$fn__32078$f__32079$respond_SINGLEQUOTE___32080 invoke "core.clj" 197]
[compojure.core$make_context$fn__32110 invoke "core.clj" 300]
[compojure.core$routes$fn__32078$f__32079 invoke "core.clj" 198]
[compojure.core$routes$fn__32078$f__32079$respond_SINGLEQUOTE___32080 invoke "core.clj" 197]
[compojure.core$make_context$fn__32110 invoke "core.clj" 300]
[compojure.core$routes$fn__32078$f__32079 invoke "core.clj" 198]
[compojure.core$routes$fn__32078$f__32079$respond_SINGLEQUOTE___32080 invoke "core.clj" 197]
[compojure.core$make_context$fn__32110 invoke "core.clj" 300]
[compojure.core$routes$fn__32078$f__32079 invoke "core.clj" 198]
[compojure.core$routes$fn__32078$f__32079$respond_SINGLEQUOTE___32080 invoke "core.clj" 197]
[compojure.core$make_context$fn__32110 invoke "core.clj" 300]
[compojure.core$routes$fn__32078$f__32079 invoke "core.clj" 198]
[compojure.core$routes$fn__32078$f__32079$respond_SINGLEQUOTE___32080 invoke "core.clj" 197]
[compojure.core$make_context$fn__32110 invoke "core.clj" 300]
[compojure.core$routes$fn__32078$f__32079 invoke "core.clj" 198]
[compojure.core$routes$fn__32078$f__32079$respond_SINGLEQUOTE___32080 invoke "core.clj" 197]
[metabase.api.routes$fn__79759$fn__79762 invoke "routes.clj" 56]
[compojure.core$routes$fn__32078$f__32079 invoke "core.clj" 198]
[compojure.core$routes$fn__32078 invoke "core.clj" 200]
[clojure.lang.AFn applyToHelper "AFn.java" 160]
[clojure.lang.AFn applyTo "AFn.java" 144]
[clojure.core$apply invokeStatic "core.clj" 667]
[clojure.core$apply invoke "core.clj" 662]
[metabase.server.routes$fn__79904$fn__79905 doInvoke "routes.clj" 57]
[clojure.lang.RestFn invoke "RestFn.java" 436]
[compojure.core$routes$fn__32078$f__32079 invoke "core.clj" 198]
[compojure.core$routes$fn__32078 invoke "core.clj" 200]
[compojure.core$make_context$handler__32106 invoke "core.clj" 289]
[compojure.core$make_context$fn__32110 invoke "core.clj" 299]
[compojure.core$routes$fn__32078$f__32079 invoke "core.clj" 198]
[compojure.core$routes$fn__32078$f__32079$respond_SINGLEQUOTE___32080 invoke "core.clj" 197]
[compojure.core$wrap_route_matches$fn__32059 invoke "core.clj" 153]
[compojure.core$routes$fn__32078$f__32079 invoke "core.clj" 198]
[compojure.core$routes$fn__32078$f__32079$respond_SINGLEQUOTE___32080 invoke "core.clj" 197]
[compojure.core$wrap_route_matches$fn__32059 invoke "core.clj" 153]
[compojure.core$routes$fn__32078$f__32079 invoke "core.clj" 198]
[compojure.core$routes$fn__32078$f__32079$respond_SINGLEQUOTE___32080 invoke "core.clj" 197]
[compojure.core$wrap_route_matches$fn__32059 invoke "core.clj" 153]
[compojure.core$routes$fn__32078$f__32079 invoke "core.clj" 198]
[compojure.core$routes$fn__32078$f__32079$respond_SINGLEQUOTE___32080 invoke "core.clj" 197]
[metabase.server.routes$fn__79892$fn__79894 invoke "routes.clj" 41]
[compojure.core$routes$fn__32078$f__32079 invoke "core.clj" 198]
[compojure.core$routes$fn__32078 invoke "core.clj" 200]
[metabase.server.middleware.exceptions$catch_uncaught_exceptions$fn__77364 invoke "exceptions.clj" 98]
[metabase.server.middleware.exceptions$catch_api_exceptions$fn__77361 invoke "exceptions.clj" 86]
[metabase.server.middleware.log$log_api_call$fn__80359$fn__80360$fn__80361 invoke "log.clj" 209]
[metabase.driver.sql_jdbc.execute.diagnostic$do_with_diagnostic_info invokeStatic "diagnostic.clj" 15]
[metabase.driver.sql_jdbc.execute.diagnostic$do_with_diagnostic_info invoke "diagnostic.clj" 9]
[metabase.server.middleware.log$log_api_call$fn__80359$fn__80360 invoke "log.clj" 201]
[toucan.db$_do_with_call_counting invokeStatic "db.clj" 216]
[toucan.db$_do_with_call_counting invoke "db.clj" 209]
[metabase.server.middleware.log$log_api_call$fn__80359 invoke "log.clj" 200]
[metabase.server.middleware.browser_cookie$ensure_browser_id_cookie$fn__83572 invoke "browser_cookie.clj" 30]
[metabase.server.middleware.security$add_security_headers$fn__59226 invoke "security.clj" 147]
[metabase.server.middleware.json$wrap_json_body$fn__82716 invoke "json.clj" 62]
[metabase.server.middleware.json$wrap_streamed_json_response$fn__82734 invoke "json.clj" 98]
[metabase.server.middleware.offset_paging$handle_paging$fn__59250 invoke "offset_paging.clj" 42]
[ring.middleware.keyword_params$wrap_keyword_params$fn__83839 invoke "keyword_params.clj" 55]
[ring.middleware.params$wrap_params$fn__83855 invoke "params.clj" 69]
[metabase.server.middleware.misc$maybe_set_site_url$fn__34077 invoke "misc.clj" 59]
[metabase.server.middleware.session$bind_current_user$fn__44978$fn__44979 invoke "session.clj" 257]
[metabase.server.middleware.session$do_with_current_user invokeStatic "session.clj" 238]
[metabase.server.middleware.session$do_with_current_user invoke "session.clj" 230]
[metabase.server.middleware.session$bind_current_user$fn__44978 invoke "session.clj" 256]
[metabase.server.middleware.session$wrap_current_user_info$fn__44965 invoke "session.clj" 216]
[metabase.server.middleware.session$wrap_session_id$fn__44951 invoke "session.clj" 162]
[metabase.server.middleware.auth$wrap_api_key$fn__70290 invoke "auth.clj" 27]
[ring.middleware.cookies$wrap_cookies$fn__83759 invoke "cookies.clj" 216]
[metabase.server.middleware.misc$add_content_type$fn__34060 invoke "misc.clj" 27]
[metabase.server.middleware.misc$disable_streaming_buffering$fn__34085 invoke "misc.clj" 76]
[ring.middleware.gzip$wrap_gzip$fn__83801 invoke "gzip.clj" 86]
[metabase.server.middleware.misc$bind_request$fn__34088 invoke "misc.clj" 93]
[metabase.server.middleware.ssl$redirect_to_https_middleware$fn__83588 invoke "ssl.clj" 38]
[metabase.server$async_proxy_handler$fn__80132 invoke "server.clj" 71]
[metabase.server.proxy$org.eclipse.jetty.server.handler.AbstractHandler$ff19274a handle nil -1]
[org.eclipse.jetty.server.handler.HandlerWrapper handle "HandlerWrapper.java" 127]
[org.eclipse.jetty.server.Server handle "Server.java" 516]
[org.eclipse.jetty.server.HttpChannel lambda$handle$1 "HttpChannel.java" 388]
[org.eclipse.jetty.server.HttpChannel dispatch "HttpChannel.java" 633]
[org.eclipse.jetty.server.HttpChannel handle "HttpChannel.java" 380]
[org.eclipse.jetty.server.HttpConnection onFillable "HttpConnection.java" 277]
[org.eclipse.jetty.io.AbstractConnection$ReadCallback succeeded "AbstractConnection.java" 311]
[org.eclipse.jetty.io.FillInterest fillable "FillInterest.java" 105]
[org.eclipse.jetty.io.ChannelEndPoint$1 run "ChannelEndPoint.java" 104]
[org.eclipse.jetty.util.thread.strategy.EatWhatYouKill runTask "EatWhatYouKill.java" 338]
[org.eclipse.jetty.util.thread.strategy.EatWhatYouKill doProduce "EatWhatYouKill.java" 315]
[org.eclipse.jetty.util.thread.strategy.EatWhatYouKill tryProduce "EatWhatYouKill.java" 173]
[org.eclipse.jetty.util.thread.strategy.EatWhatYouKill run "EatWhatYouKill.java" 131]
[org.eclipse.jetty.util.thread.ReservedThreadExecutor$ReservedThread run "ReservedThreadExecutor.java" 386]
[org.eclipse.jetty.util.thread.QueuedThreadPool runJob "QueuedThreadPool.java" 883]
[org.eclipse.jetty.util.thread.QueuedThreadPool$Runner run "QueuedThreadPool.java" 1034]
[java.lang.Thread run "Thread.java" 748]],
:cause
"Input to source-aliases does not match schema: \n\n\t [nil (named {:source-query {:fields (named (not (\"Non-empty\" a-clojure.lang.LazySeq)) \"Distinct, non-empty sequence of Field clauses\")}} inner-query)] \n\n",
:data
{:type :schema.core/error,
:schema
[{:schema Any, :optional? false, :name driver}
{:schema
(conditional
clojure.core$every-pred/ep2--8612
{(optional-key :template-tags) {(constrained Str "Non-blank string") Any},
(optional-key :collection) (maybe (constrained Str "Non-blank string")),
Keyword Any,
:native Any}
clojure.core$constantly/fn--5689
(recursive #'metabase.mbql.schema/MBQLQuery)),
:optional? false,
:name inner-query}],
:value
[:postgres
{:source-query
{:source-table 92, :expressions {:FilingReferenceID [:concat [:field 880 nil] [:field 872 nil]]}, :fields ()}}],
:error
[nil
(named {:source-query {:fields (named (not ("Non-empty" a-clojure.lang.LazySeq)) "Distinct, non-empty sequence of Field clauses")}} inner-query)]},
:message
"Input to source-aliases does not match schema: \n\n\t [nil (named {:source-query {:fields (named (not (\"Non-empty\" a-clojure.lang.LazySeq)) \"Distinct, non-empty sequence of Field clauses\")}} inner-query)] \n\n",
:value
[:postgres
{:source-query
{:source-table 92, :expressions {:FilingReferenceID [:concat [:field 880 nil] [:field 872 nil]]}, :fields ()}}],
:error
[nil
(named {:source-query {:fields (named (not ("Non-empty" a-clojure.lang.LazySeq)) "Distinct, non-empty sequence of Field clauses")}} inner-query)]}
```