Scheduled Alerts no longer working

  • 7003194
  • 01-May-2009
  • 27-Apr-2012

Environment

Novell ZENworks 7.5 Asset Management - ZAM7.5

Oracle Backend Database

 

Situation

Scheduled Alerts created within the Web Console no longer are sent.

Resolution

Fixed in ZENworks Asset Management 7.5 Interim Release 22 or newer

Interim Releases can be scheduled to run automatically or can be downloaded manually at https://download.novell.com/[patch URL here] The Interim releases can be set up within the ZAM Manager for the Task server to check the site on a scheduled basis, and download and apply them automatically. Please refer to the Help Section details of how to set up automatic downloads if desired.

Each interim release is cumulative. If Interim Release 22 is not available due to a newer interim release being placed on the website, be assured that the code needed is in the later release.

Additional Information

The error is due to the Web Console GUI allowing more digits into the MaxRecords field when you create an Alert from a custom report without the GUI alerting the user to a problem.
 
To determine if this is the problem you will need to run the below query within SQL Plus or some application to run a query against the Oracle database.  You will need to log in as NCSystem.
 
select   RAWTOHEX(WC_CReportschedules.QueryOID) QUERYOID ,  DayOfWeek,
WeekOfMonth, DayOfMonth, Frequency, WC_CReportschedules.LastScheduledRun,
CycleBeginDate, WC_CReportschedules.MaxRecords,  NonEmptyOnly, Distribution,
Alert,   RAWTOHEX(AlertOID) AlertOID  from WC_CReportschedules  inner join
WC_CReport on WC_CReportschedules.queryoid=WC_CReport.queryoid  where
CycleBeginDate <=  CURRENT_DATE  order by CycleBeginDate;
 
If you find any values within the MAXRECORDS column being more than 9 nines then you will need to go into the Web Console and edit each alert being sure that no MAXRECORD value within the GUI is more than 9 characters.