Applied Update 5, but the archive task is still failing at “Removing archived distinct properties.”
After 1000 events are archived, the following error occurs: "Failed to archive event log. Timeout expired. The timeout period elapsed prior to completion of the operation or the server is not responding. The statement has been terminated."
at System.Data.SqlClient.SqlConnection.OnError(SqlException exception, Boolean breakConnection, Action`1 wrapCloseInAction)
at System.Data.SqlClient.SqlInternalConnection.OnError(SqlException exception, Boolean breakConnection, Action`1 wrapCloseInAction)
at System.Data.SqlClient.TdsParser.ThrowExceptionAndWarning(TdsParserStateObject stateObj, Boolean callerHasConnectionLock, Boolean asyncClose)
at System.Data.SqlClient.TdsParser.TryRun(RunBehavior runBehavior, SqlCommand cmdHandler, SqlDataReader dataStream, BulkCopySimpleResultSet bulkCopyHandler, TdsParserStateObject stateObj, Boolean& dataReady)
at System.Data.SqlClient.SqlCommand.RunExecuteNonQueryTds(String methodName, Boolean async, Int32 timeout)
at System.Data.SqlClient.SqlCommand.InternalExecuteNonQuery(TaskCompletionSource`1 completion, String methodName, Boolean sendToPipe, Int32 timeout, Boolean asyncWrite)
at System.Data.SqlClient.SqlCommand.ExecuteNonQuery()
at System.Threading.Tasks.Task.Execute()
The wait operation timed out
Note: Make sure to have a current backup of the database before making any changes.
Open SQL Server Management Studio.
Expand "Databases".
Expand the ActiveAdministrator database.
Expand "Tables".
Right click dbo.tblConfig and select "Edit top200 rows".
Locate the ConfigName "PrgDbConnTmOut" and change the ConfigValue to 500 (default value is 120).
Restart the Active Administrator Foundation Server Service.
Run the archive process again.
If the timeout still occurs, trying increasing the value to 1000. If this does not resolve the issue, please try increasing the number of days processed from the default of 60 to 180.
© ALL RIGHTS RESERVED. Feedback Terms of Use Privacy Cookie Preference Center