KNOWN ISSUE: Cloned Notification Policy not working

Article:TECH31801  |  Created: 2007-07-05  |  Updated: 2007-10-12  |  Article URL http://www.symantec.com/docs/TECH31801
NOTE: If you are experiencing this particular known issue, we recommend that you Subscribe to receive email notification each time this article is updated. Subscribers will be the first to learn about any releases, status changes, workarounds or decisions made.
Article Type
Technical Solution

Issue



When cloning a Site Monitor Notification Policy, the Notification Policy will either not trigger or stop triggering after some time.

Environment



Site Monitor 6.0
You may want to clone a Notification Policy to have different actions occur during different schedules.

Cause



The default Site Monitor Notification Policies use a SQL query which explicitly reference that Notification Policy's name in the database. When you clone one of these policies, it will still be referencing the original policy's name. If the original policy ran at one point in time, the new Notification Policy may still trigger based on the original policy's record in the database. However, if the original policy is no longer enabled, it is a matter of time until the NS Purging Maintenance will remove this old record causing the cloned policy to fail. If the original Notification Policy never ran, then the cloned policy will never trigger.

Solution



When cloning the Notification Policy, the SQL query must be modified to reflect the new name of the policy.

The original Notification Policy "Unavailable Resource":

IF (SELECT COUNT(DISTINCT MonitoredResourceDisplayName) FROM vGaugeStateReferencesWithNames  
 WHERE SummaryStateGuid = '{7522bede-d9b3-4ccb-89a3-6b82a9e9a76a}' AND GaugeTypeGuid = '{4E13EEEB-B706-42D3-81C6-E26CB5A00300}'  
 AND Processed > 
  (SELECT MAX(StartTime) 
  FROM Evt_NS_Scheduled_Event 
  WHERE ItemName = 'Unavailable Resource'
 ) <= 2
 SELECT * FROM vGaugeStateReferencesWithNames   
 WHERE SummaryStateGuid = '{7522bede-d9b3-4ccb-89a3-6b82a9e9a76a}' AND GaugeTypeGuid = '{4E13EEEB-B706-42D3-81C6-E26CB5A00300}'  
 AND Processed > 
  (SELECT MAX(StartTime) 
  FROM Evt_NS_Scheduled_Event 
  WHERE ItemName = 'Unavailable Resource'
ELSE  
 SELECT * FROM vGaugeStateReferencesWithNames WHERE 1=2  

The cloned Notification Policy "Unavailable Resource - Mon-Fri":

IF (SELECT COUNT(DISTINCT MonitoredResourceDisplayName) FROM vGaugeStateReferencesWithNames  
 WHERE SummaryStateGuid = '{7522bede-d9b3-4ccb-89a3-6b82a9e9a76a}' AND GaugeTypeGuid = '{4E13EEEB-B706-42D3-81C6-E26CB5A00300}'  
 AND Processed > 
  (SELECT MAX(StartTime) 
  FROM Evt_NS_Scheduled_Event 
  WHERE ItemName = 'Unavailable Resource - Mon-Fri'
 ) <= 2  
 SELECT * FROM vGaugeStateReferencesWithNames   
 WHERE SummaryStateGuid = '{7522bede-d9b3-4ccb-89a3-6b82a9e9a76a}' AND GaugeTypeGuid = '{4E13EEEB-B706-42D3-81C6-E26CB5A00300}'  
 AND Processed > 
  (SELECT MAX(StartTime) 
  FROM Evt_NS_Scheduled_Event 
  WHERE ItemName = 'Unavailable Resource - Mon-Fri')
ELSE  
 SELECT * FROM vGaugeStateReferencesWithNames WHERE 1=2  


Supplemental Materials

SourceDEFECT
ValueNOR 14922
DescriptionLogged in alt255 (Altiris - Norwood) database

Legacy ID



36037


Article URL http://www.symantec.com/docs/TECH31801


Terms of use for this information are found in Legal Notices