Symptom

Problem

With older versions of Centreon, when a group or template is disabled but contains hosts or services, configuration export can be stuck.

Solution

• Check that you do not have any host groups or services that are disabled and have hosts/services being monitored. If so, re-enable them, this will solve the problem.
• Check that you don't have a service/host template that is disabled, but still linked to a host/service.

If the problem persists, please open a ticket with the return of these requests:

mysql -D centreon -u<your_user> -p




select * from hostgroup_relation where hostgroup_hg_id IN (select hg_id from hostgroup where hg_activate != '1');




select * from hostgroup_relation where hostgroup_hg_id IN (select hg_id from hostgroup where hg_activate != '1');




select service_template_model_stm_id from service where service_register = '1' and service_activate = '1' and service_template_model_stm_id in (select service_id from service where service_register = '0' and service_activate = '0');




select host_id from host join host_template_relation htr ON host.host_id = htr.host_tpl_id where host_register = '0' and host_activate = '0' and htr.host_host_id in (select host_id from host where host_register = '1' and host_activate = '1');

⚠️ THIS IS A BUG ALREADY FIXED, PLEASE UPDATE OR/AND UPGRADE TO AN ULTERIOR VERSION