Spectrum Synchronization Failed

Products

• CA Infrastructure Management
• CA Performance Management - Usage and Administration
• DX NetOps

Issue/Introduction

Spectrum integrated as a NetOps Portal data source.  The synchronization status for Spectrum results in synchronization failed.

Environment

Dx NetOps Performance Management  r19.1 

Cause

NetOps Portal global synchronization fails if duplicate tunnels and/or SLA paths are synchronized from any data source.  Error message similar the following would be seen in the DMService.log:

------snip------
INFO  | pool-1-thread-1          | 2020-05-26 00:00:22,963 | com.ca.im.portal.dm.productsync.GlobalSync                       
      | Starting Global Synchronization
.
ERROR | SpectrumStatusService/Thread | 2020-05-26 00:02:11,117 | com.ca.im.portal.dm.status.SpectrumStatusServiceImpl             
      | Failed to make request: An exception was thrown while attempting the Web Service call - URL: http://hostname:80/spectrum/restful/subscription
ERROR | SpectrumStatusService/Thread | 2020-05-26 00:02:11,117 | com.ca.im.portal.dm.status.SpectrumStatusServiceImpl             
      | Monitoring failed. Failed to start a subscription id for data source Spectrum Infrastructure Manager@hostname (4). Spectrum returned An exception was thrown while attempting the Web Service call - URL: http://hostname:80/spectrum/restful/subscription


ERROR | pool-4-thread-1          | 2020-05-26 00:04:15,969 | com.ca.im.portal.dm.productsync.DataSourcePoller                 
      | Exception thrown by sync task: org.springframework.dao.DuplicateKeyException: StatementCallback; SQL [INSERT INTO temp_items (itemID, sourceID, updatedOn) SELECT dst.ItemID, dst.sourceID, dst.updatedOn FROM dst_tunnel dst WHERE UpdatedOn=0]; Duplicate entry '4141090-4' for key 'PRIMARY'; nested exception is com.mysql.jdbc.exceptions.jdbc4.MySQLIntegrityConstraintViolationException: Duplicate entry '4141090-4' for key 'PRIMARY'
java.util.concurrent.ExecutionException: org.springframework.dao.DuplicateKeyException: StatementCallback; SQL [INSERT INTO temp_items (itemID, sourceID, updatedOn) SELECT dst.ItemID, dst.sourceID, dst.updatedOn FROM dst_tunnel dst WHERE UpdatedOn=0]; Duplicate entry '4141090-4' for key 'PRIMARY'; nested exception is com.mysql.jdbc.exceptions.jdbc4.MySQLIntegrityConstraintViolationException: Duplicate entry '4141090-4' for key 'PRIMARY'
------snip------

Resolution

Apply the VNA/Spectrum patch and addition need to clear up those duplicates in Spectrum. 

Additional Information

CAPM Sustaining Engineering have also addressed the issue in CAPM.  Updated the global sync SQL calls to not error when duplicate tunnels/SLA paths are sent from data source(s).  Fixed in CAPM r3.7.11, DE456711.