Spectrum Synchronization Failed

book

Article ID: 192240

calendar_today

Updated On:

Products

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

Issue/Introduction

Spectrum integrated as a CAPC data source.  The synchronaztion status for Spectrum results in synchronization failed.

Cause

CAPC 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://smc-casrm: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 [email protected] (4). Spectrum returned An exception was thrown while attempting the Web Service call - URL: http://smc-casrm: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------

Environment

NetOps r19.1 

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.