Domain Groups fails to sync
Article ID: 257922
Updated On:
Products
Issue/Introduction
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 | com.ca.im.portal.dm.productsync.DataSourcePoller
| 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'
Environment
Release : 21.2, 22.2
Cause
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.
Resolution
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
Attachments
Feedback
