didn't found anything about this on the forums or the bugtracker. So, here goes the problem, I got 2 data synchronization sources, both worked perfectly with >10000 CIs on custom clasess.
The problem appears that after updating the datamodel to add a new field to both classes via the toolkit, all is updated except the data sources fields. The new one doesn't appear then the synchronization always fails because can't find the new field.
Im guessing if the workaround is to add this field manually to the sync table but don't want to mess around with it without asking first.
SYNC OUT: ('habilitado' is the new field)
ERROR: Failed to issue SQL query: query = SELECT DISTINCT SynchroReplica_priv_sync_replica.id AS SynchroReplicaid, SynchroReplica_priv_sync_replica.sync_source_id AS SynchroReplicasync_source_id, SynchroDataSource_sync_source_id_priv_sync_datasource.scope_class AS SynchroReplicabase_class, SynchroReplica_priv_sync_replica.dest_id AS SynchroReplicadest_id, SynchroReplica_priv_sync_replica.dest_class AS SynchroReplicadest_class, SynchroReplica_priv_sync_replica.status_last_seen AS SynchroReplicastatus_last_seen, SynchroReplica_priv_sync_replica.status AS SynchroReplicastatus, SynchroReplica_priv_sync_replica.status_dest_creator AS SynchroReplicastatus_dest_creator, SynchroReplica_priv_sync_replica.status_last_error AS SynchroReplicastatus_last_error, SynchroReplica_priv_sync_replica.status_last_warning AS SynchroReplicastatus_last_warning, SynchroReplica_priv_sync_replica.info_creation_date AS SynchroReplicainfo_creation_date, SynchroReplica_priv_sync_replica.info_last_modified AS SynchroReplicainfo_last_modified, CAST(CONCAT(COALESCE('SynchroReplica', '')) AS CHAR) AS SynchroReplicafriendlyname, CAST(CONCAT(COALESCE(SynchroDataSource_sync_source_id_priv_sync_datasource.name, '')) AS CHAR) AS SynchroReplicasync_source_id_friendlyname, _extended_data_.alert_critical AS SynchroReplica_extdata_alert_critical, _extended_data_.alert_warning AS SynchroReplica_extdata_alert_warning, _extended_data_.applicationsolution_id AS SynchroReplica_extdata_applicationsolution_id, _extended_data_.applicationsolution_list AS SynchroReplica_extdata_applicationsolution_list, _extended_data_.business_criticity AS SynchroReplica_extdata_business_criticity, _extended_data_.centreon_template AS SynchroReplica_extdata_centreon_template, _extended_data_.contacts_list AS SynchroReplica_extdata_contacts_list, _extended_data_.description AS SynchroReplica_extdata_description, _extended_data_.description_crtical AS SynchroReplica_extdata_description_crtical, _extended_data_.description_warning AS SynchroReplica_extdata_description_warning, _extended_data_.documents_list AS SynchroReplica_extdata_documents_list, _extended_data_.fecha_alta AS SynchroReplica_extdata_fecha_alta, _extended_data_.group_list AS SynchroReplica_extdata_group_list, _extended_data_.grupo_servicio AS SynchroReplica_extdata_grupo_servicio, _extended_data_.habilitado AS SynchroReplica_extdata_habilitado, _extended_data_.horario_critical AS SynchroReplica_extdata_horario_critical, _extended_data_.horario_warning AS SynchroReplica_extdata_horario_warning, _extended_data_.hostname AS SynchroReplica_extdata_hostname, _extended_data_.hostname_ip AS SynchroReplica_extdata_hostname_ip, _extended_data_.move2production AS SynchroReplica_extdata_move2production, _extended_data_.name AS SynchroReplica_extdata_name, _extended_data_.org_id AS SynchroReplica_extdata_org_id, _extended_data_.providercontracts_list AS SynchroReplica_extdata_providercontracts_list, _extended_data_.service_id AS SynchroReplica_extdata_service_id, _extended_data_.service_list_moni AS SynchroReplica_extdata_service_list_moni, _extended_data_.tickets_list AS SynchroReplica_extdata_tickets_list, _extended_data_.primary_key AS SynchroReplica_extdata_primary_key FROM priv_sync_replica AS SynchroReplica_priv_sync_replicaINNER JOIN (priv_sync_datasource AS SynchroDataSource_sync_source_id_priv_sync_datasource ) ON SynchroReplica_priv_sync_replica.sync_source_id = SynchroDataSource_sync_source_id_priv_sync_datasource.idINNER JOIN (synchro_data_host_monitorizacion_1 AS _extended_data_ ) ON SynchroReplica_priv_sync_replica.id = _extended_data_.id WHERE ((((SynchroReplica_priv_sync_replica.id > '-1') AND (((SynchroReplica_priv_sync_replica.status = 'new') OR (SynchroReplica_priv_sync_replica.status = 'modified')) OR ((SynchroReplica_priv_sync_replica.status = 'synchronized') AND (SynchroReplica_priv_sync_replica.status_last_warning != '')))) AND (SynchroReplica_priv_sync_replica.sync_source_id = '1')) AND (SynchroReplica_priv_sync_replica.status_last_seen >= '1970-01-01 00:00:00')) ORDER BY SynchroReplicafriendlyname ASC , mysql_error = Unknown column 'extended_data.habilitado' in 'field list', mysql_errno = 1054
If you would like to refer to this comment somewhere else in this project, copy and paste the following link:
Hi there,
didn't found anything about this on the forums or the bugtracker. So, here goes the problem, I got 2 data synchronization sources, both worked perfectly with >10000 CIs on custom clasess.
The problem appears that after updating the datamodel to add a new field to both classes via the toolkit, all is updated except the data sources fields. The new one doesn't appear then the synchronization always fails because can't find the new field.
Im guessing if the workaround is to add this field manually to the sync table but don't want to mess around with it without asking first.
SYNC OUT: ('habilitado' is the new field)
ERROR: Failed to issue SQL query: query = SELECT DISTINCT
SynchroReplica_priv_sync_replica.idASSynchroReplicaid,SynchroReplica_priv_sync_replica.sync_source_idASSynchroReplicasync_source_id,SynchroDataSource_sync_source_id_priv_sync_datasource.scope_classASSynchroReplicabase_class,SynchroReplica_priv_sync_replica.dest_idASSynchroReplicadest_id,SynchroReplica_priv_sync_replica.dest_classASSynchroReplicadest_class,SynchroReplica_priv_sync_replica.status_last_seenASSynchroReplicastatus_last_seen,SynchroReplica_priv_sync_replica.statusASSynchroReplicastatus,SynchroReplica_priv_sync_replica.status_dest_creatorASSynchroReplicastatus_dest_creator,SynchroReplica_priv_sync_replica.status_last_errorASSynchroReplicastatus_last_error,SynchroReplica_priv_sync_replica.status_last_warningASSynchroReplicastatus_last_warning,SynchroReplica_priv_sync_replica.info_creation_dateASSynchroReplicainfo_creation_date,SynchroReplica_priv_sync_replica.info_last_modifiedASSynchroReplicainfo_last_modified, CAST(CONCAT(COALESCE('SynchroReplica', '')) AS CHAR) ASSynchroReplicafriendlyname, CAST(CONCAT(COALESCE(SynchroDataSource_sync_source_id_priv_sync_datasource.name, '')) AS CHAR) ASSynchroReplicasync_source_id_friendlyname,_extended_data_.alert_criticalASSynchroReplica_extdata_alert_critical,_extended_data_.alert_warningASSynchroReplica_extdata_alert_warning,_extended_data_.applicationsolution_idASSynchroReplica_extdata_applicationsolution_id,_extended_data_.applicationsolution_listASSynchroReplica_extdata_applicationsolution_list,_extended_data_.business_criticityASSynchroReplica_extdata_business_criticity,_extended_data_.centreon_templateASSynchroReplica_extdata_centreon_template,_extended_data_.contacts_listASSynchroReplica_extdata_contacts_list,_extended_data_.descriptionASSynchroReplica_extdata_description,_extended_data_.description_crticalASSynchroReplica_extdata_description_crtical,_extended_data_.description_warningASSynchroReplica_extdata_description_warning,_extended_data_.documents_listASSynchroReplica_extdata_documents_list,_extended_data_.fecha_altaASSynchroReplica_extdata_fecha_alta,_extended_data_.group_listASSynchroReplica_extdata_group_list,_extended_data_.grupo_servicioASSynchroReplica_extdata_grupo_servicio,_extended_data_.habilitadoASSynchroReplica_extdata_habilitado,_extended_data_.horario_criticalASSynchroReplica_extdata_horario_critical,_extended_data_.horario_warningASSynchroReplica_extdata_horario_warning,_extended_data_.hostnameASSynchroReplica_extdata_hostname,_extended_data_.hostname_ipASSynchroReplica_extdata_hostname_ip,_extended_data_.move2productionASSynchroReplica_extdata_move2production,_extended_data_.nameASSynchroReplica_extdata_name,_extended_data_.org_idASSynchroReplica_extdata_org_id,_extended_data_.providercontracts_listASSynchroReplica_extdata_providercontracts_list,_extended_data_.service_idASSynchroReplica_extdata_service_id,_extended_data_.service_list_moniASSynchroReplica_extdata_service_list_moni,_extended_data_.tickets_listASSynchroReplica_extdata_tickets_list,_extended_data_.primary_keyASSynchroReplica_extdata_primary_keyFROMpriv_sync_replicaASSynchroReplica_priv_sync_replicaINNER JOIN (priv_sync_datasourceASSynchroDataSource_sync_source_id_priv_sync_datasource) ONSynchroReplica_priv_sync_replica.sync_source_id=SynchroDataSource_sync_source_id_priv_sync_datasource.idINNER JOIN (synchro_data_host_monitorizacion_1AS_extended_data_) ONSynchroReplica_priv_sync_replica.id=_extended_data_.idWHERE ((((SynchroReplica_priv_sync_replica.id> '-1') AND (((SynchroReplica_priv_sync_replica.status= 'new') OR (SynchroReplica_priv_sync_replica.status= 'modified')) OR ((SynchroReplica_priv_sync_replica.status= 'synchronized') AND (SynchroReplica_priv_sync_replica.status_last_warning!= '')))) AND (SynchroReplica_priv_sync_replica.sync_source_id= '1')) AND (SynchroReplica_priv_sync_replica.status_last_seen>= '1970-01-01 00:00:00')) ORDER BYSynchroReplicafriendlynameASC , mysql_error = Unknown column 'extended_data.habilitado' in 'field list', mysql_errno = 1054