I have an issue from time to time where SAM templates don't get deployed or the deployment is VERY delayed, when a node is added to a group that a template is deployed to. The fix from support is dreaded because when you have 19 APEs, it's quite tedious.
--SW Stuck Processing
--Stop all polling services
DELETE FROM APM_TemplateGroupAssignmentsBlacklist
DELETE tga FROM APM_TemplateGroupAssignment as tga
LEFT JOIN APM_ApplicationTemplate as at on tga.TemplateID = at.ID
WHERE at.ID IS NULL
Update Limitations set WhereClause = REPLACE(REPLACE(REPLACE(CAST(WhereClause as varchar(max)), '( (', ' ( ( '), '((', ' ( ( '),'))',' ) ) ')
DELETE FROM Limitations WHERE WhereClause = '1=1'
DELETE FROM LimitationSnapShots
DELETE FROM ContainerMemberSnapshots
DELETE FROM PendingNotifications
--SELECT * FROM Subscriptions WHERE FailedDeliveryAttempts > 0
DELETE FROM SubscriptionTags
DELETE FROM Subscriptions WHERE EndpointAddress NOT LIKE 'http%'
-- Start all polling services
I'm posting this in the Alert Lab because I'm looking for a way to alert me to the problem because I usually only find there is an issue when some other issue is being investigated. Like, when an expected alert did not trigger and I find that the template never got deployed despite the node being added to the group.
You might think it would be something that SW would have added to Notifications and/or Deployment Health since this type of issue goes back many versions.
