The following errors appear in the logs right before the purging maintenance finishes.
Date: Mar 13 10:45:48:000 Source: Altiris.NS.StandardItems.Purge.PurgeItem.OnSchedule Description: Unable to execute the specified purge event 'Delete Resource Events'. Exception: Timeout expired. The timeout period elapsed prior to completion of the operation or the server is not responding..
Date: Mar 13 02:32:08:001 Source: Altiris.NS.StandardItems.Purge.PurgeItem.OnSchedule Description: Failed to purge resource history data. (Exception: System.InvalidOperationException: ExecuteReader requires an open and available Connection. The connection's current state is Closed.
at System.Data.SqlClient.SqlCommand.ValidateCommand(String method, Boolean executing)
at System.Data.SqlClient.SqlCommand.ExecuteReader(CommandBehavior cmdBehavior, RunBehavior runBehavior, Boolean returnStream)
at Altiris.NS.StandardItems.Purge.PurgeItem.OnSchedule(String identifier))
The evt tables are very large and the purge is timing out when trying to complete the process.
Change the settings so that you are purging a smaller amount of data until the Purge is able to complete then slowly change the settings back running the purge each time until it completes normally.
Applies To Notification Server SP2
Imported Document ID: TECH13385
Subscribing will provide email updates when this Article is updated. Login is required to Subscribe