[solved ]Search for contacts not working

  • Zammad Version 3.1.x
  • Used Zammad installation source: Ubuntu
  • Operating system: W10
  • Browser + version: Firefox + Chrome latest

Expected behavior:

When i type an receiver for E-Mail the receiver ist autocomplete.

Actual behavior:

Nothing happening always have to type full adress.

Steps to reproduce the behavior:

Try to send an E-Mail

Searching for tickets is working, elastic search is running. 
    elasticsearch.service - Elasticsearch
       Loaded: loaded (/usr/lib/systemd/system/elasticsearch.service; enabled; vendor preset: enabled)
       Active: active (running) since Thu 2019-09-19 09:02:05 CEST; 4min 41s ago
     Docs: http://www.elastic.co
      Process: 1120 ExecStartPre=/usr/share/elasticsearch/bin/elasticsearch-systemd-pre-exec (code=exited, status=0/SUCCESS)
     Main PID: 1181 (java)
    Tasks: 48
       Memory: 2.3G
      CPU: 22.108s
       CGroup: /system.slice/elasticsearch.service
           └─1181 /usr/bin/java -Xms2g -Xmx2g -XX:+UseConcMarkSweepGC -XX:CMSInitiatingOccupancyFraction=75 -XX:+UseCMSInitiatingOccupancyOnly -XX:+AlwaysPreTouch -server -Xss1m -Djava.awt.headless=true -Dfile.encoding=UTF-8 -Djna.nosys=true -Djdk.io.permissionsUseCanonicalPath=true -Dio.netty.noUnsafe=true -Dio.net
    lines 1-11/11 (END)

/var/log/zammad/production.log:

    E, [2019-09-19T10:36:47.440104 #2126-47344296095940] ERROR -- : Unable to process GET request to elasticsearch URL 'http://127.0.0.1:9200/zammad_production/User/_search'. Check the response and payload for detailed information:

    Response:

    #<UserAgent::Result:0x0000561e68845558 @success=false, @body="{\"error\":{\"root_cause\":[{\"type\":\"query_shard_exception\",\"reason\":\"No mapping found for [active.raw] in order to sort on\",\"index_uuid\":\"uSleTEZ6SMKyOX9y65OoZQ\",\"index\":\"zammad_production\"}],\"type\":\"search_phase_execution_exception\",\"reason\":\"all shards failed\",\"phase\":\"query\",\"grouped\":true,\"failed_shards\":[{\"shard\":0,\"index\":\"zammad_production\",\"node\":\"S2HtcNuPQuOFF5QNqf3kGA\",\"reason\":{\"type\":\"query_shard_exception\",\"reason\":\"No mapping found for [active.raw] in order to sort on\",\"index_uuid\":\"uSleTEZ6SMKyOX9y65OoZQ\",\"index\":\"zammad_production\"}}]},\"status\":400}", @data=nil, @code="400", @content_type=nil, @error="Client Error: #<Net::HTTPBadRequest 400 Bad Request readbody=true>!">

    Payload:

    {:from=>0, :size=>100, :sort=>[{"active.raw"=>{:order=>"desc"}}, {"updated_at"=>{:order=>"desc"}}, "_score"], :query=>{:bool=>{:must=>[{"query_string"=>{"query"=>"zinnenc*", "default_operator"=>"AND", "analyze_wildcard"=>true}}]}}}

    Payload size: 0M

    E, [2019-09-19T10:36:47.440160 #2126-47344296095940] ERROR -- : Unable to process GET request to elasticsearch URL 'http://127.0.0.1:9200/zammad_production/User/_search'. Check the response and payload for detailed information:

    Response:

    #<UserAgent::Result:0x0000561e68845558 @success=false, @body="{\"error\":{\"root_cause\":[{\"type\":\"query_shard_exception\",\"reason\":\"No mapping found for [active.raw] in order to sort on\",\"index_uuid\":\"uSleTEZ6SMKyOX9y65OoZQ\",\"index\":\"zammad_production\"}],\"type\":\"search_phase_execution_exception\",\"reason\":\"all shards failed\",\"phase\":\"query\",\"grouped\":true,\"failed_shards\":[{\"shard\":0,\"index\":\"zammad_production\",\"node\":\"S2HtcNuPQuOFF5QNqf3kGA\",\"reason\":{\"type\":\"query_shard_exception\",\"reason\":\"No mapping found for [active.raw] in order to sort on\",\"index_uuid\":\"uSleTEZ6SMKyOX9y65OoZQ\",\"index\":\"zammad_production\"}}]},\"status\":400}", @data=nil, @code="400", @content_type=nil, @error="Client Error: #<Net::HTTPBadRequest 400 Bad Request readbody=true>!">

    Payload:

    {:from=>0, :size=>100, :sort=>[{"active.raw"=>{:order=>"desc"}}, {"updated_at"=>{:order=>"desc"}}, "_score"], :query=>{:bool=>{:must=>[{"query_string"=>{"query"=>"zinnenc*", "default_operator"=>"AND", "analyze_wildcard"=>true}}]}}}

    Payload size: 0M

Please ensure that you have the needed attachment plugin installed.
Also, do a reindex afterwards, please.

Both steps can be found here: https://docs.zammad.org/en/latest/install-elasticsearch.html

Sidenote (for the next time): Installation type is package / source or docker :x

1 Like

Is already installed :confused: also it worked wuite long now.
I try to update it.

 -> Downloading ingest-attachment from elastic
    [=================================================] 100%  
    ERROR: plugin directory [/usr/share/elasticsearch/plugins/ingest-attachment] already exists; if you need to update the plugin, uninstall it first using command 'remove ingest-attachment'

To solve this Error do the following steps:

Update Plugin

1. sudo /usr/share/elasticsearch/bin/elasticsearch-plugin remove ingest-attachment
2. sudo /usr/share/elasticsearch/bin/elasticsearch-plugin install ingest-attachment

Reindex
1. sudo zammad run rake searchindex:rebuild

1 Like

This topic was automatically closed 120 days after the last reply. New replies are no longer allowed.