deleted artifact not deleted after a month

Document ID:KM03719269
Creation Date:30-Sep-2020
Modified Date:30-Sep-2020
- Micro Focus Products:
  fortify software security center server

Summary

[ERROR] com.fortify.manager.service.EmailServiceImpl - error sending email java.lang.NullPointerException: null at com.fortify.manager.service.EmailServiceImpl.sendMessage(EmailServiceImpl.java:103) [ssc-core-18.20.1071.jar:?] This was nested among the SQL deadlock errors.

Question

Recently we have experienced a deleted artifact status has been kept for a month, it is blocking further upload.
How to remove it on the way.
This is also happened for scheduling status
Please assign the ticket to experienced senior resource or Josue

Answer

To correct this issue disable alerting and restart SSC, and the database clean up should remove the offending record as it should have in the beginning. The customer then needs to go through and check the Alert set up and find the error that caused the initial failure.