DX Netops Portal failing to sync with DX Netops Spectrum
search cancel

DX Netops Portal failing to sync with DX Netops Spectrum


Article ID: 244876


Updated On:


CA Performance Management - Usage and Administration DX NetOps


Spectrum failing to sync with DX Netops Performance Management.

On the NetOps Portal (CAPC), in the DMService.log errors similar to the following are generated:

INFO   | jvm 1    | TIMESTAMP | CAPC encountered an error while trying to sync with data source Spectrum Infrastructure [email protected]  The problem is in CAPC, not the data source.  The following stack trace shows the invalid SQL statement in CAPC:
INFO   | jvm 1    | TIMESTAMP | org.springframework.dao.DuplicateKeyException: PreparedStatementCallback; SQL [INSERT INTO dst_device_life_cycle_state (SourceID, LocalID, ItemID, LifeCycleState, UpdatedOn) VALUES(11,'0x00e00c7','111061675','MAINTENANCE',1654766031),
INFO   | jvm 1    | TIMESTAMP | (13,'0x1072c70','85744444','MAINTENANCE',1623456031)]; Duplicate entry '13-0x1072c70' for key 'dst_device_life_cycle_state.PRIMARY'; nested exception is java.sql.SQLIntegrityConstraintViolationException: Duplicate entry '13-0x1072c70' for key 'dst_device_life_cycle_state.PRIMARY'
INFO   | jvm 1    | TIMESTAMP |  at org.springframework.jdbc.support.SQLErrorCodeSQLExceptionTranslator.doTranslate(SQLErrorCodeSQLExceptionTranslator.java:247) ~[spring-jdbc-5.3.18.jar:5.3.18]


DX NetOps Spectrum & CAPM Release : 21.2 or later


The nomal sync process is:

  1. Spectrum sends lifecycle state changes, we store the values.

  2. Global sync runs, and processes them and then clears the table where the values in 1 are stored.

  3. Next sync cycle we repeat #1.

If global sync is interrupted or is not completing successfully the table is never cleared and you can see the messages above.


Let the global sync complete successfully without interruption.
The errors will clear on their own during the normal sync process.

If for some reason the Global sync does not complete, or the error persists, open an issue with Support for further investigation.