SICSR-17042

[SICSR-17042] SNS Cleanup is taking too long to complete
Product Line:	P&C
Component/s:	SICS Live Desktop
Affects Version/s:	SICS 4.9.2 SSP3
Fix Version/s:	SICS 20.1
Issue Links:	is duplicated by SICSR-17060
Customer:	Swiss Re Zurich

Problem:
Description is Since December 2018, the SNS automatic cleanup job is taking over 24 hours to complete. Note the verification interval is 300 seconds. It is only scanning through a few hundred entries. Not sure why it takes that long to verify and delete. We have validated there are no timeouts or locks on this table in the database.

Solution:
Databse Transactions to deregister or update should be for a single record and a failure to commit due to the record already having gone should not affect the cleanup / checking of other records.

Workaround:

Root Cause:

Extent of Impact:

Impact on Existing Data

Recovery Method for Existing Data Affected