Timeout Exception when sending campaign test message

 While sending a test in Email Campaigns to a constituent list:
 
[11/27/2012 12:54:36 PM] - [Created]
 
[11/27/2012 12:54:36 PM] - [Prepared]
 
[11/27/2012 12:55:33 PM] - [Processing]
 
[11/27/2012 12:55:33 PM] - [Processing]
Using processor Blackbaud.AppFx.ContentManagement.Platform.Email.Catalog.LegacyDataProcessor.
 
[11/27/2012 12:55:33 PM] - [Processing]
Begin classic processing.
 
[11/27/2012 12:55:33 PM] - [Processing]
Processing list 'List Name'
 
[11/27/2012 12:56:03 PM] - [Exception]
System.Data.SqlClient.SqlException (0x80131904): 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.TdsParser.ThrowExceptionAndWarning()
   at System.Data.SqlClient.TdsParser.Run(RunBehavior runBehavior, SqlCommand cmdHandler, SqlDataReader dataStream, BulkCopySimpleResultSet bulkCopyHandler, TdsParserStateObject stateObj)
   at System.Data.SqlClient.SqlDataReader.ConsumeMetaData()
   at System.Data.SqlClient.SqlDataReader.get_MetaData()
   at System.Data.SqlClient.SqlCommand.FinishExecuteReader(SqlDataReader ds, RunBehavior runBehavior, String resetOptionsString)
   at System.Data.SqlClient.SqlCommand.RunExecuteReaderTds(CommandBehavior cmdBehavior, RunBehavior runBehavior, Boolean returnStream, Boolean async)
   at System.Data.SqlClient.SqlCommand.RunExecuteReader(CommandBehavior cmdBehavior, RunBehavior runBehavior, Boolean returnStream, String method, DbAsyncResult result)
   at System.Data.SqlClient.SqlCommand.RunExecuteReader(CommandBehavior cmdBehavior, RunBehavior runBehavior, Boolean returnStream, String method)
   at System.Data.SqlClient.SqlCommand.ExecuteReader(CommandBehavior behavior, String method)
   at System.Data.SqlClient.SqlCommand.ExecuteReader()
   at Blackbaud.Web.Content.SPWrap.spGetAppealQueryListAvailableRecordIDs.WrapperRoutines.ExecuteSP(SqlConnection conn, Int32 iSampleSize, Int32 iSampleType, Int32 iAppealListID, Int32& iReturnValue)
   at Blackbaud.Web.Content.SPWrap.spGetAppealQueryListAvailableRecordIDs.WrapperRoutines.ExecuteSP(String sConnString, Int32 iSampleSize, Int32 iSampleType, Int32 iAppealListID, Int32& iReturnValue)
   at Blackbaud.Web.Content.Core.EmailProject_AppealEmailList.AvailableRecordIDs(EmailProject_AppealEmailListEmail oEmail)
   at Blackbaud.Web.Content.Core.EmailJob.ProcessList(Int32 iListID)
   at Blackbaud.Web.Content.Core.EmailJob.ProcessAddressees()
   at Blackbaud.Web.Content.Core.EmailJob.DoProcessMailBlast()
   at Blackbaud.Web.Content.Core.EmailJob.ProcessMailBlast()
   at Blackbaud.AppFx.ContentManagement.Platform.Email.Catalog.LegacyListProcessorWrapper.PrepareForProcessing()
   at Blackbaud.AppFx.ContentManagement.Platform.Email.Catalog.LegacyDataProcessor.BuildRecipientsSelectionSQL()
   at Blackbaud.AppFx.ContentManagement.Platform.Email.Catalog.EmailProcessor.ProcessEmail()
   at Blackbaud.AppFx.ContentManagement.Platform.Email.Catalog.ProcessCMSEmailBusinessProcess.StartBusinessProcess()
 
We recommend an upper sending limit of 100k for email campaigns.

The upper limit is due to a time out issue that can occur on the servers during the preparation or processing of that email job. 
The upper sending limit is based on an email job using 1 merge field.  Additional merge fields may decrease the upper limit of any email job.

Environment

 6.51.736 ; 6.45

Was this article helpful?