BBIS\ Cannot export list of e-mail recipients

When trying to export email recipients the following error is received:
 
12223 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.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.ExecuteDbDataReader(CommandBehavior behavior) at System.Data.Common.DbCommand.System.Data.IDbCommand.ExecuteReader(CommandBehavior behavior) at System.Data.Common.DbDataAdapter.FillInternal(DataSet dataset, DataTable[] datatables, Int32 startRecord, Int32 maxRecords, String srcTable, IDbCommand command, CommandBehavior behavior) at System.Data.Common.DbDataAdapter.Fill(DataTable[] dataTables, Int32 startRecord, Int32 maxRecords, IDbCommand command, CommandBehavior behavior) at System.Data.Common.DbDataAdapter.Fill(DataTable dataTable) at Blackbaud.Web.Content.Core.PagedSQLReader.ExecuteDataTable() at Blackbaud.Web.Content.Portal.ScorpioGridWrapper.ExportToCSV() at Blackbaud.Web.Content.Portal.VerbToolbar.Button_Command(Object sender, CommandEventArgs e) at System.Web.UI.WebControls.LinkButton.OnCommand(CommandEventArgs e) at System.Web.UI.Page.ProcessRequestMain(Boolean includeStagesBeforeAsyncPoint, Boolean includeStagesAfterAsyncPoint) 6/28/2013 4:09:09 PM
 
This has been found in the following scenarios:
 
When trying to export ~5,000 records I get the error with Firefox on Mac OS 10.8.3, but it works in Chrome and Safari. 
 
On a PC running Windows 8 it works in Firefox.
 
When I go up to ~17,000 records it does not work in Chrome or Safari on Mac OS, but still works in Firefox on a PC. 
 
With ~150,000 records is does not work in Firefox on a PC. 
 
On both the Mac and PC I'm using the latest version of all browsers. 
 
Found the following in SQL Snaps:
 
Login: 07/02/2013 12:22:12 PM
NT User: AppPool21027P
Login name: BLACKBAUDHOST\AppPool21027P
Appliation: Blackbaud App Server
Client Host: D2PBBISEC001V
Batch issued: 12:22:12 PM
Batch SQL: 21027P_1928c95b...
Blocked on SPID 443
Batch Age: 18 seconds
SQL Started at 12:22:12 PM
SPID 463
12:22:30 PM
cmd: UPDATE
Status: suspended
 
SQL Snaps, Event Viewer Logs, Screenshot, Fiddler Trace:
\\cly-files\attachments\2013CS\11678451
Download and install the latest patch, which contains all fixes from previous patches. If you are running an older version, download and install the latest version and then the patch. 

Environment

 2.94.1524.58
 2.94.1524, patch 82 ; 3.0.516, Service Pack 6

Was this article helpful?