DB connection issue Act 5.5

[mrclean92124]

This has started recently, and now Act Manager only intermitently
connects...Not having any luck tracking this down.

When connecting to Act Manager from the collector server, after the failure
to connect, I get the settings dialogue, where, the Database itself is
'greyed' out. I have to re-connect to the SQL server, then reselect the DB,
re-enter password, then it goes through connection 'Please wait' action, then
throws the same error again.

From anywhere when trying to access Act Manager
***************************
Application Compatibility Manager

The connecdtion to the XXX\ACT database has been lost due to the follwoing
error:
Exception of type
'Microsoft.ApplciationExperience.Common.ObjectFramework.ConnectionLostException' was thrown
Persistence_QuerySqlError
Timeout expired. The timeout period elapsed prior to completion of operation
or the server is not responding.
***************************

From App. Event Log on collector server.
***************************
ACTUPLOAD: An exception arose during the invocation of
dbo].[LogPostProcessing_sp], the inner exception is
System.Data.SqlClient.SqlException: Transaction (Process ID 117) was
deadlocked on lock | communication buffer resources with another process and
has been chosen as the deadlock victim. Rerun the transaction.
at System.Data.SqlClient.SqlConnection.OnError(SqlException exception,
Boolean breakConnection)
at System.Data.SqlClient.SqlInternalConnection.OnError(SqlException
exception, Boolean breakConnection)
at
System.Data.SqlClient.TdsParser.ThrowExceptionAndWarning(TdsParserStateObject
stateObj)
at System.Data.SqlClient.TdsParser.Run(RunBehavior runBehavior,
SqlCommand cmdHandler, SqlDataReader dataStream, BulkCopySimpleResultSet
bulkCopyHandler, TdsParserStateObject stateObj)
at System.Data.SqlClient.SqlCommand.RunExecuteNonQueryTds(String
methodName, Boolean async)
at System.Data.SqlClient.SqlCommand.InternalExecuteNonQuery(DbAsyncResult
result, String methodName, Boolean sendToPipe)
at System.Data.SqlClient.SqlCommand.ExecuteNonQuery()
at
Microsoft.ApplicationExperience.Common.DataManipulation.XmlDataProcessorHelper.PostProcess(String inputConnection, Int32 timeout)
at
Microsoft.ApplicationExperience.Common.DataManipulation.XmlDataProcessorHelper.CallPostProcessingSProcs(String
inputConnection, Int32 timeout, EventLog actLog)

For more information, see Help and Support Center at
http://go.microsoft.com/fwlink/events.asp.
***************************

[mrclean92124]

Update:

I have a script to delete contents of "processed" collection folder going
frequently (every 5 minutes) to handle client Sweeps on a reasonable
collection share size. Would be nice to add a "checkbox" on act collection
service to clean up after itself!!!

Confirmed workaround: Stopping/restarting collector service on collector
server allows Act Management connection. Good news is DB looks sound. Other
than scheduled service restarts...any suggestions as to long term fix?

Thanks in advance.

Thanks in advance.