Purge Maintenance failing with a timeout
search cancel

Purge Maintenance failing with a timeout


Article ID: 152544


Updated On:


IT Management Suite


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 System.Data.SqlClient.SqlCommand.ExecuteNonQuery()

   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