Filter UUID

sergeydragnoel · September 5, 2022, 11:20am

Can you help me, I change the values in the column through case, since it is not tied to another table (I take the status values from the API).

.

Then I add a variable
[and {{status}}]] and I set up a filter

But it doesn't work
find

error

flamber · September 5, 2022, 11:33am

Hi @sergeydragnoel
Post "Diagnostic Info" from Admin > Troubleshooting.
Check the logs for more details - Admin > Troubleshooting > Logs.
And post the full query.

sergeydragnoel · September 5, 2022, 2:02pm

[1ab93919-cf40-452b-be73-1f963696f362] 2022-09-05T19:52:10+06:00 ERROR metabase.query-processor.middleware.catch-exceptions Ошибка обработки запроса: null
{:database_id 2,
:started_at #t "2022-09-05T13:52:10.203601Z[GMT]",
:via
[{:status :failed,
:class clojure.lang.ExceptionInfo,
:error
"Невозможно сопоставить параметры: Output of to-clause does not match schema: \n\n\t (named [nil nil (named (not (matches-some-precondition? a-java.util.UUID)) "value-or-field")] "Must be a valid instance of one of these clauses: :and, :or, :not, :<, :<=, :>, :>=, :=, :!=") \n\n",
:stacktrace
["--> driver.sql.parameters.substitute$substitute$fn__79600.invoke(substitute.clj:86)"
"driver.sql.parameters.substitute$substitute.invokeStatic(substitute.clj:83)"
"driver.sql.parameters.substitute$substitute.invoke(substitute.clj:73)"
"driver.sql$fn__80120$substitute_native_parameters__80113__80125$fn__80129.invoke(sql.clj:46)"
"driver.sql$fn__80120$substitute_native_parameters__80113__80125.invoke(sql.clj:42)"
"query_processor.middleware.parameters.native$expand_inner.invokeStatic(native.clj:39)"
"query_processor.middleware.parameters.native$expand_inner.invoke(native.clj:30)"
"query_processor.middleware.parameters$expand_one.invokeStatic(parameters.clj:49)"
"query_processor.middleware.parameters$expand_one.invoke(parameters.clj:40)"
"query_processor.middleware.parameters$expand_all$replace_49300__49301.invoke(parameters.clj:58)"
"mbql.util.match.impl$replace_in_collection$iter__20130__20134$fn__20135.invoke(impl.cljc:44)"
"mbql.util.match.impl$replace_in_collection.invokeStatic(impl.cljc:43)"
"mbql.util.match.impl$replace_in_collection.invoke(impl.cljc:38)"
"query_processor.middleware.parameters$expand_all$replace_49300__49301.invoke(parameters.clj:58)"
"query_processor.middleware.parameters$expand_all.invokeStatic(parameters.clj:58)"
"query_processor.middleware.parameters$expand_all.invoke(parameters.clj:52)"
"query_processor.middleware.parameters$expand_all.invokeStatic(parameters.clj:55)"
"query_processor.middleware.parameters$expand_all.invoke(parameters.clj:52)"
"query_processor.middleware.parameters$expand_parameters.invokeStatic(parameters.clj:76)"
"query_processor.middleware.parameters$expand_parameters.invoke(parameters.clj:72)"
"query_processor.middleware.parameters$fn__49316$substitute_parameters_STAR___49321$fn__49322.invoke(parameters.clj:81)"
"query_processor.middleware.parameters$fn__49316$substitute_parameters_STAR___49321.invoke(parameters.clj:78)"
"query_processor.middleware.parameters$substitute_parameters.invokeStatic(parameters.clj:108)"
"query_processor.middleware.parameters$substitute_parameters.invoke(parameters.clj:100)"
"query_processor$preprocess_STAR_$fn__52890.invoke(query_processor.clj:124)"
"query_processor$preprocess_STAR_.invokeStatic(query_processor.clj:122)"
"query_processor$preprocess_STAR_.invoke(query_processor.clj:117)"
"query_processor$fn__52898$combined_pre_process__52899$combined_pre_process_STAR___52900.invoke(query_processor.clj:204)"
"query_processor.middleware.resolve_database_and_driver$resolve_database_and_driver$fn__51346$fn__51351.invoke(resolve_database_and_driver.clj:35)"
"driver$do_with_driver.invokeStatic(driver.clj:75)"
"driver$do_with_driver.invoke(driver.clj:71)"
"query_processor.middleware.resolve_database_and_driver$resolve_database_and_driver$fn__51346.invoke(resolve_database_and_driver.clj:34)"
"query_processor.middleware.fetch_source_query$resolve_card_id_source_tables$fn__47451.invoke(fetch_source_query.clj:281)"
"query_processor.middleware.store$initialize_store$fn__47639$fn__47640.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__47639.invoke(store.clj:10)"
"query_processor.middleware.normalize_query$normalize$fn__51618.invoke(normalize_query.clj:22)"
"query_processor.middleware.constraints$add_default_userland_constraints$fn__48708.invoke(constraints.clj:52)"
"query_processor.middleware.process_userland_query$process_userland_query$fn__51557.invoke(process_userland_query.clj:145)"
"query_processor.middleware.catch_exceptions$catch_exceptions$fn__51929.invoke(catch_exceptions.clj:162)"
"query_processor.reducible$async_qp$qp_STAR___44179$thunk__44181.invoke(reducible.clj:100)"
"query_processor.reducible$async_qp$qp_STAR___44179$fn__44183.invoke(reducible.clj:105)"],
:error_type :invalid-query,
:ex-data
{:type :schema.core/error,
:params
{"AutorText"
(metabase.driver.common.parameters/map->FieldFilter
{:field
{:description nil,
:database_type "nvarchar",
:semantic_type :type/Name,
:table_id 737,
:coercion_strategy nil,
:name "FullName",
:settings nil,
:effective_type :type/Text,
:nfc_path nil,
:parent_id nil,
:id 5762,
:visibility_type :normal,
:display_name "FullName",
:fingerprint
{:global {:distinct-count 1000, :nil% 0.0},
:type
{:type/Text
{:percent-json 0.0,
:percent-url 0.0,
:percent-email 0.0,
:percent-state 0.0,
:average-length 15.198039215686274}}},
:base_type :type/Text},
:value :metabase.driver.common.parameters/no-value}),
"ExecutorText"
(metabase.driver.common.parameters/map->FieldFilter
{:field
{:description nil,
:database_type "nvarchar",
:semantic_type :type/Name,
:table_id 215,
:coercion_strategy nil,
:name "FullName",
:settings nil,
:effective_type :type/Text,
:nfc_path nil,
:parent_id nil,
:id 1940,
:visibility_type :normal,
:display_name "FullName",
:fingerprint
{:global {:distinct-count 993, :nil% 0.0},
:type
{:type/Text
{:percent-json 0.0,
:percent-url 0.0,
:percent-email 0.0,
:percent-state 0.0,
:average-length 15.20335636722606}}},
:base_type :type/Text},
:value :metabase.driver.common.parameters/no-value}),
"CreationDateDate"
(metabase.driver.common.parameters/map->FieldFilter
{:field
{:description nil,
:database_type "datetime",
:semantic_type nil,
:table_id 687,
:coercion_strategy nil,
:name "CreationDate",
:settings nil,
:effective_type :type/DateTime,
:nfc_path nil,
:parent_id nil,
:id 5531,
:visibility_type :normal,
:display_name "CreationDate",
:fingerprint
{:global {:distinct-count 7388, :nil% 0.0},
:type {:type/DateTime {:earliest "2020-12-23T12:41:45.897Z", :latest "2022-08-30T13:10:11.047Z"}}},
:base_type :type/DateTime},
:value :metabase.driver.common.parameters/no-value}),
"ProcessText"
(metabase.driver.common.parameters/map->FieldFilter
{:field
{:description nil,
:database_type "nvarchar",
:semantic_type :type/Name,
:table_id 395,
:coercion_strategy nil,
:name "Name",
:settings nil,
:effective_type :type/Text,
:nfc_path nil,
:parent_id nil,
:id 3250,
:visibility_type :normal,
:display_name "Name",
:fingerprint
{:global {:distinct-count 48, :nil% 0.0},
:type
{:type/Text
{:percent-json 0.0,
:percent-url 0.0,
:percent-email 0.0,
:percent-state 0.0,
:average-length 27.612176814011676}}},
:base_type :type/Text},
:value :metabase.driver.common.parameters/no-value}),
"SubjectText"
(metabase.driver.common.parameters/map->FieldFilter
{:field
{:description nil,
:database_type "nvarchar",
:semantic_type nil,
:table_id 687,
:coercion_strategy nil,
:name "Subject",
:settings nil,
:effective_type :type/Text,
:nfc_path nil,
:parent_id nil,
:id 5532,
:visibility_type :normal,
:display_name "Subject",
:fingerprint
{:global {:distinct-count 127, :nil% 0.0},
:type
{:type/Text
{:percent-json 0.0, :percent-url 0.0, :percent-email 0.0, :percent-state 0.0, :average-length 21.4238}}},
:base_type :type/Text},
:value :metabase.driver.common.parameters/no-value}),
"status"
(metabase.driver.common.parameters/map->FieldFilter
{:field
{:description nil,
:database_type "uniqueidentifier",
:semantic_type :type/Category,
:table_id 687,
:coercion_strategy nil,
:name "Status",
:settings nil,
:effective_type :type/UUID,
:nfc_path nil,
:parent_id nil,
:id 5525,
:visibility_type :normal,
:display_name "Status",
:fingerprint
{:global {:distinct-count 6, :nil% 0.0},
:type
{:type/Text
{:percent-json 0.0, :percent-url 0.0, :percent-email 0.0, :percent-state 0.0, :average-length 36.0}}},
:base_type :type/UUID},
:value
{:type :string/=,
:value [#uuid "34387afa-6b70-476f-9d34-748732059003"],
:id "1c3bfc3f-f75d-b50f-b07a-a1d3afa69d9e"}})},
:parsed-query
["SELECT \nTaskBase.[Id] as "№",\nWorkflowProcess.[Name] as "Процесс",\nTaskBase.[Subject] as "Задача",\nTaskBase.[CreationDate] as "Дата создания задачи",\n/TaskBase.[StartDate] as "Дата начала задачи",/\nTaskBase.[StartWorkDate] as "Дата начала работы задачи",\nTaskBase.[EndDate] as "Срок завершения задачи",\nTaskBase.[EndWorkDate] as "Когда завершил",\n\n(CASE \nWHEN "dbo"."TaskBase"."Status" = '34387afa-6b70-476f-9d34-748732059003' THEN 'Новая' \nWHEN "dbo"."TaskBase"."Status" = 'dd048b73-4e08-404a-b62e-c55222845cc4' THEN 'Выполнено' \nWHEN "dbo"."TaskBase"."Status" = '1710de4d-86fa-4072-951a-55ebbdcd5bf1' THEN 'Невозможно выполнить' \nWHEN "dbo"."TaskBase"."Status" = '37a184b8-a81d-4177-9eb5-4ebe3dfae959' THEN 'Выполняется' \nWHEN "dbo"."TaskBase"."Status" = 'fd7993c6-99c7-4b23-83cc-0f576a63c144' THEN 'Закрыто' \nWHEN "dbo"."TaskBase"."Status" = '85707efe-806c-4ec6-8cd6-4d5e4edd8b19' THEN 'Прочитана' \nWHEN "dbo"."TaskBase"."Status" = '112ea757-36f7-4859-b0d3-6cc0f5a04705' THEN 'Подготовлено' \nWHEN "dbo"."TaskBase"."Status" = '46f88008-94cd-4b14-985c-31ba6edeb60e' THEN 'Выполнено и проконтролировано'\nWHEN "dbo"."TaskBase"."Status" = '2968382b-e9be-4e2f-967b-0dce0a67a4c4' THEN 'Невозможно выполнить и проконтролировано' \nWHEN "dbo"."TaskBase"."Status" = 'b9c9f74a-15ec-4337-9916-f02ffec83dd4' THEN 'На предварительном согласовании' \nWHEN "dbo"."TaskBase"."Status" = '1f6de7ff-03af-401a-a3ca-23af7cab8f65' THEN 'Отказано в предварительном согласовании' \nWHEN "dbo"."TaskBase"."Status" = 'b0b6a339-ba74-4e46-b721-2733d7fb76a9' THEN 'На согласовании' \nWHEN "dbo"."TaskBase"."Status" = '70918293-8b84-43be-ad39-181375d51373' THEN 'Отказано в согласовании' \nWHEN "dbo"."TaskBase"."Status" = '98ff43bd-b897-41f0-adf2-4eb3b3783851' THEN 'Не выполнено' \nWHEN "dbo"."TaskBase"."Status" = 'b4b74155-53c6-432f-8048-fb9a579349af' THEN 'Выполнено , нужен контроль' \nWHEN "dbo"."TaskBase"."Status" = 'e498da26-0a25-4d99-a053-01dab75db84a' THEN 'Невозможно выполнить , нужен контроль' \nELSE 'Неизвестно' \nEND )AS "Статус",\n\n"User1"."FullName" AS "Автор", -- Автор\n"User"."FullName" AS "Исполнитель", --Исполнитель\n\ncase when TaskBase.CreationDate = TaskBase.CreationDate then '1' end as "1",\ncase when TaskBase.EndWorkDate > TaskBase.EndDate then '1' \n when TaskBase.EndWorkDate < TaskBase.EndDate then '0' else '' end as "Просрочено",\ncase when TaskBase.EndWorkDate is NULL then DATEDIFF(hh,TaskBase.CreationDate,GETDATE())\nwhen TaskBase.EndWorkDate > TaskBase.EndDate then DATEDIFF(hh,TaskBase.EndDate,TaskBase.EndWorkDate)\nwhen TaskBase.EndDate is NULL then DATEDIFF(hh,TaskBase.CreationDate,TaskBase.EndWorkDate)\nelse 0\n end as 'Время выполнения в часах'\n \n\nFROM "dbo"."TaskBase"\n\nLEFT JOIN dbo.WorkflowBookmark on dbo.TaskBase.WorkflowBookmark =WorkflowBookmark.Id\nLEFT JOIN dbo.WorkflowInstance on dbo.WorkflowBookmark.Instance = WorkflowInstance.Id\nLEFT JOIN dbo.WorkflowProcess on dbo.WorkflowInstance.Process = WorkflowProcess.Id\n\nLEFT JOIN "dbo"."User1" ON "dbo"."TaskBase"."CreationAuthor" = "User1"."Id" -- Автор\nLEFT JOIN "dbo"."User" ON "dbo"."TaskBase"."Executor" ="User"."Id" --Исполнитель\n\nWHERE (TaskBase."IsEmulation" = 0\n AND (WorkflowProcess.[Name] = 'Испытательный срок'\n OR WorkflowProcess.[Name] = 'Испытательный срок (после поиска)' \n\tOR WorkflowProcess.[Name] = 'Оформление документов/получение доступов' \n\tOR WorkflowProcess.[Name] = 'Оформление после поиска' \n\tOR WorkflowProcess.[Name] = 'Оформление сотрудника' \n\tOR WorkflowProcess.[Name] = 'Подпроцесс Поиск сотрудников' \n\tOR WorkflowProcess.[Name] = 'Поиск сотрудников' \n\tOR WorkflowProcess.[Name] = 'Стажировка' \n\tOR WorkflowProcess.[Name] = 'Стажировка (после поиска)' \n\tOR WorkflowProcess.[Name] = 'Табель - учет использования рабочего времени (АУП)' \n\tOR WorkflowProcess.[Name] = 'Табеля АУП' \n\tOR WorkflowProcess.[Name] = 'Увольнение сотрудника' )\n\t "
(metabase.driver.common.parameters/->Optional
"and "
(metabase.driver.common.parameters/->Param "CreationDateDate"))
"\n \t "
(metabase.driver.common.parameters/->Optional "and " (metabase.driver.common.parameters/->Param "SubjectText"))
"\n\t "
(metabase.driver.common.parameters/->Optional "and " (metabase.driver.common.parameters/->Param "ProcessText"))
"\n\t "
(metabase.driver.common.parameters/->Optional "and " (metabase.driver.common.parameters/->Param "status"))
"\n\n\n\t "
(metabase.driver.common.parameters/->Optional "and " (metabase.driver.common.parameters/->Param "AutorText"))
" -- Автор\n\t "
(metabase.driver.common.parameters/->Optional "and " (metabase.driver.common.parameters/->Param "ExecutorText"))
"--Исполнитель\n\t )\n\n\t \nORDER BY TaskBase.[StartDate] DESC \n"]}}],
:error_type :invalid-query,
:json_query
{:constraints {:max-results 10000, :max-results-bare-rows 2000},
:type :native,
:middleware {:js-int-to-string? true, :ignore-cached-results? true, :process-viz-settings? false},
:native
{:template-tags
{"AutorText"
{:id "49c34212-81a6-8126-cab2-e6efab0eab7e",
:name "AutorText",
:display-name "Autortext",
:type :dimension,
:dimension [:field 5762 nil],
:widget-type :string/contains,
:default nil},
"ExecutorText"
{:id "50f4f2a0-5044-1a63-ef16-4346077321d4",
:name "ExecutorText",
:display-name "Executortext",
:type :dimension,
:dimension [:field 1940 nil],
:widget-type :string/contains,
:default nil},
"CreationDateDate"
{:id "b81b7ef0-74f8-f533-f762-e21d7810758e",
:name "CreationDateDate",
:display-name "Creationdatedate",
:type :dimension,
:dimension [:field 5531 nil],
:widget-type :date/relative,
:default nil},
"ProcessText"
{:id "b352251a-da92-627a-2c95-a94b7e52013a",
:name "ProcessText",
:display-name "Processtext",
:type :dimension,
:dimension [:field 3250 nil],
:widget-type :string/contains,
:default nil},
"SubjectText"
{:id "4bfc3eab-f982-60d3-a4f9-f18bc9f4b56a",
:name "SubjectText",
:display-name "Subjecttext",
:type :dimension,
:dimension [:field 5532 nil],
:widget-type :string/=,
:default nil},
"status"
{:id "1c3bfc3f-f75d-b50f-b07a-a1d3afa69d9e",
:name "status",
:display-name "Status",
:type :dimension,
:dimension [:field 5525 nil],
:widget-type :string/=,
:default nil}},
:query
"SELECT \nTaskBase.[Id] as "№",\nWorkflowProcess.[Name] as "Процесс",\nTaskBase.[Subject] as "Задача",\nTaskBase.[CreationDate] as "Дата создания задачи",\n/TaskBase.[StartDate] as "Дата начала задачи",/\nTaskBase.[StartWorkDate] as "Дата начала работы задачи",\nTaskBase.[EndDate] as "Срок завершения задачи",\nTaskBase.[EndWorkDate] as "Когда завершил",\n\n(CASE \nWHEN "dbo"."TaskBase"."Status" = '34387afa-6b70-476f-9d34-748732059003' THEN 'Новая' \nWHEN "dbo"."TaskBase"."Status" = 'dd048b73-4e08-404a-b62e-c55222845cc4' THEN 'Выполнено' \nWHEN "dbo"."TaskBase"."Status" = '1710de4d-86fa-4072-951a-55ebbdcd5bf1' THEN 'Невозможно выполнить' \nWHEN "dbo"."TaskBase"."Status" = '37a184b8-a81d-4177-9eb5-4ebe3dfae959' THEN 'Выполняется' \nWHEN "dbo"."TaskBase"."Status" = 'fd7993c6-99c7-4b23-83cc-0f576a63c144' THEN 'Закрыто' \nWHEN "dbo"."TaskBase"."Status" = '85707efe-806c-4ec6-8cd6-4d5e4edd8b19' THEN 'Прочитана' \nWHEN "dbo"."TaskBase"."Status" = '112ea757-36f7-4859-b0d3-6cc0f5a04705' THEN 'Подготовлено' \nWHEN "dbo"."TaskBase"."Status" = '46f88008-94cd-4b14-985c-31ba6edeb60e' THEN 'Выполнено и проконтролировано'\nWHEN "dbo"."TaskBase"."Status" = '2968382b-e9be-4e2f-967b-0dce0a67a4c4' THEN 'Невозможно выполнить и проконтролировано' \nWHEN "dbo"."TaskBase"."Status" = 'b9c9f74a-15ec-4337-9916-f02ffec83dd4' THEN 'На предварительном согласовании' \nWHEN "dbo"."TaskBase"."Status" = '1f6de7ff-03af-401a-a3ca-23af7cab8f65' THEN 'Отказано в предварительном согласовании' \nWHEN "dbo"."TaskBase"."Status" = 'b0b6a339-ba74-4e46-b721-2733d7fb76a9' THEN 'На согласовании' \nWHEN "dbo"."TaskBase"."Status" = '70918293-8b84-43be-ad39-181375d51373' THEN 'Отказано в согласовании' \nWHEN "dbo"."TaskBase"."Status" = '98ff43bd-b897-41f0-adf2-4eb3b3783851' THEN 'Не выполнено' \nWHEN "dbo"."TaskBase"."Status" = 'b4b74155-53c6-432f-8048-fb9a579349af' THEN 'Выполнено , нужен контроль' \nWHEN "dbo"."TaskBase"."Status" = 'e498da26-0a25-4d99-a053-01dab75db84a' THEN 'Невозможно выполнить , нужен контроль' \nELSE 'Неизвестно' \nEND )AS "Статус",\n\n"User1"."FullName" AS "Автор", -- Автор\n"User"."FullName" AS "Исполнитель", --Исполнитель\n\ncase when TaskBase.CreationDate = TaskBase.CreationDate then '1' end as "1",\ncase when TaskBase.EndWorkDate > TaskBase.EndDate then '1' \n when TaskBase.EndWorkDate < TaskBase.EndDate then '0' else '' end as "Просрочено",\ncase when TaskBase.EndWorkDate is NULL then DATEDIFF(hh,TaskBase.CreationDate,GETDATE())\nwhen TaskBase.EndWorkDate > TaskBase.EndDate then DATEDIFF(hh,TaskBase.EndDate,TaskBase.EndWorkDate)\nwhen TaskBase.EndDate is NULL then DATEDIFF(hh,TaskBase.CreationDate,TaskBase.EndWorkDate)\nelse 0\n end as 'Время выполнения в часах'\n \n\nFROM "dbo"."TaskBase"\n\nLEFT JOIN dbo.WorkflowBookmark on dbo.TaskBase.WorkflowBookmark =WorkflowBookmark.Id\nLEFT JOIN dbo.WorkflowInstance on dbo.WorkflowBookmark.Instance = WorkflowInstance.Id\nLEFT JOIN dbo.WorkflowProcess on dbo.WorkflowInstance.Process = WorkflowProcess.Id\n\nLEFT JOIN "dbo"."User1" ON "dbo"."TaskBase"."CreationAuthor" = "User1"."Id" -- Автор\nLEFT JOIN "dbo"."User" ON "dbo"."TaskBase"."Executor" ="User"."Id" --Исполнитель\n\nWHERE (TaskBase."IsEmulation" = 0\n AND (WorkflowProcess.[Name] = 'Испытательный срок'\n OR WorkflowProcess.[Name] = 'Испытательный срок (после поиска)' \n\tOR WorkflowProcess.[Name] = 'Оформление документов/получение доступов' \n\tOR WorkflowProcess.[Name] = 'Оформление после поиска' \n\tOR WorkflowProcess.[Name] = 'Оформление сотрудника' \n\tOR WorkflowProcess.[Name] = 'Подпроцесс Поиск сотрудников' \n\tOR WorkflowProcess.[Name] = 'Поиск сотрудников' \n\tOR WorkflowProcess.[Name] = 'Стажировка' \n\tOR WorkflowProcess.[Name] = 'Стажировка (после поиска)' \n\tOR WorkflowProcess.[Name] = 'Табель - учет использования рабочего времени (АУП)' \n\tOR WorkflowProcess.[Name] = 'Табеля АУП' \n\tOR WorkflowProcess.[Name] = 'Увольнение сотрудника' )\n\t [[and {{CreationDateDate}}]]\n \t [[and {{SubjectText}}]]\n\t [[and {{ProcessText}}]]\n\t [[and {{status}}]]\n\n\n\t [[and {{AutorText}}]] -- Автор\n\t [[and {{ExecutorText}}]]--Исполнитель\n\t )\n\n\t \nORDER BY TaskBase.[StartDate] DESC \n"},
:database 2,
:parameters
[{:type "string/=",
:value ["34387AFA-6B70-476F-9D34-748732059003"],
:target ["dimension" ["template-tag" "status"]],
:id "1c3bfc3f-f75d-b50f-b07a-a1d3afa69d9e"}],
:async? true,
:cache-ttl nil},
:status :failed,
:class clojure.lang.ExceptionInfo,
:stacktrace
["--> driver.common.parameters.operators$fn__49022$to_clause__49027.invoke(operators.clj:56)"
"driver.sql.parameters.substitution$fn__79332$field_filter__GT_replacement_snippet_info__79337$fn__79343.invoke(substitution.clj:267)"
"driver.sql.parameters.substitution$fn__79332$field_filter__GT_replacement_snippet_info__79337.invoke(substitution.clj:256)"
"driver.sql.parameters.substitution$fn__79363.invokeStatic(substitution.clj:301)"
"driver.sql.parameters.substitution$fn__79363.invoke(substitution.clj:286)"
"driver.sql.parameters.substitute$substitute_field_filter.invokeStatic(substitute.clj:16)"
"driver.sql.parameters.substitute$substitute_field_filter.invoke(substitute.clj:11)"
"driver.sql.parameters.substitute$substitute_param.invokeStatic(substitute.clj:33)"
"driver.sql.parameters.substitute$substitute_param.invoke(substitute.clj:27)"
"driver.sql.parameters.substitute$substitute_STAR_$fn__79591.invoke(substitute.clj:66)"
"driver.sql.parameters.substitute$substitute_STAR_.invokeStatic(substitute.clj:59)"
"driver.sql.parameters.substitute$substitute_STAR_.invoke(substitute.clj:56)"
"driver.sql.parameters.substitute$substitute_optional.invokeStatic(substitute.clj:51)"
"driver.sql.parameters.substitute$substitute_optional.invoke(substitute.clj:50)"
"driver.sql.parameters.substitute$substitute_STAR_$fn__79591.invoke(substitute.clj:69)"
"driver.sql.parameters.substitute$substitute_STAR_.invokeStatic(substitute.clj:59)"
"driver.sql.parameters.substitute$substitute_STAR_.invoke(substitute.clj:56)"
"driver.sql.parameters.substitute$substitute$fn__79600.invoke(substitute.clj:84)"
"driver.sql.parameters.substitute$substitute.invokeStatic(substitute.clj:83)"
"driver.sql.parameters.substitute$substitute.invoke(substitute.clj:73)"
"driver.sql$fn__80120$substitute_native_parameters__80113__80125$fn__80129.invoke(sql.clj:46)"
"driver.sql$fn__80120$substitute_native_parameters__80113__80125.invoke(sql.clj:42)"
"query_processor.middleware.parameters.native$expand_inner.invokeStatic(native.clj:39)"
"query_processor.middleware.parameters.native$expand_inner.invoke(native.clj:30)"
"query_processor.middleware.parameters$expand_one.invokeStatic(parameters.clj:49)"
"query_processor.middleware.parameters$expand_one.invoke(parameters.clj:40)"
"query_processor.middleware.parameters$expand_all$replace_49300__49301.invoke(parameters.clj:58)"
"mbql.util.match.impl$replace_in_collection$iter__20130__20134$fn__20135.invoke(impl.cljc:44)"
"mbql.util.match.impl$replace_in_collection.invokeStatic(impl.cljc:43)"
"mbql.util.match.impl$replace_in_collection.invoke(impl.cljc:38)"
"query_processor.middleware.parameters$expand_all$replace_49300__49301.invoke(parameters.clj:58)"
"query_processor.middleware.parameters$expand_all.invokeStatic(parameters.clj:58)"
"query_processor.middleware.parameters$expand_all.invoke(parameters.clj:52)"
"query_processor.middleware.parameters$expand_all.invokeStatic(parameters.clj:55)"
"query_processor.middleware.parameters$expand_all.invoke(parameters.clj:52)"
"query_processor.middleware.parameters$expand_parameters.invokeStatic(parameters.clj:76)"
"query_processor.middleware.parameters$expand_parameters.invoke(parameters.clj:72)"
"query_processor.middleware.parameters$fn__49316$substitute_parameters_STAR___49321$fn__49322.invoke(parameters.clj:81)"
"query_processor.middleware.parameters$fn__49316$substitute_parameters_STAR___49321.invoke(parameters.clj:78)"
"query_processor.middleware.parameters$substitute_parameters.invokeStatic(parameters.clj:108)"
"query_processor.middleware.parameters$substitute_parameters.invoke(parameters.clj:100)"
"query_processor$preprocess_STAR_$fn__52890.invoke(query_processor.clj:124)"
"query_processor$preprocess_STAR_.invokeStatic(query_processor.clj:122)"
"query_processor$preprocess_STAR_.invoke(query_processor.clj:117)"
"query_processor$fn__52898$combined_pre_process__52899$combined_pre_process_STAR___52900.invoke(query_processor.clj:204)"
"query_processor.middleware.resolve_database_and_driver$resolve_database_and_driver$fn__51346$fn__51351.invoke(resolve_database_and_driver.clj:35)"
"driver$do_with_driver.invokeStatic(driver.clj:75)"
"driver$do_with_driver.invoke(driver.clj:71)"
"query_processor.middleware.resolve_database_and_driver$resolve_database_and_driver$fn__51346.invoke(resolve_database_and_driver.clj:34)"
"query_processor.middleware.fetch_source_query$resolve_card_id_source_tables$fn__47451.invoke(fetch_source_query.clj:281)"
"query_processor.middleware.store$initialize_store$fn__47639$fn__47640.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__47639.invoke(store.clj:10)"
"query_processor.middleware.normalize_query$normalize$fn__51618.invoke(normalize_query.clj:22)"
"query_processor.middleware.constraints$add_default_userland_constraints$fn__48708.invoke(constraints.clj:52)"
"query_processor.middleware.process_userland_query$process_userland_query$fn__51557.invoke(process_userland_query.clj:145)"
"query_processor.middleware.catch_exceptions$catch_exceptions$fn__51929.invoke(catch_exceptions.clj:162)"
"query_processor.reducible$async_qp$qp_STAR___44179$thunk__44181.invoke(reducible.clj:100)"
"query_processor.reducible$async_qp$qp_STAR___44179$fn__44183.invoke(reducible.clj:105)"],
:card_id 38,
:context :question,
:error "Must be a valid instance of one of these clauses: :and, :or, :not, :<, :<=, :>, :>=, :=, :!=",
:row_count 0,
:running_time 0,
:ex-data
{:type :schema.core/error,
:value
[:=
[:field
5525
{:base-type :type/UUID,
:temporal-unit nil,
:metabase.query-processor.util.add-alias-info/source-table 687,
:metabase.driver.sql.parameters.substitution/compiling-field-filter? true}]
#uuid "34387afa-6b70-476f-9d34-748732059003"],
:error
(named [nil nil (named (not (matches-some-precondition? a-java.util.UUID)) "value-or-field")] "Must be a valid instance of one of these clauses: :and, :or, :not, :<, :<=, :>, :>=, :=, :!=")},
:data {:rows [], :cols []}}

flamber · September 5, 2022, 2:29pm

@sergeydragnoel
Post "Diagnostic Info" from Admin > Troubleshooting.
UUID columns are different from other types and need to be set as "Entity Key" in the Data Model, and then you need to set the "Filter widget type"="ID" for the Field Filter.

sergeydragnoel · September 5, 2022, 3:40pm

I'm sorry, but can you tell me where to do this? and if possible in photos

flamber · September 5, 2022, 3:47pm

@sergeydragnoel

Change the Field Type in Admin > Data Model > (db) > (Taskbase) > (Status) to "Entity Key"
https://www.metabase.com/docs/latest/data-modeling/metadata-editing
Then change the "Filter widget type" in the Variables sidebar, which is currently set to "String" - right below your Taskbase.Status selection

filter277×580 10 KB

sergeydragnoel · September 5, 2022, 4:20pm

[1ab93919-cf40-452b-be73-1f963696f362] 2022-09-05T22:06:21+06:00 ERROR metabase.query-processor.middleware.catch-exceptions Ошибка обработки запроса: null
{:database_id 2,
:started_at #t "2022-09-05T16:06:21.029690Z[GMT]",
:via
[{:status :failed,
:class clojure.lang.ExceptionInfo,
:error "Error executing query: Type uuid is not a defined system type.",
:stacktrace
["--> driver.sql_jdbc.execute$execute_reducible_query$fn__54036.invoke(execute.clj:502)"
"driver.sql_jdbc.execute$execute_reducible_query.invokeStatic(execute.clj:499)"
"driver.sql_jdbc.execute$execute_reducible_query.invoke(execute.clj:486)"
"driver.sql_jdbc.execute$execute_reducible_query.invokeStatic(execute.clj:494)"
"driver.sql_jdbc.execute$execute_reducible_query.invoke(execute.clj:486)"
"driver.sql_jdbc$fn__83394.invokeStatic(sql_jdbc.clj:54)"
"driver.sql_jdbc$fn__83394.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:67)"
"query_processor.context.default$default_runf.invoke(default.clj:65)"
"query_processor.context$runf.invokeStatic(context.clj:45)"
"query_processor.context$runf.invoke(context.clj:39)"
"query_processor.reducible$identity_qp.invokeStatic(reducible.clj:12)"
"query_processor.reducible$identity_qp.invoke(reducible.clj:9)"
"query_processor.middleware.cache$maybe_return_cached_results$maybe_return_cached_results_STAR___51425.invoke(cache.clj:220)"
"query_processor.middleware.permissions$check_query_permissions$fn__47208.invoke(permissions.clj:109)"
"query_processor.middleware.mbql_to_native$mbql__GT_native$fn__50366.invoke(mbql_to_native.clj:23)"
"query_processor$fn__52898$combined_post_process__52903$combined_post_process_STAR___52904.invoke(query_processor.clj:207)"
"query_processor$fn__52898$combined_pre_process__52899$combined_pre_process_STAR___52900.invoke(query_processor.clj:204)"
"query_processor.middleware.resolve_database_and_driver$resolve_database_and_driver$fn__51346$fn__51351.invoke(resolve_database_and_driver.clj:35)"
"driver$do_with_driver.invokeStatic(driver.clj:75)"
"driver$do_with_driver.invoke(driver.clj:71)"
"query_processor.middleware.resolve_database_and_driver$resolve_database_and_driver$fn__51346.invoke(resolve_database_and_driver.clj:34)"
"query_processor.middleware.fetch_source_query$resolve_card_id_source_tables$fn__47451.invoke(fetch_source_query.clj:281)"
"query_processor.middleware.store$initialize_store$fn__47639$fn__47640.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__47639.invoke(store.clj:10)"
"query_processor.middleware.normalize_query$normalize$fn__51618.invoke(normalize_query.clj:22)"
"query_processor.middleware.constraints$add_default_userland_constraints$fn__48708.invoke(constraints.clj:52)"
"query_processor.middleware.process_userland_query$process_userland_query$fn__51557.invoke(process_userland_query.clj:145)"
"query_processor.middleware.catch_exceptions$catch_exceptions$fn__51929.invoke(catch_exceptions.clj:162)"
"query_processor.reducible$async_qp$qp_STAR___44179$thunk__44181.invoke(reducible.clj:100)"
"query_processor.reducible$async_qp$qp_STAR___44179.invoke(reducible.clj:106)"
"query_processor.reducible$async_qp$qp_STAR___44179.invoke(reducible.clj:91)"
"query_processor.reducible$sync_qp$qp_STAR___44190.doInvoke(reducible.clj:126)"
"query_processor$process_userland_query.invokeStatic(query_processor.clj:326)"
"query_processor$process_userland_query.doInvoke(query_processor.clj:322)"
"query_processor$fn__52945$process_query_and_save_execution_BANG___52954$fn__52957.invoke(query_processor.clj:337)"
"query_processor$fn__52945$process_query_and_save_execution_BANG___52954.invoke(query_processor.clj:330)"
"query_processor$fn__52989$process_query_and_save_with_max_results_constraints_BANG___52998$fn__53001.invoke(query_processor.clj:349)"
"query_processor$fn__52989$process_query_and_save_with_max_results_constraints_BANG___52998.invoke(query_processor.clj:342)"
"api.dataset$run_query_async$fn__66603.invoke(dataset.clj:68)"
"query_processor.streaming$streaming_response_STAR_$fn__39302$fn__39303.invoke(streaming.clj:162)"
"query_processor.streaming$streaming_response_STAR_$fn__39302.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__18948.invoke(streaming_response.clj:84)"],
:error_type :invalid-query,
:ex-data
{:sql
"-- Metabase:: userID: 1 queryType: native queryHash: f8ec2618daa911f3cb058ac3cfc9f90b38a82c2ab3723fac5fa4f2f158393aa1\nSELECT \nTaskBase.[Id] as "№",\nWorkflowProcess.[Name] as "Процесс",\nTaskBase.[Subject] as "Задача",\nTaskBase.[CreationDate] as "Дата создания задачи",\n/TaskBase.[StartDate] as "Дата начала задачи",/\nTaskBase.[StartWorkDate] as "Дата начала работы задачи",\nTaskBase.[EndDate] as "Срок завершения задачи",\nTaskBase.[EndWorkDate] as "Когда завершил",\n\n(CASE \nWHEN "dbo"."TaskBase"."Status" = '34387afa-6b70-476f-9d34-748732059003' THEN 'Новая' \nWHEN "dbo"."TaskBase"."Status" = 'dd048b73-4e08-404a-b62e-c55222845cc4' THEN 'Выполнено' \nWHEN "dbo"."TaskBase"."Status" = '1710de4d-86fa-4072-951a-55ebbdcd5bf1' THEN 'Невозможно выполнить' \nWHEN "dbo"."TaskBase"."Status" = '37a184b8-a81d-4177-9eb5-4ebe3dfae959' THEN 'Выполняется' \nWHEN "dbo"."TaskBase"."Status" = 'fd7993c6-99c7-4b23-83cc-0f576a63c144' THEN 'Закрыто' \nWHEN "dbo"."TaskBase"."Status" = '85707efe-806c-4ec6-8cd6-4d5e4edd8b19' THEN 'Прочитана' \nWHEN "dbo"."TaskBase"."Status" = '112ea757-36f7-4859-b0d3-6cc0f5a04705' THEN 'Подготовлено' \nWHEN "dbo"."TaskBase"."Status" = '46f88008-94cd-4b14-985c-31ba6edeb60e' THEN 'Выполнено и проконтролировано'\nWHEN "dbo"."TaskBase"."Status" = '2968382b-e9be-4e2f-967b-0dce0a67a4c4' THEN 'Невозможно выполнить и проконтролировано' \nWHEN "dbo"."TaskBase"."Status" = 'b9c9f74a-15ec-4337-9916-f02ffec83dd4' THEN 'На предварительном согласовании' \nWHEN "dbo"."TaskBase"."Status" = '1f6de7ff-03af-401a-a3ca-23af7cab8f65' THEN 'Отказано в предварительном согласовании' \nWHEN "dbo"."TaskBase"."Status" = 'b0b6a339-ba74-4e46-b721-2733d7fb76a9' THEN 'На согласовании' \nWHEN "dbo"."TaskBase"."Status" = '70918293-8b84-43be-ad39-181375d51373' THEN 'Отказано в согласовании' \nWHEN "dbo"."TaskBase"."Status" = '98ff43bd-b897-41f0-adf2-4eb3b3783851' THEN 'Не выполнено' \nWHEN "dbo"."TaskBase"."Status" = 'b4b74155-53c6-432f-8048-fb9a579349af' THEN 'Выполнено , нужен контроль' \nWHEN "dbo"."TaskBase"."Status" = 'e498da26-0a25-4d99-a053-01dab75db84a' THEN 'Невозможно выполнить , нужен контроль' \nELSE 'Неизвестно' \nEND )AS "Статус",\nTaskBase.Status as 'статус1' ,\n\n"User1"."FullName" AS "Автор", -- Автор\n"User"."FullName" AS "Исполнитель", --Исполнитель\n\ncase when TaskBase.CreationDate = TaskBase.CreationDate then '1' end as "1",\ncase when TaskBase.EndWorkDate > TaskBase.EndDate then '1' \n when TaskBase.EndWorkDate < TaskBase.EndDate then '0' else '' end as "Просрочено",\ncase when TaskBase.EndWorkDate is NULL then DATEDIFF(hh,TaskBase.CreationDate,GETDATE())\nwhen TaskBase.EndWorkDate > TaskBase.EndDate then DATEDIFF(hh,TaskBase.EndDate,TaskBase.EndWorkDate)\nwhen TaskBase.EndDate is NULL then DATEDIFF(hh,TaskBase.CreationDate,TaskBase.EndWorkDate)\nelse 0\n end as 'Время выполнения в часах'\n \n\nFROM "dbo"."TaskBase"\n\nLEFT JOIN dbo.WorkflowBookmark on dbo.TaskBase.WorkflowBookmark =WorkflowBookmark.Id\nLEFT JOIN dbo.WorkflowInstance on dbo.WorkflowBookmark.Instance = WorkflowInstance.Id\nLEFT JOIN dbo.WorkflowProcess on dbo.WorkflowInstance.Process = WorkflowProcess.Id\n\nLEFT JOIN "dbo"."User1" ON "dbo"."TaskBase"."CreationAuthor" = "User1"."Id" -- Автор\nLEFT JOIN "dbo"."User" ON "dbo"."TaskBase"."Executor" ="User"."Id" --Исполнитель\n\nWHERE (TaskBase."IsEmulation" = 0\n AND (WorkflowProcess.[Name] = 'Испытательный срок'\n OR WorkflowProcess.[Name] = 'Испытательный срок (после поиска)' \n\tOR WorkflowProcess.[Name] = 'Оформление документов/получение доступов' \n\tOR WorkflowProcess.[Name] = 'Оформление после поиска' \n\tOR WorkflowProcess.[Name] = 'Оформление сотрудника' \n\tOR WorkflowProcess.[Name] = 'Подпроцесс Поиск сотрудников' \n\tOR WorkflowProcess.[Name] = 'Поиск сотрудников' \n\tOR WorkflowProcess.[Name] = 'Стажировка' \n\tOR WorkflowProcess.[Name] = 'Стажировка (после поиска)' \n\tOR WorkflowProcess.[Name] = 'Табель - учет использования рабочего времени (АУП)' \n\tOR WorkflowProcess.[Name] = 'Табеля АУП' \n\tOR WorkflowProcess.[Name] = 'Увольнение сотрудника' )\n\t \n \t \n\t \n\t and "dbo"."TaskBase"."Status" IN (CAST('34387afa-6b70-476f-9d34-748732059003' AS uuid))\n\n\n\t -- Автор\n\t --Исполнитель\n\t )",
:params ,
:type :invalid-query}}],
:state "S0001",
:error_type :invalid-query,
:json_query
{:database 2,
:native
{:template-tags
{:AutorText
{:id "49c34212-81a6-8126-cab2-e6efab0eab7e",
:name "AutorText",
:display-name "Autortext",
:type "dimension",
:dimension ["field" 5762 nil],
:widget-type "string/contains",
:default nil},
:ExecutorText
{:id "50f4f2a0-5044-1a63-ef16-4346077321d4",
:name "ExecutorText",
:display-name "Executortext",
:type "dimension",
:dimension ["field" 1940 nil],
:widget-type "string/contains",
:default nil},
:CreationDateDate
{:id "b81b7ef0-74f8-f533-f762-e21d7810758e",
:name "CreationDateDate",
:display-name "Creationdatedate",
:type "dimension",
:dimension ["field" 5531 nil],
:widget-type "date/relative",
:default nil},
:ProcessText
{:id "b352251a-da92-627a-2c95-a94b7e52013a",
:name "ProcessText",
:display-name "Processtext",
:type "dimension",
:dimension ["field" 3250 nil],
:widget-type "string/contains",
:default nil},
:SubjectText
{:id "4bfc3eab-f982-60d3-a4f9-f18bc9f4b56a",
:name "SubjectText",
:display-name "Subjecttext",
:type "dimension",
:dimension ["field" 5532 nil],
:widget-type "string/=",
:default nil},
:status
{:id "1c3bfc3f-f75d-b50f-b07a-a1d3afa69d9e",
:name "status",
:display-name "Status",
:type "dimension",
:dimension ["field" 5525 nil],
:widget-type "id",
:default nil}},
:query
"SELECT \nTaskBase.[Id] as "№",\nWorkflowProcess.[Name] as "Процесс",\nTaskBase.[Subject] as "Задача",\nTaskBase.[CreationDate] as "Дата создания задачи",\n/TaskBase.[StartDate] as "Дата начала задачи",/\nTaskBase.[StartWorkDate] as "Дата начала работы задачи",\nTaskBase.[EndDate] as "Срок завершения задачи",\nTaskBase.[EndWorkDate] as "Когда завершил",\n\n(CASE \nWHEN "dbo"."TaskBase"."Status" = '34387afa-6b70-476f-9d34-748732059003' THEN 'Новая' \nWHEN "dbo"."TaskBase"."Status" = 'dd048b73-4e08-404a-b62e-c55222845cc4' THEN 'Выполнено' \nWHEN "dbo"."TaskBase"."Status" = '1710de4d-86fa-4072-951a-55ebbdcd5bf1' THEN 'Невозможно выполнить' \nWHEN "dbo"."TaskBase"."Status" = '37a184b8-a81d-4177-9eb5-4ebe3dfae959' THEN 'Выполняется' \nWHEN "dbo"."TaskBase"."Status" = 'fd7993c6-99c7-4b23-83cc-0f576a63c144' THEN 'Закрыто' \nWHEN "dbo"."TaskBase"."Status" = '85707efe-806c-4ec6-8cd6-4d5e4edd8b19' THEN 'Прочитана' \nWHEN "dbo"."TaskBase"."Status" = '112ea757-36f7-4859-b0d3-6cc0f5a04705' THEN 'Подготовлено' \nWHEN "dbo"."TaskBase"."Status" = '46f88008-94cd-4b14-985c-31ba6edeb60e' THEN 'Выполнено и проконтролировано'\nWHEN "dbo"."TaskBase"."Status" = '2968382b-e9be-4e2f-967b-0dce0a67a4c4' THEN 'Невозможно выполнить и проконтролировано' \nWHEN "dbo"."TaskBase"."Status" = 'b9c9f74a-15ec-4337-9916-f02ffec83dd4' THEN 'На предварительном согласовании' \nWHEN "dbo"."TaskBase"."Status" = '1f6de7ff-03af-401a-a3ca-23af7cab8f65' THEN 'Отказано в предварительном согласовании' \nWHEN "dbo"."TaskBase"."Status" = 'b0b6a339-ba74-4e46-b721-2733d7fb76a9' THEN 'На согласовании' \nWHEN "dbo"."TaskBase"."Status" = '70918293-8b84-43be-ad39-181375d51373' THEN 'Отказано в согласовании' \nWHEN "dbo"."TaskBase"."Status" = '98ff43bd-b897-41f0-adf2-4eb3b3783851' THEN 'Не выполнено' \nWHEN "dbo"."TaskBase"."Status" = 'b4b74155-53c6-432f-8048-fb9a579349af' THEN 'Выполнено , нужен контроль' \nWHEN "dbo"."TaskBase"."Status" = 'e498da26-0a25-4d99-a053-01dab75db84a' THEN 'Невозможно выполнить , нужен контроль' \nELSE 'Неизвестно' \nEND )AS "Статус",\nTaskBase.Status as 'статус1' ,\n\n"User1"."FullName" AS "Автор", -- Автор\n"User"."FullName" AS "Исполнитель", --Исполнитель\n\ncase when TaskBase.CreationDate = TaskBase.CreationDate then '1' end as "1",\ncase when TaskBase.EndWorkDate > TaskBase.EndDate then '1' \n when TaskBase.EndWorkDate < TaskBase.EndDate then '0' else '' end as "Просрочено",\ncase when TaskBase.EndWorkDate is NULL then DATEDIFF(hh,TaskBase.CreationDate,GETDATE())\nwhen TaskBase.EndWorkDate > TaskBase.EndDate then DATEDIFF(hh,TaskBase.EndDate,TaskBase.EndWorkDate)\nwhen TaskBase.EndDate is NULL then DATEDIFF(hh,TaskBase.CreationDate,TaskBase.EndWorkDate)\nelse 0\n end as 'Время выполнения в часах'\n \n\nFROM "dbo"."TaskBase"\n\nLEFT JOIN dbo.WorkflowBookmark on dbo.TaskBase.WorkflowBookmark =WorkflowBookmark.Id\nLEFT JOIN dbo.WorkflowInstance on dbo.WorkflowBookmark.Instance = WorkflowInstance.Id\nLEFT JOIN dbo.WorkflowProcess on dbo.WorkflowInstance.Process = WorkflowProcess.Id\n\nLEFT JOIN "dbo"."User1" ON "dbo"."TaskBase"."CreationAuthor" = "User1"."Id" -- Автор\nLEFT JOIN "dbo"."User" ON "dbo"."TaskBase"."Executor" ="User"."Id" --Исполнитель\n\nWHERE (TaskBase."IsEmulation" = 0\n AND (WorkflowProcess.[Name] = 'Испытательный срок'\n OR WorkflowProcess.[Name] = 'Испытательный срок (после поиска)' \n\tOR WorkflowProcess.[Name] = 'Оформление документов/получение доступов' \n\tOR WorkflowProcess.[Name] = 'Оформление после поиска' \n\tOR WorkflowProcess.[Name] = 'Оформление сотрудника' \n\tOR WorkflowProcess.[Name] = 'Подпроцесс Поиск сотрудников' \n\tOR WorkflowProcess.[Name] = 'Поиск сотрудников' \n\tOR WorkflowProcess.[Name] = 'Стажировка' \n\tOR WorkflowProcess.[Name] = 'Стажировка (после поиска)' \n\tOR WorkflowProcess.[Name] = 'Табель - учет использования рабочего времени (АУП)' \n\tOR WorkflowProcess.[Name] = 'Табеля АУП' \n\tOR WorkflowProcess.[Name] = 'Увольнение сотрудника' )\n\t [[and {{CreationDateDate}}]]\n \t [[and {{SubjectText}}]]\n\t [[and {{ProcessText}}]]\n\t [[and {{status}}]]\n\n\n\t [[and {{AutorText}}]] -- Автор\n\t [[and {{ExecutorText}}]]--Исполнитель\n\t )\n\n"},
:type "native",
:parameters
[{:type "id",
:value ["34387AFA-6B70-476F-9D34-748732059003"],
:target ["dimension" ["template-tag" "status"]],
:id "1c3bfc3f-f75d-b50f-b07a-a1d3afa69d9e"}],
:middleware {:js-int-to-string? true, :add-default-userland-constraints? true}},
:status :failed,
:class com.microsoft.sqlserver.jdbc.SQLServerException,
:stacktrace
["com.microsoft.sqlserver.jdbc.SQLServerException.makeFromDatabaseError(SQLServerException.java:262)"
"com.microsoft.sqlserver.jdbc.SQLServerStatement.getNextResult(SQLServerStatement.java:1632)"
"com.microsoft.sqlserver.jdbc.SQLServerPreparedStatement.doExecutePreparedStatement(SQLServerPreparedStatement.java:602)"
"com.microsoft.sqlserver.jdbc.SQLServerPreparedStatement$PrepStmtExecCmd.doExecute(SQLServerPreparedStatement.java:524)"
"com.microsoft.sqlserver.jdbc.TDSCommand.execute(IOBuffer.java:7418)"
"com.microsoft.sqlserver.jdbc.SQLServerConnection.executeCommand(SQLServerConnection.java:3272)"
"com.microsoft.sqlserver.jdbc.SQLServerStatement.executeCommand(SQLServerStatement.java:247)"
"com.microsoft.sqlserver.jdbc.SQLServerStatement.executeStatement(SQLServerStatement.java:222)"
"com.microsoft.sqlserver.jdbc.SQLServerPreparedStatement.executeQuery(SQLServerPreparedStatement.java:446)"
"com.mchange.v2.c3p0.impl.NewProxyPreparedStatement.executeQuery(NewProxyPreparedStatement.java:1471)"
"--> driver.sql_jdbc.execute$fn__53954.invokeStatic(execute.clj:363)"
"driver.sql_jdbc.execute$fn__53954.invoke(execute.clj:361)"
"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:372)"
"driver.sql_jdbc.execute$execute_reducible_query$fn__54036.invoke(execute.clj:500)"
"driver.sql_jdbc.execute$execute_reducible_query.invokeStatic(execute.clj:499)"
"driver.sql_jdbc.execute$execute_reducible_query.invoke(execute.clj:486)"
"driver.sql_jdbc.execute$execute_reducible_query.invokeStatic(execute.clj:494)"
"driver.sql_jdbc.execute$execute_reducible_query.invoke(execute.clj:486)"
"driver.sql_jdbc$fn__83394.invokeStatic(sql_jdbc.clj:54)"
"driver.sql_jdbc$fn__83394.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:67)"
"query_processor.context.default$default_runf.invoke(default.clj:65)"
"query_processor.context$runf.invokeStatic(context.clj:45)"
"query_processor.context$runf.invoke(context.clj:39)"
"query_processor.reducible$identity_qp.invokeStatic(reducible.clj:12)"
"query_processor.reducible$identity_qp.invoke(reducible.clj:9)"
"query_processor.middleware.cache$maybe_return_cached_results$maybe_return_cached_results_STAR___51425.invoke(cache.clj:220)"
"query_processor.middleware.permissions$check_query_permissions$fn__47208.invoke(permissions.clj:109)"
"query_processor.middleware.mbql_to_native$mbql__GT_native$fn__50366.invoke(mbql_to_native.clj:23)"
"query_processor$fn__52898$combined_post_process__52903$combined_post_process_STAR___52904.invoke(query_processor.clj:207)"
"query_processor$fn__52898$combined_pre_process__52899$combined_pre_process_STAR___52900.invoke(query_processor.clj:204)"
"query_processor.middleware.resolve_database_and_driver$resolve_database_and_driver$fn__51346$fn__51351.invoke(resolve_database_and_driver.clj:35)"
"driver$do_with_driver.invokeStatic(driver.clj:75)"
"driver$do_with_driver.invoke(driver.clj:71)"
"query_processor.middleware.resolve_database_and_driver$resolve_database_and_driver$fn__51346.invoke(resolve_database_and_driver.clj:34)"
"query_processor.middleware.fetch_source_query$resolve_card_id_source_tables$fn__47451.invoke(fetch_source_query.clj:281)"
"query_processor.middleware.store$initialize_store$fn__47639$fn__47640.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__47639.invoke(store.clj:10)"
"query_processor.middleware.normalize_query$normalize$fn__51618.invoke(normalize_query.clj:22)"
"query_processor.middleware.constraints$add_default_userland_constraints$fn__48708.invoke(constraints.clj:52)"
"query_processor.middleware.process_userland_query$process_userland_query$fn__51557.invoke(process_userland_query.clj:145)"
"query_processor.middleware.catch_exceptions$catch_exceptions$fn__51929.invoke(catch_exceptions.clj:162)"
"query_processor.reducible$async_qp$qp_STAR___44179$thunk__44181.invoke(reducible.clj:100)"
"query_processor.reducible$async_qp$qp_STAR___44179.invoke(reducible.clj:106)"
"query_processor.reducible$async_qp$qp_STAR___44179.invoke(reducible.clj:91)"
"query_processor.reducible$sync_qp$qp_STAR___44190.doInvoke(reducible.clj:126)"
"query_processor$process_userland_query.invokeStatic(query_processor.clj:326)"
"query_processor$process_userland_query.doInvoke(query_processor.clj:322)"
"query_processor$fn__52945$process_query_and_save_execution_BANG___52954$fn__52957.invoke(query_processor.clj:337)"
"query_processor$fn__52945$process_query_and_save_execution_BANG___52954.invoke(query_processor.clj:330)"
"query_processor$fn__52989$process_query_and_save_with_max_results_constraints_BANG___52998$fn__53001.invoke(query_processor.clj:349)"
"query_processor$fn__52989$process_query_and_save_with_max_results_constraints_BANG___52998.invoke(query_processor.clj:342)"
"api.dataset$run_query_async$fn__66603.invoke(dataset.clj:68)"
"query_processor.streaming$streaming_response_STAR_$fn__39302$fn__39303.invoke(streaming.clj:162)"
"query_processor.streaming$streaming_response_STAR_$fn__39302.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__18948.invoke(streaming_response.clj:84)"],
:card_id nil,
:context :ad-hoc,
:error "Type uuid is not a defined system type.",
:row_count 0,
:running_time 0,
:data {:rows , :cols }}

flamber · September 5, 2022, 4:34pm

@sergeydragnoel Post "Diagnostic Info" from Admin > Troubleshooting.

sergeydragnoel · September 5, 2022, 4:41pm

{
"browser-info": {
"language": "ru-RU",
"platform": "Win32",
"userAgent": "Mozilla/5.0 (Windows NT 10.0; Win64; x64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/103.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.15+10",
"java.vendor": "Eclipse Adoptium",
"java.vendor.url": "https://adoptium.net/",
"java.version": "11.0.15",
"java.vm.name": "OpenJDK 64-Bit Server VM",
"java.vm.version": "11.0.15+10",
"os.name": "Linux",
"os.version": "4.4.0-210-generic",
"user.language": "en",
"user.timezone": "GMT"
},
"metabase-info": {
"databases": [
"h2",
"sqlserver"
],
"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-05-02",
"tag": "v0.43.0",
"branch": "release-x.43.x",
"hash": "ee686fc"
},
"settings": {
"report-timezone": null
}
}
}

flamber · September 5, 2022, 5:14pm

@sergeydragnoel It seems like SQL Server cannot handle this in a graceful way. You should create a View on your database, so Metabase just sees a regular table.

Separately, latest release is 0.44.2 and you should migrate away from H2 if you are using Metabase in production.
https://github.com/metabase/metabase/releases/latest
https://www.metabase.com/docs/latest/installation-and-operation/migrating-from-h2

sergeydragnoel · September 5, 2022, 5:42pm

thanks for the help and information provided.

sergeydragnoel · September 6, 2022, 3:14am

Thanks again, through the "View" everything turned out