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 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

Languages

Show all

Problem

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

Source	DEFECT
Value	NOR 14922
Description	Logged in alt255 (Altiris - Norwood) database

Legacy ID

36037