Hi @Francis DOUNGA,

Are the reporting datas ok onthe Reporting  >  Dashboard  >  Hosts page ?

Also, do you have any errors in the following files (central server) :

• /var/log/centreon/eventReportBuilder.log
• /var/log/centreon/dashboardBuilder.log

Regards,

Hi @itoussies 

My dashboard returns nothing (it's weird). I have no data on a 1 day and more.

The log files have not errors.

Francis

Error, my dashboard work fine

Hi @Francis DOUNGA,

It seems that services have undetermined availabilities. Did it happend with all host and their services ?

Regard.

Hello @itoussies ,

I Have same problème Can u Help Me please!

Hello @Reda,

What is the output of usr/share/centreon-bi/etl/centreonbiMonitoring.pl --db-content on the MBI server?

Hello @itoussies 

Thanks a lot for you’re answer, there is the output,

What’s the Centreon version?

Are there any errors in /var/log/centreon-bi/centreonBIETL.log?

the Version is 22.10

it always gives these two errors at the step dimensions level

the log is :

STEP : Data extraction from monitoring server

[Thu Aug  1 04:30:02 2024] [INFO] Starting program...(pid=302767)
[Thu Aug  1 04:30:02 2024] [INFO] [DUMP] Dumping data of monitoring database to reporting server [mod_bam_reporting_ba_availabilities]
[Thu Aug  1 04:30:02 2024] [INFO] [DUMP] Dumping data of monitoring database to reporting server [data_bin]
[Thu Aug  1 04:34:47 2024] [INFO] [DUMP] Dumping data of monitoring database to reporting server [centreon_acl]
[Thu Aug  1 04:34:48 2024] [INFO] [DUMP] Dumping data of monitoring database to reporting server [index_data]
[Thu Aug  1 04:34:50 2024] [INFO] [DUMP] Dumping data of monitoring database to reporting server [metrics]
[Thu Aug  1 04:34:52 2024] [INFO] [DUMP] Dumping data of monitoring database to reporting server [hoststateevents]
[Thu Aug  1 04:34:54 2024] [INFO] [DUMP] Dumping data of monitoring database to reporting server [servicestateevents]
[Thu Aug  1 04:35:27 2024] [INFO] [DUMP] Dumping data of monitoring database to reporting server [instances]
[Thu Aug  1 04:35:27 2024] [INFO] [DUMP] Dumping data of monitoring database to reporting server [hosts]
[Thu Aug  1 04:35:27 2024] [INFO] [DUMP] Dumping data of monitoring database to reporting server [downtimes]
[Thu Aug  1 04:35:27 2024] [INFO] [DUMP] Dumping data of monitoring database to reporting server [acknowledgements]
[Thu Aug  1 04:35:27 2024] [INFO] [DUMP] Dumping data of monitoring database to reporting server [mod_bam_reporting_ba]
[Thu Aug  1 04:35:27 2024] [INFO] [DUMP] Dumping data of monitoring database to reporting server [mod_bam_reporting_ba_events]
[Thu Aug  1 04:35:27 2024] [INFO] [DUMP] Dumping data of monitoring database to reporting server [mod_bam_reporting_ba_events_durations]
[Thu Aug  1 04:35:27 2024] [INFO] [DUMP] Dumping data of monitoring database to reporting server [mod_bam_reporting_bv]
[Thu Aug  1 04:35:27 2024] [INFO] [DUMP] Dumping data of monitoring database to reporting server [mod_bam_reporting_kpi]
[Thu Aug  1 04:35:27 2024] [INFO] [DUMP] Dumping data of monitoring database to reporting server [mod_bam_reporting_kpi_events]
[Thu Aug  1 04:35:27 2024] [INFO] [DUMP] Dumping data of monitoring database to reporting server [mod_bam_reporting_relations_ba_bv]
[Thu Aug  1 04:35:27 2024] [INFO] [DUMP] Dumping data of monitoring database to reporting server [mod_bam_reporting_relations_ba_kpi_events]
[Thu Aug  1 04:35:28 2024] [INFO] [DUMP] Dumping data of monitoring database to reporting server [mod_bam_reporting_timeperiods]
[Thu Aug  1 04:35:28 2024] [INFO] [DUMP] Dumping monitoring server database directly on reporting server [centreon]
[Thu Aug  1 04:35:28 2024] [INFO] [LOAD] Loading data into reporting database [centreon]
[Thu Aug  1 04:35:33 2024] [INFO] [DUMP] Update Centreon ACL data
[Thu Aug  1 04:35:37 2024] [INFO] Exiting program...(pid=302767)

STEP : Processing dimensions

[Thu Aug  1 04:35:37 2024] [INFO] Starting program...(pid=302767)
[Thu Aug  1 04:35:37 2024] [INFO] Searching for duplicate host/service entries
[Thu Aug  1 04:35:38 2024] [INFO] Getting host properties from Centreon database
[Thu Aug  1 04:35:41 2024] [INFO] Updating host dimension in Centstorage
[Thu Aug  1 04:35:42 2024] [INFO] Getting hostgroup properties from Centreon database
[Thu Aug  1 04:35:42 2024] [INFO] Updating hostgroup dimension in Centstorage
[Thu Aug  1 04:35:42 2024] [INFO] Getting hostcategories properties from Centreon database
[Thu Aug  1 04:35:42 2024] [INFO] Updating hostcategories dimension in Centstorage
[Thu Aug  1 04:35:42 2024] [INFO] Getting servicecategories properties from Centreon database
[Thu Aug  1 04:35:42 2024] [INFO] Updating servicecategories dimension in Centstorage
[Thu Aug  1 04:35:42 2024] [INFO] Getting service properties from Centreon database
[Thu Aug  1 12:30:01 2024] [WARNING] Error connecting to MySQL, trying to reconnect to centreon
[Thu Aug  1 12:30:01 2024] [FATAL] MySQL error : cannot connect to database centreon on server localhost
[Thu Aug  1 12:30:01 2024] [FATAL] Program terminated with errors

but when I run the diagnostic the connection between the bases seems perfect.

#################### Check connection to databases ####################

 --> Connection to monitoring databases:

########## Java ##########

    [OK]      Java 17 installed
    [OK]      Connection to centreon database on XX.XXX.XX.12 successful
    [OK]      Connection to centreon_storage database on XX.XXX.XX.12 successful

 --> Connection to reporting server:

    [OK]      Connection to centreon on localhost successful
    [OK]      Connection to centreon_storage on localhost successful

####################          CBIS deamon          ####################

    [OK]      CBIS is running

####################       ETL configuration       ####################

   [INFO]     Use large memory tweaks  option is disabled
  [WARNING]   ETL logs returning errors, please check /var/log/centreon-bi/centreonBIETL.log for more details
    [OK]      ETL cron activated

Does the following SQL request return any result?
 

mariadb centreon -e "SELECT service_description FROM service WHERE service_id = service_template_model_stm_id;"

The result Returned is

+--------------------------------+
| service_description            |
+--------------------------------+
| generic-passive-service-custom |
+--------------------------------+

Hum its seems that this service template has itself as a template. You need to modifiy it and replace its template by “generic-passive-service” (or any generic passive service template). Then, on your MBI server, run the following command:

/usr/share/centreon-bi/etl/dimensionsBuilder.pl -d

If everything works fine, you can follow this procedure to rebuild your data: https://docs.centreon.com/docs/reporting/concepts/#how-to-rebuild-missing-reporting-data

Hi @itoussies  ,

I thank you for your feedback but can you be more specific please, this change should I make where and how?

I am new to Centreon and I need more details so as not to make mistakes

Hello,

You can modify a service template on the Configuration  >  Services  >  Templates page. Your generic-passive-service-custom template should look like that:

In the Template field, replace generic-passive-service-custom by generic-passive-service-custom. Then on your MBI server, run the following commands:

• /usr/share/centreon-bi/etl/importData.pl -r --centreon-only
• /usr/share/centreon-bi/etl/dimensionsBuilder.pl -d

Thank you for your feedback,

I found them like that without doing anything,
and yet the orders do not go through

Hello,
Maybe I should have been more precise but it should look like that before the change:

And it should look like that after the change:

Hello ​@itoussies 

I hope you are well and happy new year,

I thank you for your valuable information the problem has been solved and it's been a long time I work with the normal reports,

yesterday I wanted to make sure that everything is going well with the command: /usr/share/centreon-bi/etl/centreonbiMonitoring.pl --db-content

and the Output was: [mod_bi_metricmonthcapacity: 2024-11-01 00:00:00] [mod_bi_metriccentilemonthlyvalue: 2024-11-01 00:00:00]

I don't know why these tables are no longer updated

any idea about this?

cordially