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.

book

Article ID: 199217

calendar_today

Updated On:

Products

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

Issue/Introduction

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



Cause

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.

Environment

Release : 3.7

Component : IM Reporting / Admin / Configuration

Resolution

stop DM/PC/EM/SSO

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;