search cancel

Domain Groups fails to sync

book

Article ID: 257922

calendar_today

Updated On:

Products

DX NetOps

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

https://knowledge.broadcom.com/external/article/250020/

Attachments