search cancel

Domain Groups fails to sync


Article ID: 257922


Updated On:


DX NetOps


Getting a global sync failure at Domain Groups. 

I ran a Full Resync of the Data Aggregator.

Failure persists.

Error seen in DMService.log


ERROR | pool-4-thread-1          | 2023-01-17 00:00:57,996 |                

      | Exception thrown by sync task: org.springframework.jdbc.BadSqlGrammarException: PreparedStatementCallback; bad SQL grammar [INSERT INTO temp_changed (ItemID, DomainGroupID, ItemType, ItemSubType) SELECT t.ItemID, tg.ItemID, i.ItemType, t.ItemSubType FROM t_network_path t INNER JOIN items i ON t.ItemID=i.ItemID INNER JOIN t_group tg ON tg.OwnerItemID=t.DomainID WHERE i.UpdatedOn>=1671553244]; nested exception is com.mysql.jdbc.exceptions.jdbc4.MySQLSyntaxErrorException: Unknown column 't.DomainID' in 'on clause'


Release : 21.2, 22.2


The DB column 't.DomainID' was not added until 22.2.1.

Either some component has been upgraded to 22.2.1+ and pc was not, or the order was wrong and the data source was upgraded before the pc.

This includes PM, Spectrum and NFA.


Make sure all components of DX NetOps Performance Management are at the same version, then do a full resynch of the DA data source in pc console.

Additional Information