Purge Maintenance failing with a timeout

Article:TECH13385  |  Created: 2006-04-03  |  Updated: 2006-04-03  |  Article URL http://www.symantec.com/docs/TECH13385
Article Type
Technical Solution


Issue



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


Environment



Notification Server SP2

Cause



The evt tables are very large and the purge is timing out when trying to complete the process.

Solution



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.

Legacy ID



21527


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


Terms of use for this information are found in Legal Notices