ALERT: Some images may not load properly within the Knowledge Base Article. If you see a broken image, please right-click and select 'Open image in a new tab'. We apologize for this inconvenience.

Glocal Sync Failed.


Article ID: 199217


Updated On:


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


The global synch is not completing and DA and spectrum data sources stay in synchronizing state.

I see in Global Synchronization Status

Last Run Status: Failed


Services were started and then stopped in the middle of the spectrum synch, and an sql call was not completed.

We see this in the DMService.log:
INFO   | jvm 1    | 2020/09/10 16:55:12 |       | Start firstPollLoop

STATUS | wrapper  | 2020/09/10 17:02:06 | TERM trapped.  Shutting down.

INFO   | jvm 1    | 2020/09/10 17:04:54 |       | Start firstPollLoop

INFO   | jvm 1    | 2020/09/10 17:04:54 | java.util.concurrent.ExecutionException: org.springframework.dao.DuplicateKeyException: StatementCallback; SQL [CALL sp_reset_item_mapping_table()]; Duplicate entry '69975681' for key 'PRIMARY'; nested exception is com.mysql.jdbc.exceptions.jdbc4.MySQLIntegrityConstraintViolationException: Duplicate entry '69975681' for key 'PRIMARY'

So the sql call did not complete and now there are duplicate entries in the table.


Release : 3.7

Component : IM Reporting / Admin / Configuration



systemctl stop caperfcenter_console; systemctl stop caperfcenter_devicemanager; systemctl stop caperfcenter_eventmanager; systemctl stop caperfcenter_sso;

mysql netqosportal -unetqos -pnetqos (your password will vary)


mysql> show processlist;  

and make sure no sql calls being made.


Next run this sql command:

delete from item_mapping;


restart capc processes

systemctl start caperfcenter_sso; sleep 30; systemctl start caperfcenter_devicemanager; sleep 30; systemctl start caperfcenter_eventmanager; sleep 30; systemctl start caperfcenter_console;