Graph in the reporting of an admin user is emtpy

Moin-se · December 12, 2019, 7:23am

Infos:

Used Zammad version: 3.1.x
Used Zammad installation source: source
Operating system: centos 7
Browser + version: chrome Version 78.0.3904.108 64bit
elasticsearch Version: 7.4.2

Expected behavior:

Showing the Reporting Graph

Actual behavior:

All added Lines of the reporting Graph are at 0.0

image.png2016×454 22.5 KB

Steps to reproduce the behavior:

*After reindizie the electricsearch everything was gone but for 2 month there was no new data shown in the graph.

Description

I have installed Zammad in september i think. First the reporting Graph was showing Data but since December or November, im not sure, there was no new Data from closed or opend tickets. Now i did a research and found out that a reindizi for elasticsearch could help, but now no data are shown anymore.

MrGeneration · December 13, 2019, 3:16pm

Please provide a screenshot of the selected report profile.
Also logfiles might be useful.

Moin-se · December 16, 2019, 10:39am

A picture like that?

Which Logifle would you like to see?

MrGeneration · December 16, 2019, 10:56am

Please go to admin-settings -> reporting profile -> all
I want a screenshot of the settings of -all-

Your production.log ( /var/log/zammad/ ) of the moment where you’re trying to access the reporting might be useful.

Moin-se · December 16, 2019, 11:11am

I hope this is the right one

I will look for the log.

Moin-se · December 16, 2019, 11:27am

