The global synch is not completing and DA and spectrum data sources stay in synchronizing state.
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.
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.
DX NetOps CAPM 20.2 or later