hello

you will probably need to contact the support and open a case, I know there are commands and other way to get things back in order

(like this “concept” article that will tell you how to rebuild when you are missing data : Concepts | Centreon Documentation )

when I had some issue I was asked to check these commands 

systemctl status cbis -l/usr/share/centreon-bi/tools/diagnostic.sh/usr/share/centreon-bi/etl/centreonbiMonitoring.pl --db-content 

but as the database was locked there was no output on the last one, and the 2nd one was hanging after displaying a bit of information (all due to a bugged “drop database” from mariadb, a bit of nighmare to fix)

try running these 3 commands (they are just diagnotiscs) and if you get stuck, then you have a mariadb problem and you will need to fix that before

Hi,

thanks

diagnostic.sh - All OK , all green .

I have submitted a support request (08/06/2023) but have not received a response yet.

Hi,

You probably have a “template loop” (a template inheriting from itself) in your Centreon configuration.

him when i run this task

/usr/share/centreon-bi/etl/dimensionsBuilder_legacy.pl -r --log-level=debug

loop in

Thu Jun 15 09:56:51 2023] 3DEBUG] MySQL query : SELECT sc.sc_id, sc_name FROM service_categories sc, service_categories_relation scr WHERE service_service_id = 13402 AND sc.sc_id = scr.sc_id

Thu Jun 15 09:56:51 2023] 3DEBUG] MySQL query : SELECT service_id, service_template_model_stm_id FROM service WHERE service_register = '0' and service_id=13402

Thu Jun 15 09:56:51 2023] 3DEBUG] MySQL query : SELECT sc.sc_id, sc_name FROM service_categories sc, service_categories_relation scr WHERE service_service_id = 13402 AND sc.sc_id = scr.sc_id

Thu Jun 15 09:56:51 2023] 3DEBUG] MySQL query : SELECT service_id, service_template_model_stm_id FROM service WHERE service_register = '0' and service_id=13402

Thu Jun 15 09:56:51 2023] 3DEBUG] MySQL query : SELECT sc.sc_id, sc_name FROM service_categories sc, service_categories_relation scr WHERE service_service_id = 13402 AND sc.sc_id = scr.sc_id

Yep, definitely looks like it.

You can spot the related service by setting its ID in the configuration page URL:

http(s)://x.x.x.x/centreon/main.php?p=60201&o=c&service_id=13402

i checked the service

centreon-plugin-Cloud-Azure-Management-Resource-Api

Cloud-Azure-Management-Resource-Items-Api-custom

i deleted the service check ( was only one )

now i checked the mbi - rebuild again

i rebuild again

same error

pThu Jun 15 11:51:57 2023] ]DEBUG] MySQL query : SELECT service_id, service_template_model_stm_id FROM service WHERE service_register = '0' and service_id=13402

/Thu Jun 15 11:51:57 2023] ]DEBUG] MySQL query : SELECT sc.sc_id, sc_name  FROM service_categories sc, service_categories_relation scr WHERE service_service_id = 13402 AND sc.sc_id = scr.sc_id

Thu Jun 15 11:51:57 2023] 3DEBUG] MySQL query : SELECT service_id, service_template_model_stm_id FROM service WHERE service_register = '0' and service_id=13402

Thu Jun 15 11:51:57 2023] 3DEBUG] MySQL query : SELECT sc.sc_id, sc_name  FROM service_categories sc, service_categories_relation scr WHERE service_service_id = 13402 AND sc.sc_id = scr.sc_id

rThu Jun 15 11:51:57 2023] 2DEBUG] MySQL query : SELECT service_id, service_template_model_stm_id FROM service WHERE service_register = '0' and service_id=13402

In Centreon, i export the config again, and restart the monitoring engine

test again

now it is running :)))) the rebuild

Nice 

Can you please set the topic as “resolved”, so it would help other users facing the same issue.

Thanks !

Hello, I can not find the button "Resolve"

Under each post, you'll find the magical "Best Answer" button. Locate the post that truly saved your day and give it a sweet click to mark it as the ultimate solution to your problem. By doing so, you'll be spreading the love and helping fellow watchers who stumble upon the same issue. Thanks @ahartung, but also @christophe.niel-ACT and @Thibault