Question

MBI : ERROR - SQL error: Data too long for column 'metric_unit' at row

  • 20 January 2023
  • 0 replies
  • 11 views

Badge +1

Hi,

 

After migration 21.10 to 22.10, centreonBIETL generate an error :

 

2023-01-20 05:36:26 - ERROR - SQL error: Data too long for column 'metric_unit' at row 241922 (caller: gorgone::modules::centreon::mbi::libs:🇧🇮:BIMetric:/usr/share/perl5/vendor_perl/gorgone/modules/centreon/mbi/libs/bi/BIMetric.pm:87)
Query: INSERT INTO `mod_bi_tmp_servicemetrics` (`metric_id`, `metric_name`, `metric_unit`, `service_id`, `service_description`, `sc_id`, `sc_name`, `host_id`, `host_name`, `hc_id`, `hc_name`, `hg_id`, `hg_name`) SELECT `metric_id`, `metric_name`, `unit_name`, s.`service_id`, s.`service_description`,  s.`sc_id`, s.`sc_name`, s.`host_id`, s.`host_name`, `hc_id`, `hc_name`, `hg_id`, `hg_name` FROM `mod_bi_tmp_today_services` s, `metrics` m, `index_data` i WHERE i.id = m.index_id and i.host_id=s.host_id and i.service_id=s.service_id group by s.hg_id, s.hc_id, s.sc_id, m.index_id, m.metric_id


0 replies

Be the first to reply!

Reply