Report Aggregation Task time out during gathering. Error message similar to the following may be observed:
"Database Write Error: Timeout expired. DataProcessor:MailboxReview Calculate Rollups.:{E7F6DBF6-B0A6-4FFE-B508-931FB4736C1C} Datamap=DataObject:MailboxReviewObjectData:{04FF00D3-A26A-4B49-BFED-5A61ACCC456D}."
Information Store gathering warnings with
Database Write Error: Timeout expired. DataProcessor:Information Store Mailbox Writer.:{7729FF86-C8A7-4DA1-BAA1-26BD149436FF} Datamap=DataObject:Exchange Information Store Mailbox:{7824C931-C8BE-4F0B-9F38-90FCED390B9D}.
Database gathering fails with:
Error occurred while storing the primary mailbox database CN=SystemMailbox{9dbcfb86-65b7-47b7-9620-f9b948b08649},CN=Microsoft Exchange System Objects,DC=usa,DC=dce,DC=usps,DC=gov. Error message: Timeout expired. The timeout period elapsed prior to completion of the operation or the server is not responding..
The following error occurred during the processing of a given gathering: Timeout expired. The timeout period elapsed prior to completion of the operation or the server is not responding..
The following error occurred in trying to execute a given task: Quest.MessageStats.Runtime.MessageStatsException: Error in report pack data source execute ---> System.Data.SqlClient.SqlException: Timeout expired. The timeout period elapsed prior to completion of the operation or the server is not responding. 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.Fi
The Long Command Timeout Value applies to long commands like the ones in PR_CalculateRollups (used in Report Aggregation) and is there to time out any SQL command that may have hung.
Increase the Long Command Timeout Value using the following steps:
1. Stop any running tasks
2. Open the MessageStats Console, bring up the MessageStats Server Properties page.
3. Look into the Database tab and there are two timeout values that can modified.
4. Increase the existing values for these. (e.g. Double the values)
5. Click OK to apply the changes.
For full information, please refer to Page 111 of the QMS 6.9 Administrator Guide:
https://support.quest.com/Downloads.aspx?id=3530455&ver=MessageStats~6.9&productid=268435854&productversionid=268454540&category=Documentation&search=101&SKB=1
