The global synch is not completing and DA and spectrum data sources stay in synchronizing state.
Global Synchronization Status
Last Run Status: Failed
DX NetOps CAPM 20.2 or later
Services were started and then stopped in the middle of the spectrum synch, and an sql call was not completed.
The following exception is shown 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.