Payload:
{“id”=>10, “stats_store_object_id”=>1, “o_id”=>20, “key”=>“dashboard”, “related_o_id”=>nil, “related_stats_store_object_id”=>nil, “data”=>{“StatsTicketLoadMeasure”=>{“used_for_average”=>0, “average_per_agent”=>5.4, “percent”=>0, “state”=>“supergood”, “own”=>0, “total”=>0}, “StatsTicketWaitingTime”=>{“handling_time”=>0, “average_per_agent”=>0, “state”=>“supergood”, “percent”=>0.0}, “StatsTicketEscalation”=>{“used_for_average”=>0, “average_per_agent”=>0.0, “state”=>“supergood”, “own”=>0, “total”=>0}, “StatsTicketChannelDistribution”=>{“channels”=>{“email”=>{“icon”=>“email”, “inbound”=>0, “outbound”=>0, “inbound_in_percent”=>0, “outbound_in_percent”=>0}, “phone”=>{“icon”=>“phone”, “inbound”=>0, “outbound”=>0, “inbound_in_percent”=>0, “outbound_in_percent”=>0}, “twitter”=>{“icon”=>“twitter”, “inbound”=>0, “outbound”=>0, “inbound_in_percent”=>0, “outbound_in_percent”=>0}, “facebook”=>{“icon”=>“facebook”, “inbound”=>0, “outbound”=>0, “inbound_in_percent”=>0, “outbound_in_percent”=>0}}}, “StatsTicketInProcess”=>{“used_for_average”=>0, “average_per_agent”=>0.0, “state”=>“supergood”, “in_process”=>0, “percent”=>0, “total”=>0}, “StatsTicketReopen”=>{“used_for_average”=>0, “percent”=>0, “average_per_agent”=>0.0, “state”=>“supergood”, “count”=>0, “total”=>0}}, “created_by_id”=>1, “created_at”=>Thu, 10 Oct 2019 13:40:40 UTC +00:00, “updated_at”=>Mon, 16 Dec 2019 10:51:07 UTC +00:00, “stats_store_object”=>“User”, “stats_store_object_ref”=>{“id”=>20, “organization_id”=>nil, “login”=>“fj@hostname.de”, “firstname”=>“Name”, “lastname”=>“Name”, “email”=>“fj@hostname.de”, “web”=>“”, “phone”=>“”, “fax”=>“”, “mobile”=>“”, “department”=>“Softwarentwicklung”, “street”=>“”, “zip”=>“”, “city”=>“”, “country”=>“”, “address”=>“”, “vip”=>false, “verified”=>false, “active”=>true, “note”=>“”, “last_login”=>nil, “out_of_office”=>false, “out_of_office_start_at”=>nil, “out_of_office_end_at”=>nil, “out_of_office_replacement_id”=>nil, “preferences”=>{“notification_config”=>{“matrix”=>{“create”=>{“criteria”=>{“owned_by_me”=>true, “owned_by_nobody”=>true, “no”=>false}, “channel”=>{“email”=>true, “online”=>true}}, “update”=>{“criteria”=>{“owned_by_me”=>true, “owned_by_nobody”=>true, “no”=>false}, “channel”=>{“email”=>true, “online”=>true}}, “reminder_reached”=>{“criteria”=>{“owned_by_me”=>true, “owned_by_nobody”=>false, “no”=>false}, “channel”=>{“email”=>true, “online”=>true}}, “escalation”=>{“criteria”=>{“owned_by_me”=>true, “owned_by_nobody”=>false, “no”=>false}, “channel”=>{“email”=>true, “online”=>true}}}}, “locale”=>“de-de”}, “updated_by_id”=>3, “created_by_id”=>3, “created_at”=>Thu, 10 Oct 2019 13:37:52 UTC +00:00, “updated_at”=>Thu, 10 Oct 2019 13:37:53 UTC +00:00, “permissions”=>[“user_preferences”, “user_preferences.password”, “user_preferences.notifications”, “user_preferences.access_token”, “user_preferences.language”, “user_preferences.linked_accounts”, “user_preferences.device”, “user_preferences.avatar”, “user_preferences.calendar”, “user_preferences.out_of_office”, “ticket.agent”, “chat.agent”, “cti.agent”, “knowledge_base.reader”], “role_ids”=>[2]}}
Payload size: 0M):
/opt/zammad/lib/search_index_backend.rb:230:in add' /opt/zammad/app/models/concerns/has_search_index_backend.rb:66:in search_index_update_backend’
/opt/zammad/app/jobs/search_index_job.rb:14:in perform' /opt/zammad/vendor/bundle/ruby/2.5.0/gems/activejob-5.2.3/lib/active_job/execution.rb:39:in block in perform_now’
/opt/zammad/vendor/bundle/ruby/2.5.0/gems/activesupport-5.2.3/lib/active_support/callbacks.rb:109:in block in run_callbacks' /opt/zammad/vendor/bundle/ruby/2.5.0/gems/i18n-1.6.0/lib/i18n.rb:297:in with_locale’
/opt/zammad/vendor/bundle/ruby/2.5.0/gems/activejob-5.2.3/lib/active_job/translation.rb:9:in block (2 levels) in <module:Translation>' /opt/zammad/vendor/bundle/ruby/2.5.0/gems/activesupport-5.2.3/lib/active_support/callbacks.rb:118:in instance_exec’
/opt/zammad/vendor/bundle/ruby/2.5.0/gems/activesupport-5.2.3/lib/active_support/callbacks.rb:118:in block in run_callbacks' /opt/zammad/vendor/bundle/ruby/2.5.0/gems/activejob-5.2.3/lib/active_job/logging.rb:26:in block (4 levels) in module:Logging’
/opt/zammad/vendor/bundle/ruby/2.5.0/gems/activesupport-5.2.3/lib/active_support/notifications.rb:168:in block in instrument' /opt/zammad/vendor/bundle/ruby/2.5.0/gems/activesupport-5.2.3/lib/active_support/notifications/instrumenter.rb:23:in instrument’
/opt/zammad/vendor/bundle/ruby/2.5.0/gems/activesupport-5.2.3/lib/active_support/notifications.rb:168:in instrument' /opt/zammad/vendor/bundle/ruby/2.5.0/gems/activejob-5.2.3/lib/active_job/logging.rb:25:in block (3 levels) in module:Logging’
/opt/zammad/vendor/bundle/ruby/2.5.0/gems/activejob-5.2.3/lib/active_job/logging.rb:46:in block in tag_logger' /opt/zammad/vendor/bundle/ruby/2.5.0/gems/activesupport-5.2.3/lib/active_support/tagged_logging.rb:71:in block in tagged’
/opt/zammad/vendor/bundle/ruby/2.5.0/gems/activesupport-5.2.3/lib/active_support/tagged_logging.rb:28:in tagged' /opt/zammad/vendor/bundle/ruby/2.5.0/gems/activesupport-5.2.3/lib/active_support/tagged_logging.rb:71:in tagged’
/opt/zammad/vendor/bundle/ruby/2.5.0/gems/activejob-5.2.3/lib/active_job/logging.rb:46:in tag_logger' /opt/zammad/vendor/bundle/ruby/2.5.0/gems/activejob-5.2.3/lib/active_job/logging.rb:22:in block (2 levels) in module:Logging’
/opt/zammad/vendor/bundle/ruby/2.5.0/gems/activesupport-5.2.3/lib/active_support/callbacks.rb:118:in instance_exec' /opt/zammad/vendor/bundle/ruby/2.5.0/gems/activesupport-5.2.3/lib/active_support/callbacks.rb:118:in block in run_callbacks’
/opt/zammad/vendor/bundle/ruby/2.5.0/gems/activesupport-5.2.3/lib/active_support/callbacks.rb:136:in run_callbacks' /opt/zammad/vendor/bundle/ruby/2.5.0/gems/activejob-5.2.3/lib/active_job/execution.rb:38:in perform_now’
/opt/zammad/vendor/bundle/ruby/2.5.0/gems/activejob-5.2.3/lib/active_job/execution.rb:24:in block in execute' /opt/zammad/vendor/bundle/ruby/2.5.0/gems/activesupport-5.2.3/lib/active_support/callbacks.rb:109:in block in run_callbacks’
/opt/zammad/vendor/bundle/ruby/2.5.0/gems/activejob-5.2.3/lib/active_job/railtie.rb:28:in block (4 levels) in <class:Railtie>' /opt/zammad/vendor/bundle/ruby/2.5.0/gems/activesupport-5.2.3/lib/active_support/execution_wrapper.rb:87:in wrap’
/opt/zammad/vendor/bundle/ruby/2.5.0/gems/activesupport-5.2.3/lib/active_support/reloader.rb:73:in block in wrap' /opt/zammad/vendor/bundle/ruby/2.5.0/gems/activesupport-5.2.3/lib/active_support/execution_wrapper.rb:87:in wrap’
/opt/zammad/vendor/bundle/ruby/2.5.0/gems/activesupport-5.2.3/lib/active_support/reloader.rb:72:in wrap' /opt/zammad/vendor/bundle/ruby/2.5.0/gems/activejob-5.2.3/lib/active_job/railtie.rb:27:in block (3 levels) in class:Railtie’
/opt/zammad/vendor/bundle/ruby/2.5.0/gems/activesupport-5.2.3/lib/active_support/callbacks.rb:118:in instance_exec' /opt/zammad/vendor/bundle/ruby/2.5.0/gems/activesupport-5.2.3/lib/active_support/callbacks.rb:118:in block in run_callbacks’
/opt/zammad/vendor/bundle/ruby/2.5.0/gems/activesupport-5.2.3/lib/active_support/callbacks.rb:136:in run_callbacks' /opt/zammad/vendor/bundle/ruby/2.5.0/gems/activejob-5.2.3/lib/active_job/execution.rb:22:in execute’
/opt/zammad/vendor/bundle/ruby/2.5.0/gems/activejob-5.2.3/lib/active_job/queue_adapters/delayed_job_adapter.rb:42:in perform' /opt/zammad/vendor/bundle/ruby/2.5.0/gems/delayed_job-4.1.7/lib/delayed/backend/base.rb:81:in block in invoke_job’
/opt/zammad/vendor/bundle/ruby/2.5.0/gems/delayed_job-4.1.7/lib/delayed/lifecycle.rb:61:in block in initialize' /opt/zammad/vendor/bundle/ruby/2.5.0/gems/delayed_job-4.1.7/lib/delayed/lifecycle.rb:66:in execute’
/opt/zammad/vendor/bundle/ruby/2.5.0/gems/delayed_job-4.1.7/lib/delayed/lifecycle.rb:40:in run_callbacks' /opt/zammad/vendor/bundle/ruby/2.5.0/gems/delayed_job-4.1.7/lib/delayed/backend/base.rb:78:in invoke_job’
/opt/zammad/vendor/bundle/ruby/2.5.0/gems/delayed_job-4.1.7/lib/delayed/worker.rb:230:in block (2 levels) in run' /opt/zammad/vendor/ruby-2.5.5/lib/ruby/2.5.0/timeout.rb:93:in block in timeout’
/opt/zammad/vendor/ruby-2.5.5/lib/ruby/2.5.0/timeout.rb:103:in timeout' /opt/zammad/vendor/bundle/ruby/2.5.0/gems/delayed_job-4.1.7/lib/delayed/worker.rb:230:in block in run’
/opt/zammad/vendor/ruby-2.5.5/lib/ruby/2.5.0/benchmark.rb:308:in realtime' /opt/zammad/vendor/bundle/ruby/2.5.0/gems/delayed_job-4.1.7/lib/delayed/worker.rb:229:in run’
/opt/zammad/vendor/bundle/ruby/2.5.0/gems/delayed_job-4.1.7/lib/delayed/worker.rb:312:in block in reserve_and_run_one_job' /opt/zammad/vendor/bundle/ruby/2.5.0/gems/delayed_job-4.1.7/lib/delayed/lifecycle.rb:61:in block in initialize’
/opt/zammad/vendor/bundle/ruby/2.5.0/gems/delayed_job-4.1.7/lib/delayed/lifecycle.rb:66:in execute' /opt/zammad/vendor/bundle/ruby/2.5.0/gems/delayed_job-4.1.7/lib/delayed/lifecycle.rb:40:in run_callbacks’
/opt/zammad/vendor/bundle/ruby/2.5.0/gems/delayed_job-4.1.7/lib/delayed/worker.rb:312:in reserve_and_run_one_job' /opt/zammad/vendor/bundle/ruby/2.5.0/gems/delayed_job-4.1.7/lib/delayed/worker.rb:213:in block in work_off’
/opt/zammad/vendor/bundle/ruby/2.5.0/gems/delayed_job-4.1.7/lib/delayed/worker.rb:212:in times' /opt/zammad/vendor/bundle/ruby/2.5.0/gems/delayed_job-4.1.7/lib/delayed/worker.rb:212:in work_off’
/opt/zammad/app/models/scheduler.rb:367:in block (3 levels) in worker' /opt/zammad/vendor/ruby-2.5.5/lib/ruby/2.5.0/benchmark.rb:308:in realtime’
/opt/zammad/app/models/scheduler.rb:365:in block (2 levels) in worker' /opt/zammad/app/models/scheduler.rb:361:in loop’
/opt/zammad/app/models/scheduler.rb:361:in block in worker' /opt/zammad/vendor/bundle/ruby/2.5.0/gems/logging-2.2.2/lib/logging/diagnostic_context.rb:474:in block in create_with_logging_context’
E, [2019-12-16T12:12:28.613807 #754-47106290343040] ERROR – : Retrying SearchIndexJob in #<Proc:0x000055af907a2278@/opt/zammad/app/jobs/search_index_job.rb:3 (lambda)> seconds, due to a StandardError. The original exception was nil.
I, [2019-12-16T12:12:28.627216 #754-47106290343040] INFO – : Enqueued SearchIndexJob (Job ID: 0a59355a-cd19-45c1-8509-679f743dde63) to DelayedJob(default) at 2019-12-16 11:14:18 UTC with arguments: “StatsStore”, 10
I, [2019-12-16T12:12:28.632461 #754-47106290343040] INFO – : 2019-12-16T12:12:28+0100: [Worker(host:zammad.hostname.de pid:754)] Job SearchIndexJob [0a59355a-cd19-45c1-8509-679f743dde63] from DelayedJob(default) with arguments: [“StatsStore”, 10] (id=1250143) (queue=default) COMPLETED after 0.1197
I, [2019-12-16T12:12:28.639740 #754-47106290343040] INFO – : 2019-12-16T12:12:28+0100: [Worker(host:zammad.hostname.de pid:754)] Job SearchIndexJob [75dc0872-cabd-4faf-ae35-9b12d4f8345f] from DelayedJob(default) with arguments: [“StatsStore”, 11] (id=1250144) (queue=default) RUNNING
I, [2019-12-16T12:12:28.698684 #754-47106290343040] INFO – : Performing SearchIndexJob (Job ID: 75dc0872-cabd-4faf-ae35-9b12d4f8345f) from DelayedJob(default) with arguments: “StatsStore”, 11
I, [2019-12-16T12:12:28.720873 #754-47106290343040] INFO – : # curl -X POST “http://localhost:9200/zammad_production_stats_store/_doc/11?pipeline=zammad266260611308”
I, [2019-12-16T12:12:28.728569 #754-47106290343040] INFO – : # 400
E, [2019-12-16T12:12:28.731807 #754-47106290343040] ERROR – : Error performing SearchIndexJob (Job ID: 75dc0872-cabd-4faf-ae35-9b12d4f8345f) from DelayedJob(default) in 32.88ms: RuntimeError (Unable to process POST request to elasticsearch URL ‘http://localhost:9200/zammad_production_stats_store/_doc/11?pipeline=zammad266260611308’. Check the response and payload for detailed information:
Response:
#<UserAgent::Result:0x00007f8fd4514788 @success=false, @body=“{"error":{"root_cause":[{"type":"illegal_argument_exception","reason":"pipeline with id [zammad266260611308] does not exist"}],"type":"illegal_argument_exception","reason":"pipeline with id [zammad266260611308] does not exist"},"status":400}”, @data=nil, @code=“400”, @content_type=nil, @error=“Client Error: #<Net::HTTPBadRequest 400 Bad Request readbody=true>!”>
Payload:
{“id”=>11, “stats_store_object_id”=>1, “o_id”=>21, “key”=>“dashboard”, “related_o_id”=>nil, “related_stats_store_object_id”=>nil, “data”=>{“StatsTicketLoadMeasure”=>{“used_for_average”=>0.0, “average_per_agent”=>2.0, “percent”=>0.0, “state”=>“superbad”, “own”=>0, “total”=>37, “average_per_agent_in_percent”=>0.0}, “StatsTicketWaitingTime”=>{“handling_time”=>0, “average_per_agent”=>0, “state”=>“supergood”, “percent”=>0.0}, “StatsTicketEscalation”=>{“used_for_average”=>0, “average_per_agent”=>0.0, “state”=>“supergood”, “own”=>0, “total”=>0}, “StatsTicketChannelDistribution”=>{“channels”=>{“email”=>{“icon”=>“email”, “inbound”=>927, “outbound”=>10, “inbound_in_percent”=>99, “outbound_in_percent”=>100}, “phone”=>{“icon”=>“phone”, “inbound”=>1, “outbound”=>0, “inbound_in_percent”=>0, “outbound_in_percent”=>0}, “twitter”=>{“icon”=>“twitter”, “inbound”=>0, “outbound”=>0, “inbound_in_percent”=>0, “outbound_in_percent”=>0}, “facebook”=>{“icon”=>“facebook”, “inbound”=>0, “outbound”=>0, “inbound_in_percent”=>0, “outbound_in_percent”=>0}}}, “StatsTicketInProcess”=>{“used_for_average”=>0, “average_per_agent”=>0.0, “state”=>“supergood”, “in_process”=>0, “percent”=>0, “total”=>0}, “StatsTicketReopen”=>{“used_for_average”=>0, “percent”=>0, “average_per_agent”=>0.0, “state”=>“supergood”, “count”=>0, “total”=>0}}, “created_by_id”=>1, “created_at”=>Thu, 10 Oct 2019 13:40:40 UTC +00:00, “updated_at”=>Mon, 16 Dec 2019 11:02:47 UTC +00:00, “stats_store_object”=>“User”, “stats_store_object_ref”=>{“id”=>21, “organization_id”=>nil, “login”=>“Name@hostname.com”, “firstname”=>“Name”, “lastname”=>“Name”, “email”=>“Name@hostname.com”, “web”=>“”, “phone”=>“”, “fax”=>“”, “mobile”=>“”, “department”=>“Geschäftsleitung”, “street”=>“”, “zip”=>“”, “city”=>“”, “country”=>“”, “address”=>“”, “vip”=>false, “verified”=>false, “active”=>true, “note”=>“”, “last_login”=>nil, “out_of_office”=>false, “out_of_office_start_at”=>nil, “out_of_office_end_at”=>nil, “out_of_office_replacement_id”=>nil, “preferences”=>{“notification_config”=>{“matrix”=>{“create”=>{“criteria”=>{“owned_by_me”=>true, “owned_by_nobody”=>true}, “channel”=>{“email”=>false, “online”=>true}}, “update”=>{“criteria”=>{“owned_by_me”=>true, “owned_by_nobody”=>true}, “channel”=>{“email”=>false, “online”=>true}}, “reminder_reached”=>{“criteria”=>{“owned_by_me”=>true}, “channel”=>{“email”=>false, “online”=>true}}, “escalation”=>{“criteria”=>{“owned_by_me”=>true}, “channel”=>{“email”=>false, “online”=>true}}}, “group_ids”=>[“1”, “2”]}, “locale”=>“de-de”, “notification_sound”=>{“file”=>“Xylo.mp3”, “enabled”=>true}}, “updated_by_id”=>21, “created_by_id”=>3, “created_at”=>Thu, 10 Oct 2019 13:39:14 UTC +00:00, “updated_at”=>Thu, 10 Oct 2019 13:39:29 UTC +00:00, “permissions”=>[“user_preferences”, “user_preferences.password”, “user_preferences.notifications”, “user_preferences.access_token”, “user_preferences.language”, “user_preferences.linked_accounts”, “user_preferences.device”, “user_preferences.avatar”, “user_preferences.calendar”, “user_preferences.out_of_office”, “ticket.agent”, “chat.agent”, “cti.agent”, “knowledge_base.reader”], “role_ids”=>[2]}}
Payload size: 0M):
/opt/zammad/lib/search_index_backend.rb:230:in add' /opt/zammad/app/models/concerns/has_search_index_backend.rb:66:in search_index_update_backend’
/opt/zammad/app/jobs/search_index_job.rb:14:in perform' /opt/zammad/vendor/bundle/ruby/2.5.0/gems/activejob-5.2.3/lib/active_job/execution.rb:39:in block in perform_now’
/opt/zammad/vendor/bundle/ruby/2.5.0/gems/activesupport-5.2.3/lib/active_support/callbacks.rb:109:in block in run_callbacks' /opt/zammad/vendor/bundle/ruby/2.5.0/gems/i18n-1.6.0/lib/i18n.rb:297:in with_locale’
/opt/zammad/vendor/bundle/ruby/2.5.0/gems/activejob-5.2.3/lib/active_job/translation.rb:9:in block (2 levels) in <module:Translation>' /opt/zammad/vendor/bundle/ruby/2.5.0/gems/activesupport-5.2.3/lib/active_support/callbacks.rb:118:in instance_exec’
/opt/zammad/vendor/bundle/ruby/2.5.0/gems/activesupport-5.2.3/lib/active_support/callbacks.rb:118:in block in run_callbacks' /opt/zammad/vendor/bundle/ruby/2.5.0/gems/activejob-5.2.3/lib/active_job/logging.rb:26:in block (4 levels) in module:Logging’
/opt/zammad/vendor/bundle/ruby/2.5.0/gems/activesupport-5.2.3/lib/active_support/notifications.rb:168:in block in instrument' /opt/zammad/vendor/bundle/ruby/2.5.0/gems/activesupport-5.2.3/lib/active_support/notifications/instrumenter.rb:23:in instrument’
/opt/zammad/vendor/bundle/ruby/2.5.0/gems/activesupport-5.2.3/lib/active_support/notifications.rb:168:in instrument' /opt/zammad/vendor/bundle/ruby/2.5.0/gems/activejob-5.2.3/lib/active_job/logging.rb:25:in block (3 levels) in module:Logging’
/opt/zammad/vendor/bundle/ruby/2.5.0/gems/activejob-5.2.3/lib/active_job/logging.rb:46:in block in tag_logger' /opt/zammad/vendor/bundle/ruby/2.5.0/gems/activesupport-5.2.3/lib/active_support/tagged_logging.rb:71:in block in tagged’
/opt/zammad/vendor/bundle/ruby/2.5.0/gems/activesupport-5.2.3/lib/active_support/tagged_logging.rb:28:in tagged' /opt/zammad/vendor/bundle/ruby/2.5.0/gems/activesupport-5.2.3/lib/active_support/tagged_logging.rb:71:in tagged’
/opt/zammad/vendor/bundle/ruby/2.5.0/gems/activejob-5.2.3/lib/active_job/logging.rb:46:in tag_logger' /opt/zammad/vendor/bundle/ruby/2.5.0/gems/activejob-5.2.3/lib/active_job/logging.rb:22:in block (2 levels) in module:Logging’
/opt/zammad/vendor/bundle/ruby/2.5.0/gems/activesupport-5.2.3/lib/active_support/callbacks.rb:118:in instance_exec' /opt/zammad/vendor/bundle/ruby/2.5.0/gems/activesupport-5.2.3/lib/active_support/callbacks.rb:118:in block in run_callbacks’
/opt/zammad/vendor/bundle/ruby/2.5.0/gems/activesupport-5.2.3/lib/active_support/callbacks.rb:136:in run_callbacks' /opt/zammad/vendor/bundle/ruby/2.5.0/gems/activejob-5.2.3/lib/active_job/execution.rb:38:in perform_now’
/opt/zammad/vendor/bundle/ruby/2.5.0/gems/activejob-5.2.3/lib/active_job/execution.rb:24:in block in execute' /opt/zammad/vendor/bundle/ruby/2.5.0/gems/activesupport-5.2.3/lib/active_support/callbacks.rb:109:in block in run_callbacks’
/opt/zammad/vendor/bundle/ruby/2.5.0/gems/activejob-5.2.3/lib/active_job/railtie.rb:28:in block (4 levels) in <class:Railtie>' /opt/zammad/vendor/bundle/ruby/2.5.0/gems/activesupport-5.2.3/lib/active_support/execution_wrapper.rb:87:in wrap’
/opt/zammad/vendor/bundle/ruby/2.5.0/gems/activesupport-5.2.3/lib/active_support/reloader.rb:73:in block in wrap' /opt/zammad/vendor/bundle/ruby/2.5.0/gems/activesupport-5.2.3/lib/active_support/execution_wrapper.rb:87:in wrap’
/opt/zammad/vendor/bundle/ruby/2.5.0/gems/activesupport-5.2.3/lib/active_support/reloader.rb:72:in wrap' /opt/zammad/vendor/bundle/ruby/2.5.0/gems/activejob-5.2.3/lib/active_job/railtie.rb:27:in block (3 levels) in class:Railtie’
/opt/zammad/vendor/bundle/ruby/2.5.0/gems/activesupport-5.2.3/lib/active_support/callbacks.rb:118:in instance_exec' /opt/zammad/vendor/bundle/ruby/2.5.0/gems/activesupport-5.2.3/lib/active_support/callbacks.rb:118:in block in run_callbacks’
/opt/zammad/vendor/bundle/ruby/2.5.0/gems/activesupport-5.2.3/lib/active_support/callbacks.rb:136:in run_callbacks' /opt/zammad/vendor/bundle/ruby/2.5.0/gems/activejob-5.2.3/lib/active_job/execution.rb:22:in execute’
/opt/zammad/vendor/bundle/ruby/2.5.0/gems/activejob-5.2.3/lib/active_job/queue_adapters/delayed_job_adapter.rb:42:in perform' /opt/zammad/vendor/bundle/ruby/2.5.0/gems/delayed_job-4.1.7/lib/delayed/backend/base.rb:81:in block in invoke_job’
/opt/zammad/vendor/bundle/ruby/2.5.0/gems/delayed_job-4.1.7/lib/delayed/lifecycle.rb:61:in block in initialize' /opt/zammad/vendor/bundle/ruby/2.5.0/gems/delayed_job-4.1.7/lib/delayed/lifecycle.rb:66:in execute’
/opt/zammad/vendor/bundle/ruby/2.5.0/gems/delayed_job-4.1.7/lib/delayed/lifecycle.rb:40:in run_callbacks' /opt/zammad/vendor/bundle/ruby/2.5.0/gems/delayed_job-4.1.7/lib/delayed/backend/base.rb:78:in invoke_job’
/opt/zammad/vendor/bundle/ruby/2.5.0/gems/delayed_job-4.1.7/lib/delayed/worker.rb:230:in block (2 levels) in run' /opt/zammad/vendor/ruby-2.5.5/lib/ruby/2.5.0/timeout.rb:93:in block in timeout’
/opt/zammad/vendor/ruby-2.5.5/lib/ruby/2.5.0/timeout.rb:103:in timeout' /opt/zammad/vendor/bundle/ruby/2.5.0/gems/delayed_job-4.1.7/lib/delayed/worker.rb:230:in block in run’
/opt/zammad/vendor/ruby-2.5.5/lib/ruby/2.5.0/benchmark.rb:308:in realtime' /opt/zammad/vendor/bundle/ruby/2.5.0/gems/delayed_job-4.1.7/lib/delayed/worker.rb:229:in run’
/opt/zammad/vendor/bundle/ruby/2.5.0/gems/delayed_job-4.1.7/lib/delayed/worker.rb:312:in block in reserve_and_run_one_job' /opt/zammad/vendor/bundle/ruby/2.5.0/gems/delayed_job-4.1.7/lib/delayed/lifecycle.rb:61:in block in initialize’
/opt/zammad/vendor/bundle/ruby/2.5.0/gems/delayed_job-4.1.7/lib/delayed/lifecycle.rb:66:in execute' /opt/zammad/vendor/bundle/ruby/2.5.0/gems/delayed_job-4.1.7/lib/delayed/lifecycle.rb:40:in run_callbacks’
/opt/zammad/vendor/bundle/ruby/2.5.0/gems/delayed_job-4.1.7/lib/delayed/worker.rb:312:in reserve_and_run_one_job' /opt/zammad/vendor/bundle/ruby/2.5.0/gems/delayed_job-4.1.7/lib/delayed/worker.rb:213:in block in work_off’
/opt/zammad/vendor/bundle/ruby/2.5.0/gems/delayed_job-4.1.7/lib/delayed/worker.rb:212:in times' /opt/zammad/vendor/bundle/ruby/2.5.0/gems/delayed_job-4.1.7/lib/delayed/worker.rb:212:in work_off’
/opt/zammad/app/models/scheduler.rb:367:in block (3 levels) in worker' /opt/zammad/vendor/ruby-2.5.5/lib/ruby/2.5.0/benchmark.rb:308:in realtime’
/opt/zammad/app/models/scheduler.rb:365:in block (2 levels) in worker' /opt/zammad/app/models/scheduler.rb:361:in loop’
/opt/zammad/app/models/scheduler.rb:361:in block in worker' /opt/zammad/vendor/bundle/ruby/2.5.0/gems/logging-2.2.2/lib/logging/diagnostic_context.rb:474:in block in create_with_logging_context’
E, [2019-12-16T12:12:28.732027 #754-47106290343040] ERROR – : Retrying SearchIndexJob in #<Proc:0x000055af907a2278@/opt/zammad/app/jobs/search_index_job.rb:3 (lambda)> seconds, due to a StandardError. The original exception was nil.
I, [2019-12-16T12:12:28.744099 #754-47106290343040] INFO – : Enqueued SearchIndexJob (Job ID: 75dc0872-cabd-4faf-ae35-9b12d4f8345f) to DelayedJob(default) at 2019-12-16 11:14:18 UTC with arguments: “StatsStore”, 11
I, [2019-12-16T12:12:28.749126 #754-47106290343040] INFO – : 2019-12-16T12:12:28+0100: [Worker(host:zammad.hostname.de pid:754)] Job SearchIndexJob [75dc0872-cabd-4faf-ae35-9b12d4f8345f] from DelayedJob(default) with arguments: [“StatsStore”, 11] (id=1250144) (queue=default) COMPLETED after 0.1092

E, [2019-12-16T12:12:28.732027 #754-47106290343040] ERROR – : Retrying SearchIndexJob in #<Proc:0x000055af907a2278@/opt/zammad/app/jobs/search_index_job.rb:3 (lambda)> seconds, due to a StandardError. The original exception was nil.

MrGeneration · December 16, 2019, 12:58pm

Your index seems to be broken or incomplete.
Please reindex your Zammad, this might also fix the reporting issue.

zammad run rake searchindex:rebuild

You might also be affected by:

Array values (e.g. several states) nuke reporting profiles · Issue #2809 · zammad/zammad · GitHub (this is fixed with 3.2)
Elasticsearch throws error 500 when filtering for owner or custom dropdown-fields inside of report profiles · Issue #2517 · zammad/zammad · GitHub (not yet fixed, just possibly, doesn’t need to be a fitting issue )

Moin-se · December 16, 2019, 1:53pm

create pipeline (pipeline)… rake aborted!
Unable to process put request to elasticsearch URL ‘http://localhost:9200/_ingest/pipeline/zammad266260611308’. Check the response and payload for detailed information:
Response:
#<UserAgent::Result:0x000055a8e2ef4fd0 @success=false, @body=“{"error":{"root_cause":[{"type":"parse_exception","reason":"No processor type exists with name [attachment]","processor_type":"foreach"}],"type":"parse_exception","reason":"No processor type exists with name [attachment]","processor_type":"foreach"},"status":400}”, @data=nil, @code=“400”, @content_type=nil, @error=“Client Error: #<Net::HTTPBadRequest 400 Bad Request readbody=true>!”>
Payload:
{:description=>“Extract zammad-attachment information from arrays”, :processors=>[{:foreach=>{:field=>“article”, :processor=>{:foreach=>{:field=>“_ingest._value.attachment”, :processor=>{:attachment=>{:target_field=>“_ingest._value”, :field=>“_ingest._value._content”, :ignore_failure=>true, :ignore_missing=>true}}, :ignore_failure=>true, :ignore_missing=>true}}, :ignore_failure=>true, :ignore_missing=>true}}]}
Payload size: 0M
/opt/zammad/lib/search_index_backend.rb:865:in make_request_and_validate' /opt/zammad/lib/search_index_backend.rb:84:in block (2 levels) in processors’
/opt/zammad/lib/search_index_backend.rb:68:in each' /opt/zammad/lib/search_index_backend.rb:68:in block in processors’
/opt/zammad/lib/search_index_backend.rb:65:in each' /opt/zammad/lib/search_index_backend.rb:65:in processors’
/opt/zammad/lib/tasks/search_index_es.rake:95:in block (2 levels) in <main>' /opt/zammad/lib/tasks/search_index_es.rake:67:in block (2 levels) in ’
/opt/zammad/lib/tasks/search_index_es.rake:167:in block (2 levels) in <main>' /opt/zammad/vendor/bundle/ruby/2.5.0/gems/rake-12.3.2/exe/rake:27:in <top (required)>’
/opt/zammad/vendor/bundle/ruby/2.5.0/gems/bundler-1.17.3/lib/bundler/cli/exec.rb:74:in load' /opt/zammad/vendor/bundle/ruby/2.5.0/gems/bundler-1.17.3/lib/bundler/cli/exec.rb:74:in kernel_load’
/opt/zammad/vendor/bundle/ruby/2.5.0/gems/bundler-1.17.3/lib/bundler/cli/exec.rb:28:in run' /opt/zammad/vendor/bundle/ruby/2.5.0/gems/bundler-1.17.3/lib/bundler/cli.rb:463:in exec’
/opt/zammad/vendor/bundle/ruby/2.5.0/gems/bundler-1.17.3/lib/bundler/vendor/thor/lib/thor/command.rb:27:in run' /opt/zammad/vendor/bundle/ruby/2.5.0/gems/bundler-1.17.3/lib/bundler/vendor/thor/lib/thor/invocation.rb:126:in invoke_command’
/opt/zammad/vendor/bundle/ruby/2.5.0/gems/bundler-1.17.3/lib/bundler/vendor/thor/lib/thor.rb:387:in dispatch' /opt/zammad/vendor/bundle/ruby/2.5.0/gems/bundler-1.17.3/lib/bundler/cli.rb:27:in dispatch’
/opt/zammad/vendor/bundle/ruby/2.5.0/gems/bundler-1.17.3/lib/bundler/vendor/thor/lib/thor/base.rb:466:in start' /opt/zammad/vendor/bundle/ruby/2.5.0/gems/bundler-1.17.3/lib/bundler/cli.rb:18:in start’
/opt/zammad/vendor/bundle/ruby/2.5.0/gems/bundler-1.17.3/exe/bundle:30:in block in <top (required)>' /opt/zammad/vendor/bundle/ruby/2.5.0/gems/bundler-1.17.3/lib/bundler/friendly_errors.rb:124:in with_friendly_errors’
/opt/zammad/vendor/bundle/ruby/2.5.0/gems/bundler-1.17.3/exe/bundle:22:in <top (required)>' /opt/zammad/bin/bundle:3:in load’
/opt/zammad/bin/bundle:3:in `’
Tasks: TOP => searchindex:rebuild

If im doing the rebuild, this Error Occures: Unable to process put request to elasticsearch URL ‘http://localhost:9200/_ingest/pipeline/zammad266260611308’

I will look into the elasticsearch log.

MrGeneration · December 16, 2019, 2:11pm

Please install the attachment plugin for your elasticsearch version.
See: Set up Elasticsearch — Zammad System Documentation documentation

Try to reindex again afterwards.

Moin-se · December 16, 2019, 2:43pm

It Works finally

But i dont understand why it stopped working after 2 Month.

I updated zammad, maybe because of that? (Sorry for the bad english )

Edit: Thank you very much for your patience.

MrGeneration · December 16, 2019, 3:13pm

Magic

Moin-se · December 16, 2019, 3:15pm

Thats a good one ^^

system · April 14, 2020, 3:15pm

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