Infos:
- Used Zammad version: 3.3.X
- Used Zammad installation source:
- Operating system: Windows 10
- Browser + version: Chrome
Expected behavior:
- A report was created to display all tickets in different statuses without agents.
It works in the preview.
Actual behavior:
- An error message appears
{“error”:“Unable to process GET request to elasticsearch URL ‘http://localhost:9200/zammad_production/Ticket/_search’. Check the response and payload for detailed information: \n\nResponse:\n#\u003cUserAgent::Result:0x00005617938db5e8 @success=false, @body="{\"error\":{\"root_cause\":[{\"type\":\"query_shard_exception\",\"reason\":\"failed to create query: {\\n \\\"bool\\\" : {\\n \\\"must\\\" : [\\n {\\n \\\"terms\\\" : {\\n \\\"state_id\\\" : [\\n \\\"8\\\",\\n \\\"1\\\",\\n \\\"2\\\",\\n \\\"3\\\"\\n ],\\n \\\"boost\\\" : 1.0\\n }\\n },\\n {\\n \\\"term\\\" : {\\n \\\"owner_id\\\" : {\\n \\\"value\\\" : \\\"\\\",\\n \\\"boost\\\" : 1.0\\n }\\n }\\n },\\n {\\n \\\"range\\\" : {\\n \\\"created_at\\\" : {\\n \\\"from\\\" : \\\"2019-12-31T23:00:00Z\\\",\\n \\\"to\\\" : \\\"2020-12-31T22:59:59Z\\\",\\n \\\"include_lower\\\" : true,\\n \\\"include_upper\\\" : true,\\n \\\"boost\\\" : 1.0\\n }\\n }\\n }\\n ],\\n \\\"must_not\\\" : [\\n {\\n \\\"term\\\" : {\\n \\\"state.keyword\\\" : {\\n \\\"value\\\" : \\\"merged\\\",\\n \\\"boost\\\" : 1.0\\n }\\n }\\n }\\n ],\\n \\\"disable_coord\\\" : false,\\n \\\"adjust_pure_negative\\\" : true,\\n \\\"boost\\\" : 1.0\\n }\\n}\",\"index_uuid\":\"br2zfHAlT_yr6Tzd6sJTow\",\"index\":\"zammad_production\"}],\"type\":\"search_phase_execution_exception\",\"reason\":\"all shards failed\",\"phase\":\"query\",\"grouped\":true,\"failed_shards\":[{\"shard\":0,\"index\":\"zammad_production\",\"node\":\"5A25Wd3kS32cobkBHA5N3g\",\"reason\":{\"type\":\"query_shard_exception\",\"reason\":\"failed to create query: {\\n \\\"bool\\\" : {\\n \\\"must\\\" : [\\n {\\n \\\"terms\\\" : {\\n \\\"state_id\\\" : [\\n \\\"8\\\",\\n \\\"1\\\",\\n \\\"2\\\",\\n \\\"3\\\"\\n ],\\n \\\"boost\\\" : 1.0\\n }\\n },\\n {\\n \\\"term\\\" : {\\n \\\"owner_id\\\" : {\\n \\\"value\\\" : \\\"\\\",\\n \\\"boost\\\" : 1.0\\n }\\n }\\n },\\n {\\n \\\"range\\\" : {\\n \\\"created_at\\\" : {\\n \\\"from\\\" : \\\"2019-12-31T23:00:00Z\\\",\\n \\\"to\\\" : \\\"2020-12-31T22:59:59Z\\\",\\n \\\"include_lower\\\" : true,\\n \\\"include_upper\\\" : true,\\n \\\"boost\\\" : 1.0\\n }\\n }\\n }\\n ],\\n \\\"must_not\\\" : [\\n {\\n \\\"term\\\" : {\\n \\\"state.keyword\\\" : {\\n \\\"value\\\" : \\\"merged\\\",\\n \\\"boost\\\" : 1.0\\n }\\n }\\n }\\n ],\\n \\\"disable_coord\\\" : false,\\n \\\"adjust_pure_negative\\\" : true,\\n \\\"boost\\\" : 1.0\\n }\\n}\",\"index_uuid\":\"br2zfHAlT_yr6Tzd6sJTow\",\"index\":\"zammad_production\",\"caused_by\":{\"type\":\"number_format_exception\",\"reason\":\"empty String\"}}}]},\"status\":400}", @data=nil, @code="400", @content_type=nil, @error="Client Error: #\u003cNet::HTTPBadRequest 400 Bad Request readbody=true\u003e!"\u003e\n\nPayload:\n{:query=\u003e{:bool=\u003e{:must=\u003e[{"terms"=\u003e{"state_id"=\u003e["8", "1", "2", "3"]}}, {"term"=\u003e{"owner_id"=\u003e""}}, {:range=\u003e{"created_at"=\u003e{:from=\u003e"2019-12-31T23:00:00Z", :to=\u003e"2020-12-31T22:59:59Z"}}}], :must_not=\u003e[{"term"=\u003e{"state.keyword"=\u003e"merged"}}]}}, :size=\u003e0, :aggs=\u003e{:time_buckets=\u003e{:date_histogram=\u003e{:field=\u003e"created_at", :interval=\u003e"month", :time_zone=\u003e"Europe/Berlin"}}}, "sort"=\u003e[{:updated_at=\u003e{:order=\u003e"desc"}}, "_score"]}\n\nPayload size: 0M”}
Steps to reproduce the behavior:
- This is the filter: